PAT_PER_CARR_CORRS_STREET

Description:

This table contains the carrier version of the correspondence street address for a member.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	GROUP_LINE	INTEGER	No
	The line number for the associated carrier correspondence address on the member's record. Together with the PAT_ID, this forms a foreign key to the PAT_PER_CARR_ADDR table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple parts of the carrier correspondence street address associated with the member and the carrier from the PAT_PER_CARR_ADDR table.
4	STREET_ADDRESS	VARCHAR	No
	The street address of the member's correspondence address as specified by an external source.