SP_PRJBCF_NONVW

(SQL View)
Index Back

Project ID BU GL View

Uses PROJECT_TBL for SETID indirection

SELECT BUSINESS_UNIT , PROJECT_ID , DESCR FROM PS_PROJECT WHERE SUMMARY_PRJ = 'N' AND EFF_STATUS = 'A'

  • Related Language Record: BANK_CF_PROJ_LG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description