PYKB_US_PAY034

(SQL View)
 Index Back

Payroll INS US Preshe Audit

Payroll Insights US Presheet Audit View

SELECT B.PROGRAM_ID ,A.COMPANY ,C.PAYGROUP ,D.PAY_END_DT ,A.MESSAGE_ID ,A.AUDIT_SEQNUM ,A.RUN_ID ,A.EMPLID ,A.EMPL_RCD ,B.STRING_TEXT ,D.PAY_BEGIN_DT FROM PS_R_WC_PAY034 A , PS_STRINGS_TBL B , PS_JOB C , PS_PAY_CALENDAR D WHERE B.PROGRAM_ID = 'PAY034' AND A.MESSAGE_ID = B.STRING_ID AND((A.COUNTRY_CD = 'USA' AND (A.INDUSTRY_SECTOR = 'CORE' OR A.INDUSTRY_SECTOR = 'PBSC')) OR (A.COUNTRY_CD = ' ' AND A.INDUSTRY_SECTOR = ' ' )) AND A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_JOB C2 WHERE C2.EMPLID = C.EMPLID AND C2.EMPL_RCD = C.EMPL_RCD AND C2.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(C3.EFFSEQ) FROM PS_JOB C3 WHERE C3.EMPLID = C.EMPLID AND C3.EMPL_RCD = C.EMPL_RCD AND C3.EFFDT = C.EFFDT) AND D.COMPANY = A.COMPANY AND D.PAYGROUP = C.PAYGROUP AND D.PAY_END_DT <= %CurrentDateIn AND D.RUN_ID = A.RUN_ID AND D.PAY_OFF_CYCLE_CAL = 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROGRAM_SRC Character(8) VARCHAR2(8) NOT NULL Audit report program source.
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
4 PAY_END_DT Date(10) DATE Pay Period End Date
5 MESSAGE_ID Character(30) VARCHAR2(30) NOT NULL Message ID
6 AUDIT_SEQNUM Number(5,0) INTEGER NOT NULL WorkCenter audit report sequence number.
7 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
10 MESSAGE_TEXT_LONG Long Character CLOB Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
11 PAY_BEGIN_DT Date(10) DATE Pay Period Begin Date