[Home] [Help]
View: PAY_NZ_SOE_RUN_ELEMENTS_V
View Text
SELECT "ELEMENT_REPORTING_NAME"
, "CLASSIFICATION_NAME"
, "PAYMENT"
, "PROCESSING_PRIORITY"
, "ASSIGNMENT_ACTION_ID"
, "ASSIGNMENT_ID"
FROM PAY_NZ_SOE_RUN_ELEMENTS_V1 UNION ALL SELECT "ELEMENT_REPORTING_NAME"
, "CLASSIFICATION_NAME"
, "PAYMENT"
, "PROCESSING_PRIORITY"
, "ASSIGNMENT_ACTION_ID"
, "ASSIGNMENT_ID"
FROM PAY_NZ_SOE_RUN_ELEMENTS_V2
Columns
Name |
ELEMENT_REPORTING_NAME |
CLASSIFICATION_NAME |
PAYMENT |
PROCESSING_PRIORITY |
ASSIGNMENT_ACTION_ID |
ASSIGNMENT_ID |