[Home] [Help]
View: PAY_PER_LATEST_BALANCES_V1
View Text
SELECT DEFINED_BALANCE_ID
, ASSIGNMENT_ACTION_ID
, PERSON_ID
, VALUE
, LATEST_BALANCE_ID
, EXPIRED_ASSIGNMENT_ACTION_ID
, EXPIRED_VALUE
, PREV_BALANCE_VALUE
, PREV_ASSIGNMENT_ACTION_ID
, 'P' TABLE_SOURCE
FROM PAY_PERSON_LATEST_BALANCES UNION ALL SELECT DEFINED_BALANCE_ID
, ASSIGNMENT_ACTION_ID
, PERSON_ID
, VALUE
, LATEST_BALANCE_ID
, EXPIRED_ASSIGNMENT_ACTION_ID
, EXPIRED_VALUE
, PREV_BALANCE_VALUE
, PREV_ASSIGNMENT_ACTION_ID
, 'L' TABLE_SOURCE
FROM PAY_LATEST_BALANCES
WHERE ASSIGNMENT_ID IS NULL
Columns
Name |
DEFINED_BALANCE_ID |
ASSIGNMENT_ACTION_ID |
PERSON_ID |
VALUE |
LATEST_BALANCE_ID |
EXPIRED_ASSIGNMENT_ACTION_ID |
EXPIRED_VALUE |
PREV_BALANCE_VALUE |
PREV_ASSIGNMENT_ACTION_ID |
TABLE_SOURCE |