PC_ACT_STAT_CTL(SQL Table) |
Index Back |
|---|---|
Activity Status ControlActivity Status Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | ACTIVITY_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Activity Type
A=Activity Type E=Entry Type G=Group Type/Origin O=Activity Type/Origin R=Entry Type/Reason Prompt Table: PC_ACT_STAT_VW3 |
| 3 | PROJECT_STATUS |
Character(1) | VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted C=Closed H=Hold O=Open P=Proposed Prompt Table: PROJ_STATUS_TBL |
| 4 | BUSPROCNAME | Character(30) | VARCHAR2(30) NOT NULL |
Business Process Name (see PSBUSPROCDEFN).
Prompt Table: BUSPROCNAME_VW |
| 5 | ACTIVITYNAME | Character(30) | VARCHAR2(30) NOT NULL |
Name of a Business Process Activity (see PSACTIVITYDEFN).
Prompt Table: PC_BUSPRCACT_VW |
| 6 | EVENTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Defines a routing event for PS Workflow
Prompt Table: PC_ACTEVENT_VW |
| 7 | EMAIL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Email Notify for Status Change
N=No Y=Yes |