GP_ABS_PINC_LVW

(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 %Concat ' ' %Concat C.COUNTRY , D.LANGUAGE_CD , C.PIN_NM , D.DESCR , C.COUNTRY FROM PS_GP_ABS_TAKE A , PS_GP_ABS_TYPE B , PS_GP_PIN C , PS_GP_PIN_LANG 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.PIN_NUM = D.PIN_NUM 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 for GP_ABS_PIN_CVW

    • # 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 ABS_PIN_CODE Character(22) VARCHAR2(22) NOT NULL Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 COUNTRY2 Character(3) VARCHAR2(3) NOT NULL Country