BUSINESS_UNITPROJECT_IDA=Active
I=Inactive
P=Pending
A=Active
I=Inactive
PC_WC_PROJ_TEAM(SQL Table) |
Index Back |
|---|---|
Project Team WorkCenterThis Record has been created for the Project Team WorkCenter Grid. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PROCESSING_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Processing status
A=Active I=Inactive P=Pending |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 9 | PROJ_MGR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Project Manager Review |
| 10 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 11 | PLAN_PROJROLE | Character(15) | VARCHAR2(15) NOT NULL | Requirement Project Role |
| 12 | PLAN_STARTDT | Date(10) | DATE | Planned Start Date |
| 13 | PLAN_ENDDT | Date(10) | DATE | Planned End Date |
| 14 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 15 | ACT_END_DT | Date(10) | DATE | Activity End Date |
| 16 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |