GP_ABS_PIN_VW

(SQL View)
 Index Back

Pin Take prompt self-service

This is the prompt for Pin Take number on add search record for country/take self-service configuration.

SELECT DISTINCT B.COUNTRY , C.PIN_NUM , C.PIN_NM ,C.DESCR ,C.COUNTRY , C.PIN_NUM FROM PS_GP_ABS_TAKE A , PS_GP_ABS_TYPE B , PS_GP_PIN C WHERE A.EFF_STATUS = 'A' AND B.EFF_STATUS = 'A' AND A.ABS_TYPE_OPTN = B.ABS_TYPE_OPTN AND A.PIN_NUM = C.PIN_NUM AND B.REQUEST_IND = 'Y' AND C.PIN_TYPE = 'AT' AND (C.USED_BY = 'A' OR (C.USED_BY = 'C' AND B.COUNTRY = C.COUNTRY )) AND C.PIN_NUM NOT IN ( SELECT SS.PIN_TAKE_NUM FROM PS_GP_ABS_SS SS WHERE B.COUNTRY=SS.COUNTRY)

  • Related Language Record: GP_ABS_PIN_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country
    6 PIN_TAKE_NUM Number(8,0) INTEGER NOT NULL Absence Take