Corvenna Instruments, Inc. - Customer Master Data Standard DS-04 (rev. 6, effective 20X4-07-01)

Section 2 - Data quality dimensions used by Corvenna

Dimension	Definition applied by the data governance group
Completeness	A mandatory attribute is populated for every record for which it is mandatory.
Validity	A populated value conforms to the defined format mask or falls within the permitted domain of values.
Uniqueness	A single real-world entity is represented by only one record.
Accuracy	A value agrees with the designated authoritative source of record for that attribute.
Referential integrity	A foreign-key value exists in the referenced master or reference table.
Timeliness	A value reflects the recency required by the standard.
Consistency	The same attribute carries the same value across two or more systems that both store it.

Section 3 - Field-level rules and load action on failure

Rule	Attribute	Requirement	Load action on failure
R-1	CUST_ID	Must match mask C-###### (literal "C-" followed by exactly six digits)	Reject
R-2	CUST_LEGAL_NAME	Must be populated	Reject
R-3	TAX_ID	Mandatory where COUNTRY_CD = 'US'; where populated must match mask ##-#######	Reject
R-4	COUNTRY_CD	Must be a code in the permitted domain at Appendix A.1	Reject
R-5	SALES_TERR_CD	Must exist in the ERP TERRITORY master table (Appendix A.2)	Reject
R-6	CREDIT_LIMIT	Must equal the limit approved in the Credit Committee register (source of record)	Exception
R-7	TAX_ID	Must not repeat across records with STATUS_CD = 'A'. Customer IDs are issued sequentially; where a repeat occurs the duplicate-detection routine flags the higher-numbered CUST_ID.	Exception
R-8	STATUS_CD	Must be A (active), H (credit hold) or T (terminated)	Reject
R-9	LAST_REVIEW_DT	Must be no earlier than 24 months before the extract date and not later than the extract date	Exception

Section 4 - Load actions. "Reject" records are written to the reject file and are not loaded to the target platform. "Exception" records are loaded and routed to the data steward work queue for post-load remediation. A record failing no rule loads clean.

Appendix A.1 - Permitted COUNTRY_CD domain: US, CA, GB, DE, FR, JP, MX

Appendix A.2 - ERP TERRITORY master table: NE-02, SE-05, MW-03, EU-07, EM-11, AP-09

Save your progress

Configure Exam

Results

Free CPA Sample Exam