-
Notifications
You must be signed in to change notification settings - Fork 2
Data Request Client table usage audit
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