P6_ACK_STG

(SQL Table)

# 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 IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID

#	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	IBTRANSACTIONID	Character(36)	VARCHAR2(36) NOT NULL	Transaction ID