SCC_CAF_EDTB_VW

(SQL View)
Index Back

LOV Edit table prompt

LOV Edit table prompt view

SELECT A.RECNAME , A.RECTYPE , A.RECDESCR FROM PSRECDEFN A , PS_SCC_SL_LOV_HDR B WHERE RECTYPE IN (0,1) AND (A.RECNAME = B.EDITTABLE OR A.RECNAME = B.SCC_EDITTABLE)

  • Related Language Record: SCC_SL_EDTBL_LN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 RECTYPE Number(1,0) SMALLINT NOT NULL Record Type
    0=SQL Table
    1=SQL View
    2=Derived Work/Record
    3=Subrecord
    5=Dynamic View
    6=Query View
    7=Temporary Table
    3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description