BUSINESS_UNITDefault Value: RS_GRR_HDR.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
GRR_IDDefault Value: RS_GRR_HDR.GRR_ID
SCHED_NUMDefault Value: 1
A=Allocated
F=Fulfilled
R=Rejected
V=Pending Approval
X=Cancelled
Prompt Table: PROJ_ROLE
RS_GRR_SCHED(SQL Table) |
Index Back |
|---|---|
Generic Request ScheduleGeneric Resource Request Schedule. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: RS_GRR_HDR.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 2 | GRR_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Generic Resource Request ID.
Default Value: RS_GRR_HDR.GRR_ID |
| 3 | SCHED_NUM |
Number(5,0) | INTEGER NOT NULL |
Team sequence number
Default Value: 1 |
| 4 | GRR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Generic Resource Request Status
A=Allocated F=Fulfilled R=Rejected V=Pending Approval X=Cancelled |
| 5 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: PROJ_ROLE |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |