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