FS_SD_PROMPT_VW

(SQL View)
 Index Back

Prompt Records

Prompt Records for Supplemental Data

SELECT A.RECNAME ,B.RECDESCR ,B.RECTYPE ,B.DESCRLONG FROM PS_FS_SD_PROMPTREC A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME

  • Related Language Record: PSRECDEFNP_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFNPVW

    2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    3 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
    4 DESCRLONG Long Character CLOB Long Description