SCREENING_PROGRAM

Description: |
This table contains information about screening program assessment data. This includes the program type, as well as the assessment kind, location, and value. The records in this table are Orders (ORD) records that are exams within a screening program.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier (.1 item) for the order record.
2 | CONTACT_DATE_REAL | FLOAT | No |
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | PROGRAM_C_NAME | VARCHAR | No |
The screening program category ID for the screening program being documented, such as Breast Screening or Lung Screening.
May contain organization-specific values: No
Category Entries:
Lung Screening
Breast Screening
Colorectal Follow-up
EGD Follow-up
Upper EUS Follow-up
ERCP Follow-up
Diabetic Retinopathy Screening
Sigmoidoscopy Follow-up
Lower EUS Follow-up
Antegrade Enteroscopy Follow-up
Bronchoscopy Follow-up
Retrograde Enteroscopy Follow-up
Pouchoscopy Follow-Up
Ileoscopy Follow-Up
Actionable Finding
Cervical Cancer Screening
Unspecified
6 | ASSESSMENT_KIND_C_NAME | VARCHAR | No |
The assessment kind category ID for the screening program, such as Lung Assessment or Breast Incomplete Reason.
May contain organization-specific values: No
Category Entries:
Lung Assessment
Lung Modifier
Lung Incomplete Reason
Unverified Lung Assessment
Unverified Lung Modifier
Unverified Lung Incomplete Reason
Breast Incomplete Reason
Version
7 | ASSESSMENT_LOC_C_NAME | VARCHAR | No |
The location on the body category ID for the location of the assessment being documented.
May contain organization-specific values: No
Category Entries:
Right
Left
Bilateral
Right Upper Lobe
Right Middle Lobe
Right Lower Lobe
Left Upper Lobe
Lingula
Left Lower Lobe
Left Hilum
Right Hilum
Right Middle and Right Lower Lobes
Right Upper and Right Middle Lobes
Lingula
Other
Unknown
8 | SX_PROG_ASMT_C_NAME | VARCHAR | No |
The assessment value category ID documented for this screening program, such as Incomplete, Negative, and Probably Benign.
May contain organization-specific values: No
Category Entries:
Incomplete
Negative
Benign appearance or behavior
Probably benign
Suspicious - 4A
Very Suspicious - 4B
Very Suspicious - 4X
Clinically significant findings
Prior lung cancer
Incomplete coverage
Noise
Respiratory motion
Expiration
Obscured by acute abnormality
Unknown
Unable to complete
Inflammatory or infectious process
Not reported
Additional images for evaluation
Priors for comparison
Technical repeat
Version 1.0
Version 1.1
Version 2.0
9 | SX_PROG_ASMT_CMT | VARCHAR | No |
A comment for the assessment being documented.