ASSIGNMENT_DATA

Description: |
This table holds the patients and roster identifiers for whom specific roster assignment data was loaded.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ASGN_DATA_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ASGN_DATA_ID | NUMERIC | No |
The unique identifier (.1 item) for the assignment data record.
2 | RECORD_STATUS_2_C_NAME | VARCHAR | No |
Stores the record status (hidden, soft-deleted, etc...)
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 | ROSTER_IDENTIFIER_C_NAME | VARCHAR | No |
The roster population that this record contains tracking data for.
May contain organization-specific values: Yes
Category Entries:
general
LFM Rost
CFB Roster
4 | PAT_ID | VARCHAR | No |
The patient for whom this record contains roster tracking data.
5 | ASSIGNMENT_EFF_DATE | DATETIME | No |
The start date of the roster assignment period.
6 | ASSIGNMENT_TERM_DATE | DATETIME | No |
The end date of the roster assignment period.
7 | ATTRIBUTED_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.
8 | LAST_MODIFIED_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
The instant that this roster assignment period was last loaded or backed out.
9 | EXTERNAL_DEMOG_ID | NUMERIC | No |
The unique ID of the External Demographic Set that this assignment is loaded to.
10 | EXTERNAL_IDENT_BUNDLE_ID | NUMERIC | No |
The unique ID of the External System Identifier Bundle that this assignment is loaded to.
11 | SOURCE_ORG_ID | NUMERIC | No |
The source organization for an assignment record.
12 | SOURCE_ORG_ID_EXTERNAL_NAME | VARCHAR | No |
Organization's external name used as the display name on forms and user interfaces.
13 | BLK_DTA_MESSAGE_ID | NUMERIC | No |
The AMS record that most recently created or updated this assignment record.
14 | SOURCE_ENTITY_KEY_TYPE | VARCHAR | No |
An identifier for the external system's record key type, or ID assignment system.
15 | SOURCE_ENTITY_KEY | VARCHAR | No |
The key, or unique identifier, for the record provided by the source system.
16 | SOURCE_GEN_DTTM_ASN_UTC_DTTM | DATETIME (UTC) | No |
The timestamp of the source record from the external system.
17 | VOLUNTARY_ALIGN_YN | VARCHAR | No |
Whether the beneficiary is voluntarily aligned.
May contain organization-specific values: No
Category Entries:
No
Yes
18 | VOLUNTARY_ALIGN_TIN | VARCHAR | No |
The TIN of the beneficiary's designated clinician when voluntarily aligned.
19 | VOLUNTARY_ALIGN_NPI | VARCHAR | No |
The NPI of the beneficiary's designated clinician when voluntarily aligned.
20 | CLAIMS_ALIGN_YN | VARCHAR | No |
Whether the beneficiary is aligned through claims based assignment.
The category values for this column were already listed for column: VOLUNTARY_ALIGN_YN
21 | CLAIMS_ALIGN_STEP_C_NAME | NUMERIC | No |
Indicates if the beneficiary was assigned to the ACO through Step 1, Step 2, or Step 3 of the claims-based assignment.
May contain organization-specific values: No
Category Entries:
Voluntarily Aligned
Claims Step 1
Claims Step 2
Claims Step 3