GPUS_W4IRS_TMP

(SQL Table)
Index Back

IRS Report Temporary

IRS Report Temporary

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
4 EFFDT Date(10) DATE Effective Date

Default Value: %date

5 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
6 ADD_FLD1_NAME Character(50) VARCHAR2(50) NOT NULL Additional Field 1 Name
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 STATE Character(6) VARCHAR2(6) NOT NULL State
10 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
11 GPUS_FWT_MAR_ST Character(1) VARCHAR2(1) NOT NULL Tax Marital Status
H=Head of Household
M=Married
S=Single
W=Married/Withhold Single
W=Married/Withhold Single
12 GPUS_FWT_STATUS Character(1) VARCHAR2(1) NOT NULL Tax Withholding Status
E=No taxable gross; no tax taken
G=Maintain taxable gross; no FWT
N=None
13 GPUS_FWT_ALLOW Number(3,0) SMALLINT NOT NULL Withholding Allowances
14 GPUS_FWT_ADD_AMTC Character(18) VARCHAR2(18) NOT NULL Additional Amount
15 FEDERAL_EIN Number(9,0) DECIMAL(9) NOT NULL Federal EIN
16 DESCR Character(30) VARCHAR2(30) NOT NULL Description
17 ADDRESS2_OTHER Character(55) VARCHAR2(55) NOT NULL Address 2 Other
18 CITY_OTHER Character(30) VARCHAR2(30) NOT NULL City Other
19 STATE_OTHER Character(6) VARCHAR2(6) NOT NULL State Other
20 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
21 GPUS_TRANS_CNTL_CD Character(5) VARCHAR2(5) NOT NULL Transmitter Control Code