Last Updated: 9/24/2025 12:09:38 PM
Intergy Version: 22.00.00.00
AlternateID
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| AidClass | CHARACTER(3) | MANDATORY | Developer supplied class. Valid values are: D - provider (doctor) I - plan (insurance) P - person S - service center F - finance center PR - Practice C - Company | |
| AidTag | CHARACTER(8) | MANDATORY | User entered ID Tag used to label an ID number for an entity assigned to an alternate ID class. | |
| CommCode | CHARACTER(8) | OPTIONAL | User entered communication code. | |
| Description | CHAR(100) | MANDATORY | Description for the id tag. User entered. | |
| Length | INTEGER | 0 | OPTIONAL | Maximum length for an id associated with the tag. User entered. |
| System | CHARACTER(1) | OPTIONAL | Flag which indicates the tag is system defined and may not be deleted by a user. Possible values are (Y)es or (N)o and are validated by the lookup type 'Confirmation'. | |
| AllowServCtrID | CHARACTER(1) | OPTIONAL | This flag is used to indicate if the ID tag may be set at a service center level for a staff member (Y/N). | |
| EDI | CHARACTER(1) | OPTIONAL | Flag to indicate the tag is for EDI id's. This field only applies to tags of class Insurance. Possilbe values are (Y)es or (N)o and are validated by the lookup type 'Confirmation'. | |
| 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. |
| RecordStatus | CHARACTER(1) | MANDATORY | Note - RecordStatus is not being used as of 1.18. User selected record status for the service center. RecordStatus is defined in the LookupCode table for the lookup type 'RecordStatus'. Codes for lookup type 'RecordStatus' are not user definable. Valid codes are (A)ctive and (I)nactive. | |
| ANSIQualifier | CHAR(3) | OPTIONAL | Qualifier code to be used in HIPAA compliant ANSI transactions such as claims and eligibility. User entered and validated by lookuptype(s). |
| Parent Table | Join Phrase | When deleting parent record... |
|---|
| Child Table | Join Phrase | When deleting AlternateID record... |
|---|---|---|
| PlanAltID | PlanAltID.ProviderClass = AlternateID.AidClass and PlanAltID.ProviderTag = AlternateID.AidTag |
RESTRICT if PlanAltID exists |
| PersonAltID | PersonAltID.AidClass = AlternateID.AidClass and PersonAltID.AidTag = AlternateID.AidTag |
CASCADE if PersonAltID exists |
| PlanAltID | PlanAltID.AidClass = AlternateID.AidClass and PlanAltID.AidTag = AlternateID.AidTag |
CASCADE if PlanAltID exists |