RC_BP_DEFN_VW(SQL View) |
Index Back |
|---|---|
Business ProjectsBusiness 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 | Character(15) | VARCHAR2(15) NOT NULL | Business Process ID used in Business Process tracking. | |
| 2 | Date(10) | DATE |
Effective Date
Default Value: %date |
|
| 3 | 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 |