Data SnapShot - Insured Party

Credit

Denoted below are specific Insured Party data items and their associated data types to assist with processing a data snapshot.


Field

Description

Values

SEQNO

Unique identifier for the insured party.

Numeric - 8 digits

PATIENT


The ID of the Patient.  Foreign key to the PACCTNO column in Patient.
Numeric - 8 digits

INSURED_PATIENT


The ID of the patient who owns the insurance (used for Family accounts). If set, always different from PATIENT.  Foreign key to the PACCTNO column in Patient.
Numeric - 8 digits

RELATION

Relationship of the insured party to the patient.

0:Unknown
1:Spouse
2: Child
3: Other
4:Self

EMPSTATUS

Employment status of the insured party.

0:Employed full-time
1: Employed part-time
2: Not employed 
3:Self employed
4:Retired
5:On active military duty
6:Unknown

INACTIVE

Whether the insured party has been inactivated.

0:Active
1:Inactive