!!!Alias: MAC 
(P2K_AM_ACCESSORS)

Unique Keys: User ([MUS_ID]) + Identity ([EID_ID]) + Candidate ([RCA_ID]) + Role ([MRO_ID]) + Recruiter ([RRE_ID])

ERD: [ERD-AM90]

description

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[EID_ID]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES]
|[MRO_ID]|Number(10)|[ID]| |link to [P2K_AM_ROLES]
|[MUS_ID]|Number(10)|[ID]| |link to [P2K_AM_USERS]
|[RCA_ID]|Number(10)|[ID]| |link to [P2K_RE_CANDIDATES]
|[RRE_ID]|Number(10)|[ID]| |link to [P2K_RE_RECRUITERS]
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[ACCESS_START_DATE]|Date()|[DATE]| |
|[ACCESS_END_DATE]|Date()|[DATE]| |
|[FORCE_PASSWORD_CHANGE]|Varchar2(1)|[TOGGLE]| |
|[LAST_GOOD_ACCESS]|Date()|[TIMESTAMP]| |
|[LOGINS_TO_DATE]|Number(10)|[NUMBER10|NUMBERn]| |
|[ACCESSOR_KEY]|Varchar2(50)|[VARCHAR30|VARCHARnn]| |


!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_EMAIL_PASSWORD]
|[DRV_EXISTING_PASSWORD]
|[DRV_GENERATE_PASSWORD]
|[DRV_NEW_PASSWORD]
|[DRV_PASSWORD_CONFIRMATION]



User Fields: Not Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_AM_ACCESSORS] 	
[{InsertPage page='Internal.P2K_AM_ACCESSORS' default='Click to create a new notes page'}]