SGHE Banner Operational Data Store
Composite View Source: MATCHING_CLAIM_EXPRESSIONS - NULL
Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
MATCHING_CLAIM_ACTIVE_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_DELETE_IND = 'I' THEN 0 ELSE 1 END |
MATCHING_CLAIM_ACTIVE_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_DELETE_IND = 'I' THEN 'Yes' ELSE 'No' END |
MATCHING_CLAIM_ACTIVE_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_DELETE_IND = 'I' THEN 'Yes' ELSE 'No' END |
MATCHING_CLAIM_PAID_STATUS_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_AMT > 0 AND AGBMGID_AMT_PAID < AGBMGID_AMT AND AGBMGID_AMT_PAID > 0 THEN 'MP' WHEN AGBMGID_AMT > 0 AND AGBMGID_AMT_PAID >= AGBMGID_AMT THEN 'MF' WHEN AGBMGID_AMT >= 0 AND AGBMGID_AMT_PAID = 0 THEN 'MN' ELSE 'MN' END |
MATCHING_CLAIM_PAID_STATUS_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_AMT > 0 AND AGBMGID_AMT_PAID < AGBMGID_AMT AND AGBMGID_AMT_PAID > 0 THEN 'Match Partially Paid' WHEN AGBMGID_AMT > 0 AND AGBMGID_AMT_PAID >= AGBMGID_AMT THEN 'Match Fully Paid' WHEN AGBMGID_AMT >= 0 AND AGBMGID_AMT_PAID = 0 THEN 'Match Not Paid' ELSE 'Match Not Paid' END |
MATCHING_CLAIM_PAID_STATUS_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_AMT > 0 AND AGBMGID_AMT_PAID < AGBMGID_AMT AND AGBMGID_AMT_PAID > 0 THEN 'Match Partially Paid' WHEN AGBMGID_AMT > 0 AND AGBMGID_AMT_PAID >= AGBMGID_AMT THEN 'Match Fully Paid' WHEN AGBMGID_AMT >= 0 AND AGBMGID_AMT_PAID = 0 THEN 'Match Not Paid' ELSE 'Match Not Paid' END |
MATCHING_CLAIM_STATUS_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_DELETE_IND IS NULL THEN CASE WHEN AGBMGID_STATUS IS NULL THEN 'W' WHEN AGBMGID_STATUS = 'P' THEN 'P' WHEN AGBMGID_STATUS = 'I' THEN 'I' ELSE 'N' END END |
MATCHING_CLAIM_STATUS_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_DELETE_IND IS NULL THEN CASE WHEN AGBMGID_STATUS IS NULL THEN 'No Payment' WHEN AGBMGID_STATUS = 'P' THEN 'Paid In Full' WHEN AGBMGID_STATUS = 'I' THEN 'Waiting, Partial Payment' ELSE 'No Payment Expected' END END |
MATCHING_CLAIM_STATUS_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBMGID_DELETE_IND IS NULL THEN CASE WHEN AGBMGID_STATUS IS NULL THEN 'No Payment' WHEN AGBMGID_STATUS = 'P' THEN 'Paid In Full' WHEN AGBMGID_STATUS = 'I' THEN 'Waiting, Partial Payment' ELSE 'No Payment Expected' END END |
MATCH_CLAIM_FORM_RCVD_IND_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBGIFT_MATCH_RECEIVED = 'Y' THEN 1 ELSE 0 END |
MATCH_CLAIM_FORM_RCVD_IND_LD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBGIFT_MATCH_RECEIVED ='Y' THEN 'Yes' ELSE 'No' END |
MATCH_CLAIM_FORM_RCVD_IND_SD_EXPRESSION |
TBD |
|
|
|
CASE WHEN AGBGIFT_MATCH_RECEIVED ='Y' THEN 'Yes' ELSE 'No' END |