PROCESS_INSTANCEBUSINESS_UNITPROJECT_IDN=Work Breakdown Level
Y=Entire Work Breakdown
Y/N Table Edit
Default Value: N
D=Duration Percent Complete
P=Performance Percent Complete
U=Unit Percent Complete
P6_DRIV_PROJSTG(SQL Table) |
Index Back |
|---|---|
Project / Template temp tableProject / Template temporary table. Used in Project Synchronization Driver. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | PROJ_HDR_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Header Export Flag |
| 6 | PROJ_HDR_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Header Import Flag |
| 7 | WBS_ACT_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Work Breakdown / Activity Export Flag |
| 8 | WBS_ACT_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Work Breakdown / Activity Import Flag |
| 9 | RSRC_ASGN_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Resource Assignment Export Flag |
| 10 | RSRC_ASGN_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Resource Assignment Import Flag |
| 11 | BUDGT_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Budget Export Flag |
| 12 | BUDGT_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Budget Import Flag |
| 13 | HRS_WRKD_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Hours Worked Export Flag |
| 14 | HRS_WRKD_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Hours Worked Import Flag |
| 15 | ACT_COST_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Actual Cost Export Flag |
| 16 | ACT_COST_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Actual Cost Import Flag |
| 17 | CMTMNT_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Commitment Export Flag |
| 18 | CMTMNT_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Commitment Import Flag |
| 19 | P6_WBS_LVL | Number(2,0) | SMALLINT NOT NULL | Work Breakdown Structure Level |
| 20 | ALL_WBS | Character(1) | VARCHAR2(1) NOT NULL |
Entire WBS
N=Work Breakdown Level Y=Entire Work Breakdown Y/N Table Edit Default Value: N |
| 21 | P6_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | P6 Synchronization Template Id |
| 22 | WBS_PC_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Percent Complete Export Flag |
| 23 | WBS_PC_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Percent Complete Import Flag |
| 24 | WBS_PC_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Percent Complete Source
D=Duration Percent Complete P=Performance Percent Complete U=Unit Percent Complete |
| 25 | PROJ_TEAM_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Team Export Flag |
| 26 | PROJ_TEAM_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Team Import Flag |
| 27 | TEAM_EQUIP_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Team Export - Include Equipment (Asset) Assignments |
| 28 | TEAM_LABOR_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Team Export - Include Labor Resource Assignments |