TAAS

=> GUI Change
-> User Mandatory and User 
-> Document Activity List change
- Remove Created By Column
- Remove Action Date & Time Column
- Increase Action width
-> Master Activity List change
- Remove Created By Column
- Remove Action Date & Time Column
- Increase Action width 

=> Document Activity SQL
========================

SELECT MAX(bin_documents_id) AS bin_documents_id,

        MAX(fk_branch_id) AS fk_branch_id,
     MAX(fk_department_id) fk_department_id,

    MAX(vhr_document_no) AS vhr_document_no,,
    MAX(dat_document) AS dat_document,
    MAX(vhr_account_code) AS vhr_account_code,
    MAX(vhr_account_name) AS vhr_account_name,

        ARRAY_AGG ('Created'  || '#' ||  fk_created_user_id::text || '#' || to_char(DATE dtm_created, 'DD/MM/YYYY') || '~Edited#' || fk_last_modified_user_id::text || '#' || to_char(DATE dtm_last_modified, 'DD/MM/YYYY') || '~Deleted#' || fk_deleted_user_id::text || '#' || to_char(DATE dtm_deleted, 'DD/MM/YYYY') || '~Prited#' || fk_printed_user_id::text || '#' || to_char(DATE dtm_printed, 'DD/MM/YYYY') ) arr_actions

FROM (
SELECT pk_documents_id AS bin_documents_id,
        fk_branch_id,
    fk_department_id,

    vhr_document_no,
    dat_document,
    vhr_account_code,
    vhr_account_name,

        fk_created_user_id,
    dtm_created,
    fk_last_modified_user_id,
    dtm_last_modified,
    fk_deleted_user_id,
    dtm_deleted,
        NULL fk_printed_user_id,
        NULL prl.dtm_printed
FROM document.tbl_documents doc
    LEFT JOIN accounts.tbl_account ac
        ON doc.fk_ledger_id = ac.pk_account_id
WHERE fk_branch_id = 
    AND fk_department_id
    AND (fk_created_user_id = INPUT_USER_ID OR fk_last_modified_user_id = INPUT_USER_ID OR fk_deleted_user_id = INPUT_USER_ID)
    AND (dtm_created BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_last_modified BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_deleted BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO)
    AND dat_document BETWEEN INPUT_DOCFROM AND INPUT_DOC_TO
    ...
UNION ALL

SELECT bin_documents_id,
        fk_branch_id,
    fk_department_id,

    vhr_document_no,
    dat_document,
    vhr_account_code,
    vhr_account_name,

        fk_created_user_id,
    dtm_created,
    fk_last_modified_user_id,
    dtm_last_modified,
    fk_deleted_user_id,
    dtm_deleted,
        NULL fk_printed_user_id,
        NULL prl.dtm_printed
FROM FROM tbl_documents_log docl
    LEFT JOIN accounts.tbl_account ac
        ON docl.fk_ledger_id = ac.pk_account_id
WHERE fk_branch_id = 
    AND fk_department_id
    AND (fk_created_user_id = INPUT_USER_ID OR fk_last_modified_user_id = INPUT_USER_ID OR fk_deleted_user_id = INPUT_USER_ID)
    AND (dtm_created BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_last_modified BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_deleted BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO)
    AND dat_document BETWEEN INPUT_DOCFROM AND INPUT_DOC_TO
    ...

UNION ALL

SELECT doc.pk_documents_id AS bin_documents_id,
        doc.fk_branch_id,
    doc.fk_department_id,

    doc.vhr_document_no,
    doc.dat_document,
    doc.vhr_account_code,
    doc.vhr_account_name,

        NULL fk_created_user_id,
    NULL dtm_created,
    NULL fk_last_modified_user_id,
    NULL dtm_last_modified,
    NULL fk_deleted_user_id,
    NULL dtm_deleted,
        prl.fk_printed_user_id,
        prl.dtm_printed,
FROM tbl_print_action_log prl
        LEFT JOIN document.tbl_documents doc
                ON prl.vhr_document_no doc.vhr_document_no
    LEFT JOIN accounts.tbl_account ac
        ON doc.fk_ledger_id = ac.pk_account_id
WHERE fk_branch_id = 
    AND fk_department_id
    AND (fk_created_user_id = INPUT_USER_ID OR fk_last_modified_user_id = INPUT_USER_ID OR fk_deleted_user_id = INPUT_USER_ID)
    AND (dtm_created BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_last_modified BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO OR dtm_deleted BETWEEN INPUT_ACTION_FROM AND INPUT_ACTION_TO)
    AND dat_document BETWEEN INPUT_DOCFROM AND INPUT_DOC_TO
    ...
UNION ALL

...
service.tbl_service
service.tbl_service_log
..
)
GROUP BY vhr_document_no
ORDER BY bin_documents_id

-> Action Column Value

LstAction = []

loop strAction in arr_actions
lst1 = strAction.split("~")
loop str1 in lst1 
lst2 = str1.split("#")

IF lst2 [1] == INPUT_USER_ID
    LstAction.Add(lst2[0] + "(" + lst2[2] + ")" )

strAction = LstAction.join(', ')

=> Master Tab SQL
=================
SELECT sin_ac_category,
    vhr_account_code,
    vhr_account_name,

    fk_created_user_id,
        dtm_created,
        fk_last_modified_user_id,
        dtm_last_modified,
        fk_deleted_user_id,
        dtm_deleted,
FROM accounts.tbl_account

UNION

settings.tbl_settings

UNION 

localization.tbl_language

UNION 

localization.tbl_country

UNION

[All INHERITS(tbl_action_user_and_date_time) non document and support doc tables]

-> Action Column Value
IF fk_created_user_id == INPUT_USER_ID
    LstAction.Add("Created(" + dtm_created.forat(..) + ")" )
IF fk_last_modified_user_id== INPUT_USER_ID
    LstAction.Add("Edited(" + dtm_last_modified.forat(..) + ")" )
IF fk_deleted_user_id== INPUT_USER_ID
    LstAction.Add("Deleted(" + dtm_deleted.forat(..) + ")" )

TESTING DONE

TESTING DONE