OB_HSB_DEL_PROV
Description:
This table contains information about the providers who participated in the delivery.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique ID assigned to the episode record (HSB .1).
2 LINE INTEGER No
The Line Count
3 OB_DEL_PROV_ID VARCHAR No
The unique ID associated with the provider who was present at the delivery. This information is entered on the mother's chart in the Delivery Summary Activity. This column is frequently used to link to the CLARITY_SER table.
4 OB_DEL_PROV_ROLE_C_NAME VARCHAR No
The category number for the role of a provider who was present during delivery. This column is entered on the mother's chart in the Delivery Summary Activity.
May contain organization-specific values: Yes