SCC_SL_KEY_ADMN

(SQL Table)
 Index Back

LOV Prompt Keys

  • Related Language Record: SCC_KEY_ADMN_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID
    2 SCC_SL_LOV_CONTEXT Character(25) VARCHAR2(25) NOT NULL LOV Context
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSRECFIELD

    5 SCC_SL_KEYFIELD Character(18) VARCHAR2(18) NOT NULL Field Name

    Prompt Table: SCC_EDTTBL_VW4

    6 SCC_SL_KEY_SOURCE Character(1) VARCHAR2(1) NOT NULL Source
    C=Constant
    R=Request XML

    Default Value: R

    7 FIELD_CHAR Character(200) VARCHAR2(200) NOT NULL Field Char
    8 SCC_SL_BLANKS Character(1) VARCHAR2(1) NOT NULL Allow Blanks

    Y/N Table Edit

    Default Value: N

    9 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    10 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    11 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    12 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time