GPDE_DV_FABNRAD

(SQL Table)
Index Back

DEUEV Flat Absence Table

DEUEV Flat Absence Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_PKG_ID Character(10) VARCHAR2(10) NOT NULL Field used for element packaging
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GPDE_DV_AB_CODE Character(2) VARCHAR2(2) NOT NULL DEUEV Absence Code
6 EFFDT Date(10) DATE Effective Date
7 ABS_BGN_DT Date(10) DATE Absence Begin Date
8 ABS_END_DT Date(10) DATE Absence End Date
9 ABS_PRD_BGN_DT Date(10) DATE Absence Period Begin Date
10 ABS_PRD_END_DT Date(10) DATE Absence Period End Date
11 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
12 PIN_TK_NUM Number(8,0) INTEGER NOT NULL Element number field
13 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
14 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit
15 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
16 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
17 JOB_EFFDT Date(10) DATE Job Effective Date