Attached Files:  U4A2 Table.docx (13.543 KB) Assignment Objectives: Meet CAHI

Attached Files:

 U4A2 Table.docx (13.543 KB)

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

You may also like