|
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 |
|
|
