GP_ABS_SS_ADD

(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.COUNTRY ,A.PIN_NUM , C.PIN_NM ,C.DESCR FROM PS_GP_ABS_TAKE A , PS_GP_ABS_TYPE B , PS_GP_PIN C , PS_GP_OPR_RULE_PRF D 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_SSADD_LV

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