OPRIDDEFAULT_FLAGDefault Value: N
N=No
Y=Yes
Prompt Table: SP_BU_CA_NONVW
S=Specify
U=Projects User Preferences
Default Value: U
DRAF=1. Draft
RDY=2. Ready
H=01 - High
L=O3 - Low
M=02 - Medium
D=By Day
H=By Hour
Default Value: H
GM_PE_RDEMD_PRS(SQL Table) |
Index Back |
|---|---|
RESOURCE DEMAND PERSRecord for Resource on Demand chart, personalization table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | DEFAULT_FLAG |
Character(1) | VARCHAR2(1) NOT NULL |
Default
Default Value: N |
| 3 | MY_PROPOSAL | Character(1) | VARCHAR2(1) NOT NULL |
My Proposals
N=No Y=Yes |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_CA_NONVW |
| 5 | PC_BU_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
A flag to indicate where the Business Unit personalization filter will come from: User Preference or a Specified Value.
S=Specify U=Projects User Preferences Default Value: U |
| 6 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | SUBMIT_STATUS_PE | Character(4) | VARCHAR2(4) NOT NULL |
Status
DRAF=1. Draft RDY=2. Ready |
| 9 | CONF_LEVEL | Character(1) | VARCHAR2(1) NOT NULL |
Confidence Level
H=01 - High L=O3 - Low M=02 - Medium |
| 10 | HOURS_DAY | Character(1) | VARCHAR2(1) NOT NULL |
Hour/Day
D=By Day H=By Hour Default Value: H |