GPUS_GRN_WA_HST

(SQL Table)
Index Back

FederalTax Data Writable Array

This is the Archive (history/shadow) table used in Data Archiving for the record: GPUS_GRN_FTX_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 Rcd Nbr
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 CALC_SEQ_NUM Number(9,0) DECIMAL(9) NOT NULL Calc Seq Num
11 GPUS_GRN_ID Character(16) VARCHAR2(16) NOT NULL GPUS_GARNID
12 GPUS_FTAXDED_TYPE Character(2) VARCHAR2(2) NOT NULL Deduction Type
10=Initial Deduction
20=Adjustment

Default Value: 10

13 GPUS_DED_STARTDT Date(10) DATE NOT NULL GPUS_STARTDT
14 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: GPUS_FEDLEVY_VW

15 GPUS_MONVALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Monetary Value
16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

17 GPUS_DECVALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL Decimal Value
18 CALC_RULE Character(2) VARCHAR2(2) NOT NULL Function Library field
AM=Amount
PB=Base * Percent
RP=Unit * Rate * Percent
RU=Unit * Rate
19 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base
20 PIN_BASE_NUM Number(8,0) INTEGER NOT NULL PIN-Number Base
21 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount