GPSC_ELM_PINCNT

(SQL View)
 Index Back

Element List View

Element Browser Element List View

SELECT PIN_NM ,PIN_NUM , COUNTRY , PIN_CODE , PIN_TYPE , DESCR , GP_VERSION FROM PS_GP_PIN WHERE PIN_NUM <= 50000000 UNION SELECT A.PIN_NM ,B.PIN_NUM_TGT , A.COUNTRY , A.PIN_CODE , A.PIN_TYPE , A.DESCR , A.GP_VERSION FROM PS_GP_PIN A , PS_GP_ELM_BR_PKG B WHERE B.GP_PKG_NEW_PIN_FLG='Y' AND A.PIN_NUM=(50000000+B.PIN_NUM)

  • Related Language Record: GPSC_PNCNT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

    Default Value: 999999

    3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    4 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
    5 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.