HSP_ACCT_EBC_MMLAD

Description:

This table contains the mother's mailing address information from 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 electronic birth certificate information.
2	LINE	INTEGER	No
	The line number associated with mother's mailing address on the electronic birth certificate associated with the hospital account.
3	EBC_MOM_MAIL_ADDR	VARCHAR	No
	The mother's mailing address on the electronic birth certificate associated with the hospital account.