BUSINESS_UNITPrompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: SP_PROJ_NONVW
TEAM_MEMBERA=Allocated
F=Fulfilled
R=Rejected
V=Pending Approval
X=Cancelled
Default Value: V
Default Value: PROJECT.START_DT
Default Value: PROJECT.END_DT
RS_GRR_SRCH(SQL View) |
Index Back |
|---|---|
Generic Request HeaderGeneric Resource Request Header |
| SELECT BUSINESS_UNIT , PROJECT_ID , TEAM_MEMBER , GRR_STATUS , GRR_ID , PLAN_STARTDT , PLAN_ENDDT FROM %Table(RS_GRR_HDR) WHERE GRR_STATUS IN ('A','V') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 3 | TEAM_MEMBER |
Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 4 | GRR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Generic Resource Request Status
A=Allocated F=Fulfilled R=Rejected V=Pending Approval X=Cancelled Default Value: V |
| 5 | GRR_ID | Character(10) | VARCHAR2(10) NOT NULL | Generic Resource Request ID. |
| 6 | PLAN_STARTDT | Date(10) | DATE |
Planned Start Date
Default Value: PROJECT.START_DT |
| 7 | PLAN_ENDDT | Date(10) | DATE |
Planned End Date
Default Value: PROJECT.END_DT |