HSP_ACCT_EBC_RSKFC
Description:
This table contains multiple-response medical risk factors for pregnancy electronic birth certificate information in the Hospital Accounts Receivable (HAR) master file.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
This column stores the unique identifier for the hospital account with associated medical risk factors for the pregnancy electronic birth certificate information.
2 LINE INTEGER No
The line number associated with medical risk factors for the pregnancy on the electronic birth certificate associated with the hospital account.
3 EBC_MED_RSK_FAC_C_NAME VARCHAR No
Indicates the medical risk factors of the pregnancy on the electronic birth certificate associated with the hospital account. 0-None, 1-Anemia, 2-Cardiac Disease, 3-Acute or Chronic Lung Disease, 4-Diabetes, 5-Genital Herpes, 6-Hydramnios/Oligohydramnios, 7-Hemoglobinopathy, 8-Hypertension, Chronic, 9-Hypertension, Pregnancy-associated, 10-Eclampsia, 11-Incompetent Cervix, 12-Previous Infant 4000+ grams, 13-Previous Preterm or Small for Gestational Age Infant, 14-Renal Disease, 15-RH Sensitization, 16-Uterine Bleeding, 17-Infectious Disease, 18-Low MSAFP, 19-High MSAFP, 20-Other
May contain organization-specific values: Yes
Category Entries:
None
Anemia
Cardiac Disease
Acute or Chronic Lung Disease
Diabetes
Genital Herpes
Hydramnios/Oligohydramnios
Hemoglobinopathy
Hypertension, Chronic
Hypertension, Pregnancy-associated
Eclampsia
Incompetent Cervix
Previous Infant 4000+ grams
Previous Preterm or Small for Gestational Age Infant
Renal Disease
RH Sensitization
Uterine Bleeding
Infectious Disease
Low MSAFP
High MSAFP
Other