GP_ABS_ANLY_LNG

(SQL Table)
Index Back

Absence analytics record

Absence analytics record

  • Related Language Record for GP_ABS_ANLYTICS
  • # 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 Record
    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 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    9 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
    10 ABS_BGN_DT Date(10) DATE Absence Begin Date
    11 ABS_END_DT Date(10) DATE Absence End Date
    12 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
    13 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
    14 PRD_BGN_DT Date(10) DATE Period Begin Date
    15 PRD_END_DT Date(10) DATE Pay Period End Date
    16 ELIG_IND Character(1) VARCHAR2(1) NOT NULL Eligibility Indicator
    17 MIN_IND Character(1) VARCHAR2(1) NOT NULL Minimum Period Indicator
    18 LINKED_IND Character(1) VARCHAR2(1) NOT NULL Linked Indicator
    19 PIN_MAP_TO_NUM Number(8,0) INTEGER NOT NULL Element number field
    20 PIN_SOURCE_NUM Number(8,0) INTEGER NOT NULL Element number field
    21 PIN_NEG_ABS_NUM Number(8,0) INTEGER NOT NULL Element number field
    22 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    25 ABS_REASON_DESCR Character(30) VARCHAR2(30) NOT NULL Absence Reason
    26 DESCR35_A Character(35) VARCHAR2(35) NOT NULL Job Offer
    27 DESCR35_B Character(35) VARCHAR2(35) NOT NULL Notifications
    28 DESCR35_C Character(35) VARCHAR2(35) NOT NULL Submitted Applications
    29 ACTION_DESCR Character(50) VARCHAR2(50) NOT NULL Action Description
    30 GP_HR_ACTION_DESCR Character(30) VARCHAR2(30) NOT NULL GP_HR_ACTION_DESCR