GPBR_SEFIP_ABSP

(SQL Table)
 Index Back

SEFIP Absence Parameters

SEFIP Absence Parameters

  • Parent record: GPBR_SEF_TKE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take
    2 ABSENCE_REASON Character(3) VARCHAR2(3) NOT NULL absence reason
    10=Vacations
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    5 GPBR_DAYS_BEFORE Number(3,0) SMALLINT NOT NULL This field is used to indicate how many days before the current date to show the history date range.
    6 GPBR_RETURN_CODE Character(2) VARCHAR2(2) NOT NULL Return Code
    7 GPBR_ABSENCE_CODE Character(2) VARCHAR2(2) NOT NULL Absence Code
    10=Sickness
    20=Work Accident
    30=Vacations

    Prompt Table: GPBR_SEF_ABS_VW

    8 GPBR_RETURN_CODE2 Character(2) VARCHAR2(2) NOT NULL Return Code
    9 GPBR_ABSENCE_CODE2 Character(2) VARCHAR2(2) NOT NULL Absence Code

    Prompt Table: GPBR_SEF_ABS_VW
    Set Control Field: GPBR_ABSENCE_CODE

    10 GPBR_MULTPLE_OCCUR Character(1) VARCHAR2(1) NOT NULL If It is Multiple Occurs

    Y/N Table Edit

    Default Value: N

    11 GPBR_RETURN_CODE3 Character(2) VARCHAR2(2) NOT NULL Return Code
    12 GPBR_ABSENCE_CODE3 Character(2) VARCHAR2(2) NOT NULL Absence Code

    Prompt Table: GPBR_SEF_ABS_VW
    Set Control Field: GPBR_ABSENCE_CODE