RS_GENRES_DATES(SQL Table) |
Index Back |
|---|---|
Generic resource schedule dateSchedule dates for each resource role of generic resources with PRL status. For each role of generic resources, there are multiple resources. Each of them can have multiple date ranges. All of them are accounted in the sequence number SCHED_NUM. This table will be updated 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 | 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 |
| 3 | PROJ_ROLE |
Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Default Value: PROJECT_TEAM.PLAN_PROJROLE Prompt Table:
RS_PROJROLE_VW
|
| 4 | SCHED_NUM |
Number(5,0) | INTEGER NOT NULL |
Team sequence number
Default Value: 1 |
| 5 | 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 |
| 6 | PC_HOURS_PER_DAY | Number(2,0) | SMALLINT NOT NULL | Hours per Day |
| 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 |