PPT Slide
I.B.8. QUERY DATABASE (Example #5)
REPORT GENERATOR OPTION > QUERY DATABASE
FORM. SELECTION > LCA = BIRTH CERTIFICATE
LEVEL 1: FIELD TO BE REPORTED ON > I24B (RESIDENCE COUNTY CODE)
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
Data Dictionary: You must enter the EXACT value expected in that field.
LEVEL 4: FIELD TO BE REPORTED ON > 24E (MOTHER'S RES ZIP CODE)
LEVEL 4: PLEASE ENTER SPECIFIC VALUE(S) > 93033
LEVEL 5: FIELD TO BE REPORTED ON > LFN (ASSIGNED LOCAL FILE NO)
LEVEL 5: 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: 93033 ... 13 SUCCESSES 36 FAILURES ASSIGNED LOCAL FILE NUMBER:
1200056000094 ... 1 ... 7.69% FILE# 1200056000094 (56:LCA) 1200056000321 ... 1 ... 7.69% FILE# 1200056000321 (56:LCA) 1200056000944 ... 1 ... 7.69% FILE# 1200056000944 (56:LCA)