| # |
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 |
OCP_SHOW_MONTH |
Character(2) |
VARCHAR2(2) NOT NULL |
OCP analytic show month field
1M=1 Month
2M=2 Months
3M=3 Months
4M=4 Months
5M=5 Months
6M=6 Months
Default Value: 2M
|
| 3 |
PRIM_SUPPLY_CATGRY |
Character(2) |
VARCHAR2(2) NOT NULL |
Operational Capacity Planning primary supply category selection
C1=Resource Pool
C2=Project Role
C3=Personnel Status
C4=Region
Default Value: C1
|
| 4 |
SCND_SUPPLY_CATGRY |
Character(2) |
VARCHAR2(2) NOT NULL |
Operational Capacity Planning secondary supply category selection
C0=NONE
C1=Resource Pool
C2=Project Role
C3=Personnel Status
C4=Region
Default Value: C0
|
| 5 |
OCP_GROUP_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
OCP analytic group by option.
M=Monthly
W=Weekly
Default Value: M
|
| 6 |
OCP_VIEW_IN |
Character(1) |
VARCHAR2(1) NOT NULL |
Operational Capacity Planning view in option field
D=Days
H=Hours
Default Value: D
|
| 7 |
START_MONTH_YEAR |
Character(7) |
VARCHAR2(7) NOT NULL |
Start month with year for the OCP (Operational Capacity Planning) display data.
|
| 8 |
END_MONTH_YEAR |
Character(7) |
VARCHAR2(7) NOT NULL |
End month with year for the OCP (Operational Capacity Planning) display data.
|
| 9 |
START_MONTH |
Character(3) |
VARCHAR2(3) NOT NULL |
Start month
M01=01 January
M02=02 February
M03=03 March
M04=04 April
M05=05 May
M06=06 June
M07=07 July
M08=08 August
M09=09 September
M10=10 October
M11=11 November
M12=12 December
|
| 10 |
START_DATE_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
Start date year field
|