SCC_LOV_SRCH_V3

(SQL View)
 Index Back

LOV view


SELECT A.SCC_LOV_UID ,A.DESCR ,%Substring(CASE A.SCC_LOV_TYPE WHEN '01' THEN ('Ad Hoc values ') WHEN '02' THEN ('Prompt on ' %Concat A.EDITTABLE %Concat '.' %Concat A.PROMPTFIELD) WHEN '03' THEN ('Translate values of ' %Concat A.PROMPTFIELD) END ,1,100) ,A.RECNAME ,A.FIELDNAME ,A.SCC_SL_LOV_CONTEXT FROM PS_SCC_SL_LOV_HDR A

  • Related Language Record: SCC_LOV_SRCH_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSRECFIELDALL

    6 SCC_SL_LOV_CONTEXT Character(25) VARCHAR2(25) NOT NULL LOV Context