HSP_ACCT_EBC_2
Description:
This table contains electronic birth certificate information from the Hospital Accounts Receivable (HAR) master file.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1

Column Information
Name Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
The unique identifier for the hospital account record.
2 CHILD_SUF_C_NAME VARCHAR No
The child suffix category ID for Electronic Birth Certificate information.
May contain organization-specific values: Yes
Category Entries:
Sr.
Jr.
II
III
IV
V
3 MOM_RES_APT VARCHAR No
Electronic Birth Certificate mother residence apartment number.
4 MOM_STAT_RES_C_NAME VARCHAR No
The mother's residence state/territory/country category ID for Electronic Birth Certificate information.
May contain organization-specific values: Yes
5 MOM_EMAIL VARCHAR No
Electronic Birth Certificate mother email.
6 MOM_MAIL_APT VARCHAR No
Electronic Birth Certificate mother mailing apartment number.
7 MOM_MAIL_ST_C_NAME VARCHAR No
The mother's mailing state/territory/country category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_STAT_RES_C_NAME
8 MOM_SUF_C_NAME VARCHAR No
The mother's suffix category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: CHILD_SUF_C_NAME
9 MOM_BIRTH_ST_C_NAME VARCHAR No
The mother's birth state/territory/country category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_STAT_RES_C_NAME
10 DAD_SUF_C_NAME VARCHAR No
The father's suffix category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: CHILD_SUF_C_NAME
11 DAD_BIRTH_ST_C_NAME VARCHAR No
The father's birth state/territory/country category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_STAT_RES_C_NAME
12 PUB_CHILD_NM_YN VARCHAR No
Indicates whether this child's name should be published for Electronic Birth Certificate information.
May contain organization-specific values: No
Category Entries:
No
Yes
13 MOM_HISP_ORGN_CMT VARCHAR No
Electronic Birth Certificate mother's Hispanic origin other comment.
14 MOM_RACE_TRIBE_CMT VARCHAR No
Electronic Birth Certificate mother's tribe.
15 MOM_RACE_ASIAN_CMT VARCHAR No
Electronic Birth Certificate mother's race other Asian comment.
16 MOM_RACE_PC_ISL_CMT VARCHAR No
Electronic Birth Certificate mother's race other Pacific Islander comment.
17 MOM_RACE_OTHER_CMT VARCHAR No
Electronic Birth Certificate mother's race other comment.
18 DAD_HISP_ORGN_CMT VARCHAR No
Electronic Birth Certificate father's Hispanic origin other comment.
19 DAD_RACE_TRIBE_CMT VARCHAR No
Electronic Birth Certificate father's tribe.
20 DAD_RACE_ASIAN_CMT VARCHAR No
Electronic Birth Certificate father's race other Asian comment.
21 DAD_RACE_PC_ISL_CMT VARCHAR No
Electronic Birth Certificate father's race other Pacific Islander comment.
22 DAD_RACE_OTHER_CMT VARCHAR No
Electronic Birth Certificate father's race other comment.
23 PLN_HM_BIRTH_YN VARCHAR No
Indicates whether this birth was planned to deliver at home for Electronic Birth Certificate information.
The category values for this column were already listed for column: PUB_CHILD_NM_YN
24 PLACE_OCCUR_CMT VARCHAR No
Electronic Birth Certificate place where birth occurred comment.
25 ATTENDANT_NPI VARCHAR No
Electronic Birth Certificate attendant NPI number.
26 ATTENDANT_TITLE_CMT VARCHAR No
Electronic Birth Certificate attendant title other comment.
27 MOM_TRANSFERRED_C_NAME VARCHAR No
The mother's transfer status category ID for Electronic Birth Certificate information.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
28 MOM_TRANS_FROM VARCHAR No
Electronic Birth Certificate area from which the mother was transferred. This item is free-text.
29 FIRST_PN_VISIT_DT VARCHAR No
Electronic Birth Certificate date of first prenatal care visit. This date is stored as free-text to capture unknown values. Expected format is MM/DD/YYYY, where zeroes can be substituted for any unknown month, day, or year.
30 LAST_PN_VISIT_DT VARCHAR No
Electronic Birth Certificate date of last prenatal care visit. This date is stored as free-text to capture unknown values. Expected format is MM/DD/YYYY, where zeroes can be substituted for any unknown month, day, or year.
31 MOM_HEIGHT VARCHAR No
Electronic Birth Certificate mother height. Format: ft/in.
32 MOM_PREPREG_WEIGHT INTEGER No
Electronic Birth Certificate pre-pregnancy weight.
33 MOM_DELIVERY_WEIGHT INTEGER No
Electronic Birth Certificate delivery weight.
34 MOM_WIC_FOOD_C_NAME VARCHAR No
The mother's 'Special Supplemental Nutrition Program for Women, Infants and Children' food status category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_TRANSFERRED_C_NAME
35 CIG_BEFORE_PREG INTEGER No
Electronic Birth Certificate number of cigarettes/day 3 months before pregnancy.
36 CIG_TRIMESTER_1 INTEGER No
Electronic Birth Certificate number of cigarettes/day during first trimester.
37 CIG_TRIMESTER_2 INTEGER No
Electronic Birth Certificate number of cigarettes/day during second trimester.
38 CIG_TRIMESTER_3 INTEGER No
Electronic Birth Certificate number of cigarettes/day during third trimester.
39 PRINCIPAL_PMT_SRC_C_NAME VARCHAR No
The principal source of payment category ID for Electronic Birth Certificate information.
May contain organization-specific values: Yes
Category Entries:
Medicaid
Private Insurance
Self-pay
Tricare or other Military Insurance
Other
Unknown
40 PRINCIPAL_PMT_SRC_CMT VARCHAR No
Electronic Birth Certificate principal source of payment -- comment for other.
41 RISK_FACTORS_DIABETES_C_NAME VARCHAR No
The mother's diabetes risk category ID for Electronic Birth Certificate information.
May contain organization-specific values: Yes
Category Entries:
Prepregnancy
Gestational
42 RISK_FACTORS_HYPERTENSION_C_NAME VARCHAR No
The mother's hypertension risk category ID for Electronic Birth Certificate information.
May contain organization-specific values: Yes
Category Entries:
Prepregnancy
Gestational
Eclampsia
43 RSKFC_PREV_CSECT INTEGER No
Electronic Birth Certificate number of previous caesarian deliveries risk factor.
44 FORCEPS_C_NAME VARCHAR No
The 'forceps attempted?' category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_TRANSFERRED_C_NAME
45 VACUUM_C_NAME VARCHAR No
The 'vacuum extraction attempted?' category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_TRANSFERRED_C_NAME
46 PRESENTATION_C_NAME VARCHAR No
The fetal presentation category ID for Electronic Birth Certificate information.
May contain organization-specific values: Yes
Category Entries:
Cephalic
Breech
Other
Unknown
47 ROUT_AND_METHOD_C_NAME VARCHAR No
The route and method category ID for Electronic Birth Certificate information.
May contain organization-specific values: Yes
Category Entries:
Vaginal/Spontaneous
Vaginal/Forceps
Vaginal/Vacuum
Cesarean with trial of labor
Cesarean without trial of labor
Cesarean unknown trial of labor
48 CHILD_TRANSFERRED_C_NAME VARCHAR No
The child's transfer status category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_TRANSFERRED_C_NAME
49 CHILD_TRANS_TO VARCHAR No
Electronic Birth Certificate area to which the child was transferred. This item is free-text.
50 CHILD_ALIVE_C_NAME VARCHAR No
The child's living status category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_TRANSFERRED_C_NAME
51 CHILD_BREASTFED_C_NAME VARCHAR No
The child's breastfed status category ID for Electronic Birth Certificate information.
The category values for this column were already listed for column: MOM_TRANSFERRED_C_NAME