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