Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | ObjectId of HInsuranceDetails Rows generated by Architecture |
InstanceHFCID | smallint | NOT NULL | Instance HFC(Healthcare Foundation Class) ID generated by Architecture |
RecordId | int | NULL | Not Used. |
IsDeleted | bit | NOT NULL | Indicates if the row has been deleted. |
Description | varchar(255) | NULL | Not Used. |
IsVersioned | bit | NOT NULL | Indicates if the row has been modified. Allowable Values: 0 - Not Modified 1 - Modified |
CreatedUserId | int | NULL | UserId of the user who created the HInsuranceDetails row |
CreationTime | smalldatetime | NULL | Date and time when the object is created. |
InsPlan | varchar(64) | NULL | Specific insurance plan that the subscriber has for insurance coverage. |
InsCoName | varchar(64) | NULL | The name of the insurance company. |
Referral | varchar(75) | NULL | The referral number from the payer. This number is assigned to the authorization provided by the payer to pay for certain services rendered to the subscriber. |
CoPay | varchar(75) | NULL | The copayment charge for the patient's visit that is collected at the time of visit. |
Policy | varchar(75) | NULL | The insurance number of the payer responsible for paying the subscriber's billing account. |
VerificationInd | varchar(64) | NULL | The status of the subscriber's billing account. The status of an account can be active, inactive, temporary, or closed. |
Priority | varchar(2) | NULL | The priority for paying the subscriber's billing account. If the priority is high, the payer responsible for the subscriber's billing account will be required to settle the account immediately. |
GroupNo | varchar(20) | NULL | The group number of the organization that has subscribers to a particular insurance plan. |
GroupName | varchar(75) | NULL | The group name of the organization that has subscribers for the insurance policies of an insurance company. |
GroupEmpID | varchar(30) | NULL | The group ID of the organization that has subscribers to a particular insurance plan. |
PayerID | varchar(30) | NULL | The unique ID assigned to the payer. |
TreatAuth | varchar(75) | NULL | The authorization code from the payer when the payer authorizes to pay for the services rendered to the patient. |
SubscriberID | varchar(30) | NULL | Unique ID assigned to the subscriber by the payer. |
SubscriberRelationToPt | varchar(5) | NULL | Relationship of the subscriber to the patient. For example: 'Self', or 'Patient'. |
SubscriberSex | tinyint | NULL | Gender of the subscriber. Allowable Values: 0 - Male, 1 - Female, 2 - Other, 3 - Unknown, 4 - AllType, 5 - Nothing or NULL |
SubscriberDOB | datetime | NULL | Date of Birth of the subscriber |
SubscriberSSN | varchar(20) | NULL | The Social Security Number(SSN) of the subscriber. |
SubscriberEmployerName | varchar(64) | NULL | The name of the subscriber's employer. |
PatientVisit_oid | int | NOT NULL | Patient Visit OID associated with provided insurance information. This must match objectID in HPatientVisit Table. |
InsCoContactName_oid | int | NULL | Name of the person designated as a contact for the insurance company. |
SubscriberName_oid | int | NULL | ObjectID for the patient name object. This should be linked to the ObjectID in HName table. |
SubscriberAddress_oid | int | NULL | ObjectID for the patient address object. This should be linked to the Objectid in HAddress table. |
SubscriberEmployerAddress_oid | int | NULL | ObjectID for the patient employer address object. This should be linked to the Objectid in HAddress table |
InsCoAddress_oid | int | NULL | insurance company address oid related to objectid in HAddress table |
LastCngDtime | datetime | NULL | Last system UTC date /time when row was updated. |
PlanType | varchar(64) | NULL | Plan type. For example: Medicare, Medicaid, BlueCross, etc. |
|
|