Security fixes.
[openemr.git] / sql / metadata_de_identification.txt
blob84532267cb43a6819416ec8532ba1675aff4bac6
1 patient_data,title,0,1,1
2 patient_data,language,0,1,0
3 patient_data,financial,0,1,0
4 patient_data,fname,1,0,1
5 patient_data,mname,1,0,1
6 patient_data,lname,1,0,1
7 patient_data,DOB,0,2,1
8 patient_data,street,1,0,1
9 patient_data,postal_code,1,3,1
10 patient_data,city,1,0,1
11 patient_data,state,1,0,1
12 patient_data,country_code,0,0,1
13 patient_data,drivers_license,1,0,1
14 patient_data,ss,1,0,1
15 patient_data,occupation,0,1,1
16 patient_data,phone_home,1,0,1
17 patient_data,phone_biz,1,0,1
18 patient_data,phone_contact,1,0,1
19 patient_data,phone_cell,1,0,1
20 patient_data,status,0,1,0
21 patient_data,contact_relationship,0,4,0
22 patient_data,date,0,2,0
23 patient_data,sex,0,1,0
24 patient_data,referrer,1,0,1
25 patient_data,email,0,0,1
26 patient_data,ethnoracial,0,4,0
27 patient_data,interpretter,1,0,1
28 patient_data,migrantseasonal,0,4,0
29 patient_data,family_size,0,4,0
30 patient_data,monthly_income,0,1,0
31 patient_data,homeless,0,4,0
32 patient_data,financial_review,0,2,0
33 patient_data,genericname1,0,4,0
34 patient_data,genericname2,0,4,0
35 patient_data,genericval1,0,4,0
36 patient_data,genericval2,0,4,0
37 patient_data,fitness,0,1,0
38 patient_data,referral_source,0,1,0
39 patient_data,usertext1,0,4,0
40 patient_data,usertext2,0,4,0
41 patient_data,usertext3,0,4,0
42 patient_data,usertext4,0,4,0
43 patient_data,usertext5,0,4,0
44 patient_data,usertext6,0,4,0
45 patient_data,usertext7,0,4,0
46 patient_data,usertext8,0,4,0
47 patient_data,userlist1,1,0,0
48 patient_data,userlist2,1,0,0
49 patient_data,userlist3,1,0,0
50 patient_data,userlist4,1,0,0
51 patient_data,userlist5,1,0,0
52 patient_data,userlist6,1,0,0
53 patient_data,userlist7,1,0,0
54 patient_data,pricelevel,0,1,0
55 patient_data,regdate,0,2,0
56 patient_data,contrastrat,0,2,0
57 history_data,coffee,0,4,0
58 history_data,tobacco,0,4,0
59 history_data,alcohol,0,4,0
60 history_data,sleep_patterns,0,4,0
61 history_data,exercise_patterns,0,4,0
62 history_data,seatbelt_use,0,4,0
63 history_data,counseling,0,4,0
64 history_data,hazardous_activities,0,4,0
65 history_data,last_breast_exam,0,4,0
66 history_data,last_mammogram,0,4,0
67 history_data,last_gynocological_exam,0,4,0
68 history_data,last_rectal_exam,0,4,0
69 history_data,last_prostate_exam,0,4,0
70 history_data,last_physical_exam,0,4,0
71 history_data,last_sigmoidoscopy_colonoscopy,0,4,0
72 history_data,last_ecg,0,4,0
73 history_data,last_cardiac_echo,0,4,0
74 history_data,last_retinal,0,4,0
75 history_data,last_fluvax,0,4,0
76 history_data,last_pneuvax,0,4,0
77 history_data,last_ldl,0,4,0
78 history_data,last_hemoglobin,0,4,0
79 history_data,last_psa,0,4,0
80 history_data,last_exam_results,0,4,0
81 history_data,history_mother,0,4,0
82 history_data,history_father,0,4,0
83 history_data,history_siblings,0,4,0
84 history_data,history_offspring,0,4,0
85 history_data,history_spouse,0,4,0
86 history_data,relatives_cancer,0,4,0
87 history_data,relatives_tuberculosis,0,4,0
88 history_data,relatives_high_blood_pressure,0,4,0
89 history_data,relatives_heart_problems,0,4,0
90 history_data,relatives_stroke,0,4,0
91 history_data,relatives_epilepsy,0,4,0
92 history_data,relatives_mental_illness,0,4,0
93 history_data,relatives_suicide,0,4,0
94 history_data,cataract_surgery,0,2,0
95 history_data,tonsillectomy,0,2,0
96 history_data,cholecystestomy,0,2,0
97 history_data,heart_surgery,0,2,0
98 history_data,hysterectomy,0,2,0
99 history_data,hernia_repair,0,2,0
100 history_data,hip_replacement,0,2,0
101 history_data,knee_replacement,0,2,0
102 history_data,appendectomy,0,2,0
103 history_data,date,0,2,0
104 history_data,name_1,0,4,0
105 history_data,name_2,0,4,0
106 history_data,value_1,0,4,0
107 history_data,value_2,0,4,0
108 history_data,additional_history,0,4,0
109 history_data,exams,0,4,0
110 history_data,usertext11,0,4,0
111 history_data,usertext12,0,4,0
112 history_data,usertext13,0,4,0
113 history_data,usertext14,0,4,0
114 history_data,usertext15,0,4,0
115 history_data,usertext16,0,4,0
116 history_data,usertext17,0,4,0
117 history_data,usertext18,0,4,0
118 history_data,usertext19,0,4,0
119 history_data,usertext20,0,4,0
120 history_data,usertext21,0,4,0
121 history_data,usertext22,0,4,0
122 history_data,usertext23,0,4,0
123 history_data,usertext24,0,4,0
124 history_data,usertext25,0,4,0
125 history_data,usertext26,0,4,0
126 history_data,usertext27,0,4,0
127 history_data,usertext28,0,4,0
128 history_data,usertext29,0,4,0
129 history_data,usertext30,0,4,0
130 history_data,userdate11,0,2,0
131 history_data,userdate12,0,2,0
132 history_data,userdate13,0,2,0
133 history_data,userdate14,0,2,0
134 history_data,userdate15,0,2,0
135 history_data,userarea11,0,4,0
136 history_data,userarea12,0,4,0
137 lists,date,0,2,0
138 lists,type,0,1,0
139 lists,title,0,4,0
140 lists,begdate,0,2,0
141 lists,enddate,0,2,0
142 lists,returndate,0,2,0
143 lists,occurrence,0,1,0
144 lists,classification,0,1,0
145 lists,referredby,1,0,0
146 lists,extrainfo,0,4,0
147 lists,diagnosis,0,1,0
148 lists,activity,0,1,0
149 lists,comments,0,4,0
150 lists,user,1,0,0
151 lists,groupname,0,1,0
152 lists,outcome,0,1,0
153 lists,destination,0,4,0
154 prescriptions,date_added,0,2,0
155 prescriptions,date_modified,0,2,0
156 prescriptions,start_date,0,2,0
157 prescriptions,drug,0,1,0
158 prescriptions,drug_id,0,1,0
159 prescriptions,dosage,0,1,0
160 prescriptions,quantity,0,1,0
161 prescriptions,size,0,1,0
162 prescriptions,unit,0,1,0
163 prescriptions,route,0,1,0
164 prescriptions,substitute,0,1,0
165 prescriptions,refills,0,1,0
166 prescriptions,per_refill,0,1,0
167 prescriptions,filled_date,0,2,0
168 prescriptions,medication,0,1,0
169 prescriptions,note,0,4,0
170 prescriptions,active,0,1,0
171 immunizations,administered_date,0,2,0
172 immunizations,immunization_id,0,1,0
173 immunizations,manufacturer,0,1,0
174 immunizations,administered_by,1,0,0
175 immunizations,education_date,0,2,0
176 immunizations,vis_date,0,2,0
177 immunizations,note,0,4,0
178 immunizations,create_date,0,2,0
179 immunizations,update_date,0,2,0
180 immunizations,created_by,1,0,0
181 immunizations,updated_by,1,0,0
182 transactions,date,0,2,0
183 transactions,title,0,4,0
184 transactions,body,0,4,0
185 transactions,user,1,0,0
186 transactions,groupname,0,1,0
187 transactions,authorized,0,1,0
188 transactions,refer_date,0,2,0
189 transactions,refer_diag,0,4,0
190 transactions,refer_risk_level,0,4,0
191 transactions,refer_vitals,0,1,0
192 transactions,refer_external,0,1,0
193 transactions,reply_date,0,2,0
194 transactions,reply_from,1,0,0
195 transactions,reply_init_diag,0,4,0
196 transactions,reply_final_diag,0,4,0
197 transactions,reply_documents,0,4,0
198 transactions,reply_findings,0,4,0
199 transactions,reply_services,0,4,0
200 transactions,reply_recommend,0,4,0
201 transactions,reply_rx_refer,1,0,0
202 payments,dtime,0,2,0
203 payments,user,1,0,0
204 payments,amount1,0,1,0
205 payments,posted1,0,1,0
206 payments,amount2,0,1,0
207 payments,posted2,0,1,0
208 billing,date,0,2,0
209 billing,code_type,0,1,0
210 billing,user,1,0,0
211 billing,groupname,0,1,0
212 billing,authorized,0,1,0
213 billing,billed,0,1,0
214 billing,bill_date,0,2,0
215 billing,process_date,0,2,0
216 billing,modifier,0,1,0
217 billing,units,0,1,0
218 billing,fee,0,1,0
219 insurance_data,type,0,1,0
220 insurance_data,provider,1,0,0
221 insurance_data,plan_number,0,1,0
222 insurance_data,policy_number,0,1,0
223 insurance_data,subscriber_lname,1,0,0
224 insurance_data,subscriber_mname,1,0,0
225 insurance_data,subscriber_fname,1,0,0
226 insurance_data,subscriber_ss,1,0,0
227 insurance_data,subscriber_DOB,0,2,0
228 insurance_data,subscriber_street,1,0,0
229 insurance_data,subscriber_postal_code,0,3,0
230 insurance_data,subscriber_city,1,0,0
231 insurance_data,subscriber_state,1,0,0
232 insurance_data,subscriber_country,0,1,0
233 insurance_data,subscriber_phone,1,0,0
234 insurance_data,subscriber_employer,1,0,0
235 insurance_data,subscriber_employer_street,1,0,0
236 insurance_data,subscriber_employer_postal_code,0,3,0
237 insurance_data,subscriber_employer_country,0,1,0
238 insurance_data,subscriber_employer_state,1,0,0
239 insurance_data,subscriber_employer_city,1,0,0
240 insurance_data,copay,0,1,0
241 insurance_data,date,0,2,0
242 insurance_data,subscriber_sex,0,1,0
243 insurance_data,accept_assingment,0,1,0
244 facility,name,1,0,0
245 facility,phone,1,0,0
246 facility,fax,1,0,0
247 facility,street,1,0,0
248 facility,city,1,0,0
249 facility,state,1,0,0
250 employer_data,name,1,0,0
251 employer_data,street,1,0,0
252 employer_data,city,1,0,0
253 employer_data,state,1,0,0
254 users,username,1,0,0
255 users,fname,1,0,0
256 users,mname,1,0,0
257 users,lname,1,0,0
258 users,organization,1,0,0
259 users,street,1,0,0
260 users,streetb,1,0,0
261 users,city,1,0,0
262 users,state,1,0,0
263 users,street2,1,0,0
264 users,streetb2,1,0,0
265 users,city2,1,0,0
266 users,state2,1,0,0
267 users,phone,1,0,0
268 users,fax,1,0,0
269 users,phonew1,1,0,0
270 users,phonew2,1,0,0
271 users,phonecell,1,0,0
272 addresses,line1,1,0,0
273 addresses,line2,1,0,0
274 addresses,city,1,0,0
275 addresses,state,1,0,0