Last Updated: 7/22/2025 8:42:49 PM

Intergy Version: 22.00.00.00

PlanClaimDiag

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table stores the snapshot of diagnosis that will appear on a claim. This table is used for billing and historical reference of what was billed.

Field Datatype Default Null Option Comment
PlanID INTEGER ?   MANDATORY FK - From PlanClaim table.
PolicyNumber CHARACTER(20)   MANDATORY FK - From PlanClaim table.
ClaimSID INTEGER ?   MANDATORY FK - From PlanClaim table.
DiagnosisType CHAR(1) Alpha_-_O   MANDATORY The type of UB diagnosis. O = Other, V = Reason for Visit, E = External Cause of Injury, A = Admitting Diagnosis. Note: Professional claims all have diag type O = Other.
OrderNumber INTEGER 0   MANDATORY Programmatically set order. This is the order that the diags will appear on the claim.
DiagnosisCode CHAR(10)   MANDATORY Diagnosis code that corresponds to the diagnosis.
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.
PresentOnAdmission CHAR(1) Set_To_Empty_String   OPTIONAL Specifies whether or not the diag was present on admission. Y = Yes , N = No , U = Unknown , W = Not Applicable.

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
PlanClaim PlanClaimDiag.PlanID = PlanClaim.PlanID and
PlanClaimDiag.PolicyNumber = PlanClaim.PolicyNumber and
PlanClaimDiag.ClaimSID = PlanClaim.ClaimSID		 CASCADE if PlanClaimDiag exists

Child Tables
Child TableJoin PhraseWhen deleting PlanClaimDiag record...