GP_ABS_SSADD_LV

(SQL View)
 Index Back

Rel Lang Pin Take Prompt SS

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

SELECT DISTINCT B.COUNTRY ,C.COUNTRY ,A.PIN_NUM ,E.LANGUAGE_CD ,E.PIN_NM ,E.DESCR FROM PS_GP_ABS_TAKE A , PS_GP_ABS_TYPE B , PS_GP_PIN C , PS_GP_PIN_LANG E 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 C.PIN_NUM = E.PIN_NUM AND A.PIN_NUM = E.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 for GP_ABS_SS_ADD

    • # 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 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