P6_WBSXREF_TAO (SQL Table)	Index Back
Temp table for WBS XREF Temp table that will contain data from the WBS_GUID XREF.

P6_WBSXREF_TAO

(SQL Table)

Temp table for WBS XREF

Temp table that will contain data from the WBS_GUID XREF.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 P6_WBS_GUID Character(36) VARCHAR2(36) NOT NULL P6 WBS GUID

3 EOTF_IMPORT_FLG Character(1) VARCHAR2(1) NOT NULL Import Value Map
N=No
Y=Yes

4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

6 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

7 ACTIVITY_OBJECTID Number(10,0) DECIMAL(10) NOT NULL A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	P6_WBS_GUID	Character(36)	VARCHAR2(36) NOT NULL	P6 WBS GUID
3	EOTF_IMPORT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Import Value Map N=No Y=Yes
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
6	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID
7	ACTIVITY_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.