SVC_STD_TXT_HISTORY
This table stores the history table of Standard Text usage for user reporting.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_STD_TXT_HISTORY_PK |
STD_TXT_HIST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| STD_TXT_HIST_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | ||
| 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. | |||
| USER_PARTY_ID | NUMBER | 18 | Foreign Key to HZ_PARTIES.PARTY_ID. Indicates the user that used the Standard Text. | |||
| TYPE | VARCHAR2 | 32 | Foreign Key to the Type of the Standard Text used. | |||
| OBJECT_USED | VARCHAR2 | 30 | The object this Standard Text was used in. | |||
| OBJECT_REFERENCE | VARCHAR2 | 30 | Unique reference to the row in the object this Standard Text was used in. | |||
| OBJECT_REFERENCE_ID | NUMBER | 18 | Foreign Key to the primary key of the referenced object | |||
| STD_TXT_ID | NUMBER | 18 | Yes | Foreign Key to the Standard Text. | ||
| STDTXT_NAME | VARCHAR2 | 50 | Short descriptive name for the Standard Text. | Obsolete | ||
| TEXT | CLOB | The actual Standard Text that was used after variable substitution. | Obsolete | |||
| TXT_LANG | VARCHAR2 | 4 | Yes | Indicates the code of the language into which the contents of the translatable columns are translated. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| SVC_STD_TXT_HISTORY | svc_standard_text_b | STD_TXT_ID |
| SVC_STD_TXT_HISTORY | hz_parties | USER_PARTY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_STD_TXT_HISTORY_F1 | Non Unique | Default | STD_TXT_ID |
| SVC_STD_TXT_HISTORY_F2 | Non Unique | Default | USER_PARTY_ID |
| SVC_STD_TXT_HISTORY_N1 | Non Unique | Default | OBJECT_USED, OBJECT_REFERENCE |
| SVC_STD_TXT_HISTORY_N2 | Non Unique | Default | OBJECT_REFERENCE_ID |
| SVC_STD_TXT_HISTORY_N3 | Non Unique | Default | OBJECT_USED, OBJECT_REFERENCE_ID |
| SVC_STD_TXT_HISTORY_N4 | Non Unique | Default | TRUNC("LAST_UPDATE_DATE") |
| SVC_STD_TXT_HISTORY_PK | Unique | Default | STD_TXT_HIST_ID |