| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PC_MSP2_SERVER |
Character(64) |
VARCHAR2(64) NOT NULL |
Microsoft Project Server
Prompt Table:
PC_MSP2_SERV_VW
|
| 2 |
SESSION_NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
MSP Integrator Session Name - name given by the Windows Terminal Service session.
|
| 3 |
PC_MSP2_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
MSP Integrator Status:
Waiting = idle
Working = currently integrating
Absent = no longer responding
Error = error occurred and no longer workable.
Pause = keep the integrator from processing
ABS=Absent
ERR=Error
PS=Hold
WK=Busy
WT=Waiting
|
| 4 |
PC_MSP2_PRIORITY |
Number(3,0) |
SMALLINT NOT NULL |
Priority
|
| 5 |
LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 6 |
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
|
| 7 |
PC_FILE_PATH |
Character(254) |
VARCHAR2(254) NOT NULL |
.mpp File Path
|
| 8 |
PC_SCH_3D_PROJECT |
Character(40) |
VARCHAR2(40) NOT NULL |
Third Party Projects
|
| 9 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 10 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 12 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
SP_PROJ_NONVW
|
| 13 |
PROJECT_ID_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Project
|
| 14 |
PASSWORD |
Character(254) |
VARCHAR2(254) NOT NULL |
Password
|
| 15 |
PROJ_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Project ID Description
|
| 16 |
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
|
| 17 |
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
|
| 18 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
|
| 19 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPL
|
| 20 |
PC_HTDOCROOT |
Character(30) |
VARCHAR2(30) NOT NULL |
HTTP Document Root
|
| 21 |
FTP_SERVER |
Character(254) |
VARCHAR2(254) NOT NULL |
FTP Server Name
|
| 22 |
IN_USE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Row in use flag
Default Value: N
|
| 23 |
PC_SCHEDULE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Schedule From Start?
N=Schedule from End Date
Y=Schedule from Start Date
|
| 24 |
ATTACHUSERFILE |
Character(64) |
VARCHAR2(64) NOT NULL |
Attached File
|
| 25 |
PC_UPLOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Add .mpp file
|
| 26 |
PC_MSP_OVERWRITE |
Character(1) |
VARCHAR2(1) NOT NULL |
Overwrite Existing Data
N=No
Y=Yes
Default Value: N
|
| 27 |
PC_MSP_DELETE |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Existing Activities
N=No
Y=Yes
Default Value: N
|
| 28 |
PC_MSP_DEL_RES |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Existing Transactions
N=No
Y=Yes
|
| 29 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
PC_TREESTRCT_VW
|
| 30 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
Prompt Table:
PC_TREE_EFDT_VW
|
| 31 |
PARENT_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Tree Node
Prompt Table:
PC_TREE_NODE_VW
|
| 32 |
PC_WBS_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
This is the Projects WBS id. It is longer than the previous WBS_ID field. This field will replace the old WBS_ID field in the next major release.
|
| 33 |
PC_WBS_TREE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
WBS Tree Description
|
| 34 |
PC_WBS_TREE_EFDT |
Date(10) |
DATE |
WBS Tree Effective Date
|
| 35 |
PC_WBS_TREE_NEW |
Character(18) |
VARCHAR2(18) NOT NULL |
New WBS Tree Name
|
| 36 |
PC_WBS_TREE_SYN |
Character(18) |
VARCHAR2(18) NOT NULL |
WBS Tree Name
|
| 37 |
PC_WBS_TR_EFDT_NEW |
Date(10) |
DATE |
WBS Tree Effective Date
|
| 38 |
SCH_ACT_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Actuals =
Prompt Table:
PROJ_AN_GRP_TBL
|
| 39 |
SCH_BUD_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Budgets =
Prompt Table:
PROJ_AN_GRP_TBL
|
| 40 |
SCH_FTC_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecasts =
Prompt Table:
PROJ_AN_GRP_TBL
|
| 41 |
SCH_INBOUND_BUD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Type
Prompt Table:
PC_MSP2_BUD_VW
|
| 42 |
SCH_INBOUND_FTC |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecast Analysis Type
Prompt Table:
PROJ_ANTYPE_TBL
|
| 43 |
SCH_OUTBOUND_ACT |
Character(5) |
VARCHAR2(5) NOT NULL |
Outbound Actuals Analysis Type
Prompt Table:
PROJ_AN_GRP_TBL
|
| 44 |
SCH_AN_TYPE_FTC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Analysis Type Forecast
N=No
Y=Yes
Default Value: N
|
| 45 |
SCH_AN_GRP_MAP_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
OutBound Analysis Group Map
N=No
Y=Yes
Default Value: Y
|
| 46 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
Prompt Table:
PROJ_AN_GRP_TBL
|
| 47 |
BUDG_ANALYSIS_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Group
Prompt Table:
PROJ_AN_GRP_TBL
|
| 48 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
|
| 49 |
SCH_DEF_PRJ_INACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Project to Inactive
N=No
Y=Yes
Default Value: Y
|
| 50 |
SCH_DEF_ACT_INACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Activities to Inactive
Default Value: Y
|
| 51 |
PC_CUST_PROJ_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow user to define their own project id - if blank, then the system defaults to "NEXT".
N=No
Y=Yes
|
| 52 |
PC_SCH_SYN_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Activity Information flag.
N=No
Y=Yes
|
| 53 |
PC_SCH_SYN_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Project Information flag.
N=No
Y=Yes
|
| 54 |
PC_SCH_SYN_RES |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Resources Information flag.
N=No
Y=Yes
|
| 55 |
PC_SCH_SYN_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Roles for Third Party Integration
N=No
Y=Yes
|
| 56 |
PC_SCH_SYN_RST |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Resource Pool/Dictionary Information flag.
N=No
Y=Yes
|
| 57 |
MSP_PROJRSCLABOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Integrate Project Resource List Labor
Y/N Table Edit
|
| 58 |
MSP_PROJRSCMTRIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Integrate Project Resource List Material
Y/N Table Edit
|
| 59 |
PC_SCH_SYN_ACTRST |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Resource Pool/Dictionary Information flag.
N=No
Y=Yes
|
| 60 |
MSP_ACTRSCLABOR |
Character(1) |
VARCHAR2(1) NOT NULL |
Integrate Activity Resource List Labor
Y/N Table Edit
|
| 61 |
MSP_ACTRSCMTRIAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Integrate Activity Resource List Material
Y/N Table Edit
|
| 62 |
PC_SCH_SYN_WBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Activity WBS Information flag.
N=No
Y=Yes
|
| 63 |
PC_PERCENT_COM_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Complete
N=No
Y=Yes
|
| 64 |
PC_PCTCOM_PRJ_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Percent Complete
N=No
Y=Yes
|
| 65 |
PC_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Date
N=No
Y=Yes
Default Value: Y
|
| 66 |
PC_MILESTONE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Milestone Activity
N=No
Y=Yes
Default Value: Y
|
| 67 |
MSP_ACTCOSTLVLWBS |
Number(3,0) |
SMALLINT NOT NULL |
Integrate only costing level WBS
|
| 68 |
PC_DURATION_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
MSP Integration. Copy Durations switch.
N=No
Y=Yes
|
| 69 |
PC_SYNC_WORK |
Character(1) |
VARCHAR2(1) NOT NULL |
Work Entered in Microsoft
N=No
Y=Yes
|
| 70 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
Prompt Table:
CAL_DEFN_TB4_VW
|
| 71 |
PC_SYNC_ETC |
Character(1) |
VARCHAR2(1) NOT NULL |
Estimate To Completion
N=No
Y=Yes
Default Value: Y
|
| 72 |
PC_MSP2_BUD_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to select the source of the Budget Rows from MSP:
Task.Cost
Task.BaselineCost
Resource.Cost
Resource.BaselineCost
1=Task.Cost
2=Task.BaselineCost
3=Resource.Cost
4=Resource.BaselineCost
|
| 73 |
PC_MSP2_FTC_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to select the source of Forecast to Complete values:
Task
Resource
1=Task.RemainingCost
2=Resource.RemainingCost
|
| 74 |
PC_MSP2_ETC_SOURCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Used to select source of Estimate To Completion from MSP:
Task.RemainingWork
Resource.RemainingWork
1=Task.RemainingWork
2=Resource.RemainingWork
|
| 75 |
PC_SYNC_PRL |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Resource List
N=No
Y=Yes
Default Value: N
|
| 76 |
PC_ASSIGNMENTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Group box label.
Also, for MSP Integration, Checkbox for Proj Team Assignments
N=No
Y=Yes
|
| 77 |
PC_PR_SCHED_FIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in MSP Integration Wizard to flag scheduling fields to be copied or not.
N=No
Y=Yes
Default Value: Y
|
| 78 |
PC_AC_SCHED_FIELDS |
Character(1) |
VARCHAR2(1) NOT NULL |
Used in MSP Integration Wizard to flag scheduling fields to be copied or not.
N=No
Y=Yes
Default Value: Y
|
| 79 |
PC_BUDGET_PERIODS |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget periods
|
| 80 |
PC_SCH_FIELD1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
Prompt Table:
GM_BUD_CATEGORY
|
| 81 |
PC_SCH_FIELD2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 82 |
PC_SCH_FIELD3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 83 |
PC_SCH_FIELD4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 84 |
PC_SCH_FIELD5 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 85 |
BUDGET_ITEM_LAB |
Character(15) |
VARCHAR2(15) NOT NULL |
Labor Budget Item
|
| 86 |
BUDGET_ITEM_MAT |
Character(15) |
VARCHAR2(15) NOT NULL |
Material Budget Item
|
| 87 |
COST_RATE_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource Cost Rate Type
C=User Defined Rate
E=Employee Rate
J=Jobcode Rate
R=Project Role Rate
|
| 88 |
BILL_RATE_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Named Resource Bill Rate Type
C=User Defined Rate
E=Employee Rate
J=Jobcode Rate
R=Project Role Rate
|
| 89 |
COST_RATE_GENERIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Resource Cost Rate Type
C=User Defined Rate
R=Project Role Rate
|
| 90 |
BILL_RATE_GENERIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Generic Resource Bill Rate Type
C=User Defined Rate
R=Project Role Rate
|
| 91 |
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
|
| 92 |
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
|
| 93 |
AUTO_NAM_ASSIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Assign Named Resource
Y/N Table Edit
Default Value: N
|
| 94 |
AUTO_GEN_ASSIGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocate Generic Resource
Y/N Table Edit
Default Value: N
|
| 95 |
ALLOW_OVERBOOK |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow OverBooking
Y/N Table Edit
Default Value: N
|
| 96 |
REGION_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
Prompt Table:
RS_REGION_VW
|