|
Name |
Type |
Discontinued? |
|
| 1 |
AUTH_REQUEST_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the authorization request. |
|
|
| 2 |
RECORD_STATUS_2_C_NAME |
VARCHAR |
No |
|
|
|
| The Chronicles record status category ID for the authorization request. |
| May contain organization-specific values: No |
| Category Entries: |
| Soft Deleted |
| Hidden |
| Hidden and Soft Deleted |
|
|
| 3 |
EXTERNAL_IDENTIFIER |
VARCHAR |
No |
|
|
|
| The external identifier of the authorization request. |
|
|
| 4 |
LAST_EDIT_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The date and time (UTC) of the latest published (non-draft) contact of the authorization request. |
|
|
| 5 |
REQUEST_CONTEXT_C_NAME |
VARCHAR |
No |
|
|
|
| The request context category ID for the authorization request. |
| May contain organization-specific values: No |
| Category Entries: |
| Utilization Management |
| Utilization Management Appeals |
| Utilization Management Bed Days |
|
|
| 6 |
PAT_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the patient/member that this authorization request is for. This column is frequently used to link to the PATIENT table. |
|
|
| 7 |
REFERRAL_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the referral record that this authorization request is associated with. |
|
|
| 8 |
COVERAGE_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the coverage record that applies to this authorization request. |
|
|
| 9 |
REQUEST_CREATION_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The date and time (UTC) that this authorization request was initiated. |
|
|
| 10 |
LOB_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the line of business associated with the coverage when the authorization request was processed. |
|
|
| 11 |
LOB_ID_LOB_NAME |
VARCHAR |
No |
|
|
|
| The name of the line of business record. |
|
|
| 12 |
PAYER_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the payer associated with the coverage when the authorization request was processed. |
|
|
| 13 |
BENEFIT_PLAN_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the plan associated with the coverage when the authorization request was processed. |
|
|
| 14 |
ORDER_ENTRY_ORDER_ID |
NUMERIC |
No |
|
|
|
| When an authorization request is received, if any of the requested services were created during order entry, this column will be populated as a pointer back to the order. |
|
|
| 15 |
DECISION_USER_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the user responsible for the decision of the authorization request. In the case of medical director review, this is the person who conducted the medical director review rather than the user who changed the status in the system. This column is frequently used to link to the CLARITY_EMP table. |
|
|
| 16 |
DECISION_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 17 |
UM_DECISION_USER_ROLE_C_NAME |
VARCHAR |
No |
|
|
|
| The decision user role category ID for the user making the decision on the authorization request. |
| May contain organization-specific values: No |
| Category Entries: |
| Non-Medical Director |
| Medical Director |
| Auto Status Assignment |
| Decision Made Externally |
| Auto Status Assignment Pre-Check |
|
|
| 18 |
RESP_PARTY_AGENCY_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the responsibility class of the party responsible for rendering a decision for the authorization request. |
|
|
| 19 |
RESP_PARTY_AGENCY_ID_AGENCY_NAME |
VARCHAR |
No |
|
|
|
|
| 20 |
EXT_TRACKED_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| Keeps track of the reason why this auth request's turnaround time is tracked externally. |
| May contain organization-specific values: No |
| Category Entries: |
| Legacy Auth Request |
| Routed Through Payer Platform |
| Incoming 278N |
|
|
| 21 |
APPEALED_AUTH_REQUEST_ID |
NUMERIC |
No |
|
|
|
| The Authorization Request that was adversely determined and is being appealed by this Request. |
|
|
| 22 |
REGION_ID |
NUMERIC |
No |
|
|
|
| The facility profile ID of the region on the coverage used for this auth request. |
|
|
| 23 |
MEDICAL_GROUP_ID |
NUMERIC |
No |
|
|
|
| The facility profile ID of the medical group on the coverage used for this auth request. |
|
|
| 24 |
CREATED_BY_PENDING_CVG_YN |
VARCHAR |
No |
|
|
|
| This item will be set to Yes if the authorization request was originally created using a non-verified coverage. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 25 |
PREVIOUS_COVERAGE_ID |
NUMERIC |
No |
|
|
|
| When an Authorization Request is created with a non-verified coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item will provide a link to the previous coverage. |
|
|
| 26 |
CVG_CHANGE_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
| When an Authorization Request is created with a pending coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item indicates if the change was initiated manually by a user or done automatically by the system. |
| May contain organization-specific values: No |
| Category Entries: |
| Manual |
| Automatic |
|
|
| 27 |
CVG_CHANGE_USER_ID |
VARCHAR |
No |
|
|
|
| When an Authorization Request is created with a pending coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item provides a link to the user that initiated the change. |
|
|
| 28 |
CVG_CHANGE_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 29 |
CVG_CHANGE_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| When an Authorization Request is created with a pending coverage, the Authorization Request is eligible for a one-time coverage change. If the coverage is changed, this item stores the instant in which the change was made. |
|
|
| 30 |
REQUESTING_ORGANIZATION_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the organization that initiated this auth request. |
|
|
| 31 |
REQUESTING_ORGANIZATION_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| Organization's external name used as the display name on forms and user interfaces. |
|
|
| 32 |
GUIDE_REVIEW_VENDOR_C_NAME |
VARCHAR |
No |
|
|
|
| The guideline review vendor that is used for the guideline review process for the authorization request. |
| May contain organization-specific values: Yes |
|
|
| 33 |
GUIDE_REV_INIT_MTHD_C_NAME |
VARCHAR |
No |
|
|
|
| The method used to initiate the guideline review process for the authorization request. |
| May contain organization-specific values: No |
| Category Entries: |
| Automated Request |
| Manual Entry |
| Tapestry Link |
|
|
| 34 |
GUIDE_REV_REQ_DTTM |
DATETIME (Local) |
No |
|
|
|
| The instant the guideline review request was sent to the guideline review vendor. If the guideline review was manually initiated, this item is left blank. |
|
|
| 35 |
GUIDE_REV_REQ_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The instant the guideline review request was sent to the guideline review vendor. If the guideline review was manually initiated, this item is left blank. |
|
|
| 36 |
EXT_EVENT_MSG |
VARCHAR |
No |
|
|
|
| Event-level MSG data received by Payer Platform from an external system. |
|
|
| 37 |
EXT_EVT_REF_NUM |
VARCHAR |
No |
|
|
|
| the administrative reference number received by Payer Platform from an external system for this event |
|
|
| 38 |
EXT_EVT_AUTH_NUM |
VARCHAR |
No |
|
|
|
| the authorization number received by Payer Platform from an external system for this event |
|
|
