CF_PRMPTRECS_VW

(SQL View)
 Index Back

Distinct SetID/Chartfield/Recs


select distinct A.SETID, A.CHARTFIELD, A.RECNAME, B.RECDESCR from PS_LED_FLDS_TBL A, PSRECDEFN B where B.RECNAME=A.RECNAME

  • Parent record: LED_DEFN_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField

    Prompt Table: RECFIELD_VW

    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

    4 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description