Alias: MII#
(P2K_AM_IMPORTANT_INFORMATION)Unique Keys:
Child Table:
Parent Table:
ERD:
P2K_AM_IMPORTANT_INFORMATION
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| INFO_CODE | VARCHAR2(60) | VARCHAR60 | Y | |
| DESCRIPTION | VARCHAR2(200) | VARCHAR200 | N | |
| INFO_STATUS | VARCHAR2(2) | X_INFO_STATUS | N | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CREATE_DATE | Date() | DATE | Y | |
| INFO_TYPE | VARCHAR2(2) | X_INFO_TYPE | N | |
| START_DATE | DATE() | DATE | N | |
| END_DATE | DATE() | DATE | N | |
| WEB_ADDRESS | VARCHAR2(200) | URL | N | |
| INFORMATION | VARCHAR2(4000) | VARCHAR4000 | N | |
| SIGN_OFF_REQUIRED | VARCHAR2(1) | TOGGLE | N | |
| MASTER_DOCUMENT | VARCHAR2(1) | TOGGLE | N | |
| MII_ID | Number(10) | ID | N | link to P2K_AM_IMPORTANT_INFORMATION |
User Fields: Allowed
Audit Logging: Allowed
