Oracle Customer Hub (UCM) Privacy Tables

The following tables are used in Oracle Customer Hub (UCM) Privacy Management solution. The following table shows details of the Privacy Option with Source Ranking table.

Module	Standard Phrasing to Retrieve Values	Description
Privacy option with source hierarchy	A privacy flag source has a rank	This table maintains the relative priority of privacy flag sources when rolling up privacy elections to the financial account level. This table uses the entity, privacy flag source, and a manually created integer value concept, rank. Note: An opt-out request must always be ranked number 1.

The following table shows details of the State Code Cover Letter Table and State Code Notice Type table.

Module	Standard Phrasing to Retrieve Values	Description
CUST.1 Owner type tables	A state code with an owner type determines whether a cover letter or privacy notice is sent.	These tables store the cover letter and privacy notice type codes based on the state code and owner type, or communication message type.

The following table shows details of the Owner Type State Code Change Cover Letter Table.

Module	Standard Phrasing to Retrieve Values	Description
CUST.2 Address changes the tables	A cover letter type is determined after a second state code changes from a first state code.	These tables store the cover letter type codes based on the original state code and the new state code. These tables are instances of the same table type. The correct table is selected by the applicability condition on the parent module based on the owner type.

The following table shows details of the State Restrictiveness Ranking Table.

Module	Standard Phrasing to Retrieve Values	Description
U.S. country rules	A state has a rank.	This table ranks states by their restrictiveness and is used to determine which state must be the privacy state code for a financial account when there are multiple states that come with all the financial account contacts on the financial account.

The following table shows details of the Default Privacy for Privacy Flag table.

Module	Standard Phrasing to Retrieve Values	Description
U.S. FS.1 Default privacy option tables.	A state determines a privacy flag.	These tables determine the default privacy flag options for each privacy flag based on the state code.