POOL_IDPrompt Table: RS_POOL_MEMBER
MEMBER_IDPrompt Table: RS_POOL_MEMBER
SCHED_NUMDefault Value: 1
Prompt Table: RS_ACT_EMPL
AL=Allocated
CA=Cancelled
CM=Committed
CO=Considered
CP=Completed
RE=Rejected
RQ=Requested
RS_POOLRES_TMP(SQL Table) |
Index Back |
|---|---|
Project schedule datesProject schedule dates for each named resource with PRL status. It will be updated either in the OCP or in an application engine and hooks in PRL. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | POOL_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Pool ID field.
Prompt Table: RS_POOL_MEMBER |
| 2 | MEMBER_ID |
Number(6,0) | INTEGER NOT NULL |
Member ID.
Prompt Table: RS_POOL_MEMBER |
| 3 | SCHED_NUM |
Number(5,0) | INTEGER NOT NULL |
Team sequence number
Default Value: 1 |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RS_ACT_EMPL |
| 5 | PC_HOURS_PER_DAY | Number(2,0) | SMALLINT NOT NULL | Hours per Day |
| 6 | RESOURCE_STS | Character(2) | VARCHAR2(2) NOT NULL |
11/15/2004 - New field added.
AL=Allocated CA=Cancelled CM=Committed CO=Considered CP=Completed RE=Rejected RQ=Requested |
| 7 | AVAIL_UNITS | Number(6,0) | INTEGER NOT NULL | Availability Units |
| 8 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 9 | END_DATE | Date(10) | DATE | End Date |
| 10 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 11 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |