SCC_LOV_SRCH_V2

(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 WHERE A.SCC_LOV_TYPE = '01'

# 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