Data Dictionary
>
FPSBASE Tables
> FPSBASE.MSO_SEQUENCES
Table FPSBASE.MSO_SEQUENCES"
This table lists the MSO sequence objects and what table and column they populate via table triggers. The purpose of this table is for the ADM_MSO_UTILITIES package to be able to recreate sequences when rules are copied from another database to ensure the copy procedures can reset the sequence value based on the current value or highest value in the table.
-
Schema: FPSBASE
-
Tablespace: FPSDATA
-
Primary key: SEQUENCE_OWNER, SEQUENCE_NAME
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
SEQUENCE_OWNER |
VARCHAR2(30) |
N |
|
|
SEQUENCE_NAME |
VARCHAR2(30) |
N |
|
|
COLUMN_NAME |
VARCHAR2(30) |
Name of the column in DWH. Note: The column may exist in more than one table and/or schema. (* from FPSINPUT.GEN_EXPLANATIONS) |
|
|
TABLE_NAME |
VARCHAR2(30) |