GPIT_CUD_WA_HST

(SQL Table)
Index Back

Table for WA 'CUD WA DATICUD'

This is the Archive (shadow) table used in Data Archiving for the record: GPIT_CUD_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 SLICE_END_DT Date(10) DATE Element Slice End Date
11 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
12 GPIT_CUD_QUALIF Character(1) VARCHAR2(1) NOT NULL Field for CUD Report
13 GPIT_GG_INPS Number(2,0) SMALLINT NOT NULL INPS days for reports
14 GPIT_SETT_INPS Number(1,0) SMALLINT NOT NULL INPS weeks for reports
15 GPIT_INPS_PTWEEKS Number(5,2) DECIMAL(4,2) NOT NULL INPS part time weeks
16 GPIT_CUD_STAMPA Character(1) VARCHAR2(1) NOT NULL Population for CUD Printing
0=TFR Not Payed
1=TFR Payed
2=All
17 GPIT_CUD_FISCOOK Number(1,0) SMALLINT NOT NULL Field for CUD Report
18 GPIT_CUD_PREVOK Number(1,0) SMALLINT NOT NULL Contribution part for CUD
19 GPIT_TFR_FUND Number(19,6) DECIMAL(18,6) NOT NULL TFR fund for reports
20 GPIT_TFR_FLAGPAG Number(1,0) SMALLINT NOT NULL Field for the Previdential CUD Control which contains the flag TFR already paid
21 GPIT_CUD_LABAGREEM Character(3) VARCHAR2(3) NOT NULL Field for the Previdential CUD Report which contains the LABOR_AGREEMENT kept from the bracket GEN BR LABAGREEM
22 GPIT_FPC_TYP Character(2) VARCHAR2(2) NOT NULL Complementary Fund Type