Skip to content

Data Request Client table usage audit

Maria Martinez 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 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_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