Repository navigation
Expand file tree
/
Copy pathapplication_codest270623.sql
More file actions
36 lines (35 loc) · 11.7 KB
/
Copy pathapplication_codest270623.sql
File metadata and controls
36 lines (35 loc) · 11.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('DSD_MODEL_COMMUNITY', 'Mother infant pair/Mentor mother led', 'en', '', 'DSD_MODEL_COMMUNITY_MOTHER_INFANT_PAIR_MENTOR_MOTHER_LED', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('DSD_FACILITY', 'Mother infant pair/Mentor mother led', 'en', '', 'DSD_FACILITY_MOTHER_INFANT_PAIR_MENTOR_MOTHER_LED', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('TB_SCREENING_OUTCOME', 'TB Suspected and referred for evaluation', 'en', '', 'TB_SCREENING_OUTCOME_TB_SUSPECTED_AND_REFERRED_FOR_EVALUATION', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('TB_SCREENING_OUTCOME', 'No sign or symptoms of TB', 'en', '', 'TB_SCREENING_OUTCOME_NO_SIGN_OR_SYMPTOMS_OF_TB', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Others (specify)', 'en', '', 'COVID_ADVERSE_EFFECT_OTHERS_(SPECIFY)', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Facial Paralysis', 'en', '', 'COVID_ADVERSE_EFFECT_FACIAL_PARALYSIS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Neck Stiffness', 'en', '', 'COVID_ADVERSE_EFFECT_NECK_STIFFNESS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Encephalopathy', 'en', '', 'COVID_ADVERSE_EFFECT_ENCEPHALOPATHY', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Sepsis', 'en', '', 'COVID_ADVERSE_EFFECT_SEPSIS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Unconsciousness', 'en', '', 'COVID_ADVERSE_EFFECT_UNCONSCIOUSNESS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Acute Flaccid Paralysis', 'en', '', 'COVID_ADVERSE_EFFECT_ACUTE_FLACCID_PARALYSIS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Fever', 'en', '', 'COVID_ADVERSE_EFFECT_FEVER', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Joint pain', 'en', '', 'COVID_ADVERSE_EFFECT_JOINT_PAIN', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'muscle pain', 'en', '', 'COVID_ADVERSE_EFFECT_MUSCLE_PAIN', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Bleeding', 'en', '', 'COVID_ADVERSE_EFFECT_BLEEDING', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Diarrhoea', 'en', '', 'COVID_ADVERSE_EFFECT_DIARRHOEA', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Vomiting', 'en', '', 'COVID_ADVERSE_EFFECT_VOMITING', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Abd cramps', 'en', '', 'COVID_ADVERSE_EFFECT_ABD_CRAMPS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Lymph node enlargement', 'en', '', 'COVID_ADVERSE_EFFECT_LYMPH_NODE_ENLARGEMENT', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Rash/Urticaria', 'en', '', 'COVID_ADVERSE_EFFECT_RASH_URTICARIA', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Abscess at injection site', 'en', '', 'COVID_ADVERSE_EFFECT_ABSCESS_AT_INJECTION_SITE', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Site induration', 'en', '', 'COVID_ADVERSE_EFFECT_SITE_INDURATION', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Local reaction', 'en', '', 'COVID_ADVERSE_EFFECT_LOCAL_REACTION', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Loss of vision', 'en', '', 'COVID_ADVERSE_EFFECT_LOSS_OF_VISION', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Seizures/convulsion', 'en', '', 'COVID_ADVERSE_EFFECT_SEIZURES_CONVULSION', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Fainting/Syncope', 'en', '', 'COVID_ADVERSE_EFFECT_FAINTING_SYNCOPE', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Headache', 'en', '', 'COVID_ADVERSE_EFFECT_HEADACHE', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Dizziness', 'en', '', 'COVID_ADVERSE_EFFECT_DIZZINESS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Anaphylactic Shock', 'en', '', 'COVID_ADVERSE_EFFECT_ANAPHYLACTIC_SHOCK', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_ADVERSE_EFFECT', 'Anaphylaxis', 'en', '', 'COVID_ADVERSE_EFFECT_ANAPHYLAXIS', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_DOSAGE_NUMBER', 'Booster', 'en', '', 'COVID_DOSAGE_NUMBER_BOOSTER', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_DOSAGE_NUMBER', 'Second Dose', 'en', '', 'COVID_DOSAGE_NUMBER_SECOND_DOSE', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('COVID_DOSAGE_NUMBER', 'First Dose', 'en', '', 'COVID_DOSAGE_NUMBER_FIRST_DOSE', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
INSERT INTO base_application_codeset (codeset_group, display, language, version, code, date_created, created_by, date_modified, modified_by, archived) VALUES ('CERVICAL_CANCER_SCREENING_METHOD', 'HPV', 'en', '', 'CERVICAL_CANCER_SCREENING_METHOD_HPV', '2023-06-27 00:00:00', 'guest@lamisplus.org', '2023-06-27 00:00:00', 'guest@lamisplus.org', 0);
SELECT pg_catalog.setval('base_application_codeset_id_seq', (SELECT MAX(id) FROM base_application_codeset) , true);