PAY_NA_TAX_L_VW

(SQL View)
Index Back

NA Payroll Dist Tax Liab View

NA Payroll Distribution Tax Liability View

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.SEPCHK , A.STATE , A.LOCALITY , A.TAX_CLASS , A.WORK_PSD_CD , A.ACCT_CD , A.SEQNO , A.ADDL_NBR , A.ERNCD , A.ACCOUNT , A.TAX_CUR FROM PS_PAY_NA_TAX_DIST A WHERE A.PY_LIABEXPFLG IN ('L','R')

# 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 SEPCHK Number(1,0) SMALLINT NOT NULL Separate check number.
8 STATE Character(6) VARCHAR2(6) NOT NULL State
9 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
10 TAX_CLASS Character(1) VARCHAR2(1) NOT NULL Tax Balance Class
11 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
12 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

Prompt Table: ACCT_CD_TBL

13 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
14 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line #
15 ERNCD Character(3) VARCHAR2(3) NOT NULL Earnings Code
16 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
17 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax