PY_MOD_TCHNG_VW

(SQL View)
 Index Back

Paycheck Modeling Tax Changes

Paycheck Modeling Tax Changes View

SELECT ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , ' ' , ' ' , 0 , ' ' , 0 , 0 , ' ' , ' ' , ' ' , 0 , 0 , 0 , ' ' , ' ' , 0 , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , 0 , 0 , 0 , ' ' , 0 , 0 , 0 , 0 , ' ' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PY_MOD_TAX_JRSDCTN Character(1) VARCHAR2(1) NOT NULL Paycheck Modeling Tax Jurisdiction
A=Federal
B=State
C=Local
2 STATE Character(6) VARCHAR2(6) NOT NULL State
3 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
4 PY_MOD_DESCR60_LBL Character(75) VARCHAR2(75) NOT NULL Tax Jurisdiction
5 CHANGE_CODE Character(1) VARCHAR2(1) NOT NULL Whether this record represents an New, Change, Delete or initial load. Used in discounts and perks eligibility file.
C=Change
D=Delete
I=Initial Load
N=New
6 SWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL SWT Marital/Tax Status
7 SWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL Withholding Allowances
8 SWT_ADDL_AMT Signed Number(9,2) DECIMAL(7,2) NOT NULL SWT Additional Amount
9 SWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL SWT Additional Percentage
10 MARRIED_FILE_SINGL Character(1) VARCHAR2(1) NOT NULL Married Filing Single
11 EIC_STATUS Character(1) VARCHAR2(1) NOT NULL Earned Income Credit Status
M=Married, both spouses filing
N=Not applicable
S=Single,or Head of Household
U=Married without spouse filing
12 SWT_ADDL_ALLOWNCES Number(3,0) SMALLINT NOT NULL Additional Allowances
13 EIC_STATUS_ST Character(1) VARCHAR2(1) NOT NULL Earned Income Credit
14 ANNL_EXEMPTION_AMT Number(8,0) INTEGER NOT NULL MS Annual Exemption Amount
15 PERCENT_OF_FWT Number(6,3) DECIMAL(5,3) NOT NULL AZ Withholding Percent
16 ADDL_AMT_ADJ Character(1) VARCHAR2(1) NOT NULL Additional Amount Adjustment
D=Decrease Additional Amount
I=Increase Additional Amount
17 WT4A_FILED Character(1) VARCHAR2(1) NOT NULL Designates that Form WT-4A has been filed to allow the addiitonal amount to be used as a standing Flat Tax Amount. As such, Reciprocity rules are enforced.
18 FWT_MAR_STATUS Character(1) VARCHAR2(1) NOT NULL FWT Marital Status
H=Head of Household
M=Married
S=Single
X=Exempt
19 FWT_ALLOWANCES Number(3,0) SMALLINT NOT NULL FWT Allowances
20 FWT_ADDL_AMT Number(8,2) DECIMAL(7,2) NOT NULL FWT Additional Amount
21 FWT_ADDL_PCT Number(6,3) DECIMAL(5,3) NOT NULL FWT Additional Percentage
22 MARRIED Character(1) VARCHAR2(1) NOT NULL Student Married
1=Yes
2=No
23 STATUS_VALUE Character(1) VARCHAR2(1) NOT NULL Status Value
24 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
25 STATUS_IND Character(1) VARCHAR2(1) NOT NULL Status Include Exclude Ind
0=Include
1=Exclude
26 EXEMPTION_AMT Number(9,0) DECIMAL(9) NOT NULL Exemption Amount
27 FWT_ADDL_PCT_TAX Number(6,3) DECIMAL(5,3) NOT NULL FWT Additional Percentage
28 ADDL_TAXES Character(1) VARCHAR2(1) NOT NULL Additional Taxes
29 FILED_BY Character(1) VARCHAR2(1) NOT NULL Filed By
E=Employee/Applicant
O=Other
U=Union
30 FWT_FORM_VERSION Character(1) VARCHAR2(1) NOT NULL 2020 W4 - to indicate if the tax data is based on 2019 W4 form or 2020 W4 form.
A=W-4 - 2019 or Earlier
B=W-4 - 2020 or Later
C=W-4P - 2022 or Later
D=W-4R - 2022 or Later

Default Value: A

31 FWT_MULTI_JOBS Character(1) VARCHAR2(1) NOT NULL 2020 W4 changes - Multiple Jobs Indicator

Y/N Table Edit

Default Value: N

32 FWT_TTL_DEP_AMT Number(11,2) DECIMAL(10,2) NOT NULL 2020 W4 - Total Dependent Amount
33 FWT_OTH_INCOME Number(11,2) DECIMAL(10,2) NOT NULL 2020 W4 - Other Income
34 FWT_DED_ADJ Number(11,2) DECIMAL(10,2) NOT NULL 2020 W4 - Deduction Adjustment
35 FWT_MULTI_JOBS_PM Character(1) VARCHAR2(1) NOT NULL 2020 W4 changes - Multiple Jobs Indicator
36 FWT_TTL_DEP_AMT_PM Number(11,2) DECIMAL(10,2) NOT NULL 2020 W4 - Total Dependent Amount
37 FWT_OTH_INCOME_PM Number(11,2) DECIMAL(10,2) NOT NULL 2020 W4 - Other Income
38 FWT_DED_ADJ_PM Number(11,2) DECIMAL(10,2) NOT NULL 2020 W4 - Deduction Adjustment
39 ANNL_EXEMP_AMT_FRM Number(8,0) INTEGER NOT NULL MS Annual Exemption Amount
40 PY_SWT_FORM_RECVD Character(1) VARCHAR2(1) NOT NULL State form received.
B=Received - Line 2 Blank
N=Form Not Received
Y=Received - Line 2 Not Blank

Y/N Table Edit

Default Value: N