GP_ABS_TYPE_VW

(SQL View)
 Index Back

Search record for Absence Type

Used as search record for Absence Type component

SELECT B.OPRID , A.USED_BY , A.COUNTRY , A.ABS_TYPE_OPTN , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.REQUEST_IND FROM PS_GP_ABS_TYPE A , PS_GP_OPR_RULE_PRF B WHERE B.COUNTRY = 'ALL' OR (B.COUNTRY <> 'ALL' AND A.COUNTRY = B.COUNTRY) OR A.COUNTRY = 'ALL'

  • Related Language Record: GP_ABS_TYPE_LV

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
    A=All Countries
    C=Specific Country
    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: GP_CNTRY_OP2_VW

    4 ABS_TYPE_OPTN Character(3) VARCHAR2(3) NOT NULL Absence Type
    5 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    6 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    9 REQUEST_IND Character(1) VARCHAR2(1) NOT NULL This fields indicates if the country is allowed to add new Leave Request in the Self Service Absences Pages
    N=No
    Y=Yes