GPSC_RM_PIN_LNG

(SQL Table)
Index Back

Remote PayItem Name - Rel Lang

Remote PayItem Name - Rel Lang

  • Related Language Record for GPSC_RM_PIN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    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_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 COMMENTS Long Character CLOB Comment