FILING_ORDER_HX

Description:

This table stores the filing order changes for a member.

Primary Key

Column Name	Ordinal Position
RECORD_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	RECORD_ID	NUMERIC	No
	The unique identifier for the Filing Order History record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	FO_EFF_DT	DATETIME	No
	The effective date of the filing order for a coverage
6	CVG_ID	NUMERIC	No
	This item stores the coverage ID.
7	MANUAL_FILING_ORDER	INTEGER	No
	The manual filing order of the coverage.
8	AUTO_FILING_ORDER	INTEGER	No
	The automatic filing order of the coverage.
9	CVG_EFF_YN	VARCHAR	No
	Flag indicating if the coverage is effective May contain organization-specific values: No Category Entries: No Yes
10	MANUAL_FO_C_NAME	VARCHAR	No
	This item stores the category of the manual filing order. May contain organization-specific values: No Category Entries: Special N/A N/A and Special
11	AFO_ASSIGNED_TIER	VARCHAR	No
	This item stores the tier assigned to a coverage by based on the logic on the configuration table.
12	COVERED_STATUS_C_NAME	VARCHAR	No
	This item stores the covered status of the coverage. May contain organization-specific values: No Category Entries: Covered Not Covered Pending In Question Invalid
13	AFO_TIEBREAKER_C_NAME	VARCHAR	No
	The tier of the Automatic Filing Order (AFO) tiebreaker that a coverage matched on."-" (category value 30) indicates that the tiebreaker was calculated, but not present. An empty value means that the filing order history contact was saved before the system started saving the tiebreaker. May contain organization-specific values: Yes Category Entries: Special coverage Payor or Plan set to always first Non-dependent, through current employment Non-dependent, through retirement Non-dependent, through continuation of benefits Non-dependent, unknown if it is through employment Non-dependent, not through employment Adult dependent, through current employment Adult dependent, through retirement Adult dependent, through continuation of benefits Adult dependent, unknown if it is through employment Adult dependent, not through employment Child dependent, court decree makes subscriber responsible for cost Child dependent, court decree makes subscriber's spouse responsible Child dependent, court decree makes subscriber jointly responsible Child dependent, court decree makes subscriber's spouse jointly responsible Child dependent, no court decree, custody N/A Child dependent, no court decree, subscriber has more than 50% custody Child dependent, no court decree, subscriber has equal custody Child dependent, no court decree, subscriber's spouse has more than 50% custody Child dependent, no court decree, subscriber's spouse has equal custody Child dependent, no court decree, subscriber has less than 50% custody Child dependent, no court decree, subscriber's spouse has less than 50% custody Child dependent, court decree makes subscriber not responsible Child dependent, court decree makes subscriber's spouse not responsible Spouse or child relationship to subscriber, if coverages with both of these relationships to subscriber are present Not listed as a member yet Payor or Plan set to always last Medicaid N/A -
14	AFO_TIEBREAKER_SORT_C_NAME	VARCHAR	No
	The sort order for coverages that match on the same tiebreaker line (AFO_TIEBREAKER_C). "-" (category value 30) represents that the tiebreaker sort order was calculated, but not present. An empty value means that the filing order history contact was saved before the system started saving the tiebreaker sort order. May contain organization-specific values: Yes Category Entries: Covered through status, effective date, then creation instant Birthday rule Effective date, then birthday rule Birthday rule, covered through status, then effective date Birthday rule, then effective date Effective date, then creation instant - Creation instant Covered through status, then creation instant Birthday rule, then covered through status
15	GROUP_NUMBER	VARCHAR	No
	This column stores what the group number was for this coverage during the filing order effective range. Group number is an identification number assigned to the employer or plan group.