[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 |