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