Benutzer:Rainerb/Anonymization

aus Wikipedia, der freien Enzyklopädie

Anonymization / Deanonymization

Reference data

Process type reference – HTC Anonym Validation Types

In form HTC Anonym Validation Types the minimum cancellation age are configured for customers that shall be anonymized in relation to the different process types.

Figure 1 1

HTC Anonym Validation Types
ID Process type ID
Name Name of the process type.
Description Description of the process type.
Min. can. age Minimum number of days a customer has to be cancelled before he may be anonymized.

TTT

There are sex differences in stages of addiction (see Table 1: (Becker et al., 2017, p. 137)). Women tend to show a greater sensitivity to stress and are less supported for being abstinent. A social problem is the greater stigmatization of addicted women, hindering their recovery [1]. Additionally, women in drug abuse treatment report more severe functional impairment as well as an overall lower quality in life. Women tend to seek treatment more quickly after the initiation of drug use and addiction onset than men. Differences in treatment outcome might emerge from gender differences, but overall behavioral therapy studies found similar outcome in men and women for treatments like cognitive behavior therapy or contingency management. There are controverse findings whether gender-specific treatments produce better outcome due to enhanced comfort, feelings of safety, etc. among women, but no evidence had been yet found [2].



TSTTST

In der nordwestlichen Ecke des Gebiets des Ortsteils Isenbruch befindet sich der westlichste Punkt[3] Deutschlands, der am 20. Juni 2015 feierlich als Erlebnisraum eingeweiht wurde. Auch schon vor[4] den Grenzverschiebungen nach dem Ersten Weltkrieg bei Eupen und Malmedy galt Isenbruch


Anonymization

Data discovery - [5]BC will make detail analysis of the system to find all the tables and fields that need to be updated during anonymization process. BC will deliver to HT list of tables and fields that will be included in process of anonymization in technical specification after analysis. Some tables will not be under anonymized/deletion by some short period of time (LOGS) or they don’t have the specific data even though they are extension of original table (HIST). Table that contains list of customers that HT has put on blacklist (BLACKLIST tables) will not be anonymized.

Anonymization – A new recurring process for anonymization. Update on the data (anonymization) will be done without sending update of master data to other systems (CRM and SAP) and with making Note in Notes but with special message defined only for anonymization.

The contract OIB identifies customers to be anonymized.

Processing

Processing is separated in two processing steps. First validation of data and secondly the anonymization process, supported by queue tables:

  • Validation: HTC_CUST_ANONYM_VAL_QUEUE
  • Anonymization: HTC_CUST_ANONYM_REQ_QUEUE


Preconditions

Postal Code 99999 for all countries has to be available in POSTAL_CODES_REF.

Validation
Candidate Check

Verify for data of queue table HTC_CUST_ANONYM_VAL_QUEUE that it adheres to the following rules:

  • Number of cancellation days defined in setting HTC_ANONYM_MIN_CANC_AGE (minimum number of months a customer has to be in cancellation before it can be anonymized).
  • Contract / Subscriber cancelled
  • Products cancelled
  • Service cancelled
  • Contract: all subscribers in a contract are in status cancelled or contract is empty
  • In case of duplicate OIB / JMBG: the first OIB / JMBG is processed if preconditions are fulfilled. The second one and perhaps further will be ignored.
Check Target Anonymized OIB

The purpose of this process is to check whether an OIB, JMGB that has been detected by DWH and Trust Center as candidate for anonymization can be anonymized in Billing Components. It is verified that the new planned anonymized OIB - OIB/JMBG is not already in use.


Queue table HTC_CUST_ANONYM_VAL_QUEUE
Column Name Type Description
ID NUMBER (11) Unique identifier
OIB VARCHAR2 (18) OIB number
JMBG VARCHAR2 (18) JMBG number
PROCESS_TYPE VARCHAR2 (1) Defined in Process Type Reference
PROCESS_STATUS VARCHAR2 (1) N - new, not processed
D – technically processed. Note: will be set for technical processing, even if TIBCO RESULT_CODE is negative.
E - fatal processing error
ERROR_TEXT VARCHAR2 (2000) Error text
PROCESS_STATUS_DATE DATE Processing date
RESULT_CODE VARCHAR2 (13) TIBCO result code:
SUCCESS: operation successfully completed
DENIED: user has active service
NOT FOUND: user does not exist in system
OIB COLLISION: anonymized OIB exists
RESULT_DESCIRPTION VARCHAR2 (256) Description
TC_TRANSACTION_ID VARCHAR2 (30)
TIBCO_TRANSACTION_ID VARCHAR2 (30)

