AUTO_SECONDARY_INQ_IND |
DOUBLE |
Y |
Indicates if a secondary eligibility inquiry should be published automatically. |
AUTO_SECONDARY_INQ_RANGE_DAYS |
DOUBLE |
Y |
The time range, in calendar days, used to search for past eligibility inquiries when determining if an automatic secondary eligibility inquiry should be published. If the Auto Secondary Inquiry Indicator is 1 and the Auto Secondary Inquiry Range Days is 0, ignore past eligibility inquiries and automatically publish a secondary inquiry. |
AUTO_SEC_INQ_BEG_COV_DT_ISO |
VARCHAR(10) |
Y |
The plan coverage date for which eligibility is requested of the payer when publishing an automatic secondary eligibility inquiry. Date format is YYYY-MM-DD. Currently only a range of a single day is supported. |
GROUP_NAME |
VARCHAR(200) |
Y |
The group name associated to the health plan identifier returned by the eligibility response rule. Used for automated processing of the health plan relationship. |
GROUP_NBR |
VARCHAR(100) |
Y |
The group number associated to the health plan identifier returned by the eligibility response rule. Used for automated processing of the health plan relationship. |
HEALTH_PLAN_ID |
DOUBLE |
N |
The Millennium health plan identifier returned by the eligibility response rules to be used for automated processing of the health plan relationship. |
MEMBER_NBR |
VARCHAR(100) |
Y |
The member number associated to the health plan identifier returned by the eligibility response rule. Used for automated processing of the health plan relationship. |
RULE_TYPE_CD |
DOUBLE |
N |
The type of rule used to determine how the health plan relationship should be processed based of the eligibility response. For example add or update. |
STATUS_CD |
DOUBLE |
N |
Defines the current state of the eligibility response rule to determine if processing is still necessary. |
TRANSACTION_ELIGIBILITY_ID |
DOUBLE |
N |
The identifier of the transaction_eligibility table to which this auto plan is related. |
TRANS_ELIG_AUTO_PLAN_ID |
DOUBLE |
N |
Unique generated number that identifies a single row on the TRANS_ELIG_AUTO_PLAN table. |
UPDT_APPLCTX |
DOUBLE |
N |
The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT |
DOUBLE |
N |
Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM |
DATETIME |
N |
The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID |
DOUBLE |
N |
The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK |
DOUBLE |
N |
The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |