Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
Carrier
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| CarrierCode | CHARACTER(6) | MANDATORY | Code of the carrier responsible for this insurance plan. Specific values in this field are required in each state for proper ERS script operation. User entered. | |
| Name | CHARACTER(30) | MANDATORY | The name of the insurance carrier which has plans used by the practice. User entered. | |
| Naic | CHARACTER(15) | OPTIONAL | The NAIC ID number for the carrier. This provides support for electronic member roster download by the Managed Care system. User entered. | |
| Neic | CHARACTER(10) | OPTIONAL | The NEIC ID number for the carrier. This provides support for electronic member roster download by the Managed Care system. User entered. | |
| GovtProgram | CHARACTER(8) | MANDATORY | System defined. User selects government program code. Field is supported by the lookup types:[GovProgram]. Values are defined in the LookupCode table for the above lookup types. | |
| 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. |
| CarrierID | INTEGER | ? | MANDATORY | System generated unique id using the Entity sequence. |
| LastAutoPlanCode | CHARACTER(6) | OPTIONAL | The last automatically generated plan number (Base 36), used in creating a new plan code. System generated. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Entity | Carrier.CarrierID = Entity.EntitySID | CASCADE if Carrier exists |
| Child Table | Join Phrase | When deleting Carrier record... |
|---|---|---|
| Plan | Plan.CarrierCode = Carrier.CarrierCode | RESTRICT if Plan exists |