LAYOUT FOR AVSS 2007 CBC FILE
Use: GENERATE 2007 CBC FILE (1800)

REC	FIELD	LEN	BEG	END	Description	Format
1	SFN	13	1	13	STATE FILE NUMBER	105YYYYNNNNNN
2	LFN	13	14	26	LOCAL REGISTRATION NUMBER	1YYYYCCNNNNNN
3	1A	30	27	56	NAME OF CHILD - FIRST	ALPHA
4	1B	24	57	80	MIDDLE	ALPHA
5	1C	34	81	114	LAST NAME	ALPHA
6	2	6	115	120	SEX (TEXT)	ALPHA
7	I2	1	121	121	SEX (CODE)	N (1, 2, 9)
8	3A	12	122	133	THIS BIRTH, SINGLE, TWIN, ETC.	ALPHA
9	I3A	1	134	134	BIRTH TYPE (PLURALITY) CODE	N (1-8, 9)
10	3B	1	135	135	THIS CHILD 1ST, 2ND, ETC.	N
11	4A	10	136	145	DATE OF BIRTH	CCYY-MM-DD
12	4B	4	146	149	HOUR - 24 HOUR CLOCK TIME	NNNN
13	5A	36	150	185	PLACE OF BIRTH - NAME OF HOSPITAL/FACILITY	ALPHA
14	5B	44	186	229	STREET ADDRESS - STREET, NUMBER, LOCATION	ALPHA
15	5C	36	230	265	CITY	ALPHA
16	5D	16	266	281	COUNTY	ALPHA
17	I5D	3	282	284	COUNTY OF BIRTH CODE	NNN
18	6A	20	285	304	NAME OF FATHER/PARENT	ALPHA
19	6B	15	305	319	MIDDLE	ALPHA
20	6C	26	320	345	LAST	ALPHA
21	7	15	346	360	FATHER'S BIRTHPLACE TEXT	ALPHA
22	I7	3	361	363	FATHER'S BIRTHPLACE CODE	NNN: APPENDIX
23	8	10	364	373	FATHER'S DATE OF BIRTH	CCYY-MM-DD
24	FAGE	2	374	375	FATHER'S AGE	NN
25	9A	20	376	395	NAME OF MOTHER/PARENT	ALPHA
26	9B	15	396	410	MIDDLE	ALPHA
27	9C	26	411	436	LAST	ALPHA
28	10	15	437	451	MOTHER'S BIRTHPLACE TEXT	ALPHA
29	I10	3	452	454	MOTHER'S BIRTHPLACE CODE	NNN: APPENDIX
30	11	10	455	464	MOTHER'S DATE OF BIRTH	CCYY-MM-DD
31	MAGE	2	465	466	MOTHER'S AGE	NN
32	12A	39	467	505	PARENT OR OTHER INFORMANT - SIGNATURE	ALPHA
33	12B	16	506	521	RELATIONSHIP TO CHILD (OF PARENT OR OTHER)	ALPHA
34	I12B	1	522	522	RELATIONSHIP TO CHILD (CODE)	N
35	12C	10	523	532	DATE SIGNED (BY PARENT OR OTHER INFORMANT)	CCYY-MM-DD
36	13B	13	533	545	LICENSE NUMBER (OF ATTENDANT)	ALPHA
37	13C	10	546	555	DATE SIGNED (BY ATTENDANT OR CERTIFIER)	CCYY-MM-DD
38	13D	60	556	615	NAME, TITLE AND MAILING ADDRESS OF ATTNDT	ALPHA
39	14	29	616	644	NAME/TITLE OF CERTIFIER IF OTHER THAN ATTDNT	ALPHA
40	15A	10	645	654	DATE OF DEATH	CCYY-MM-DD
41	15B	13	655	667	STATE FILE NUMBER (OF DEATH CERTIFICATE)	305YYYYNNNNNN
42	DI	1	668	668	DEATH INDICATOR	N (0, 1, 2, 3)
43	16	38	669	706	LOCAL REGISTRAR - SIGNATURE	ALPHA
44	17	10	707	716	DATE ACCEPTED FOR REGISTRATION	CCYY-MM-DD
45	18	50	717	766	RACE (OF FATHER)	ALPHA
46	18	48	767	814	FATHER'S MULTIPLE RACE TEXT VALUES (3X16)	ALPHA
47	I18M	6	815	820	MULTIPLE RACE CODES (OF FATHER)	NN x 3: RACE CODES
48	19	18	821	838	FATHER HISPANIC, LATINO, OR SPANISH?	ALPHA: APPENDIX
49	I19	1	839	839	HISPANIC CODE (OF FATHER)	HISPANIC CODE
50	20	10	840	849	DATE LAST WORKED (OF FATHER)	CCYY-MM---
51	20A	39	850	888	USUAL OCCUPATION (OF FATHER)	ALPHA
52	20B	36	889	924	KIND OF BUSINESS OR INDUSTRY/FATHER	ALPHA
53	20C	16	925	940	EDUCATION - HIGHEST LEVEL OR DEGREE/FATHER)	ALPHA: APPENDIX
54	21	50	941	990	RACE (OF MOTHER)	ALPHA
55	21	48	991	1038	MOTHER'S MULTIPLE RACE TEXT VALUES (3X16)	ALPHA
56	I21M	6	1039	1044	MULTIPLE RACE CODES (OF MOTHER)	NN x 3: RACE CODES
57	22	18	1045	1062	MOTHER HISPANIC, LATINO, OR SPANISH?	ALPHA: APPENDIX
58	I22	1	1063	1063	HISPANIC CODE (OF MOTHER)	HISPANIC CODE
59	23	10	1064	1073	DATE LAST WORKED (OF MOTHER)	CCYY-MM---
60	23A	39	1074	1112	USUAL OCCUPATION (OFMOTHER)	ALPHA
61	23B	36	1113	1148	KIND OF BUSINESS OR INDUSTRY/MOTHER	ALPHA
62	23C	16	1149	1164	EDUCATION - HIGHEST LEVEL OR DEGREE/MOTHER	ALPHA: APPENDIX
63	24A	50	1165	1214	MOTHER'S RESIDENCE STREET NUMBER LOCATION	ALPHA
64	24B	30	1215	1244	COUNTY/PROVINCE	ALPHA: APPENDIX
65	24C	35	1245	1279	CITY	ALPHA: APPENDIX
66	24D	25	1280	1304	STATE/FOREIGN COUNTRY	ALPHA: APPENDIX
67	24E	5	1305	1309	ZIP CODE	NNNNN
68	25A	10	1310	1319	DATE LAST NORMAL MENSES BEGAN	CCYY-MM-DD
69	25AA	10	1320	1329	DATE FIRST PRENATAL CARE VISIT	CCYY-MM-DD
70	25B	3	1330	1332	MONTH PRENATAL CARE BEGAN	ALPHA
71	I25B	2	1333	1334	MONTH PRENATAL CARE BEGAN CODE	NN
72	25BA	10	1335	1344	DATE LAST PRENATAL CARE VISIT	CCYY-MM-DD
73	25C	2	1345	1346	NUMBER OF PRENATAL VISITS	NN
74	25D	2	1347	1348	PRINICIPAL SOURCE PAYMENT/PRENATAL CARE	NN: APPENDIX
75	26	4	1349	1352	BIRTHWEIGHT	NNNN
76	26A	2	1353	1354	OBSTETRIC EST OF GESTATION - WKS	NN
77	GAGE	3	1355	1357	DAYS GESTATION FROM LMP TO DOB	NNN
78	26B	24	1358	1381	HEARING SCREENING	ALPHA: APPENDIX
79	27A	2	1382	1383	PREVIOUS LIVE BIRTHS - NOW LIVING	NN
80	27B	2	1384	1385	PREVIOUS LIVE BIRTHS - NOW DEAD	NN
81	27C	10	1386	1395	DATE OF LAST LIVE BIRTH	CCYY-MM-DD
82	27D	2	1396	1397	OTHER TERMINATIONS BEFORE 20 WEEKS	NN
83	27E	2	1398	1399	OTHER TERMINATIONS AFTER 20 WEEKS	NN
84	27F	10	1400	1409	DATE OF LAST OTHER TERMINATION	CCYY-MM---
85	TLB	2	1410	1411	TOTAL LIVE BIRTHS	NN
86	TCB	2	1412	1413	TOTAL CHILDREN EVER BORN	NN
87	28AA	2	1414	1415	METHOD OF DELIVERY (FINAL DELIVERY ROUTE)	NN: APPENDIX
88	28AB	1	1416	1416	HOW MANY PREVIOUS CESAREANS	N: APPENDIX
89	28AC	1	1417	1417	FETAL PRESENTATION	N: APPENDIX
90	28AD	1	1418	1418	VAGINAL DELIVERY WITH FORCEPS ATTEMPTED?	N: APPENDIX
91	28AE	1	1419	1419	VAGINAL DELIVERY WITH VACUUM ATTEMPTED?	N: APPENDIX
92	28B	2	1420	1421	EXPECTED SOURCE OF PAYMENT FOR DELIVERY	N: APPENDIX
93	29	32	1422	1453	COMPLICATIONS/PROCEDURES OF PREGNANCY	NN x 16: APPENDIX
94	30	18	1454	1471	COMPLICATIONS/PROCEDURES LABOR/DELIVERY	NN x 9: APPENDIX
95	31	20	1472	1491	ABNORMAL CONDITIONS & CLINICAL PROCEDURES	NN x 10: APPENDIX
96	32	9	1492	1500	FATHER/PARENT SOCIAL SECURITY NUMBER	ALPHA
97	33	9	1501	1509	MOTHER/PARENT SOCIAL SECURITY NUMBER	ALPHA
98	A	4	1510	1513	MATERNITY HOSPITAL CODE	Hospital Code
99	B	3	1514	1516	PLACE OF MOTHER'S RESIDENCE CODE	NNN: APPENDIX
100	CT	6	1517	1522	CENSUS TRACT	NNNNNN
101	FIPS1	5	1523	1527	FIPS CITY PLACE CODE (MOTHER'S RESIDENCE)	BLANKS
102	FIPS2	3	1528	1530	FIPS COUNTY PLACE CODE (MOTHER'S RESIDENCE)	BLANKS
103	D	1	1531	1531	TYPE OF ATTENDANT/CERTIFIER CODE	N (1-6,9)
104	F	2	1532	1533	ENUMERATION AT BIRTH	YY, YN, NN
105	CSSN	9	1534	1542	SSN (OF CHILD)	BLANKS
106	APGAR1	2	1543	1544	APGAR SCORE AT 1 MINUTE	NN (1-10, 99)
107	APGAR5	2	1545	1546	APGAR SCORE AT 5 MINUTES	NN (1-10, 99)
108	APGAR10	2	1547	1548	APGAR SCORE AT 10 MINUTES	NN (1-10, 99)
109	CIGPN	2	1549	1550	NO OF CIGARETTES/DAY 3 MOS BEFORE PREG	NN
110	CIGFN	2	1551	1552	NO OF CIGARETTES/DAY FIRST TRIMESTER	NN
111	CIGSN	2	1553	1554	NO OF CIGARETTES/DAY SECOND TRIMESTER	NN
112	CIGTN	2	1555	1556	NO OF CIGARETTES/DAY THIRD TRIMESTER	NN
113	DECP	1	1557	1557	DECLARATION OF PATERNITY	BLANK
114	MAR	1	1558	1558	MOTHER MARRIED?	BLANK
115	MSTREET	50	1559	1608	MOTHER'S MAILING ADDRESS (STREET OR PO BOX)	ALPHA
116	MCITY	35	1609	1643	MAILING ADDRESS CITY OR TOWN	ALPHA
117	MCOUNTY	30	1644	1673	MAILING ADDRESS COUNTY	ALPHA
118	MSTATE	25	1674	1698	MAILING ADDRESS STATE	ALPHA
119	MZIP	5	1699	1703	MAILING ADDRESS ZIP CODE	NNNNN
120	MHT1	1	1704	1704	MOTHER'S HEIGHT (FEET)	N
121	MHT2	2	1705	1706	MOTHER'S HEIGHT (INCHES 0-12)	NN
122	MWT1	3	1707	1709	MOTHER'S PREPREGNANCY WEIGHT	NNN
123	MWT2	3	1710	1712	MOTHER'S DELIVERY WEIGHT	NNN
124	WIC	1	1713	1713	DID MOTHER GET WIC FOOD	N
125	AMEND	1	1714	1714	AMENDMENT INDICATOR	BLANK, 1
126	MSCODE	3	1715	1717	STATE/FOREIGN COUNTRY (MAILING ADDRESS)	N (0, 1, 2)
127	BOX E	1	1718	1718	PLANNED PLACE OF BIRTH CODE (2006 ONLY)	N
128	UNUSED	82	1719	1800	UNUSED BLANKS	BLANK

Return To AVSS Home Page