!!!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 name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[USER_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[USER_PASSWORD]|Varchar2(16)|[ENCRYPTED]|Y| |[PASSWORD_CHANGED_DATE]|Date()|[DATE]| | |[PASSWORD_CHANGED_BY]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[ACCESS_START_DATE]|Date()|[DATE]| | |[ACCESS_END_DATE]|Date()|[DATE]| | |[LAST_ACCESSED_TIMESTAMP]|Date()|[TIMESTAMP]| | |[LOGINS_TO_DATE]|Number(10)|[NUMBER10|NUMBERn]| | |[CREATE_ALLOWED]|Varchar2(1)|[TOGGLE]| | |[RETRIEVE_ALLOWED]|Varchar2(1)|[TOGGLE]| | |[UPDATE_ALLOWED]|Varchar2(1)|[TOGGLE]| | |[DELETE_ALLOWED]|Varchar2(1)|[TOGGLE]| | |[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| | |[EMAIL_ADDRESS(Field)]|Varchar2(100)|[EMAIL]| | |[EID_ID]|Number(10)|[ID]| |associated to [P2K_HR_IDENTITIES] |[FILTERS_ON]|Varchar2(1)|[TOGGLE]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[RAW_PASSWORD]|Varchar2(50)|[RAW50]| | User Fields: Not Allowed\\ Audit Logging: Not Allowed\\ ---- ![Notes|Edit:Internal.P2K_AM_USERS] [{InsertPage page='Internal.P2K_AM_USERS' default='Click to create a new notes page'}]