PC_REQUEST_IDPC_REQUEST_TYPEPrompt Table: PC_REQUEST_TYPE
PC_REQUEST_DESCRTEAM_MEMBERPrompt Table: PC_ALLEMP_VW
E=Employee
G=Generic Resource
N=Not Applicable
A=Asset
L=Labor
M=Material
O=Other
Prompt Table: PC_PROJROLE_VW
N=No
Y=Yes
PC_PRQ_PRJ_TEAM(SQL Table) |
Index Back |
|---|---|
Team Request |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PC_REQUEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | Request Id |
| 2 | PC_REQUEST_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Request Type
Prompt Table: PC_REQUEST_TYPE |
| 3 | PC_REQUEST_DESCR |
Character(254) | VARCHAR2(254) NOT NULL | Request Description |
| 4 | TEAM_MEMBER |
Character(30) | VARCHAR2(30) NOT NULL |
Team Member
Prompt Table: PC_ALLEMP_VW |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 7 | TEAM_MEMBER_IND | Character(1) | VARCHAR2(1) NOT NULL |
Team Member Indicator
E=Employee G=Generic Resource N=Not Applicable |
| 8 | TEAM_MEMBER_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
05/26/2004 - FS
Translate Value "O" added.
A=Asset L=Labor M=Material O=Other |
| 9 | PLAN_STARTDT | Date(10) | DATE | Planned Start Date |
| 10 | PLAN_ENDDT | Date(10) | DATE | Planned End Date |
| 11 | PLAN_PROJROLE | Character(15) | VARCHAR2(15) NOT NULL |
Requirement Project Role
Prompt Table: PC_PROJROLE_VW |
| 12 | EMAIL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Email Notify for Status Change
N=No Y=Yes |