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 (A.USED_BY = 'A' OR (A.USED_BY = 'C' AND B.USED_BY = 'A') OR (A.USED_BY = 'C' AND A.COUNTRY = B.COUNTRY)) AND (A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_GP_ABS_TYPE A1 WHERE A1.USED_BY = A.USED_BY AND A1.ABS_TYPE_OPTN = A.ABS_TYPE_OPTN AND A1.COUNTRY = A.COUNTRY AND A1.EFFDT <= %CurrentDateIn))

  • 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