PAY_NA_NET_D_VW

(SQL View)
 Index Back

Net Pay Liability

NA Payroll Distribution - Net Pay liability view.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.SEPCHK , A.ERNCD , A.ACCT_CD , B.BUSINESS_UNIT , B.EMPLID , B.EMPL_RCD , B.DEPTID , B.POSITION_NBR , B.JOBCODE , A.ACCOUNT , A.NET_PAY FROM PS_PAY_NA_NET_DIST A , PS_PAY_NA_EARNINGS B WHERE A.COMPANY = B.COMPANY AND A.PAYGROUP = B.PAYGROUP AND A.PAY_END_DT = B.PAY_END_DT AND A.OFF_CYCLE = B.OFF_CYCLE AND A.PAGE_NUM = B.PAGE_NUM AND A.LINE_NUM = B.LINE_NUM AND A.ADDL_NBR = B.ADDL_NBR AND A.SEPCHK = B.SEPCHK AND A.ERNCD = B.ERNCD

# 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(5,0) INTEGER NOT NULL Page Nbr
6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
9 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
10 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_TBL

11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
13 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
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 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
18 NET_PAY Signed Number(12,2) DECIMAL(10,2) NOT NULL Net Pay