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 VARCHAR No
This is the provider who was documented as currently being responsible for following up on this screening program recommendation.
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