VIEW: HR.PAY_IE_PRSI_DETAILS_F#

Source

View Text - Preformatted

select PRSI_DETAILS_ID PRSI_DETAILS_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ASSIGNMENT_ID ASSIGNMENT_ID, CONTRIBUTION_CLASS CONTRIBUTION_CLASS, OVERRIDDEN_SUBCLASS OVERRIDDEN_SUBCLASS, SOC_BEN_FLAG SOC_BEN_FLAG, SOC_BEN_START_DATE SOC_BEN_START_DATE, OVERRIDDEN_INS_WEEKS OVERRIDDEN_INS_WEEKS, NON_STANDARD_INS_WEEKS NON_STANDARD_INS_WEEKS, EXEMPTION_START_DATE EXEMPTION_START_DATE, EXEMPTION_END_DATE EXEMPTION_END_DATE, CERT_ISSUED_BY CERT_ISSUED_BY, DIRECTOR_FLAG DIRECTOR_FLAG, COMMUNITY_FLAG COMMUNITY_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "HR"."PAY_IE_PRSI_DETAILS_F"

View Text - HTML Formatted

SELECT PRSI_DETAILS_ID PRSI_DETAILS_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ASSIGNMENT_ID ASSIGNMENT_ID
, CONTRIBUTION_CLASS CONTRIBUTION_CLASS
, OVERRIDDEN_SUBCLASS OVERRIDDEN_SUBCLASS
, SOC_BEN_FLAG SOC_BEN_FLAG
, SOC_BEN_START_DATE SOC_BEN_START_DATE
, OVERRIDDEN_INS_WEEKS OVERRIDDEN_INS_WEEKS
, NON_STANDARD_INS_WEEKS NON_STANDARD_INS_WEEKS
, EXEMPTION_START_DATE EXEMPTION_START_DATE
, EXEMPTION_END_DATE EXEMPTION_END_DATE
, CERT_ISSUED_BY CERT_ISSUED_BY
, DIRECTOR_FLAG DIRECTOR_FLAG
, COMMUNITY_FLAG COMMUNITY_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "HR"."PAY_IE_PRSI_DETAILS_F"