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 | 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 |