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

Intergy Version: 22.00.00.00

Patient

Table Definition  Parent Tables  Child Tables

Table Definition

Description: This table is used to assign a patient to a practice.

Field Datatype Default Null Option Comment
PracticeID INTEGER ?   MANDATORY FK
PatientID INTEGER ?   MANDATORY FK
Class CHARACTER(6)   OPTIONAL User entered patient class. Field is supported by the lookup type PatientClass.
ChartNumber CHARACTER(14)   OPTIONAL Chart number of the patient. User entered or system generated using the ChartNumber sequence if auto chart numbering is turned on.
StaffID INTEGER ?   OPTIONAL FK
ReferralSource CHARACTER(6)   OPTIONAL Referral source is the way the patient was made aware of the practice. The lookup type 'ReferralSource' is used to select the source of referral.
RefDoctorID INTEGER ?   OPTIONAL FK
RecordStatus CHARACTER(1)   MANDATORY User selected record status for the patient. 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.
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.
RegistrationComplete CHARACTER(1)   OPTIONAL This field indicates that the patient has been temporarily or quickly registered in the system for the appointment scheduler. No account or policy information has been entered for the atient. A patient with this flag set to 'N' may not be selected by any module that accesses the patient's account. Possible Values: (Y)es (N)o
DNLastName CHAR(35)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNFirstName CHAR(35)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNMiddleName CHAR(35)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNNameSuffix CHARACTER(20)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNSSN CHARACTER(11)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNSex CHARACTER(1)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNDOB DATE   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNHomePhone CHARACTER(20)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
DNPersonNumber CHARACTER(14)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
PatInfoReleaseOnFile CHARACTER(1)   OPTIONAL This field indicates whether or not the patient has approved the practice to release medical info as needed. Possible values: (Y)es, (N)o
RegistrationDate DATE   OPTIONAL This indicates when the patient ws fully registered in the system.
FavoritePharmacyID INTEGER ?   OPTIONAL FK
DNSortChartNumber CHARACTER(14)   OPTIONAL This is a denormalized field that is maintained by a customized write trigger. It is used for sorting purposes.
DNSortPersonNumber CHARACTER(14)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
FrontImageSID INTEGER ?   OPTIONAL General file unique identifier. The unique identifier is obtained from the GENERAL sequence. Note - Partially obsoleted for new images (see Design 1586)
BackImageSID INTEGER ?   OPTIONAL General file unique identifier. The unique identifier is obtained from the GENERAL sequence. Note - Partially obsoleted for new images (see Design 1586)
FormularyPlanID CHARACTER(15)   OPTIONAL
FormularyGroupID CHARACTER(32)   OPTIONAL
FormularyState CHARACTER(1)   OPTIONAL Indicates whether or not the Formulary is disable for the patient.
NumDisclosureReports INTEGER 0   OPTIONAL Number of disclosure reports run for patient.
LastDiscReportDateStamp CHARACTER(14)   OPTIONAL Datestamp of last disclosure report run.
LastMarkerNumber INTEGER ?   OPTIONAL Sequential number at patient level that will increment when a marker is added to an encounter note. If no marker ever assigned, value will be ?.
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".
ChartScanned LOGICAL Logical_False   OPTIONAL YES/NO - Indicates that the patient's entire chart has been scanned into the imaging system.
FrontImageFileID CHARACTER(15)   OPTIONAL Front Image Storage Location ID |YYYYMM is from StorageDevice.StorageDeviceCode is generated by the sequence StorageDeviceImage
BackImageFileID CHARACTER(15)   OPTIONAL Back Image Storage Location ID |YYYYMM is from StorageDevice.StorageDeviceCode is generated by the sequence StorageDeviceImage
TakingMedsIndicator CHARACTER(1) Alpha_-_U   MANDATORY Indicates if medications have been reported for this person. "N": provider has indicated that the patient is currently not taking medications. "U": unknown as to whether or not the patient is taking any medications
TakingMedsConfirmationUser INTEGER ?   OPTIONAL UserID of person that confirms the existence or lack of medications for the patient.
TakingMedsConfirmationStamp CHARACTER(14)   OPTIONAL Timestamp for the event of confirming the eixtence of medications or lack of medications for the patient
DuplicatePersonID INTEGER ?   OPTIONAL FK
DeactivationNote CHARACTER(28000)   OPTIONAL This field will be used to store the reason for deactivation and any additional notes put in by the user. It is not mandatory when a patient is created but it is when a patient is deactivated.
DeactivationDate DATE   OPTIONAL This field will contain the date the patient was marked deactivated.
DeactivationReason CHAR(1)   OPTIONAL Deactivation Reason: Values: P - Duplicate Person M - Merged into Another Patient D - Discharged (No longer at practice) O - Other Note that this field is separate from Deceased.
DeactivationUser INTEGER ?   OPTIONAL UserID for the user who deactivated the patient
Confidential LOGICAL Logical_False   OPTIONAL Patient confidential setting. True - Patient is always confidential, False - Patient confidentiality is controlled by assigned Problems.
ConfidentialDate DATE   OPTIONAL Date of the last update to the Confidential field.
ConfidentialUser INTEGER ?   OPTIONAL UserID of the person that last updated the Confidential field.
ConfidentialReason CHARACTER(80)   OPTIONAL Confidential reason.
ExemptFromReporting LOGICAL Logical_False   MANDATORY A value of true indicates that the patient should be excluded from clinical reports. Example usage: The patient is no longer receiving care at the practice.
RecallMethod CHAR(10) Paper   OPTIONAL The patient's preferred method of recall notification. Codes for the lookup type "RecallMethod" are not user definable. Valid codes are "Paper" and "SecureMsg" Even if the stored value of this field is SecureMsg, the displayed value may revert to Paper if PracPerson.PracPortalPersonID is empty or if PracPerson.SecureMessageEnabled is false.
ClinicalChangeTimeStamp CHAR(14)   OPTIONAL The date/time stamp when the patient's chart data was last modified, to warrant a new interop document.
VFCEligibilityCode CHAR(12)   OPTIONAL Indicates VFC (Vaccines For Children) eligibility. Eligible values are defined for lookup type VFCCode
VFCEffectiveDate DATE   OPTIONAL Date VFC Eligibility Code is effective.
MappedAtImmuRegistry LOGICAL Logical_False   OPTIONAL This flag indicates if the patient has a mapping at the state immunization registry between our internal patient ID and the registry's patient ID.
RiskLevel CHAR(2) Set_To_Empty_String   OPTIONAL The Risk Level of Patient. Defined by lookupType PatientRiskLevel.
SecondaryPharmacyID INTEGER ?   OPTIONAL FK to Pharmacy table.
PrimaryCareProviderID INTEGER ?   OPTIONAL Patient's Primary Care Provider ID. FK from ProviderID.
CareCoordinatorID INTEGER ?   OPTIONAL UserID of Patient's Care Coordinator. FK from PracticeUser
GenderIdentity CHAR(3)   OPTIONAL Gender identity code. Gender identity codes are defined in the Lookup Code table for the lookup type 'GenderIdentity'.
GenderIdentityFreeText CHARACTER(60)   OPTIONAL Free text for gender identity.
SexualOrientation CHAR(3)   OPTIONAL Sexual orientation code. Sexual orientation codes are defined in the Lookup Code table for the lookup type 'SexualOrientation'.
SexualOrientationFreeText CHARACTER(60)   OPTIONAL Free text for Patient's sexual orientation.
DNMobilePhone CHARACTER(20)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
PublicityCode CHAR(2)   OPTIONAL Defined by ImmPublicityCode lookup type.
PublicityCodeEffectiveDate DATE   OPTIONAL Date of last time PublicityCode field was changed.
FrontImageScanStamp CHARACTER(14)   OPTIONAL User defined - Indicates when the image was last scanned.
BackImageScanStamp CHARACTER(14)   OPTIONAL User defined - Indicates when the image was last scanned.
FrontImageScanUserID INTEGER ?   OPTIONAL User who Scanned the Front Image of a Patient card
BackImageScanUserID INTEGER ?   OPTIONAL User who Scanned the Back Image of a Patient card
EnrolledInCommonWell LOGICAL Logical_False   OPTIONAL Indicates whether patient is enrolled in CommonWell and practice has been linked to that enrollment record.
CommonWellEnrollmentDate DATE   OPTIONAL Date the patient's enrollment in CommonWell began.
CommonWellUnenrollmentDate DATE   OPTIONAL Date the patient's enrollment in CommonWell ended.
PendingPortalEmancipation CHARACTER(1) Yes_Value__Y_   MANDATORY Determines if the patient will be emancipated by the GPP Emancipation System job when they are of age. Defined by lookup type Confirmation.
DNBirthSex CHAR(1)   OPTIONAL Denormalized for performance reasons from the Person table. Do not write to this field. The person write triggers will keep field up-to-date.
IsPregnant LOGICAL Logical_False   OPTIONAL This Field Is Obsolete now.
RxTextPhone CHARACTER(20)   OPTIONAL Phone number used to text Rx supporting information to patient.
SexForClinicalUse CHARACTER(3) Set_To_Empty_String   OPTIONAL System Defined. Sex the provider is intended to use for clinical decision making. Field is supported by the lookuptype:[SexForClinicalUse], which is derived from ValueSet: [Sex Parameter for Clinical Use - HL7 Terminology (THO)].

