GPUS_FDSM_TMP

(SQL Table)
Index Back

Tax Report Temporary Table

Temporary table used by Tax Reports. This table is populated by Report Data.

# 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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
11 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
12 GPUS_YE_RPT_CO Character(3) VARCHAR2(3) NOT NULL Year-End Reporting Company
13 STATE Character(6) VARCHAR2(6) NOT NULL State
14 GPUS_TAX_RPT_TYPE Character(2) VARCHAR2(2) NOT NULL Tax Report Type
10=W-2
20=W-2AS
30=W-2GU
40=W-2PR
50=W-2VI
60=1099-R
70=1099-MISC
15 GPUS_TAX_CATEGORY Character(2) VARCHAR2(2) NOT NULL Tax Category
01=Withholding
02=OASDI Employee
03=OASDI Employer
04=Medicare Employee
05=Medicare Employer
06=FUTA
07=Earned Income Credit
16 PYMT_DT Date(10) DATE Payment Date
17 GPUS_TAX_NL_GRS Number(16,6) DECIMAL(15,6) NOT NULL Non Limited Taxable Gross
18 GPUS_TAX_GRS Number(16,6) DECIMAL(15,6) NOT NULL Taxable Gross
19 GPUS_TAX_AMT Signed Number(17,6) DECIMAL(15,6) NOT NULL Tax Amount