FV_DATA_ACT_REPORT_EXTRACT
This table stores the data in the printable format.
Details
-
Schema: FUSION
-
Object owner: FV
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
FV_DATA_ACT_REP_EXTRACT_PK |
REPORT_EXTRACT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REPORT_EXTRACT_ID | NUMBER | 18 | Yes | Unique identifier of the report output record. | |
| REPORT_RUN_ID | NUMBER | 18 | Yes | Unique identifier of the file processing attributes. | |
| SEQUENCE_NUMBER | NUMBER | 6 | Yes | Sequence number that specifies in which order the records are to be printed on the report. | |
| TEXT_COLUMN_1 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_2 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_3 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_4 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_5 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_6 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_7 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_8 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_9 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_10 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_11 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_12 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_13 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_14 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_15 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_16 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_17 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_18 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_19 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_20 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_21 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_22 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_23 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_24 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_25 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_26 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_27 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_28 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_29 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_30 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_31 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_32 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_33 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_34 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_35 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_36 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_37 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_38 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_39 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_40 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_41 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_42 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_43 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_44 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_45 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_46 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_47 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_48 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_49 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_50 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_51 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_52 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_53 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_54 | VARCHAR2 | 120 | COLUPrintable format of the report output valueMN1 | ||
| TEXT_COLUMN_55 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_56 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_57 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_58 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_59 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_60 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_61 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_62 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_63 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_64 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_65 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_66 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_67 | VARCHAR2 | 120 | COLUPrintable format of the report output valueMN1 | ||
| TEXT_COLUMN_68 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_69 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_70 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_71 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_72 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_73 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_74 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_75 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_76 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_77 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_78 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_79 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_80 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_81 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_82 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_83 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_84 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_85 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_86 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_87 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_88 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_89 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_90 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_91 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_92 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_93 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_94 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_95 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_96 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_97 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_98 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_99 | VARCHAR2 | 120 | Printable format of the report output value | ||
| TEXT_COLUMN_100 | VARCHAR2 | 120 | Printable format of the report output value | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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 |
|---|---|---|---|
| FV_DATA_ACT_REPORT_EXT_U2 | Unique | FUSION_TS_TX_DATA | REPORT_RUN_ID, SEQUENCE_NUMBER |
| FV_DATA_ACT_REP_EXTRACT_U1 | Unique | FUSION_TS_TX_DATA | REPORT_EXTRACT_ID |