VIEW: HR.PAY_NL_IZA_UPLD_STATUS#

Source

View Text - Preformatted

select BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, EMPLOYER_NUMBER EMPLOYER_NUMBER, SUB_EMPLOYER_NUMBER SUB_EMPLOYER_NUMBER, PAYROLL_CENTER PAYROLL_CENTER, PROCESS_YEAR_MONTH PROCESS_YEAR_MONTH, PERSON_ID PERSON_ID, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, PROCESS_STATUS PROCESS_STATUS, PROVINCE_CODE PROVINCE_CODE, DATE_OF_BIRTH DATE_OF_BIRTH, PARTICIPANT_NUMBER PARTICIPANT_NUMBER, EMPLOYEE_NAME EMPLOYEE_NAME, CONTRIBUTION_1 CONTRIBUTION_1, CORRECTION_CONTRIBUTION_1 CORRECTION_CONTRIBUTION_1, DATE_CORRECTION_1 DATE_CORRECTION_1, CONTRIBUTION_2 CONTRIBUTION_2, CORRECTION_CONTRIBUTION_2 CORRECTION_CONTRIBUTION_2, DATE_CORRECTION_2 DATE_CORRECTION_2, REJECT_REASON REJECT_REASON, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PAY_NL_IZA_UPLD_STATUS"

View Text - HTML Formatted

SELECT BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, EMPLOYER_NUMBER EMPLOYER_NUMBER
, SUB_EMPLOYER_NUMBER SUB_EMPLOYER_NUMBER
, PAYROLL_CENTER PAYROLL_CENTER
, PROCESS_YEAR_MONTH PROCESS_YEAR_MONTH
, PERSON_ID PERSON_ID
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, PROCESS_STATUS PROCESS_STATUS
, PROVINCE_CODE PROVINCE_CODE
, DATE_OF_BIRTH DATE_OF_BIRTH
, PARTICIPANT_NUMBER PARTICIPANT_NUMBER
, EMPLOYEE_NAME EMPLOYEE_NAME
, CONTRIBUTION_1 CONTRIBUTION_1
, CORRECTION_CONTRIBUTION_1 CORRECTION_CONTRIBUTION_1
, DATE_CORRECTION_1 DATE_CORRECTION_1
, CONTRIBUTION_2 CONTRIBUTION_2
, CORRECTION_CONTRIBUTION_2 CORRECTION_CONTRIBUTION_2
, DATE_CORRECTION_2 DATE_CORRECTION_2
, REJECT_REASON REJECT_REASON
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PAY_NL_IZA_UPLD_STATUS"