[Home] [Help]
View: PAY_NZ_ASG_LEAVE_TAKEN_V
View Text
SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V1 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V2 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V3 UNION ALL SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_DURATION"
, "PAYMENT"
, "DATE_EARNED"
FROM PAY_NZ_ASG_LEAVE_TAKEN_V4
Columns
Name |
ROW_ID |
ASSIGNMENT_ID |
TIME_PERIOD_ID |
ELEMENT_REPORTING_NAME |
START_DATE |
END_DATE |
ABSENCE_DURATION |
PAYMENT |
DATE_EARNED |