P6_PRJHDR_AET(SQL Table) |
Index Back |
|---|---|
P6 Project Header AET recordUsed in P6 Primavera integration; AET record for the Project Header Library |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | PROJ_HDR_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Header Export Flag |
| 3 | PROJ_HDR_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Header Import Flag |
| 4 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 5 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 6 | RECNAME1 | Character(15) | VARCHAR2(15) NOT NULL | Record Name 1 |
| 7 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 8 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 9 | PROJECT_OBJECTID | Number(10,0) | DECIMAL(10) NOT NULL | A unique ID that is the Project key to a corresponding table in an external system such as Primavera. |
| 10 | INTFC_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Interface Line Number |
| 11 | P6_INTEGRATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Integration Type
I=Inbound O=Outbound |
| 12 | COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 13 | COUNTER1 | Number(16,2) | DECIMAL(15,2) NOT NULL | Counter 1 |
| 14 | COUNT_ACT | Number(10,0) | DECIMAL(10) NOT NULL | Count ACT rows |
| 15 | COUNT_WBS | Number(10,0) | DECIMAL(10) NOT NULL | Count WBS Rows |
| 16 | P6_WBS_LVL | Number(2,0) | SMALLINT NOT NULL | Work Breakdown Structure Level |
| 17 | ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Error Flag |
| 18 | PRJ_HDR_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Mapping Export Flag |
| 19 | WBS_ACT_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Work Breakdown / Activity Export Flag |
| 20 | HRS_WRKD_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Hours Worked Export Flag |
| 21 | CMTMNT_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Commitment Export Flag |
| 22 | ACT_COST_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Actual Cost Export Flag |
| 23 | BUDGT_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Budget Export Flag |
| 24 | RSRC_ASGN_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Resource Assignment Export Flag |
| 25 | WBS_PC_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Percent Complete Export Flag |
| 26 | PROCESS_INSTANCE2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 27 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 28 | P6_IMPORT_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Import from P6 Status
010=Complete 020=Error 030=Complete With Warnings 050=Time Out 060=Not Processed 070=Sending 080=Received 090=Complete With Errors |
| 29 | STATUS_NEW | Character(3) | VARCHAR2(3) NOT NULL | New Status |
| 30 | P6_APP_ERR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Data
E=Error F=Fault Error N=No Errors R=P6 Response Error W=Warning |
| 31 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | Flag1 |
| 32 | ACT_COST_EXP_LVL | Character(1) | VARCHAR2(1) NOT NULL |
Acttual Cost Export Level
A=Total S=Source Type |
| 33 | COUNTER2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Counter 2 |
| 34 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 35 | WHERE_CLAUSE1 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 36 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 37 | COUNT_TEAM | Number(10,0) | DECIMAL(10) NOT NULL | To count number of team members at Project Level |
| 38 | P6_SQL_LONG | Long Character(4096) | CLOB | SQL String |
| 39 | PROJ_TEAM_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Team Export Flag |
| 40 | TEAM_EQUIP_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Team Export - Include Equipment (Asset) Assignments |
| 41 | TEAM_LABOR_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Project Team Export - Include Labor Resource Assignments |
| 42 | ALL_WBS | Character(1) | VARCHAR2(1) NOT NULL |
Entire WBS
N=Work Breakdown Level Y=Entire Work Breakdown |