| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 4 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_PROJ_NONVW
|
| 5 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
PROJ_ACTIVITY
|
| 6 |
SUMMARY_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity
|
| 7 |
MY_PROJECTS |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to determine whether filter criteria is using the operator's My Projects list.
N=My Projects
Y=My Projects
|
| 8 |
PROJECT_MANAGER |
Character(11) |
VARCHAR2(11) NOT NULL |
Project Manager
Prompt Table:
PC_PROJ_MGRS_VW
|
| 9 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_VW
|
| 10 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
Prompt Table:
PROJ_STAT_VW
|
| 11 |
PERCENTAGE1 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 12 |
PERCENTAGE2 |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Percentage
|
| 13 |
PC_SHOW_VAR_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Only
A=All
B=Variance Hours Percent Over
C=Variance Hours Percent Under
D=Variance Days Over
E=Variance Days Under
Default Value: A
|
| 14 |
PC_VAR_VALUE |
Number(8,0) |
INTEGER NOT NULL |
Variance Value
|
| 15 |
PC_SUMMARIZE_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Summarize By
A=Activity
P=Project
Default Value: P
|
| 16 |
SELECT_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Dynamic Where Clause Sel Parms
|
| 17 |
FROM_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
From Clause
|
| 18 |
GROUP_BY_TEXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Group by text
|
| 19 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 20 |
SUMMARY_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project
Y=Program
|
| 21 |
MAX_LEVEL_DISP |
Character(1) |
VARCHAR2(1) NOT NULL |
Defines the maximum levels within a tree to be displayed.
1=01
2=02
3=03
|
| 22 |
PC_NUM_TEAM_MEMS |
Number(5,0) |
INTEGER NOT NULL |
Number of Team Members
|
| 23 |
COMPLETION_DATE |
Date(10) |
DATE |
Completion Date
|