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.