FFS_DWH_EXPORT_FILE
Defines a list of files to be exported by Daily Extract.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: DATA
Primary Key
| Name | Columns |
|---|---|
|
FFS_DWH_EXPORT_FILE_PK |
FILE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| FILE_ID | NUMBER | 5 | Yes | Unique identifier for the export file. | |
| FILE_NAME | VARCHAR2 | 1020 | Specifies file name a data to be exported to. | ||
| ENTITY | VARCHAR2 | 1020 | Name of the entity for which data is exported. | ||
| FORMAT | VARCHAR2 | 3 | File format of exporting data: xml or csv. | ||
| ARCHIVE | VARCHAR2 | 6 | Specifies type of the archive of the exporting file. | ||
| FOLDER | VARCHAR2 | 1020 | Specifies a folder in which export file will be located. | ||
| NAME_ARCHIVE | VARCHAR2 | 1020 | Specifies format of the archive file name. | ||
| EXTERNAL_ARCHIVE | VARCHAR2 | 1020 | Deprecated. Will be removed soon. | ||
| CSV_FIELDS_TERMINATED | VARCHAR2 | 12 | Specifies a separator which is used to delimit fields in csv file. | ||
| CSV_ENCLOSED_HEADER | VARCHAR2 | 12 | Specifies a symbol which is used for csv file header fields enclosing. . | ||
| CSV_ENCLOSED | VARCHAR2 | 12 | Specifies a symbol for csv fields enclosing. | ||
| CSV_LINE_END_IS | VARCHAR2 | 32 | Specifies a symbol which is added at the end of each csv line. | ||
| CSV_EMPTY_ENCLOSED | VARCHAR2 | 4 | Specifies a symbol which is used for enclosing of empty csv fields. | ||
| ENCODING | VARCHAR2 | 256 | Specifies file encoding. UTF-8 is used by default. | ||
| REALTIME_ENABLED | NUMBER | 5 | Yes | If this flag is set then realtime data update is enabled. | |
| CHANNEL_ID | NUMBER | 5 | Yes | Link to the channel the export file belongs. Reference to Message Agent table. | |
| SUBSCRIPTION_ID | VARCHAR2 | 1020 | Outbound Integration Channel name. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_DWH_EXPORT_FILE_PK | Unique | DATA | FILE_ID |