P6_PRJXREF_AET (SQL Table)	Index Back
P6 Xref AET table Used in P6 Primavera integration; AET record for the Project Header Library. Used to delete EOTF_XREF_DATA where exported project data was deleted in receiving application (P6).

P6_PRJXREF_AET

(SQL Table)

P6 Xref AET table

Used in P6 Primavera integration; AET record for the Project Header Library. Used to delete EOTF_XREF_DATA where exported project data was deleted in receiving application (P6).

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.

3 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.

4 TEAM_OBJECTID Number(10,0) DECIMAL(10) NOT NULL P6 Project Team ObjectID

5 COUNT_XREF Number(10,0) DECIMAL(10) NOT NULL Xref Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	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.
3	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.
4	TEAM_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	P6 Project Team ObjectID
5	COUNT_XREF	Number(10,0)	DECIMAL(10) NOT NULL	Xref Count