| # |
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 |
PC_SCH_PRODUCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Product code used by Projects to determine the third party scheduling product being integrated with.
Prompt Table:
PC_SCH_PRODUCT
|
| 3 |
USERID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID
|
| 4 |
PC_PASSWORD |
Character(30) |
VARCHAR2(30) NOT NULL |
Password
|
| 5 |
PC_SCH_PRJ_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Project Level Integration Options - 3rd Party Schedule Integration
CP3D=Send Project to 3rd Party
CPPS=Send Project to PeopleSoft
UP3D=Update Project in 3rd Party
UPPS=Update Project in PeopleSoft
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_PC_NONVW
|
| 7 |
PC_SCH_ACT_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Activity Integration options for 3rd Party Scheduling.
CA3D=Send Activity to 3rd Party
CAPS=Send Activity to PeopleSoft
UA3D=Update Activity in 3rd Party
UAPS=Update Activity in PeopleSoft
|
| 8 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PC_PARNTNODE_VW
|
| 9 |
PC_SCH_RST_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Resource Pool Options - either Create a Resource Sheet/Dictionary or update an existing Resource Sheet/Dictionary
CR3D=Create Source Type/EmplID
UR3D=Update Source Type/EmplID
|
| 10 |
PC_SCH_RES_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Resource Assignment Options - either do Budget Integration or Actual Integration
ACTL=Actuals Integration
BDGT=Budget Integration
|
| 11 |
PC_SCH_ROLE_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Sync Resource Roles or JobCodes
INRL=Create Resource Roles/JobCodes
UPRL=Update Resource Roles/JobCodes
|
| 12 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
|
| 13 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
PROJ_AN_GRP_VW
|
| 14 |
PC_SCH_PTR_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Options for Project Tree Integration with Third Party scheduling software
APP=Append Node to Existing Tree
NEW=Create New Tree
UPD=Update Existing Tree
|
| 15 |
PC_SCH_WBS_OPT |
Character(4) |
VARCHAR2(4) NOT NULL |
Options for WBS Tree Integration with Third Party scheduling software
APP=Append Node to Existing Tree
NEW=Create New WBS Tree
UPD=Update Existing WBS Tree
|
| 16 |
PC_SCH_OWNER |
Character(4) |
VARCHAR2(4) NOT NULL |
Schedule Integration Product Owner - PeopleSoft or Third Party.
3RPT=3RD PARTY
PSFT=PEOPLESOFT
Default Value: PSFT
|
| 17 |
PC_SCH_SYN_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Project Information flag.
N=No
Y=Yes
Default Value: N
|
| 18 |
PC_SCH_SYN_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Activity Information flag.
N=No
Y=Yes
Default Value: N
|
| 19 |
PC_SCH_SYN_RES |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Resources Information flag.
N=No
Y=Yes
Default Value: N
|
| 20 |
PC_SCH_SYN_EPS |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Project Tree Information flag.
N=No
Y=Yes
Default Value: N
|
| 21 |
PC_SCH_SYN_WBS |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Activity WBS Information flag.
N=No
Y=Yes
Default Value: N
|
| 22 |
PC_SCH_SYN_RST |
Character(1) |
VARCHAR2(1) NOT NULL |
Synchronize Resource Pool/Dictionary Information flag.
N=No
Y=Yes
Default Value: N
|
| 23 |
PC_SCH_SYN_ROLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Roles for Third Party Integration
N=No
Y=Yes
Default Value: N
|
| 24 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
PC_TREESTRCT_VW
|
| 25 |
TREE_EFFDT |
Date(10) |
DATE |
Effective date of the Tree
Prompt Table:
PC_TREE_EFDT_VW
|
| 26 |
PC_WBS_TREE_SYN |
Character(18) |
VARCHAR2(18) NOT NULL |
WBS Tree Name
|
| 27 |
PC_WBS_TREE_EFDT |
Date(10) |
DATE |
WBS Tree Effective Date
|
| 28 |
PARENT_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Parent Tree Node
Prompt Table:
PC_SUMM_NODE_VW
|
| 29 |
PC_PROJ_TREE_NEW |
Character(18) |
VARCHAR2(18) NOT NULL |
New Project Tree Name
|
| 30 |
PC_PRJ_TR_EFDT_NEW |
Date(10) |
DATE |
Effective Date of New Tree
|
| 31 |
PC_WBS_TREE_NEW |
Character(18) |
VARCHAR2(18) NOT NULL |
New WBS Tree Name
|
| 32 |
PC_WBS_TR_EFDT_NEW |
Date(10) |
DATE |
WBS Tree Effective Date
|
| 33 |
PC_WBS_TREE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
WBS Tree Description
|
| 34 |
PC_PRJ_TREE_DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Tree Description
|
| 35 |
PC_SCH_3D_PROJECT |
Character(40) |
VARCHAR2(40) NOT NULL |
Third Party Projects
|
| 36 |
PC_TREE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to identify type of tree (project or wbs).
PRJ=Project
WBS=Work Breakdown Structure
|
| 37 |
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
|
| 38 |
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
|
| 39 |
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
|
| 40 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPL
|