SCC_SL_LOV_HDR

(SQL Table)
 Index Back

LOV Header record

  • Related Language Record: SCC_LOV_HDR_LNG

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

    5 SCC_SL_LOV_OPT Character(3) VARCHAR2(3) NOT NULL LOV Context
    DEF=Default
    TC=CTM Transaction Code
    UD=User Defined Context
    6 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

    Prompt Table: SCC_SL_EDTBL_VW

    7 SCC_EDITTABLE Character(15) VARCHAR2(15) NOT NULL Admin mode edit table

    Prompt Table: SCC_SL_EDTBL_VW

    8 PROMPTFIELD Character(18) VARCHAR2(18) NOT NULL Dropdown Prompt Field

    Prompt Table: %EDITTABLE
    Set Control Field: EDITTABLE

    9 SCC_PROMPTFIELD Character(18) VARCHAR2(18) NOT NULL Admin mode prompt field

    Prompt Table: SCC_EDTTBL_VW2

    10 FIELDNAME_DESCR Character(18) VARCHAR2(18) NOT NULL Fieldname Journal Line Descr

    Prompt Table: SCC_EDTTBL_VW
    Set Control Field: EDITTABLE

    11 SCC_FIELDNAME_DESC Character(18) VARCHAR2(18) NOT NULL Admin mode fieldname description

    Prompt Table: SCC_EDTTBL_VW4

    12 SCC_SL_TRANSLATE Character(1) VARCHAR2(1) NOT NULL Translate Usage
    L=Use Long Description
    S=Use Short Description

    Default Value: L

    13 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: SCC_SL_LOV_HDR.RECNAME

    14 SCC_LOV_TYPE Character(2) VARCHAR2(2) NOT NULL CAF Value Type
    01=Ad Hoc Values
    02=Table
    03=Translate Values

    Default Value: 02

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

    Prompt Table: SCC_LOVDBFLD_VW

    16 SCC_LOV_WS_ENABLE Character(1) VARCHAR2(1) NOT NULL Enable for Web Service

    Y/N Table Edit

    Default Value: N

    17 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    18 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    19 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    20 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time