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.