WM_SUBREC_VW

(SQL View)
Index Back

Record Prompt View

Record Definition Prompt view - where criteria limits Record Type to sub records.

SELECT A.RECNAME ,A.RECDESCR FROM PSRECDEFN A WHERE A.RECTYPE = 3 AND A.RECNAME IN ('WM_MOVE_SBR')

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