SUMLD_PROJSL_VW

(SQL View)
Index Back

Selected Project ID's

This View is used to prompt the valid values for certain Summary Ledger Chartfield. The values are stored in LED_SUMV_TBL table. The first three keys (SETID, LEDGER, CHARTFIELD) are matched with the values on the panel.

SELECT F.SETID ,F.LEDGER ,F.CHARTFIELD ,D.SETID ,D.PROJECT_ID ,D.DESCR FROM PS_LED_FLDS_TBL F ,PS_LED_SUMV_TBL V ,PS_PROJECT_ID_VW D WHERE V.LEDGER=F.LEDGER AND V.SETID=F.SETID AND V.FIELD_SEQUENCE=F.FIELD_SEQUENCE AND D.PROJECT_ID = V.SELECT_VALUE

  • Related Language Record: SUMLD_PROJSLLNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 DTL_SETID Character(5) VARCHAR2(5) NOT NULL Tree Structure Summary Detail Tree SetId
    5 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description