Alias: MOF#
(P2K_AM_OPENDED_FORMS)Unique Keys:
ERD:
Opened Forms
Table Columns#
Column name | Data Type / Size | Domain | Mand. | Notes |
---|---|---|---|---|
CHANGE_DATE | DATE | DATE | Y | |
CREATE_DATE | DATE | DATE | Y | |
ID | NUMBER(10,0) | ID | Y | |
MFN_ID | NUMBER(10,0) | ID | Y | |
MSA_ID | NUMBER(10,0) | ID | Y | |
CLOSED_TIMESTAMP | DATE | TIMESTAMP | ||
OPENED_TIMESTAMP | DATE | TIMESTAMP | Y | |
EXCEPTIONS_ENCOUNTERED | VARCHAR2(1) | TOGGLE | ||
CREATE_USER | VARCHAR2(30) | VARCHAR30 | Y | |
CHANGE_USER | VARCHAR2(30) | VARCHAR30 | Y |
User Fields: Allowed
Audit Logging: Allowed