GPUS_RST_WA_HST

(SQL Table)
Index Back

State Tax Results

This is the Archive (history/shadow) table used in Data Archiving for the record: GPUS_RSLT_ST_WA.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
10 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
11 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
12 CALC_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL Calc Seq Num
13 STATE Character(6) VARCHAR2(6) NOT NULL State
14 GPUS_TAX_EIN Character(9) VARCHAR2(9) NOT NULL Federal Employer Identification Number
15 GPUS_SWT_EIN Character(20) VARCHAR2(20) NOT NULL Employer Identification Number (SWT)
16 FREQUENCY_TYPE Character(1) VARCHAR2(1) NOT NULL Indicates the type of a frequency ID.
A=Annual
B=Biweekly
C=Contract
D=Daily
F=Every Four Weeks
H=Hourly
M=Monthly
Q=Quarterly
S=Semimonthly
W=Weekly
17 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
18 GPUS_YE_RPT_CO Character(3) VARCHAR2(3) NOT NULL Year-End Reporting Company
19 GPUS_TAX_NL_GRS Number(16,6) DECIMAL(15,6) NOT NULL Non Limited Taxable Gross
20 GPUS_TAX_GRS Number(16,6) DECIMAL(15,6) NOT NULL Taxable Gross
21 GPUS_TAX_AMT Signed Number(17,6) DECIMAL(15,6) NOT NULL Tax Amount
22 GPUS_TAX_PCT Number(7,3) DECIMAL(6,3) NOT NULL Tax Percent