SDTE_EXTRACT_DETAIL

Details

Schema: FUSION
Object owner: FND
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
SDTE_EXTRACT_DETAIL_PK	EXTRACT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
EXTRACT_ID	NUMBER		18	Yes	This field will use SDTE_EXTRACT_DETAIL_S sequence to generate auto-increment unique number to store the information of extraction request.
EXTRACT_NAME	VARCHAR2	100		Yes	The name of the extract.The name should be unique.
EXTRACT_TYPE	VARCHAR2	2		Yes	The type of data extraction method. Supported values are BV/AV.
EXTRACT_DESCRIPTION	VARCHAR2	4000			Description of the extraction request.
IS_PRIMARY_EXTRACT_REQ	NUMBER		1		In case the data extraction also requires the Primary Keys
IS_METADATA_EXTRACT_REQ	NUMBER		1		In case the data extraction also requires the metadata field.
BOSS_MODULE_NAME	VARCHAR2	500			BOSS module entity name.
BOSS_OBJECT_NAME	VARCHAR2	500			BOSS Object entity name.
BOSS_EXTRACTION_QUERY	BLOB				BOSS custom payload for an extraction.
BOSS_BV_NAME	VARCHAR2	100			BOSS analytical view/Business View name for the extraction.
OCI_OBJECT_STORAGE_PAR_URL	VARCHAR2	1000			OCI Object Storage Pre-Authenticated Requests URL.
OUTPUT_DATA_FORMAT	VARCHAR2	100			The data format of extracted data.
CSV_DELIMETER	VARCHAR2	2			Custom Delimeter of the CSV file format.
COMPRESSION_TECHNIQUE	NUMBER		1		0 - Disbale, 1- Enable. Supports only GZIP compression per output file.
EXTRACTION_STARTDATETIME	TIMESTAMP				Used in the first extract time.
CATEGORY_NAME	VARCHAR2	500			Category Name
OWNER	VARCHAR2	200			Owner of the extract
APPLICATION_NAME	VARCHAR2	200			Application Identifier
DATA_CHUNK_SIZE	NUMBER		18		Chunk size of the data
ROTATING_FILE_COUNT_IN_ZIP	NUMBER		18		Number of files in the output zip file
ADD_FD_1	VARCHAR2	4000			Additional Field
ADD_FD_2	VARCHAR2	4000			Additional Field
ADD_FD_3	BLOB				Additional Field
ADD_FD_4	BLOB				Additional Field
ADD_FD_5	NUMBER		18		Additional Field
ADD_FD_6	NUMBER		18		Additional Field
ADD_FD_7	TIMESTAMP				Additional Field
ADD_FD_8	TIMESTAMP				Additional Field
ADD_FD_9	VARCHAR2	200			Additional Field
ADD_FD_10	VARCHAR2	200			Additional Field
ADD_FD_11	VARCHAR2	200			Additional Field
ADD_FD_12	VARCHAR2	200			Additional Field
EXTRACT_BY_DATE_FIELD	VARCHAR2	200			Data extraction by given date field from Business Object.
EXTRACTION_VIEW_PARAMS	CLOB				To store extraction view parameters
CSV_FORMAT_TYPE	VARCHAR2	200			CSV format type
EXTRACT_HISTORY_START_DATE	TIMESTAMP				extract history start date
SORT_BY	VARCHAR2	200			sort by
CUSTOM_STORAGE_INFO	VARCHAR2	1000			Custom storage info bucket
DATA_CHUNK_SIZE_ROWS	NUMBER		10		Data chunk size in number of objects/rows
EXTRACT_JOB_PARAMS	CLOB				JSON map for additional extract detail parameters
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index	Uniqueness	Tablespace	Columns
SDTE_EXTRACT_DETAIL_U1	Unique	Default	EXTRACT_ID
SDTE_EXTRACT_DETAIL_U2	Unique	Default	EXTRACT_NAME