| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 3 |
DISP_PROJ_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Project ID
Y/N Table Edit
Default Value: Y
|
| 4 |
DISP_ACT_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Activity ID
Y/N Table Edit
Default Value: Y
|
| 5 |
VW_SCHED_DT |
Date(10) |
DATE |
View Schedule from
Default Value: %date
|
| 6 |
PROJ_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Project Option stores the Project Workload Scope
EW=Enterprise Wide
MP=Multiple Projects
PG=Single Program
SP=Single Project
Default Value: SP
|
| 7 |
RES_OPT |
Character(2) |
VARCHAR2(2) NOT NULL |
Resource Scope store the Resource workload Scope
DP=Department Resources
PR=Project Resources
RG=Resource Group
SR=Selected Resources
Default Value: PR
|
| 8 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_VW
|
| 9 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 10 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
PGM_DEPTID
|
| 11 |
PROJECT_ID_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Project
Prompt Table:
PGM_PROGM
|
| 12 |
RS_RSRCGRP_NAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Resource Group ID
Prompt Table:
PGM_RSRCGRP
|
| 13 |
GROUP_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Group By
D=Daily
M=Monthly
W=Weekly
Default Value: D
|
| 14 |
OCP_YN |
Character(1) |
VARCHAR2(1) NOT NULL |
Called from OCP
|