data-dictionary

FPSADMIN.FR_W_MNT_DEF_VERS_CHG_HIST

Data Dictionary

>

FPSADMIN Tables

> FPSADMIN.FR_W_MNT_DEF_VERS_CHG_HIST

Table FPSADMIN.FR_W_MNT_DEF_VERS_CHG_HIST"

Stores the change log of changes made to maintenance definition versions

  • Schema: FPSADMIN

  • Tablespace: FPSDATAHIST

  • Primary key: ID


Column

Type

Nullable

Comment

ID

NUMBER(16)

N

INST

DATE

Time when the event occurred. (* from FPSINPUT.WIP_EVENT_HIST)

MNT_DEF_VERSION_TRANSACTION

VARCHAR2(50)

TRANSACTION_USER_EMAIL

VARCHAR2(200)

TRANSACTION_USER_NAME_DISPLAY

VARCHAR2(200)

VERSION_APPROVER_NOTES

VARCHAR2(1000)

VERSION_CATEGORY

VARCHAR2(200)

VERSION_CURRENT_APPROVER_LIST

VARCHAR2(1000)

VERSION_DESCRIPTION

VARCHAR2(500)

VERSION_EQP_TYPES

VARCHAR2(2000)

VERSION_MULTIPLE_CHAMBER

CHAR(1)

VERSION_NAME

VARCHAR2(200)

VERSION_PRCD

CLOB

VERSION_REVIEW_ROLE

VARCHAR2(200)