Alias: MST#
(P2K_AM_SITES)Unique Keys: SITE_CODE
ERD: ERD-AM20
A physical location where products are installed.
Note that only one record is expected in this tableTable Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | Y | |
| SITE_CODE | Varchar2(16) | CODE | Y | |
| MST_ID | Number(10) | ID | link to P2K_AM_SITES | |
| DESCRIPTION | Varchar2(50) | DESCRIPTION | ||
| USER_PASSWORD_DAYS | Number(5) | NUMBER5 | Now set in IMAR | |
| USER_PASSWORD_LENGTH | Number(10) | NUMBER10 | Now set in IMAR | |
| PIN_NUMBER_DAYS | Number(5) | NUMBER5 | Now set in IMAR | |
| DEMO_KEY | Varchar2(16) | ENCRYPTED | No longer used | |
| DEMO_EXPIRY_DATE | Date() | DATE | No longer used | |
| ACTIVATION_KEY | Varchar2(16) | ENCRYPTED | No longer used | |
| CONCURRENT_USERS | Number(5) | NUMBER5 | No longer used | |
| LICENSE_TYPE | Varchar2(2) | X_LICENSE_TYPE | No longer used | |
| ENVIRONMENT | Varchar2(2000) | VARCHAR2000 | ||
| MAIL_HOST | Varchar2(200) | URL | ||
| MAIL_DOMAIN | Varchar2(200) | URL | ||
| CREATE_DATE | Date() | DATE | Y | |
| CREATE_USER | Varchar2(30) | VARCHAR30 | Y | |
| CHANGE_DATE | Date() | DATE | Y | |
| CHANGE_USER | Varchar2(30) | VARCHAR30 | Y | |
| USER_PASSWORD_DIGIT | Varchar2(1) | TOGGLE | ||
| USER_PASSWORD_PUNCTUATION | Varchar2(1) | TOGGLE | ||
| J2EE_LAST_PING | Date() | TIMESTAMP | ||
| RAW_KEY | Varchar2(50) | RAW50 | ||
| MAIL_PORT | NUMBER(5,0) | NUMBERn | ||
| MAIL_AUTHENTICATION_PW | RAW(50) | RAW50 | ||
| MAIL_AUTHENTICATION_USER | VARCHAR2(100) | VARCHARnn | ||
| ENCRYPTION_ENABLED | Varchar2(1) | TOGGLE |
Derived Fields#
| Column Name |
|---|
| DRV_ALL_USERS_MESSAGE |
| DRV_AS_OF_DATE |
| DRV_DB_IP |
| DRV_DB_SID |
| DRV_DB_VERSION |
| DRV_PERSONALITY |
| DRV_SERVER_VERSION |
| DRV_USER |
| DRV_VERSION |
| DRV_WINDWARD_VERSION |
User Fields: Not Allowed
Audit Logging: Not Allowed
