Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
Policy
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PlanID | INTEGER | ? | MANDATORY | FK |
| PolicyNumber | CHARACTER(20) | MANDATORY | User entered ID Number of the patient's insurance policy. | |
| Class | CHARACTER(6) | OPTIONAL | User selects the policy class code. Policy class codes are defined in the LookupCode table for the lookup type 'PolicyClass'. Codes for lookup type 'PolicyClass' are user definable. | |
| GroupNumber | CHARACTER(30) | OPTIONAL | FK | |
| SubscriberID | INTEGER | ? | MANDATORY | FK |
| AssignBenefits | CHARACTER(1) | OPTIONAL | 07/21/04 - Obselete Field per Jason D. Assignment flag (Y/N) indicating whether or not benefits can be assigned. User entered. | |
| Description | CHARACTER(60) | OPTIONAL | User entered description. | |
| StartDate | DATE | OPTIONAL | User entered start date of the policy. | |
| EndDate | DATE | OPTIONAL | User entered end date of the policy. | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| AuthorizePayment | CHARACTER(1) | OPTIONAL | Indicates that the patient does not necessarily assign benefits but does authorize the insurance company to pay the doctor. This field is supported by the Confirmation lookup type. Possible Values: (Y)es (N)o | |
| HL7Updated | CHARACTER(1) | OPTIONAL | This field indicates if HL7 has processed this table entry and will be used by the DB triggers. values "Y" or "N". |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Entity | Policy.SubscriberID = Entity.EntitySID | RESTRICT if Policy exists |
| PlanGroup | Policy.PlanID = PlanGroup.PlanID and Policy.GroupNumber = PlanGroup.GroupNumber |
RESTRICT if Policy exists |
| Plan | Policy.PlanID = Plan.PlanID | RESTRICT if Policy exists |
| Child Table | Join Phrase | When deleting Policy record... |
|---|---|---|
| Eligibility | Eligibility.PlanID = Policy.PlanID and Eligibility.PolicyNumber = Policy.PolicyNumber |
CASCADE if Eligibility exists |
| Charge | Charge.RespPartyID = Policy.PlanID and Charge.PolicyNumber = Policy.PolicyNumber |
RESTRICT if Charge exists |
| ResponsibilityTransfer | ResponsibilityTransfer.RespPartyID = Policy.PlanID and ResponsibilityTransfer.PolicyNumber = Policy.PolicyNumber |
RESTRICT if ResponsibilityTransfer exists |
| PolicyMember | PolicyMember.PlanID = Policy.PlanID and PolicyMember.PolicyNumber = Policy.PolicyNumber |
CASCADE if PolicyMember exists |
| WorkersComp | WorkersComp.PlanID = Policy.PlanID and WorkersComp.PolicyNumber = Policy.PolicyNumber |
RESTRICT if WorkersComp exists |
| PlanClaim | PlanClaim.PlanID = Policy.PlanID and PlanClaim.PolicyNumber = Policy.PolicyNumber |
RESTRICT if PlanClaim exists |