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.