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 inserting into client tables. We could start by one week period, but would like to keep auditing for about 3 month, to see which app other than client is doing inserting.

Client tables need auditing:

BUSINESS_CONTACT_CODE
CLIENT_AUDIT_CODE
CLIENT_CONTACT
CLIENT_DOING_BUSINESS_AS
CLIENT_ID_TYPE_CODE
CLIENT_LOCATION
CLIENT_RELATIONSHIP_CODE
CLIENT_STATUS_CODE
CLIENT_TYPE_CODE
CLIENT_UPDATE_ACTION_CODE
CLIENT_UPDATE_REASON
CLIENT_UPDATE_REASON_CODE
FOREST_CLIENT
MAILING_CITY
MAILING_COUNTRY
MAILING_PROVINCE_STATE
MAX_CLIENT_NMBR (not sure if this table still exists)
REGISTRY_COMPANY_TYPE_CODE
RELATED_CLIENT
CLIENT_ACRONYM

Thanks!

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

  • Architecture

  • Data Model

Clone this wiki locally