!!!Alias: MCL (P2K_AM_CHANGE_LOGS) Unique Keys: None ERD: [ERD-AM30] Header for detail of changes made. !!Table Columns ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[MTD_ID]|Number(10)|[ID]|Y|link to [P2K_AM_TABLE_DETAILS] |[REFERENCE_ID]|Number(10)|[NUMBER10|NUMBERn]|Y| |[CHANGE_ACTION]|Varchar2(2)|[X_CHANGE_ACTION]|Y| |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[SUBJECT_REF_ID]|Number(10)|[NUMBER10|NUMBERn]| | |[SUBJECT_REF_CODE]|Varchar2(16)|[CODE]| | |[EFFECTIVE]|Date()|[EFFECTIVE]| | |[EXPIRY]|Date()|[EXPIRY]| | |[CHANGE_CODE]|Varchar2(16)|[CODE]| | |[FUNCTION_NAME]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CONTEXT_1]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]|Parent record information is shown here (in XML format) | |[CONTEXT_2]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]|Full record information is shown here (in XML format) | |[MSA_ID]|Number(10)|[ID]| |link to [P2K_AM_SESSION_AUDITS] User Fields: Not Allowed\\ Audit Logging: Not Allowed\\ [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.P2K_AM_CHANGE_LOGS] [{InsertPage page='Internal.P2K_AM_CHANGE_LOGS' default='Click to create a new discussion page'}] }]