ORDER_RES_3
Description:
The ORDER_RES_3 table contains result finding information for an order. Result findings include mammography pathology results, cardiovascular palette findings, and other result findings.

Primary Key
Column Name Ordinal Position
FINDING_ID 1

Column Information
Name Type Discontinued?
1 FINDING_ID NUMERIC No
The unique identifier (.1 item) for the finding record.
2 LUNG_SEC_HIST_C_NAME VARCHAR No
Determines the type of cancer that was found in the secondary cell type of the tissue sample.
May contain organization-specific values: No
Category Entries:
Non-small cell cancer
Small cell lung cancer
Carcinoid
Atypical carcinoid
Other
Unknown
3 LUNG_SEC_NONSMALL_C_NAME VARCHAR No
If secondary histology is "Non Small Cell Lung Cancer", then this item specifies the type of the cancer.
May contain organization-specific values: No
Category Entries:
Invasive adenocarcinoma
Squamous cell carcinoma
Adenosquamous cell carcinoma
Large cell carcinoma
Undifferentiated carcinoma
Other
4 LUNG_SEC_NS_COMM VARCHAR No
If Secondary histology - Non-Small Cell Lung Cancer is Other, Specify, then this item holds a free text description of the cancer.
5 FIRST_DOCUMENTED_UTC_DTTM DATETIME (UTC) No
The date and time when this lesion was first documented.
6 FOLLOWUP_CUR_RESP_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
7 FINDING_HIDDEN_YN VARCHAR No
Indicates whether a finding in the image documentation section in study review for a breast imaging study is hidden. 'Y' indicates that a finding has been hidden. 'N' or NULL indicate that a finding has not been hidden.
May contain organization-specific values: No
Category Entries:
No
Yes
8 FINDING_SUP_MOPS_YN VARCHAR No
Indicates whether a finding in the image documentation section in study review for a MOPS breast imaging study is suppressed. 'Y' indicates that a finding has been suppressed. 'N' or NULL indicate that a finding has not been suppressed.
The category values for this column were already listed for column: FINDING_HIDDEN_YN
9 LUNG_HISTOLOGY_OTHER VARCHAR No
If RES 52271 - LUNG HISTOLOGY contains Other, this item contains a free text description of the cancer.
10 LUNG_SECONDARY_HISTOLOGY_OTHER VARCHAR No
If RES 52283 - LUNG SECONDARY HISTOLOGY contains Other, this item contains a free text description of the secondary cancer.
11 ANAT_LOC_CODE_SYS VARCHAR No
The terminology system used to specifiy the anatomic location of the observation.
12 ANAT_LOC_CODE VARCHAR No
The anatomic location of the observation. This code is part of the anatomic location code system (stored in I RES 52560).
13 ANAT_LOC_NAME VARCHAR No
The display name of the observation's anatomic location code (I RES 52561).
14 OBS_CODE_SYS VARCHAR No
The terminology system that the observation code (I RES 52566) belongs to.
15 OBS_CODE VARCHAR No
The element set (observation) that this record represents. This code is part of the observation code system (stored in I RES 52565).
16 OBS_NAME VARCHAR No
The display name of the observation code (I RES 52566).
17 FINDING_MNLY_EXCLD_YN VARCHAR No
This item indicates whether a finding was excluded from the result. 'Y' indicates that a finding is excluded from the result. 'N' or NULL indicate that a finding has not been excluded.
The category values for this column were already listed for column: FINDING_HIDDEN_YN
18 RSLT_TRK_RULE_ID VARCHAR No
Stores the .1 of the CER rule which was evaluated to create this finding.
19 RSLT_TRK_RULE_ID_RULE_NAME VARCHAR No
The name of the rule.