GP_ELN_ATTR_SET

(SQL Table)
 Index Back

Element List Attribute (Set)

Element List Attribute (Set)

  • Related Language Record: GP_ELN_SET_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: ALL

    Prompt Table: GP_COUNTRY

    2 GP_ELN_APP Character(15) VARCHAR2(15) NOT NULL ELN Application
    3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 1

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 GP_ELN_ATTR_TYP Character(1) VARCHAR2(1) NOT NULL Attribute Type for Application Setup
    1=Edit Box
    2=Check Box
    3=Drop Down List
    4=Translate

    Default Value: 1

    6 GP_ELN_ATTR Character(20) VARCHAR2(20) NOT NULL ELN Attribute
    7 PROMPTVIEW Character(18) VARCHAR2(18) NOT NULL Element Entry Prompt View

    Prompt Table: GP_PSRECDEFN_VW

    8 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    9 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data