Data Dictionary
>
FPSADMIN Tables
> FPSADMIN.MSOUI_W_TRANSACTION_HIST
Table FPSADMIN.MSOUI_W_TRANSACTION_HIST"
Master MSO transaction history. All changes are made at lower level tables. One record for each transaction is stored in this table and the transaction id is what links all the sub tables together based on the parent_transaction_id.
-
Schema: FPSADMIN
-
Tablespace: FPSDATAHIST
-
Primary key: TRANSACTION_ID
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
TRANSACTION_ID |
VARCHAR2(75) |
N |
|
|
OS_USER_ID |
VARCHAR2(50) |
N |
|
|
TRANSACTION_CHANGE_DESC |
VARCHAR2(1000) |
N |
|
|
TRANSACTION_CHANGE_TYPE |
VARCHAR2(100) |
N |
|
|
TRANSACTION_COMMENT |
VARCHAR2(2000) |
||
|
TRANSACTION_INST |
DATE |