SSF_PAY_TAX_VW

(SQL View)
 Index Back

U.S. Payroll Tax

This view contains employee paycheck tax information.

SELECT COMPANY ,PAYGROUP ,PAY_END_DT ,OFF_CYCLE ,PAGE_NUM ,LINE_NUM ,SEPCHK ,STATE ,LOCALITY ,TAX_CLASS ,RESIDENT ,NLGRS_CUR ,TXGRS_CUR ,TAX_CUR ,TXGRS_AGG ,TAX_AGG ,TAX_NOT_TAKEN ,TIPS_CUR ,TIPS_DELAYED ,AP_STATUS ,GVT_SCHEDULE_NO ,GVT_PAY_ID_LINE_1 ,GVT_PAY_ID_LINE_2 ,GVT_ECS_LTD_INDIC ,GVT_ECS_OFF_ACCT ,GVT_RITS_DT ,GVT_TSP_SEQ_YR ,GVT_TSP_SEQ_NO FROM PS_PAY_TAX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
3 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?

Y/N Table Edit

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 RESIDENT Character(1) VARCHAR2(1) NOT NULL Resident

Y/N Table Edit

12 NLGRS_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current No Limit Gross
13 TXGRS_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Taxable Gross
14 TAX_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tax
15 TXGRS_AGG Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax Gross Aggregate
16 TAX_AGG Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax Aggregate
17 TAX_NOT_TAKEN Signed Number(12,2) DECIMAL(10,2) NOT NULL Tax Not Taken
18 TIPS_CUR Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tips subject to tax
19 TIPS_DELAYED Signed Number(12,2) DECIMAL(10,2) NOT NULL Current Tips Delayed for W/H
20 AP_STATUS Character(1) VARCHAR2(1) NOT NULL AP Status
S=Sent to AP
X=Extracted
21 GVT_SCHEDULE_NO Character(14) VARCHAR2(14) NOT NULL Schedule Number
22 GVT_PAY_ID_LINE_1 Character(40) VARCHAR2(40) NOT NULL Payment ID Line 1
23 GVT_PAY_ID_LINE_2 Character(40) VARCHAR2(40) NOT NULL Payment ID Line 2
24 GVT_ECS_LTD_INDIC Character(1) VARCHAR2(1) NOT NULL LTD Pay Indicator
25 GVT_ECS_OFF_ACCT Character(16) VARCHAR2(16) NOT NULL Account Symbol
26 GVT_RITS_DT Date(10) DATE Track processing date of Occ Cycle RITS deductions
27 GVT_TSP_SEQ_YR Number(2,0) SMALLINT NOT NULL TSP Voucher Number
28 GVT_TSP_SEQ_NO Number(4,0) SMALLINT NOT NULL Voucher Seq No