FT_INC_DTL (SQL Table)	Index Back
Fusion Coex Incremental Extrac Record used with Fusion Coex Incremental Extract to store extract details

FT_INC_DTL

(SQL Table)

Fusion Coex Incremental Extrac

Record used with Fusion Coex Incremental Extract to store extract details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FT_OB_MODE Character(1) VARCHAR2(1) NOT NULL Stores the execution mode- Bulk or Incremental
B=Full Data Publish
I=Incremental Data Publish

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

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

4 LASTEXECDTTM DateTime(26) TIMESTAMP DateTime of Last Execution.

5 FLAG Character(1) VARCHAR2(1) NOT NULL Flag

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FT_OB_MODE	Character(1)	VARCHAR2(1) NOT NULL	Stores the execution mode- Bulk or Incremental B=Full Data Publish I=Incremental Data Publish
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	LASTUPDDTTM	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.
4	LASTEXECDTTM	DateTime(26)	TIMESTAMP	DateTime of Last Execution.
5	FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag