!!!Alias: MAR
(P2K_AM_ACCESS_RULES)

Unique Keys: [ACCESSOR_TYPE]

ERD: [ERD-AM90]

description

!!Table Columns
\\
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]|Y|
|[ACCESSOR_TYPE]|Varchar2(3)|[X_ACCESSOR_TYPE]|Y|
|[VALIDATION_METHOD]|Varchar2(3)|[X_VALIDATION_METHOD]|Y|
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CREATE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[PASSWORD_LENGTH]|Number(5)|[NUMBER5|NUMBERn]| |
|[PASSWORD_DIGIT]|Varchar2(1)|[TOGGLE]| |
|[PASSWORD_PUNCTUATION]|Varchar2(1)|[TOGGLE]| |
|[PASSWORD_DAYS]|Number(5)|[NUMBER5|NUMBERn]| |
|[PASSWORD_MUST_CHANGE]|Varchar2(1)|[TOGGLE]| |
|[EXPIRE_LOCK_AFTER_DAYS]|Number(5)|[NUMBER5|NUMBERn]| |
|[NUMBER_PRIOR_PASSWORDS]|Number(5)|[NUMBER5|NUMBERn]| |
|[LOGIN_ATTEMPTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[MAX_LOGIN_ATTEMPTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[IP_LOCKOUT_MINUTES]|Number(5)|[NUMBER5|NUMBERn]| |
|[FORCE_PASSWORD_CHANGE]|Varchar2(1)|[TOGGLE]| |

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


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