PAT_LIFETIME_MAX

Description:

The PAT_LIFETIME_MAX table contains information regarding patients' amounts credited toward lifetime maximum benefits (assuming the benefit plan is properly configured for tracking lifetime maximum benefits).

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2	LINE	INTEGER	No
	The line number within a multiple response or over time item
3	LIFEMAX_CARRIER_ID	VARCHAR	No
	The unique ID of the carrier for which this set of lifetime maximum buckets is counting.
4	LIFEMAX_CARRIER_ID_CARRIER_NAME	VARCHAR	No
	The name of the carrier record.
5	LIFEMAX_FLAG_C_NAME	VARCHAR	No
	Indicates if the patient has approached or exceeded the lifetime maximum limit for the carrier May contain organization-specific values: No Category Entries: Approaching Exceeded
6	LIFEMAX_BKT_MAN_IN	NUMERIC	No
	Allows manual override of the lifetime maximum in-plan accumulated amount
7	LIFEMAXBKT_MAN_OUT	NUMERIC	No
	Allows manual override of the lifetime maximum out-of-plan accumulated amount
8	LIFEMAXBKT_MAN_ALL	NUMERIC	No
	Allows manual override of the lifetime maximum total accumulated amount
9	LIFEMAXAPPR_CLM_ID	NUMERIC	No
	The unique identifier of the accounts payable claim record which caused the "approaching" flag to be set
10	LIFEMAX_APP_DATE	DATETIME	No
	The date on which the approaching lifetime maximum flag was set
11	LIFEMAX_BKT_IN	NUMERIC	No
	The accumulated in-plan amount for claims paid under this carrier
12	LIFEMAX_BUCKET_OUT	NUMERIC	No
	The accumulated out-of-plan amount for claims paid under this carrier