RS_OCPCHART_TMP(SQL Table) |
Index Back |
|---|---|
Record for resource chartThis is a tmp record for resource chart. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 2 | DAYS_HOURS | Number(8,0) | INTEGER NOT NULL | Days or hours |
| 3 | RES_ASSGN_STS | Character(1) | VARCHAR2(1) NOT NULL |
Resource status. Capacity, Requested, Assigned, and Available.
A=Assigned R=Requested |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |