AP_CLAIM_AUTH_ASGN

Description: |
Services that have manually assigned authorizations, which are used to fulfill the services' authorization requirements before other authorizations.
Please refer to the query below for how to associate manually assigned referrals and authorizations to services. Note that REFERRAL_ID will always be set, but AUTH_ID might be NULL if the assignment is at the referral level, rather than the service-level authorization.
SELECT AP_CLAIM_AUTH_ASGN.CLAIM_ID,
AP_CLAIM_AUTH_ASGN.TX_ID,
AP_CLAIM_AUTH_ASGN.LINE ASSIGNED_ORDER,
AP_CLAIM_AUTH_ASGN_RFLS.REFERRAL_ID,
AP_CLAIM_AUTH_ASGN_AUTHS.AUTH_ID
FROM AP_CLAIM_AUTH_ASGN
INNER JOIN AP_CLAIM_AUTH_ASGN_RFLS
ON AP_CLAIM_AUTH_ASGN.CLAIM_ID = AP_CLAIM_AUTH_ASGN_RFLS.CLAIM_ID
AND AP_CLAIM_AUTH_ASGN.LINE = AP_CLAIM_AUTH_ASGN_RFLS.GROUP_LINE
LEFT OUTER JOIN AP_CLAIM_AUTH_ASGN_AUTHS
ON AP_CLAIM_AUTH_ASGN.CLAIM_ID = AP_CLAIM_AUTH_ASGN_AUTHS.CLAIM_ID
AND AP_CLAIM_AUTH_ASGN.LINE = AP_CLAIM_AUTH_ASGN_AUTHS.GROUP_LINE
AND AP_CLAIM_AUTH_ASGN_RFLS.VALUE_LINE = AP_CLAIM_AUTH_ASGN_AUTHS.VALUE_LINE

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CLAIM_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CLAIM_ID | NUMERIC | No |
The unique identifier for the claim record.
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 | TX_ID | NUMERIC | No |
Services that have manually assigned authorizations, which will be used to fulfill the services' authorization requirements before other authorizations.