CX_PAT_TRANSITION_TRACKER
Description:
This table contains data for a patient's claims that is tracked for Claims Exchange transition purposes. Each row stores the earliest claim service start date that a patient receives through Claims Exchange for an organization and/or program.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CX_ORGANIZATION_ID NUMERIC No
The payer source organization (DXO) transitioning to Claims Exchange
4 CX_ORGANIZATION_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.
5 CX_PROGRAM_ID NUMERIC No
The contract (VBP) of the payer source organization (DXO) that is transitioning to Claims Exchange.
6 CX_PROGRAM_ID_RECORD_NAME VARCHAR No
The name of the program record.
7 CX_EARLY_CLAIM_DATE DATETIME No
Earliest claim service start date received for a patient through Claims Exchange from a payer source organization (DXO).