| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
PSOPRDEFN_SRCH
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 4 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: NEXT
|
| 5 |
PC_SYNC_DIR |
Character(3) |
VARCHAR2(3) NOT NULL |
Sync direction for MSP Integration.
CMS = Copy to Microsoft
CPS = Copy to PeopleSoft
UMS = Update Microsoft
UPS = Upgrade PeopleSoft
UPR = Get Update from Project Resource List (PRL)
CMS=Copy Project to Microsoft
CPS=Copy Project to PeopleSoft
UMS=Update Project in Microsoft
UPR=Project Resource List Update
UPS=Update Project in PeopleSoft
|
| 6 |
PROJ_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Project ID Description
|
| 7 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPL
|
| 8 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_TBL
|
| 9 |
PROJECT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted
C=Closed
H=Hold
O=Open
P=Proposed
Prompt Table:
PROJ_STATUS_TBL
Set Control Field: SETID
|
| 10 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 11 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
PC_TREESTRCT_VW
|
| 12 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
Prompt Table:
PC_TREE_EFDT_VW
|
| 13 |
PARENT_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Tree Node
Prompt Table:
PC_TREE_NODE_VW
|
| 14 |
ATTACHSYSFILENAME |
Character(128) |
VARCHAR2(128) NOT NULL |
Unique Sys Filename
|
| 15 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 16 |
CHARGING_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Charging Level - identifies which level of the WBS activities are available for charging.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
|
| 17 |
CHARGING_LEVEL_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Report Charging Level - identifies which level of the WBS activities are available for charging on time reports enter in Expenses.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
|