Assignment Objectives:

Meet CAHIIM Curriculum requirement for Associate Degree
Domain VI. Leadership
Subdomain VI.K. Enterprise Information Management
Section 1. Apply knowledge of database architecture and design
Competencies: Data dictionary, interoperability
Meet CAHIIM Curriculum requirement for Associate Degree
Domain I. Data Content Structure and Standards
Subdomain I.C. Data Governance
Section 1. Apply policies and procedures to ensure the accuracy and integrity of health data
Competencies: Data Integrity concepts and standards
Meet CAHIIM Curriculum requirement for Bachelor Degree
Domain III. Informatics, Analytics and Data Use
Subdomain III.H. Information Integrity and Data Quality
Section: 5. Model policy initiatives that influence data integrity
Competencies: Characteristics of data integrity
Meet CAHIIMA Curriculum requirement for Bachelor Degree
Domain I. Data Content Structure and Standards
Subdomain I.C. Data Governance
Section 2. Construct and maintain the standardization of data dictionaries to meet the needs of the enterprise
Competencies: Data sources
Assignment Purpose:

HIM Professionals will frequently work with data dictionaries. This assignment will build an understanding of data dictionary development and maintenance and the importance of data integrity.

Assignment Description:

Step One: Review the sample data dictionary below. There are a number of blank fields in the table. Your first task is to fill in all of the blank fields,

Field Name

Field Type

Field Size

Definition

Acceptable Values

Patient_ID (primary key)

Number

8

Unique patient number automatically generated

0-9

Gender

Character

1

Gender of the patient

M = Male

F = Female

U = Unknown

PT_LN

Alphanumeric

50

Patient’s legal surname

A-Z

PT_FN

Alphanumeric

50

Patient’s legal first name

A-Z

PT_DOB

0-9

8

Patient’s date of birth

MM-DD-YYYY

PT_Race

Alphanumeric

25

Patient’s declared race

American Indian

Alaskan Native

Asian

African American

White

PayerType

Alphanumeric

25

Patient’s primary source of payment

BC/BS

CHAMPUS

Medicaid

Medicare

Self-Pay

Other

InsuranceID

City

State

Zip

Country

VisitDate

Step Two: Write a justification discussing why each field was necessary and why the value you used was appropriate. (NOTE: Address every blank that you filled in)

Step Three: Next discuss the characteristics of data integrity