[Home] [Help]
View: PAY_AU_ASG_LEAVE_TAKEN_V
View Text
SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V1 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V2 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V3 UNION ALL SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V4 UNION ALL SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V5
Columns
Name |
ROW_ID |
ASSIGNMENT_ID |
TIME_PERIOD_ID |
ELEMENT_REPORTING_NAME |
START_DATE |
END_DATE |
ABSENCE_HOURS |
PAYMENT |