RS_OCP_RESW_TMP(SQL Table) |
Index Back |
|---|---|
Weekly OCP res infoWeekly OCP information for each named resource in each pool. This is a temp table that will never be updated in the database. |
| # | 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 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 4 | DISPLAY_WEEK_SEQ | Number(3,0) | SMALLINT NOT NULL | Display weekly sequnece from 1 to 28 or so. |
| 5 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: RS_ACT_EMPL |
| 6 | SETID_ROLE | Character(5) | VARCHAR2(5) NOT NULL |
SetID Role is used in the resource profile to allow select a valid project role.
Prompt Table: SP_SETID_NONVW |
| 7 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table:
RS_PROJROLE_VW
|
| 8 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
REGION_CD
|
| 9 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
| 10 | OCP_CAPACITY | Number(12,2) | DECIMAL(11,2) NOT NULL | Field for OCP capacity |
| 11 | OCP_REQUESTED | Number(12,2) | DECIMAL(11,2) NOT NULL | Field for OCP REQUESTED |
| 12 | OCP_REQUESTED_HOUR | Number(12,2) | DECIMAL(11,2) NOT NULL | Field for OCP REQUESTED in hours |
| 13 | OCP_ASSIGNED | Number(12,2) | DECIMAL(11,2) NOT NULL | Field for OCP ASSIGNED |
| 14 | OCP_ASSIGNED_HOUR | Number(12,2) | DECIMAL(11,2) NOT NULL | Field for OCP ASSIGNED in hours |
| 15 | OCP_AVAILABLE | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Field for OCP AVAILABLE |