Data Dictionary
>
FPSAPP Tables
> FPSAPP.ADM_VERSIONS
Table FPSAPP.ADM_VERSIONS"
Installation history of all versions of the FPS DWH and the database objects for each application. Please note this it is allowed to install the same version repeatedly which often happens during development and testing of a new version.
-
Schema: FPSAPP
-
Tablespace: FPSDATA
-
Primary key: INSTALL_INST
|
Column |
Type |
Nullable |
Comment |
|---|---|---|---|
|
INSTALL_INST |
DATE |
N |
This is the time when the script started running on this database. |
|
INSTALLED_BY |
VARCHAR2(64) |
N |
|
|
INSTALL_COMMENT |
VARCHAR2(128) |
||
|
INSTALL_COMPLETE_INST |
DATE |
This is the time when the script complete running on this database. To be more specific, it is the time when we turned ETL on (or when we skipped turning ETL on because we knew we were continuing to upgrade to a newer version). A a null value in this column signifies that the upgrade script for the version has not yet completed. |
|
|
RELEASE_INST |
DATE |
N |
This is the time is when the script was built by Build_official_upgrade_script.sh. |