RFL_OUTSD_CVG_EFF_DT

Description:

This table extracts the effective date for the coverage stored in RFL_OUTSD_CVG. The corresponding payer, plan, insurance ID, termination date, authorization and precert number and comments can be found in RFL_OUTSD_CVG_PAYER, RFL_OUTSD_CVG_PLAN, RFL_OUTSD_CVG_INS, RFL_OUTSD_CVG_TERM_DT, RFL_OUTSD_CVG_AUTH_NUM, RFL_OUTSD_CVG_PRECERT_NUM and RFL_OUTSD_CVG_CMT tables for matching values of REFERRAL_ID, GROUP_LINE, and VALUE_LINE.

Primary Key

Column Name	Ordinal Position
REFERRAL_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	REFERRAL_ID	NUMERIC	No
	The unique identifier (.1 item) for the referral record.
2	GROUP_LINE	INTEGER	No
	The line number of one of the multiple updates received from an outside organization for a referral. Together with REFERRAL_ID, this forms the foreign key to the RFL_OUTSD_CVG table.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple outside coverages received in a referral update from an outside organization for a referral in the RFL_OUTSD_CVG table.
4	OUT_CVG_EFF_DATE	DATETIME	No
	Effective date for one of the multiple outside coverages received in a referral update from an outside organization for a referral in the RFL_OUTSD_CVG table.