GPIT_CUD_WA

(SQL Table)
 Index Back

Table for WA 'CUD WA DATICUD'

Table which contains the data of the Writable Array 'CUD WA DATICUD'

# 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 SLICE_END_DT Date(10) DATE Element Slice End Date
9 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
10 GPIT_CUD_QUALIF Character(1) VARCHAR2(1) NOT NULL Field for CUD Report
11 GPIT_GG_INPS Number(2,0) SMALLINT NOT NULL INPS days for reports
12 GPIT_SETT_INPS Number(1,0) SMALLINT NOT NULL INPS weeks for reports
13 GPIT_INPS_PTWEEKS Number(5,2) DECIMAL(4,2) NOT NULL INPS part time weeks
14 GPIT_CUD_STAMPA Character(1) VARCHAR2(1) NOT NULL Population for CUD Printing
0=TFR Not Payed
1=TFR Payed
2=All
15 GPIT_CUD_FISCOOK Number(1,0) SMALLINT NOT NULL Field for CUD Report
16 GPIT_CUD_PREVOK Number(1,0) SMALLINT NOT NULL Contribution part for CUD
17 GPIT_TFR_FUND Number(19,6) DECIMAL(18,6) NOT NULL TFR fund for reports
18 GPIT_TFR_FLAGPAG Number(1,0) SMALLINT NOT NULL Field for the Previdential CUD Control which contains the flag TFR already paid
19 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
20 GPIT_FPC_TYP Character(2) VARCHAR2(2) NOT NULL Complementary Fund Type