RC_BUS_PROJ_VW

(SQL View)
Index Back

Business Process

This table will store Business Processes. These Business Processes will be attached to cases to control progress through cases that require many tasks.

SELECT rc_bus_process_id , effdt ,BUS_PROJ_TYPE , descr FROM PS_RC_BUS_PROCESS

  • Related Language Record: RC_BUS_PROJ_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RC_BUS_PROCESS_ID Character(15) VARCHAR2(15) NOT NULL Business Process ID used in Business Process tracking.
    2 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    3 BUS_PROJ_TYPE Character(1) VARCHAR2(1) NOT NULL Business Project Type
    M=Main Business Project
    N=Sub-Business Project
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description