Last Updated: 9/24/2025 12:09:38 PM

Intergy Version: 22.00.00.00

PlanAltID

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to record the alternate id's for a plan.

Field Datatype Default Null Option Comment
PlanID INTEGER ?   MANDATORY FK
AidClass CHARACTER(3)   MANDATORY Developer supplied class. Valid values are: D - provider (doctor) E - EDI I - plan (insurance) ID - insurance provider IP - insurance practice P - person S - service center F - finance center
AidTag CHARACTER(8)   MANDATORY User entered ID Tag used to label an ID number for an entity assigned to an alternate ID class.
ProviderClass CHARACTER(3)   MANDATORY Developer supplied class. Valid values are: D - provider (doctor) E - EDI I - plan (insurance) ID - insurance provider IP - insurance practice P - person S - service center F - finance center
ProviderTag CHARACTER(8)   MANDATORY User entered ID Tag used to label an ID number for an entity assigned to an alternate ID class.
ID CHARACTER(20)   MANDATORY The alternate id for the associated alternate id tag. User entered.
Options CHARACTER(20)   OPTIONAL Options for the alternate id. User entered.
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.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
AlternateID PlanAltID.ProviderClass = AlternateID.AidClass and
PlanAltID.ProviderTag = AlternateID.AidTag		 RESTRICT if PlanAltID exists
AlternateID PlanAltID.AidClass = AlternateID.AidClass and
PlanAltID.AidTag = AlternateID.AidTag		 CASCADE if PlanAltID exists
Plan PlanAltID.PlanID = Plan.PlanID CASCADE if PlanAltID exists

Child Tables
Child TableJoin PhraseWhen deleting PlanAltID record...