Alias: MUS#

(P2K_AM_USERS)

Unique Keys: USER_NAME

ERD: ERD-AM10

A database user that is allowed to use the system.

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
USER_NAMEVarchar2(30)VARCHAR30Y
USER_PASSWORDVarchar2(16)ENCRYPTEDY
PASSWORD_CHANGED_DATEDate()DATE
PASSWORD_CHANGED_BYVarchar2(50)VARCHAR50
ACCESS_START_DATEDate()DATE
ACCESS_END_DATEDate()DATE
LAST_ACCESSED_TIMESTAMPDate()TIMESTAMP
LOGINS_TO_DATENumber(10)NUMBER10
CREATE_ALLOWEDVarchar2(1)TOGGLE
RETRIEVE_ALLOWEDVarchar2(1)TOGGLE
UPDATE_ALLOWEDVarchar2(1)TOGGLE
DELETE_ALLOWEDVarchar2(1)TOGGLE
DESCRIPTIONVarchar2(50)DESCRIPTION
EMAIL_ADDRESS(Field)Varchar2(100)EMAIL
EID_IDNumber(10)ID associated to P2K_HR_IDENTITIES
FILTERS_ONVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
RAW_PASSWORDVarchar2(50)RAW50

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page