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 | ||
USER_PASSWORD_LENGTH | Number(10) | NUMBER10 | ||
PIN_NUMBER_DAYS | Number(5) | NUMBER5 | ||
DEMO_KEY | Varchar2(16) | ENCRYPTED | ||
DEMO_EXPIRY_DATE | Date() | DATE | ||
ACTIVATION_KEY | Varchar2(16) | ENCRYPTED | ||
CONCURRENT_USERS | Number(5) | NUMBER5 | ||
LICENSE_TYPE | Varchar2(2) | X_LICENSE_TYPE | ||
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 |
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