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.