INTFC_PROJ_TAO(SQL Table) |
Index Back |
|---|---|
Interface Project General |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | INTFC_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Trans Load Type |
| 4 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: BPC |
| 5 | APPROVAL_SW | Character(1) | VARCHAR2(1) NOT NULL |
Auto Approval Status
Y/N Table Edit |
| 6 | INTFC_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Interface Status
CON=Consolidated DON=Mass Changes Generated ERR=Error NEW=Mass Changes Not Generated REP=Replaced by Other Records (AP) UNI=Unitized |
| 7 | LOAD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized |
| 8 | ORIG_INTFC_ID | Number(8,0) | INTEGER NOT NULL | Original Interface ID |
| 9 | ORIG_LINE_NUM | Number(8,0) | INTEGER NOT NULL | Original Interface Line Number |
| 10 | INTEGRATION_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Integration
Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL Prompt Table: PC_INT_TMPL |
| 11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 12 | PROJECT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Project Type
A=Activity G=Grant H=Phase P=Project S=Segment Default Value: 00000 Prompt Table: PROJ_TYPE_TBL |
| 13 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |
| 14 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 15 | PROFILE_ID | Character(10) | VARCHAR2(10) NOT NULL | Asset Profile ID |
| 16 | GROUP_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Group Asset ID |
| 17 | PARENT_ID | Character(12) | VARCHAR2(12) NOT NULL | Parent ID |
| 18 | AM_DISTRIB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
AM Distribution Status
D=Distributed I=Ignore M=Modified N=Not Distributed P=Pending V=Reversed |
| 19 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |
| 20 | TAG_NUMBER | Character(12) | VARCHAR2(12) NOT NULL | Tag Number |
| 21 | TRANS_CODE | Character(5) | VARCHAR2(5) NOT NULL | Transaction Code |
| 22 | TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Project Template
Default Value: OPR_DEF_TBL_PC.TEMPLATE_ID Prompt Table: PROJECT_TMPL_VW |
| 23 | TEMPLATE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given bank transfer transaction should be designated as a
Y/N Table Edit Default Value: N |
| 24 | AFUDC_PROJ_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Interest Calculation
Y/N Table Edit Default Value: N |
| 25 | TARGET_PROJ_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allocation Target
Y/N Table Edit Default Value: N |
| 26 | SALES_TAX_PROJ_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Sales Tax Calculation
Y/N Table Edit |
| 27 | DOCKET_NUMBER | Character(15) | VARCHAR2(15) NOT NULL | Docket Number |
| 28 | PROJECT_FUNCTION | Character(10) | VARCHAR2(10) NOT NULL | Project Function |
| 29 | DTTM_STAMP | 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. |
| 30 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 31 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 32 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 33 | ADDRESS_ID | Character(3) | VARCHAR2(3) NOT NULL | Address ID |
| 34 | LOCATION_EFFDT | Date(10) | DATE | Location Effective Date |
| 35 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 36 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOCATION_TBL |
| 37 | LOCATION_FRACTION | Number(4,2) | DECIMAL(3,2) NOT NULL | Fraction of Cost at Location |
| 38 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 39 | PS_OWNER | Character(2) | VARCHAR2(2) NOT NULL |
PeopleSoft Owner
AM=Asset Management AP=Accounts Payable AR=Accounts Receivable BD=Budgets BI=Billing CA=Contracts CM=Cost Management CS=Customer Service EN=Engineering EX=Expenses GL=General Ledger HR=Human Resources IN=Inventory MG=Manufacturing OM=Order Management PC=Project Costing PL=Planning PO=Purchasing PR=Production Control PT=PeopleTools TL=Time and Labor TR=Treasury |
| 40 | FLEX_FORMULA | Character(15) | VARCHAR2(15) NOT NULL | Formula Name |
| 41 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL |
Team Member
Prompt Table: PROJ_TEAM_VW |
| 42 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: PROJ_ROLE |
| 43 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 44 | MANAGER_EFFDT | Date(10) | DATE | Project Manager Effective Date |
| 45 | PROJECT_MANAGER | Character(11) | VARCHAR2(11) NOT NULL |
Project Manager
Prompt Table: PROJ_MGR_VW |
| 46 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |
| 47 | MANAGER_START_DT | Date(10) | DATE | Project Manager Start Date |
| 48 | MANAGER_END_DT | Date(10) | DATE | Project Manager End Date |
| 49 | STATUS_EFFDT | Date(10) | DATE | Project Status Effective Date |
| 50 | 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 |
| 51 | START_DT_2 | Date(10) | DATE | Start Date |
| 52 | END_DT_2 | Date(10) | DATE | End Date |
| 53 | START_DT | Date(10) | DATE | Start Date |
| 54 | END_DT | Date(10) | DATE | End Date |
| 55 | PROJECT_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Project Priority |
| 56 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL | % Complete |
| 57 | INTEREST_FACTOR | Signed Number(5,2) | DECIMAL(3,2) NOT NULL | Interest Calculation Factor |
| 58 | MILESTONE_EFFDT | Date(10) | DATE | Milestone Effective Date |
| 59 | MILESTONE_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Milestone Type |
| 60 | MILESTONE_CODE | Character(15) | VARCHAR2(15) NOT NULL | Milestone Code |
| 61 | MILESTONE_ORIGIN | Character(1) | VARCHAR2(1) NOT NULL |
Milestone Origin
A=Project C=Contract |
| 62 | TRANS_DT | Date(10) | DATE | Transaction Date |
| 63 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |
| 64 | SCHEDULE_TYPE | Character(15) | VARCHAR2(15) NOT NULL |
Phase Type
Prompt Table: PROJ_PHASE_TBL |
| 65 | SCHEDULE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Schedule Status
A=Actual Schedule E=Estimated Schedule Default Value: A |
| 66 | SCHEDULE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Project Schedule Description |
| 67 | FROM_DT | Date(10) | DATE | From Date |
| 68 | TO_DT | Date(10) | DATE | To Date |
| 69 | DOCUMENT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Document Type
123=Lotus 1-2-3 AVI=Video for Windows CAD=AutoCad Document DOC=Microsoft Winword MPP=MicroSoft Project NON=No Document Type PST=PeopleSoft PeopleTools SCR=Lotus ScreenCam TLP=TimeLine for Windows TXT=Notepad for ASCII Text XLS=Microsoft Excel |
| 70 | DOCUMENT_NAME | Character(30) | VARCHAR2(30) NOT NULL | Document Path and Name |
| 71 | DOCUMENT_PATH | Character(80) | VARCHAR2(80) NOT NULL | Application Path |
| 72 | PROJECT_USER1 | Character(10) | VARCHAR2(10) NOT NULL | Project User 1 |
| 73 | PROJECT_USER2 | Character(10) | VARCHAR2(10) NOT NULL | Project User 2 |
| 74 | PROJECT_USER3 | Character(10) | VARCHAR2(10) NOT NULL | Project User 3 |
| 75 | PROJECT_USER4 | Character(10) | VARCHAR2(10) NOT NULL | Project User 4 |
| 76 | PROJECT_USER5 | Character(10) | VARCHAR2(10) NOT NULL | Project User 5 |
| 77 | PROJECT_USER_DT1 | Date(10) | DATE | Date 1 |
| 78 | PROJECT_USER_DT2 | Date(10) | DATE | Date 2 |
| 79 | PC_USER_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
User Currency
Prompt Table: CURRENCY_CD_TBL |
| 80 | PROJECT_USERAMT1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 1 |
| 81 | PROJECT_USERAMT2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 2 |
| 82 | PROJECT_USERAMT3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 3 |
| 83 | AN_GRP_ACTV_BUD | Character(5) | VARCHAR2(5) NOT NULL | Budget Analysis Group |
| 84 | AN_GRP_TOT_COSTS | Character(5) | VARCHAR2(5) NOT NULL | Cost Analysis Group |
| 85 | SET_OVERRIDE | Character(5) | VARCHAR2(5) NOT NULL |
FS_08 SetID
Default Value: INTFC_PROJ_GEN.BUSINESS_UNIT Prompt Table: SP_SETID_NONVW |
| 86 | PROJ_TOLERANCE_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Proj Activity Tolerance Type
A=Fixed Amount P=Percent |
| 87 | PROJ_TOLERANCE_AMT | Number(18,2) | DECIMAL(17,2) NOT NULL | Project Tolerance Amount |
| 88 | PROJ_TOLERANCE_PCT | Number(3,0) | SMALLINT NOT NULL | Project Tolerance Percent |
| 89 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 90 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 91 | ADDRESS2 | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 92 | ADDRESS3 | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 93 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 94 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 95 | NUM1 | Character(6) | VARCHAR2(6) NOT NULL | Number 1 |
| 96 | NUM2 | Character(6) | VARCHAR2(6) NOT NULL | Number 2 |
| 97 | HOUSE_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
House Type
AB=House Boat WW=Trailer |
| 98 | ADDR_FIELD1 | Character(2) | VARCHAR2(2) NOT NULL | Address Field 1 |
| 99 | ADDR_FIELD2 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 2 |
| 100 | ADDR_FIELD3 | Character(4) | VARCHAR2(4) NOT NULL | Address Field 3 |
| 101 | COUNTY | Character(30) | VARCHAR2(30) NOT NULL | County |
| 102 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: %EDIT_STATE |
| 103 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 104 | GEO_CODE | Character(11) | VARCHAR2(11) NOT NULL | Geo Code |
| 105 | IN_CITY_LIMIT | Character(1) | VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit |
| 106 | EARLY_START_DT | Date(10) | DATE | Early Start Date |
| 107 | EARLY_FINISH_DT | Date(10) | DATE | Early Finish Date |
| 108 | ACTUAL_START_DT | Date(10) | DATE | Actual Start Date |
| 109 | ACTUAL_FINISH_DT | Date(10) | DATE | Actual Finish Date |
| 110 | BASELINE_START_DT | Date(10) | DATE | Baseline Start Date |
| 111 | BASELINE_FINISH_DT | Date(10) | DATE | Baseline Finish Date |
| 112 | LATE_START_DT | Date(10) | DATE | Late Start Date |
| 113 | LATE_FINISH_DT | Date(10) | DATE | Late Finish Date |
| 114 | PC_SCH_PRODUCT | Character(3) | VARCHAR2(3) NOT NULL | Product code used by Projects to determine the third party scheduling product being integrated with. |
| 115 | PC_SCH_FIELD1 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 116 | PC_SCH_FIELD2 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 117 | PC_SCH_FIELD3 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 118 | PC_SCH_FIELD4 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 119 | PC_SCH_FIELD5 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 120 | PC_SCH_FIELD6 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 121 | PC_SCH_FIELD7 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 122 | PC_SCH_FIELD8 | Character(100) | VARCHAR2(100) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
| 123 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 124 | PC_INDENT_LEVEL | Number(3,0) | SMALLINT NOT NULL | Tree Indent Level |
| 125 | SUMMARY_PRJ | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project Y=Program |
| 126 | ENFORCE | Character(1) | VARCHAR2(1) NOT NULL |
Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
E=Expenses N=No T=Time&Labor Y=Exp and TL |
| 127 | ENFORCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Enforce project and activity team based prompt.
B=Project and Activity Team N=Do Not Enforce P=Project Team Only R=Project Resource Pools Only S=Project Activity Resource Pool X=Decide at the Project Level |
| 128 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 129 | PROJ_REQUEST_ID | Character(15) | VARCHAR2(15) NOT NULL | A unique identifier that represents a Project Request. |
| 130 | PPK_PROJ_VERSION | Character(15) | VARCHAR2(15) NOT NULL | An identifier that represents a version of the Project Request. |
| 131 | PGM_SCHED_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
The method to be used for Project Scheduling. Valid methods are: Fixed Units, Fixed Duration, and Fixed Work
D=Fixed Duration U=Fixed Units W=Fixed Work |
| 132 | PC_PERCENT_DTTM | DateTime(26) | TIMESTAMP | The datetime stamp of when the Project Percent Complete was either last calculated or manually entered. |
| 133 | HOLIDAY_LIST_ID | Character(10) | VARCHAR2(10) NOT NULL | This is used to identify what holiday calendar to use. This is the access field for all financials groups. |
| 134 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
| 135 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
| 136 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 137 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
| 138 | PLAN_STARTDT | Date(10) | DATE | Planned Start Date |
| 139 | PLAN_ENDDT | Date(10) | DATE | Planned End Date |
| 140 | PLAN_PROJROLE | Character(15) | VARCHAR2(15) NOT NULL | Requirement Project Role |
| 141 | CONSTRAINT_DT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Always Honor Constraint Dates |
| 142 | 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 |
| 143 | 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 |
| 144 | RATE_PLAN | Character(15) | VARCHAR2(15) NOT NULL | Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line. |
| 145 | BUDGET_APPROVER | Character(11) | VARCHAR2(11) NOT NULL | Budget Approver - the employee id of the individual who will be responsible for approving budget changes for a given project. |
| 146 | SCEN_ADJUST_PCT_TM | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Scenario Adjustment % for Time 06/09/2004 PR_FS_B005 Added Label - LABOR_ADJUST |
| 147 | SCEN_ADJUST_PCT_EX | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Scenario Adjustment % for Expense 06/09/2004 PR_FS_B005 Added Label NON_LABOR_ADJUST |
| 148 | MANAGED_BY_WO | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether a project is Work Order Managed.
N=No Y=Yes Y/N Table Edit Default Value: N |
| 149 | PC_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Rate Template ID |
| 150 | RATE_SELECT | Character(1) | VARCHAR2(1) NOT NULL |
This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set 2=Rate Plan |
| 151 | PC_REV_BUD_AN_GRP | Character(5) | VARCHAR2(5) NOT NULL | Revenue budget analysis group |
| 152 | AN_GRP_TOT_REV | Character(5) | VARCHAR2(5) NOT NULL | Cost Analysis Group |
| 153 | AN_GRP_EAC | Character(5) | VARCHAR2(5) NOT NULL | Analysis group representing the Estimate at Completion (a.k.a. Forecast). |
| 154 | RETAIN_HISTORY | Character(1) | VARCHAR2(1) NOT NULL |
Indicator to determine how often history is retained.
D=Daily M=Monthly Q=Quarterly W=Weekly |
| 155 | AN_GRP_FREV | Character(5) | VARCHAR2(5) NOT NULL | Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue. |
| 156 | ANLTC_ACT_COST | Character(5) | VARCHAR2(5) NOT NULL | Actual Cost analysis group for profitability reporting - contains all the analysis types that make up Actual Cost. |
| 157 | ANLTC_ACT_REV | Character(5) | VARCHAR2(5) NOT NULL | Actual Revenue analysis group for profitability reporting - contains all the analysis types that make up Actual Revenue. |
| 158 | ANLTC_FC_COST | Character(5) | VARCHAR2(5) NOT NULL | Forecast Cost analysis group for profitability reporting - contains all the analysis types that make up Forecast Cost. |
| 159 | ANLTC_FC_REV | Character(5) | VARCHAR2(5) NOT NULL | Forecast Revenue analysis group for profitability reporting - contains all the analysis types that make up Forecast Revenue. |
| 160 | ONE_TARGET_SW | Character(1) | VARCHAR2(1) NOT NULL |
Group target definitions
N=No Y=Yes Y/N Table Edit Default Value: BUS_UNIT_OPT_PC.ONE_TARGET_SW |
| 161 | P6_INCL_INTGRTN | Character(1) | VARCHAR2(1) NOT NULL | Include In Integration |
| 162 | P6_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | P6 Synchronization Template Id |
| 163 | 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. |
| 164 | P6_PROJECT_GUID | Character(36) | VARCHAR2(36) NOT NULL | Project GUID |