data-dictionary

FPSADMIN.FR_W_MNT_TASK_VERSIONS

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.FR_W_MNT_TASK_VERSIONS

Table FPSADMIN.FR_W_MNT_TASK_VERSIONS"

Stores the definition details for each FabRecover task version

  • Schema: FPSADMIN

  • Tablespace: FPSDATA

  • Primary key: VERSION_NAME

  • Foreign keys: FR_W_MNT_TASK_VERSIONS_FK_TASK: MNT_TASK REFERENCES FPSAPP.FR_W_MNT_TASKS (MNT_TASK)

  • Referenced by: FPSAPP.FR_W_MNT_TASK_VERS_APPROVER (VERSION_NAME)


Column

Type

Nullable

Comment

VERSION_NAME

VARCHAR2(200)

N

INST_LAST_TRANSACTION

DATE

INST_TO_PROD

DATE

INST_TO_TEST

DATE

MNT_TASK

VARCHAR2(200)

PACKAGE_LN_FRAMEWORK

VARCHAR2(50)

PACKAGE_UPLOAD_EXTENSION

VARCHAR2(200)

PACKAGE_UPLOAD_NAME

VARCHAR2(200)

PACKAGE_UPLOAD_PATH

VARCHAR2(200)

PACKAGE_UPLOAD_TARGET

VARCHAR2(200)

VERSION_ENVIRONMENT

VARCHAR2(50)

VERSION_NUMBER

NUMBER(10)

VERSION_RELEASE_NOTES

VARCHAR2(1000)

VERSION_STATE

VARCHAR2(20)

VERSION_SUBMIT_USER_EMAIL

VARCHAR2(200)

VERSION_SUBMIT_USER_NAME

VARCHAR2(200)