LED_DRILL_CF_VW

(SQL View)
 Index Back

RTBL Ledger Drill ChartFields

RTBL Ledger Drill ChartFields view to display the longname for the ChartField instead of the fieldname.

SELECT DISTINCT A.CHARTFIELD , B.LONGNAME FROM PS_LED_DRILL_CF A , PSDBFLDLABL_VW B WHERE A.CHARTFIELD = B.FIELDNAME

  • Parent record: LED_INQ_CRIT

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

    Prompt Table: PSDBFLDLABL_VW

    2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name