RFL_OUTSD_CVG_PRECERT_NUM

Description:

This table extracts the precert number for the coverage stored in RFL_OUTSD_CVG. The corresponding payer, plan, insurance ID, effective and termination date, authorization number and comments can be found in RFL_OUTSD_CVG_PAYER, RFL_OUTSD_CVG_PLAN, RFL_OUTSD_CVG_INS, RFL_OUTSD_CVG_EFF_DT, RFL_OUTSD_CVG_TERM_DT, RFL_OUTSD_CVG_AUTH_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_PRECERT_NUM	VARCHAR	No
	Precert number 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.