P6_RESXREF_TAO (SQL Table)	Index Back
Temp table for Employee XREF Temp table that will contain data from the RESOURCE_EMPLOYEE_GUID XREF.

P6_RESXREF_TAO

(SQL Table)

Temp table for Employee XREF

Temp table that will contain data from the RESOURCE_EMPLOYEE_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_RSRC_GUID Character(36) VARCHAR2(36) NOT NULL Resource GUID

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

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

5 RSRC_OBJECTID Number(10,0) DECIMAL(10) NOT NULL Resource Object ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	P6_RSRC_GUID	Character(36)	VARCHAR2(36) NOT NULL	Resource GUID
3	EOTF_IMPORT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Import Value Map N=No Y=Yes
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	RSRC_OBJECTID	Number(10,0)	DECIMAL(10) NOT NULL	Resource Object ID