PAY_NA_EARN_VW

(SQL View)
 Index Back

Pay Earnings View

View on NA Payroll Distribution - pay earnings split into individual earning codes.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.SEPCHK , A.EMPLID , A.EMPL_RCD , A.ERNCD , A.EARNINGS , A.BUSINESS_UNIT , A.DEPTID , A.POSITION_NBR , A.JOBCODE , B.CURRENCY_CD FROM PS_PAY_NA_EARNINGS A , PS_PAYGROUP_TBL B WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_PAYGROUP_TBL B_ED WHERE B.COMPANY = B_ED.COMPANY AND B.PAYGROUP = B_ED.PAYGROUP AND B_ED.EFFDT <= A.PAY_END_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

Prompt Table: PAYGROUP_TBL

3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
5 PAGE_NUM Number(4,0) SMALLINT NOT NULL Page #
6 LINE_NUM Number(2,0) SMALLINT NOT NULL Line #
7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
8 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
9 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
10 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
11 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code

Prompt Table: EARNINGS_TBL

12 EARNINGS Signed Number(15,2) DECIMAL(13,2) NOT NULL Earnings
13 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
14 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
15 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
16 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code