GP_ABS_CS_RECVW

(SQL View)
 Index Back

Record definition prompt view

Configurable Sections: View against PSRECDEFN to be used for prompting. Includes only records of types 1 (SQL table) that have EMPLID, EMPL_RCD and TRANSACTION_NBR as key.

SELECT A.RECNAME ,A.RECDESCR FROM PSRECDEFN A WHERE A.RECTYPE = 0 AND EXISTS ( SELECT 'X' FROM PSRECFLDKEYSVW B WHERE A.RECNAME = B.RECNAME AND FIELDNAME = 'EMPLID') AND EXISTS ( SELECT 'X' FROM PSRECFLDKEYSVW B WHERE A.RECNAME = B.RECNAME AND FIELDNAME = 'EMPL_RCD') AND EXISTS ( SELECT 'X' FROM PSRECFLDKEYSVW B WHERE A.RECNAME = B.RECNAME AND FIELDNAME = 'TRANSACTION_NBR')

  • Related Language Record: GP_ABS_RCLKVWL

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