Parent Tables
Parent TableJoin PhraseWhen deleting parent record...
Provider Patient.PrimaryCareProviderID = Provider.ProviderID RESTRICT if Patient exists
Person Patient.DuplicatePersonID = Person.PersonID SET NULL if Patient exists
GenFile Patient.BackImageSID = GenFile.GenFileSID SET NULL if Patient exists
GenFile Patient.FrontImageSID = GenFile.GenFileSID SET NULL if Patient exists
RefDoctor Patient.RefDoctorID = RefDoctor.RefDoctorID RESTRICT if Patient exists
Person Patient.PatientID = Person.PersonID RESTRICT if Patient exists
Practice Patient.PracticeID = Practice.PracticeID RESTRICT if Patient exists
Staff Patient.PracticeID = Staff.PracticeID and
Patient.StaffID = Staff.StaffID		 RESTRICT if Patient exists

Child Tables
Child TableJoin PhraseWhen deleting Patient record...
CareTeamMember CareTeamMember.PracticeID = Patient.PracticeID and
CareTeamMember.PatientID = Patient.PatientID		 CASCADE if CareTeamMember exists
PatientCarePlan PatientCarePlan.PracticeID = Patient.PracticeID and
PatientCarePlan.PatientID = Patient.PatientID		 CASCADE if PatientCarePlan exists
PatientRSRNote PatientRSRNote.PracticeID = Patient.PracticeID and
PatientRSRNote.PatientID = Patient.PatientID		 CASCADE if PatientRSRNote exists
PatientCPGoal PatientCPGoal.PracticeID = Patient.PracticeID and
PatientCPGoal.PatientID = Patient.PatientID		 CASCADE if PatientCPGoal exists
PatientCPHealthConcern PatientCPHealthConcern.PracticeID = Patient.PracticeID and
PatientCPHealthConcern.PatientID = Patient.PatientID		 CASCADE if PatientCPHealthConcern exists
PatImplantableDevice PatImplantableDevice.PracticeID = Patient.PracticeID and
PatImplantableDevice.PatientID = Patient.PatientID		 CASCADE if PatImplantableDevice exists
RxChangeRequest RxChangeRequest.PracticeID = Patient.PracticeID and
RxChangeRequest.PatientID = Patient.PatientID		 RESTRICT if RxChangeRequest exists
PatientCareProgram PatientCareProgram.PracticeID = Patient.PracticeID and
PatientCareProgram.PatientID = Patient.PatientID		 CASCADE if PatientCareProgram exists
PatientRSRInfo PatientRSRInfo.PracticeID = Patient.PracticeID and
PatientRSRInfo.PatientID = Patient.PatientID		 CASCADE if PatientRSRInfo exists
DURAlert DURAlert.PracticeID = Patient.PracticeID and
DURAlert.PatientID = Patient.PatientID		 RESTRICT if DURAlert exists
ImportEncFindingSet ImportEncFindingSet.PracticeID = Patient.PracticeID and
ImportEncFindingSet.PatientID = Patient.PatientID		 CASCADE if ImportEncFindingSet exists
PracPersonSpecialInfo PracPersonSpecialInfo.PracticeID = Patient.PracticeID and
PracPersonSpecialInfo.PersonID = Patient.PatientID		 CASCADE if PracPersonSpecialInfo exists
PracPersonHousehldIncome PracPersonHousehldIncome.PracticeID = Patient.PracticeID and
PracPersonHousehldIncome.PersonID = Patient.PatientID		 CASCADE if PracPersonHousehldIncome exists
RxEligRequest RxEligRequest.PracticeID = Patient.PracticeID and
RxEligRequest.PatientID = Patient.PatientID		 CASCADE if RxEligRequest exists
CardioOrder CardioOrder.PracticeID = Patient.PracticeID and
CardioOrder.PatientID = Patient.PatientID		 RESTRICT if CardioOrder exists
PatientRefDocSpecialty PatientRefDocSpecialty.PracticeID = Patient.PracticeID and
PatientRefDocSpecialty.PatientID = Patient.PatientID		 CASCADE if PatientRefDocSpecialty exists
AdvanceDirective AdvanceDirective.PracticeID = Patient.PracticeID and
AdvanceDirective.PatientID = Patient.PatientID		 RESTRICT if AdvanceDirective exists
PatientOrderSet PatientOrderSet.PracticeID = Patient.PracticeID and
PatientOrderSet.PatientID = Patient.PatientID		 RESTRICT if PatientOrderSet exists
OBPatient OBPatient.PracticeID = Patient.PracticeID and
OBPatient.PatientID = Patient.PatientID		 CASCADE if OBPatient exists
ClinicalCase ClinicalCase.PracticeID = Patient.PracticeID and
ClinicalCase.PatientID = Patient.PatientID		 RESTRICT if ClinicalCase exists
PatientRxDenial PatientRxDenial.PracticeID = Patient.PracticeID and
PatientRxDenial.PatientID = Patient.PatientID		 RESTRICT if PatientRxDenial exists
CLWCorrespondence CLWCorrespondence.PracticeID = Patient.PracticeID and
CLWCorrespondence.PatientID = Patient.PatientID		 RESTRICT if CLWCorrespondence exists
Questionnaire Questionnaire.PracticeID = Patient.PracticeID and
Questionnaire.PatientID = Patient.PatientID		 CASCADE if Questionnaire exists
PatientVacDose PatientVacDose.PracticeID = Patient.PracticeID and
PatientVacDose.PatientID = Patient.PatientID		 RESTRICT if PatientVacDose exists
PatientClinicalSummary PatientClinicalSummary.PracticeID = Patient.PracticeID and
PatientClinicalSummary.PatientID = Patient.PatientID		 CASCADE if PatientClinicalSummary exists
PatientProblem PatientProblem.PracticeID = Patient.PracticeID and
PatientProblem.PatientID = Patient.PatientID		 CASCADE if PatientProblem exists
RISVisit RISVisit.PracticeID = Patient.PracticeID and
RISVisit.PatientID = Patient.PatientID		 RESTRICT if RISVisit exists
Eligibility Eligibility.PracticeID = Patient.PracticeID and
Eligibility.PatientID = Patient.PatientID		 CASCADE if Eligibility exists
PHIDisclosure PHIDisclosure.PracticeID = Patient.PracticeID and
PHIDisclosure.PatientID = Patient.PatientID		 CASCADE if PHIDisclosure exists
PHIAuthorization PHIAuthorization.PracticeID = Patient.PracticeID and
PHIAuthorization.PatientID = Patient.PatientID		 CASCADE if PHIAuthorization exists
PHIConsent PHIConsent.PracticeID = Patient.PracticeID and
PHIConsent.PatientID = Patient.PatientID		 CASCADE if PHIConsent exists
LabOrderTask LabOrderTask.PracticeID = Patient.PracticeID and
LabOrderTask.PatientID = Patient.PatientID		 CASCADE if LabOrderTask exists
ProcedureEvent ProcedureEvent.PracticeID = Patient.PracticeID and
ProcedureEvent.PatientID = Patient.PatientID		 NONE if ProcedureEvent exists
RecallNotice RecallNotice.PracticeID = Patient.PracticeID and
RecallNotice.PatientID = Patient.PatientID		 RESTRICT if RecallNotice exists
TMSCatalog TMSCatalog.PracticeID = Patient.PracticeID and
TMSCatalog.PatientID = Patient.PatientID		 RESTRICT if TMSCatalog exists
RxRequest RxRequest.PracticeID = Patient.PracticeID and
RxRequest.PatientID = Patient.PatientID		 RESTRICT if RxRequest exists
PatientRx PatientRx.PracticeID = Patient.PracticeID and
PatientRx.PatientID = Patient.PatientID		 RESTRICT if PatientRx exists
Encounter Encounter.PracticeID = Patient.PracticeID and
Encounter.PatientID = Patient.PatientID		 RESTRICT if Encounter exists
ApptRecall ApptRecall.PracticeID = Patient.PracticeID and
ApptRecall.PatientID = Patient.PatientID		 CASCADE if ApptRecall exists
Appointment Appointment.PracticeID = Patient.PracticeID and
Appointment.PatientID = Patient.PatientID		 RESTRICT if Appointment exists
PatientAccount PatientAccount.PracticeID = Patient.PracticeID and
PatientAccount.PatientID = Patient.PatientID		 RESTRICT if PatientAccount exists
Referral Referral.PracticeID = Patient.PracticeID and
Referral.PatientID = Patient.PatientID		 RESTRICT if Referral exists
Ailment Ailment.PracticeID = Patient.PracticeID and
Ailment.PatientID = Patient.PatientID		 RESTRICT if Ailment exists
InpatientVisit InpatientVisit.PracticeID = Patient.PracticeID and
InpatientVisit.PatientID = Patient.PatientID		 RESTRICT if InpatientVisit exists