GPUS_NRP_ST_VW

(SQL View)
 Index Back

State Tax Results

Writable Array Table used to store all the information used for Tax Calculation during payroll.

SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , PIN_NUM+50000000 , INSTANCE , CALC_SEQ_NUM , STATE , GPUS_TAX_EIN , GPUS_SWT_EIN , FREQUENCY_TYPE , COMPANY , GPUS_YE_RPT_CO , GPUS_TAX_NL_GRS , GPUS_TAX_GRS , GPUS_TAX_AMT , GPUS_TAX_PCT FROM PS_GPUS_RSLT_ST_WA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
10 CALC_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL Calc Seq Num
11 STATE Character(6) VARCHAR2(6) NOT NULL State
12 GPUS_TAX_EIN Character(9) VARCHAR2(9) NOT NULL Federal Employer Identification Number
13 GPUS_SWT_EIN Character(20) VARCHAR2(20) NOT NULL Employer Identification Number (SWT)
14 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
15 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
16 GPUS_YE_RPT_CO Character(3) VARCHAR2(3) NOT NULL Year-End Reporting Company
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
20 GPUS_TAX_PCT Number(7,3) DECIMAL(6,3) NOT NULL Tax Percent