Skip to content

Data Request Client table usage audit

MCatherine edited this page Dec 2, 2022 · 8 revisions

Shall we please start some audit for the client tables? We would like to see which applications are doing inserts into those client tables. We could start by one-week period, but we would like to potential keep auditing for about 3 months to see which apps other than client is doing insertions.

Client tables that need auditing:

BUSINESS_CONTACT_CODE
CLIENT_ACTION_REASON_XREF
CLIENT_AUDIT_CODE
CLIENT_CONTACT
CLIENT_DOING_BUSINESS_AS
CLIENT_DOING_BUSINESS_AS_AUDIT
CLIENT_ID_TYPE_CODE
CLIENT_LOCATION
CLIENT_RELATIONSHIP_CODE
CLIENT_RELATIONSHIP_TYPE_XREF
CLIENT_STATUS_CODE
CLIENT_TYPE_CODE
CLIENT_TYPE_COMPANY_XREF
CLIENT_UPDATE_ACTION_CODE
CLIENT_UPDATE_REASON
CLIENT_UPDATE_REASON_CODE
CLI_CON_AUDIT
CLI_LOCN_AUDIT
FOREST_CLIENT
FOR_CLI_AUDIT
MAILING_CITY
MAILING_COUNTRY
MAILING_PROVINCE_STATE
MAX_CLIENT_NMBR (not sure if this table still exists)
REGISTRY_COMPANY_TYPE_CODE
RELATED_CLIENT
REL_CLI_AUDIT
CLIENT_ACRONYM
V_CLIENT_PUBLIC

Thanks!

CLIENT application (The Ministry of Forests' client management system)

  • Architecture

  • Data Model

Clone this wiki locally