GPCH_RP_TX3_HST

(SQL Table)
Index Back

GPCH_RP_TX03

This is the Archive (shadow) table used in Data Archiving for the record GPCH_RP_TX03 .

# 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

Prompt Table: PERSON

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 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
10 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
11 PRD_END_DT Date(10) DATE Pay Period End Date
12 SLICE_END_DT Date(10) DATE Element Slice End Date
13 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
14 GPCH_RP_YEAR Date(10) DATE Report Year
15 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
16 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

17 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton
18 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code
19 BEGIN_DT Date(10) DATE Begin Date
20 END_DT Date(10) DATE end date
21 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
22 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
23 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
24 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
25 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
26 GPCH_TX_STAXB_PCT Number(7,4) DECIMAL(6,4) NOT NULL Withholding Tax on Commission
27 GPCH_RP_AMOUNT6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value