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.
20 LUNG_HIST_SM_C_NAME VARCHAR No
Lung cancer histology for a small cell cancer pathology finding.
May contain organization-specific values: No
Category Entries:
Limited
Extensive
21 LUNG_SEC_HIST_SM_C_NAME VARCHAR No
Lung cancer histology of the secondary cell type for a pathology finding when the histology is "Small Cell Lung Cancer".
The category values for this column were already listed for column: LUNG_HIST_SM_C_NAME
22 LUNG_T_PREFIX_C_NAME VARCHAR No
Lung cancer histology T status prefix for a pathology finding.
May contain organization-specific values: No
Category Entries:
c
p
yc
yp
rc
rp
23 LUNG_N_PREFIX_C_NAME VARCHAR No
Lung cancer histology N status prefix for a pathology finding.
The category values for this column were already listed for column: LUNG_T_PREFIX_C_NAME
24 LUNG_M_PREFIX_C_NAME VARCHAR No
Lung cancer histology M status prefix for a pathology finding.
The category values for this column were already listed for column: LUNG_T_PREFIX_C_NAME
25 ENDO_PROC_SRC_IDENT VARCHAR No
Stores the reference ID of the endoscopy procedure this finding is related to.
26 ENDO_PROC_DDP_IDENT VARCHAR No
Stores the deduplicated reference ID of the endoscopy procedure this finding is related to.
27 RSLT_TRK_REV_INST_UTC_DTTM DATETIME (UTC) No
Stores the instant when this actionable finding was reviewed by a reading provider in Study Review.
28 OUTDATED_REV_FND_YN VARCHAR No
Flag indicating that this reviewed finding no longer evaluates to true for its rule
The category values for this column were already listed for column: FINDING_HIDDEN_YN
29 RULE_REVIEW_USER_ID VARCHAR No
Stores the user who reviewed this rule-based finding in Study Review.
30 RULE_REVIEW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
31 ORIGINATING_EXTERNAL_ORDER_ID NUMERIC No
When an external order is used to resolve a prior recommendation and create this recommendation, this item will be set with the external order's ID. This is needed for reporting and to ensure the external order can be linked to this recommendation.