PPT Slide
I.B.7. QUERY DATABASE (Example #4)
REPORT GENERATOR OPTION > QUERY DATABASE
FORM. SELECTION > LCA = BIRTH CERTIFICATE
LEVEL 1: FIELD TO BE REPORTED ON > I24B (RESIDENCE COUNTY CODE)
Data Dictionary: Field 24B is county of mother’s residence and I=Integer LEVEL 1: PLEASE ENTER SPECIFIC VALUE(S) > 56
LEVEL 2: FIELD TO BE REPORTED ON > 25B (MONTH PRENATAL CARE BEGAN)
LEVEL 2: PLEASE ENTER SPECIFIC VALUE(S) > 7TH;8TH;9TH
LEVEL 3: FIELD TO BE REPORTED ON > 10 (MOTHER'S STATE OF BIRTH)
LEVEL 3: PLEASE ENTER SPECIFIC VALUE(S) > MEXICO
LEVEL 4: FIELD TO BE REPORTED ON > 24E (MOTHER'S RES ZIP CODE)
LEVEL 4: PLEASE ENTER SPECIFIC VALUE(S) >
RESIDENCE COUNTY CODE: 56 ... 5616 SUCCESSES 999 FAILURES (84.90%)
MONTH OF PREGNANCY OR DATE PRENATAL CARE BEGAN: 7TH;8TH;9TH ...
93 SUCCESSES 5523 FAILURES(1.66%)
MOTHER'S STATE BIRTH: MEXICO .. 49 SUCCESSES 44 FAILURES (52.69%)
MOTHER'S RESIDENCE ZIP CODE:
93010 ... 1 ... 2.04% FILE# 1200056000347 (56:LCA)