ID NUMBER (11) Unique identifier OIB VARCHAR2 (18) OIB number JMBG VARCHAR2 (18) JMBG number PROCESS_TYPE VARCHAR2 (1) Defined in Process Type Reference PROCESS_STATUS VARCHAR2 (1) N - new, not processed D – technically processed. Note: will be set for technical processing, even if TIBCO RESULT_CODE is negative. E - fatal processing error ERROR_TEXT VARCHAR2 (2000) Error text PROCESS_STATUS_DATE DATE Processing date RESULT_CODE VARCHAR2 (13) TIBCO result code: - SUCCESS: operation successfully completed - DENIED: user has active service - NOT FOUND: user does not exist in system - OIB COLLISION: anonymized OIB exists RESULT_DESCIRPTION VARCHAR2 (256) Description TC_TRANSACTION_ID VARCHAR2 (30) TIBCO_TRANSACTION_ID VARCHAR2 (30) Table 2 1 HTC_CUST_ANONYM_VAL_QUEUE

Anonymization / Deanonymization

Customer are identifiable as anonymized / deanonymized on contract and subscriber level in logging tables CUST_CONTRACTS_ANONYM and CUST_SUBSCRIBERS_ANONYM.

Queue table HTC_CUST_ANONYM_REQ_QUEUE:

Column Name Type Description ID NUMBER(11) Unique identifier ORIG_OIB VARCHAR2(18) Original OIB ORIG_JMBG VARCHAR2(18) Original JMBG NEW_OIB VARCHAR2(18) New OIB NEW_JMBG VARCHAR2(18) New JMBG NEW_FIRST_NAME VARCHAR2(30) New customer first name NEW_LAST_NAME VARCHAR2(30) New customer last name NEW_BILL_EMAIL VARCHAR2(40) New bill E-Mail NEW_CONTACT_EMAIL VARCHAR2(40) New contact E-Mail TASK_ID VARCHAR2(30) - ANONYMIZE - DEANONYMIZE PROCESS_STATUS VARCHAR2(1) - N - new, not processed - D – successfully processed - E - validation, processing error or fatal exception ERROR_TEXT VARCHAR2(2000) Textual error description PROCESS_STATUS_DATE DATE Processing date RESULT_CODE VARCHAR2(13) TIBCO result code: - SUCCESS: operation successfully completed - DENIED: user has active service - NOT FOUND: user does not exist in system - OIB COLLISION: anonymized OIB exists RESULT_DESCRIPTION VARCHAR2(256) Result description NEW_LEGAL_ADDRESS_CITY VARCHAR2(20) New legal address city NEW_LEGAL_ADDRESS_NUMBER VARCHAR2(9) New legal address number NEW_LEGAL_ADDRESS_ADD_NUMBER VARCHAR2(40) New legal address and number NEW_DELIVERY_ADDRESS_CITY VARCHAR2(20) New delivery address city NEW_DELIVERY_ADDRESS_NUMBER VARCHAR2(9) New delivery address number NEW_DELIVERY_ADDRESS_ADD_NUM VARCHAR2(40) New delivery address and number NEW_CONTACT_PHONE VARCHAR2(15) New contact phone NEW_CALLER_NUMBER VARCHAR2(128) New caller number NEW_CALLED_NUMBER VARCHAR2(128) New called number VALIDATION_TYPE VARCHAR2(1) Defined in Process Type Reference Table 2 2 HTC_CUST_ANONYM_REQ_QUEUE


Recurring Processes
Recurring process name Log ID Process description
PROC_CUST_ANONYM_VAL PROC_CUST_ANONYM_VALIDATION Validate customer anonymization data.
PROC_CUST_ANONYM_REQ PROC_CUST_ANONYM_REQUESTS Process customer anonymization/de-anonymization.


Settings
Setting name Description Example
HTC_ANONYM_MIN_CANC_AGE Min. number of months a customer has to be in cancellation before it can be anonymized. Default 11 years = 132 months. 132
  1. Becker, J. B., McClellan, M. L., & Reed, B. G. (2017). Sex differences, gender and addiction. JOURNAL OF NEUROSCIENCE RESEARCH, 95(1-2), 136-147. https://deepblue.lib.umich.edu/bitstream/handle/2027.42/134421/jnr23963_am.pdf?sequence=1
  2. McHugh, R. K., Votaw, V. R., Sugarman, D. E., & Greenfield, S. F. (2018). Sex and gender differences in substance use disorders. Clinical Psychology Review, 66, 12-23. https://doi.org/10.1016/j.cpr.2017.10.012
  3. In openstreetmap: [1]
  4. … der westlichste Punkt ist Isenbruch im Kreise Heinsberg, in dem zur preußischen Rheinprovinz gehörigen Regierungsbezirk Aachen, unter 51° 6' n. Br. und 23° 40' ö. L. Nach Andern liegt der westlichste Punkt eine Meile südwestlich von der niederländisch-limburgischen Stadt Weert, am Süd-Wilhelms-Canal, unter 23° 15' ö. L.S. 4 in S. Steinhard: Deutschland und sein Volk: ein Lese- und Hausbuch für Jung und Alt zur Förderung und Belebung vaterländischen Sinnes und Wissens, Band 1, Friedrich Brandstetter, 1856
  5. dies ist eine Referenz.