3-1 Activity: Data Dictionary Development

Tags:

• Activity
• Age
• Analysis
• Antibiotic
• Applied
• Being
• Body
• Calculation
• Care
• Case Study 1 for a
• Code
• Collection
• Commission
• Content
• Cost
• Data
• Description
• Determination
• Development
• Dictionary
• During
• Element
• Elements
• Essay on Quality
• Evil Lies Deep Within Analysis of The

Show more

Pages:

1

Words:

275

Get document Get an original paper

3-1 Activity: Data Dictionary Development Name Institutional Affiliation 3-1 Activity: Data Dictionary Development Categories in the Data Dictionary Template HIM 350 Communications and TechnologiesModule Three Data Dictionary Template Table Field Datatype Description and/or Calculation PATIENT DOB Date The birthdate for the patient AGE Integer The age of the patient NAME Varchar(64) The official name of the patient NEXT_OF_KIN Varchar(64) The occupation of the patient DIAGNOSIS DIAGNOSIS_CODE Varchar(64) The code for the patient's diagnosis PRINCIPAL_DIAGNOSIS Varchar(64) Diagnosis of the patient's primary condition SECONDARY_DIAGNOSIS Varchar(64) Diagnosis of the patient’s underlying and secondary conditions DIAGNOSIS_PROCEDURE Varchar(64) The procedure the physician undertook in the primary and secondary diagnosis ENCOUNTER ADMIT_TIMESTAMP Date The admission date and time for a patient's visit LENGTH_OF_STAY Integer The length of stay at the hospital INPATIENT_SERVICE_DAYS Integer The number of days taken during treatment DISCHARGE_INSTRUCTIONS Varchar(64) The instructions for the patient at the time of discharge SPECIAL_INSTRUCTIONS Varchar(64) The special instructions for the patient during treatment ATTENDING_PHYSICIAN Varchar(64) The name of the physician responsible for the patient       MEDICATION NAME Varchar(64) The name of the antibiotic given DOSE Integer The duration and quantity of medication intake MEDICATION_ROUTE Varchar(64) The process of delivering the medication into the patient’s system SPECIAL_INSTRUCTIONS Varchar(64) The special instructions that accompany the patient’s self-medication PROCEDURE PROCEDURE_ID