GPIT_ABS_VERREV

(SQL Table)
Index Back

WA Table for Absence Wk Data

WA Table for Absence Weekly Data

# 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 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
9 MONTHOFYEAR Number(2,0) SMALLINT NOT NULL Month of Year
10 WEEKOFYEAR Number(2,0) SMALLINT NOT NULL Week Of Year
11 TAKE_CONFIG1 Character(10) VARCHAR2(10) NOT NULL Field reserved for custom attribution to an Absence Take
12 ABS_BGN_DT Date(10) DATE Absence Begin Date
13 GPIT_SAT_DATE Date(10) DATE Date of the next Saturday
14 DURATION_DAYS Number(7,3) DECIMAL(6,3) NOT NULL Duration (Days)
15 GPIT_WEEK_ABSN_HRS Number(6,2) DECIMAL(5,2) NOT NULL Absence Hours for the Week (WA table)
16 GPIT_DAYS_MON_SAT Number(2,0) SMALLINT NOT NULL Absence Days from Monday to Saturday
17 GPIT_SS_PAYMNT Number(19,6) DECIMAL(18,6) NOT NULL Social Secutiy Payment
18 GPIT_SS_PMNT_GROSS Number(19,6) DECIMAL(18,6) NOT NULL Social Security Payment Gross Value
19 GPIT_COMPNY_INTEGR Signed Number(20,6) DECIMAL(18,6) NOT NULL Company Integration to the Gross Social Security Payment
20 GPIT_CMP_HLDY_INT Number(19,6) DECIMAL(18,6) NOT NULL Company Holiday Integration
21 GPIT_ABS_DEDUCTION Number(19,6) DECIMAL(18,6) NOT NULL Absence Deduction
22 GPIT_DAYS_HDY_CPAY Number(2,0) SMALLINT NOT NULL Days of Holiday Company Payment
23 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code