RC_BP_DEFN_VW

(SQL View)
Index Back

Business Projects

Business Projects

SELECT RC_BUS_PROCESS_ID , EFFDT , SOURCE_PHASE , TARGET_PHASE , AUTOMATIC FROM PS_RC_BP_TRNS_TO

# 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 RC_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID used in Business Process tracking.
4 TARGET_PHASE Character(15) VARCHAR2(15) NOT NULL Target Phase
5 AUTOMATIC Character(1) VARCHAR2(1) NOT NULL This field is a flag for Business Process tracking to indicate whether a transition is Automatic or Manual.
A=Automatic
M=Manual