Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PatientContact_PatientContactID | int | 4 | null |
|
|
Contact identifier - Unique identifier for each patient contact record |
||
| PatientContact_ContactType | int | 4 | √ | null |
|
|
Contact type - Type of contact relationship (parent, guardian, emergency contact, etc.) |
|
| PatientContact_ContactFirstName | varchar | 50 | null |
|
|
Contact first name - First name of the contact person |
||
| PatientContact_ContactLastName | varchar | 50 | null |
|
|
Contact last name - Last name of the contact person |
||
| PatientContact_ContactAddress | varchar | 50 | √ | null |
|
|
Contact address - Street address of the contact person |
|
| PatientContact_ContactState | varchar | 50 | √ | null |
|
|
Contact state - State/province of the contact person |
|
| PatientContact_ContactCity | varchar | 50 | √ | null |
|
|
Contact city - City of the contact person |
|
| PatientContact_ContactZip | varchar | 10 | √ | null |
|
|
Contact zip code - ZIP/postal code of the contact person |
|
| PatientContact_ContactPhone | varchar | 15 | √ | null |
|
|
Contact phone - Primary phone number of the contact person |
|
| PatientContact_ContactWorkPhone | varchar | 15 | √ | null |
|
|
Contact work phone - Work phone number of the contact person |
|
| PatientContact_ContactWorkExt | int | 4 | √ | null |
|
|
Contact work extension - Work phone extension of the contact person |
|
| PatientContact_ContactFax | varchar | 15 | √ | null |
|
|
Contact fax - Fax number of the contact person |
|
| PatientContact_ContactCell | varchar | 15 | √ | null |
|
|
Contact cell phone - Cell phone number of the contact person |
|
| PatientContact_ContactBeeper | varchar | 15 | √ | null |
|
|
Contact beeper - Beeper/pager number of the contact person |
|
| PatientContact_ContactComments | varchar | 1000 | √ | null |
|
|
Contact comments - Comments and notes about the contact person |
|
| PatientContact_PatientID | int | 4 | null |
|
|
Patient reference - Links to Patient table for the associated patient |
||
| PatientContact_Prim_Type | int | 4 | √ | null |
|
|
Primary contact type - Indicates if this is a primary contact |
|
| PatientContact_Legal_Type | int | 4 | √ | null |
|
|
Legal contact type - Indicates if this contact has legal authority |
|
| PatientContact_ContactSex | varchar | 20 | √ | null |
|
|
Contact gender - Gender of the contact person |
|
| PatientContact_caseID | int | 4 | √ | null |
|
|
Case reference - Links to PatientAdministration table for the case |
|
| PatientContact_DateCreated | smalldatetime | 16 | √ | null |
|
|
Contact creation date - Date when contact record was created |
|
| PatientContact_CreatedBy | int | 4 | √ | null |
|
|
Contact created by - UserID of the person who created this contact record |
|
| PatientContact_DateUpdated | smalldatetime | 16 | √ | null |
|
|
Contact update date - Date when contact record was last updated |
|
| PatientContact_UpdatedBy | int | 4 | √ | null |
|
|
Contact updated by - UserID of the person who last updated this contact record |
|
| PatientContact_ContactAddress2 | varchar | 50 | √ | null |
|
|
Contact address line 2 - Additional address information for the contact person |
|
| PatientContact_Email | varchar | 100 | √ | null |
|
|
Contact email - Email address of the contact person |
|
| Patient_PatientID | int | 4 | null |
|
|
Patient identifier - Unique identifier for each patient/client in the system |
||
| Patient_FirstName | varchar | 50 | √ | null |
|
|
Patient first name - Patient’s given name for identification and communication |
|
| Patient_MiddleName | varchar | 50 | √ | null |
|
|
Patient middle name - Patient’s middle name or initial for complete identification |
|
| Patient_LastName | varchar | 50 | √ | null |
|
|
Patient last name - Patient’s surname for identification and alphabetical sorting |
|
| Patient_Sex | varchar | 20 | √ | null |
|
|
Patient gender - Patient’s gender for demographic reporting and appropriate care matching |
|
| Patient_DateOfBirth | datetime | 16,3 | √ | null |
|
|
Patient birth date - Patient’s date of birth for age calculations and eligibility determination |
|
| Patient_Address | varchar | 50 | √ | null |
|
|
Patient primary address - Patient’s street address for service delivery and communication |
|
| Patient_City | varchar | 50 | √ | null |
|
|
Patient city - City of patient’s primary residence |
|
| Patient_State | varchar | 50 | √ | null |
|
|
Patient state - State/province of patient’s primary residence |
|
| Patient_ZipCode | varchar | 10 | √ | null |
|
|
Patient postal code - ZIP/postal code for patient’s address |
|
| Patient_Telephone | varchar | 30 | √ | null |
|
|
Patient phone number - Primary telephone number for patient contact |
|
| Patient_Ethnicity | varchar | 20 | √ | null |
|
|
Patient ethnicity - Patient’s ethnic background for demographic reporting and cultural considerations |
|
| Patient_InsuranceID | int | 4 | √ | null |
|
|
Patient insurance reference - Links to Insurance table for primary insurance coverage |
|
| Patient_DateEntered | datetime | 16,3 | √ | null |
|
|
Patient enrollment date - Date when patient was first entered into the system |
|
| Patient_DatePrescription | datetime | 16,3 | √ | null |
|
|
Patient prescription date - Date of medical prescription or referral for services |
|
| Patient_AgencyID | int | 4 | √ | null |
|
|
Patient agency reference - Links to Agency table for the healthcare provider serving this patient |
|
| Patient_ForestCareID | int | 4 | √ | null |
|
|
ForestCare identifier - External system identifier for ForestCare integration |
|
| Patient_Comments | varchar | 500 | √ | null |
|
|
Patient comments - General comments and notes about the patient |
|
| Patient_District | int | 4 | √ | null |
|
|
Patient district - School or administrative district for the patient |
|
| Patient_Borough | char | 20 | √ | null |
|
|
Patient borough - Borough or administrative region for the patient |
|
| Patient_RxDate | datetime | 16,3 | √ | null |
|
|
Prescription date - Date of medical prescription or referral |
|
| Patient_BillingType | int | 4 | √ | null |
|
|
Patient billing type - Type of billing arrangement for the patient |
|
| Patient_DateAnnualMedical | datetime | 16,3 | √ | null |
|
|
Annual medical date - Date of annual medical examination |
|
| Patient_DateAudiological | datetime | 16,3 | √ | null |
|
|
Audiological assessment date - Date of hearing/audiological evaluation |
|
| Patient_DateVisionTest | datetime | 16,3 | √ | null |
|
|
Vision test date - Date of vision screening or examination |
|
| Patient_DateSCConsent | datetime | 16,3 | √ | null |
|
|
Service coordination consent date - Date when service coordination consent was obtained |
|
| Patient_DateReleaseInfoConsent | datetime | 16,3 | √ | null |
|
|
Information release consent date - Date when consent to release information was obtained |
|
| Patient_DateEvalConsent | datetime | 16,3 | √ | null |
|
|
Evaluation consent date - Date when evaluation consent was obtained |
|
| Patient_DateFamilyInfoWorksheet | datetime | 16,3 | √ | null |
|
|
Family information worksheet date - Date when family information worksheet was completed |
|
| Patient_DateMedicalInfoWorksheet | datetime | 16,3 | √ | null |
|
|
Medical information worksheet date - Date when medical information worksheet was completed |
|
| Patient_Date45DayLimit | datetime | 16,3 | √ | null |
|
|
45-day timeline date - Date related to 45-day service timeline requirements |
|
| Patient_DateChildInfoChange | datetime | 16,3 | √ | null |
|
|
Child information change date - Date when child information was last changed |
|
| Patient_DateSurrogacyForm | datetime | 16,3 | √ | null |
|
|
Surrogacy form date - Date when surrogacy form was completed |
|
| Patient_DateClosureForm | datetime | 16,3 | √ | null |
|
|
Closure form date - Date when case closure form was completed |
|
| Patient_OtherInsurance | char | 5 | √ | null |
|
|
Other insurance flag - Indicates if patient has additional insurance coverage |
|
| Patient_MedicalID | varchar | 50 | √ | null |
|
|
Medical record ID - Medical record number or identifier |
|
| Patient_DateHIPAAPrivacyReceived | datetime | 16,3 | √ | null |
|
|
HIPAA privacy notice date - Date when HIPAA privacy notice was received |
|
| Patient_SignatureOnFile | varchar | 1 | √ | null |
|
|
Signature on file flag - Indicates if patient signature is on file |
|
| Patient_DateSigned | datetime | 16,3 | √ | null |
|
|
Signature date - Date when consent forms were signed |
|
| Patient_Age | int | 4 | √ | null |
|
|
Patient current age - Patient’s current age (calculated field) |
|
| Patient_MaritalStatus | varchar | 3 | √ | null |
|
|
Patient marital status - Patient’s marital status (for adult patients) |
|
| Patient_DateOfDeath | datetime | 16,3 | √ | null |
|
|
Patient death date - Date of death if applicable |
|
| Patient_EmploymentStatus | varchar | 3 | √ | null |
|
|
Patient employment status - Employment status (for adult patients) |
|
| Patient_CreatedBy | int | 4 | √ | null |
|
|
Patient record created by - UserID of the person who created this patient record |
|
| Patient_DateUpdated | smalldatetime | 16 | √ | null |
|
|
Patient record last update date - Timestamp of the most recent patient record update |
|
| Patient_UpdatedBy | int | 4 | √ | null |
|
|
Patient record updated by - UserID of the person who last modified this patient record |
|
| Patient_Pregnancy | varchar | 1 | √ | null |
|
|
Patient pregnancy status - Pregnancy status indicator |
|
| Patient_SiteID | int | 4 | √ | null |
|
|
Patient site reference - Links to AgencySite table for primary service location |
|
| Patient_patientStatus | varchar | 30 | √ | null |
|
|
Patient status - Current status of the patient in the system |
|
| Patient_source | varchar | 2 | √ | null |
|
|
Patient data source - Source of patient data entry |
|
| Patient_Address2 | varchar | 50 | √ | null |
|
|
Patient address line 2 - Additional address information (apartment, suite, etc.) |
|
| Patient_InternalID | int | 4 | √ | null |
|
|
Patient internal ID - Internal system identifier |
|
| Patient_Email | varchar | 100 | √ | null |
|
|
Patient email address - Patient or guardian email for communication |
|
| Patient_ImportID | int | 4 | √ | null |
|
|
Patient import identifier - Reference ID for data migration and import tracking |
|
| PatientContactCustom_pkID | int | 4 | null |
|
|
Contact custom primary key - Unique identifier for each custom contact record |
||
| PatientContactCustom_DateCreated | datetime | 16,3 | √ | null |
|
|
Contact custom creation date - Date when custom contact record was created |
|
| PatientContactCustom_CreatedBy | int | 4 | √ | null |
|
|
Contact custom created by - UserID of the person who created this custom contact record |
|
| PatientContactCustom_DateUpdated | datetime | 16,3 | √ | null |
|
|
Contact custom update date - Date when custom contact record was last updated |
|
| PatientContactCustom_UpdatedBy | int | 4 | √ | null |
|
|
Contact custom updated by - UserID of the person who last updated this custom contact record |
|
| PatientContactCustom_DateDeleted | datetime | 16,3 | √ | null |
|
|
Contact custom deletion date - Soft delete timestamp for audit trail purposes |
|
| PatientContactCustom_fkPatientContactID | int | 4 | null |
|
|
Contact custom reference - Links to PatientContact table for the associated contact |
||
| PatientContactCustom_Contact | nvarchar | 1073741823 | √ | null |
|
|
Contact custom information - Additional custom contact information |
|
| PatientContactCustom_SecondaryPhone | nvarchar | 1073741823 | √ | null |
|
|
Contact secondary phone - Secondary phone number for the contact |
|
| PatientContactCustom_PrimaryLanguage | nvarchar | 1073741823 | √ | null |
|
|
Contact primary language - Primary language spoken by the contact |
|
| PatientContactCustom_DateofBirth | datetime | 16,3 | √ | null |
|
|
Contact birth date - Date of birth of the contact person |
|
| PatientContactCustom_Employer | nvarchar | 1073741823 | √ | null |
|
|
Contact employer - Employer information for the contact |
|
| PatientContactCustom_EmployerAddress | nvarchar | 1073741823 | √ | null |
|
|
Contact employer address - Address of the contact’s employer |
|
| PatientContactCustom_City | nvarchar | 1073741823 | √ | null |
|
|
Contact custom city - City information for custom contact fields |
|
| PatientContactCustom_State | nvarchar | 1073741823 | √ | null |
|
|
Contact custom state - State information for custom contact fields |
|
| PatientContactCustom_Zip | nvarchar | 1073741823 | √ | null |
|
|
Contact custom zip - ZIP code information for custom contact fields |
|
| PatientContactCustom_EmployerPhone | nvarchar | 1073741823 | √ | null |
|
|
Contact employer phone - Phone number of the contact’s employer |
|
| PatientContactCustom_TestColumn1 | nvarchar | 510 | √ | null |
|
|
Contact test column - Test column for custom contact data |
|
| PatientContactCustom_Friendly | bit | 1 | √ | null |
|
|
Contact friendly flag - Indicates if contact is friendly/cooperative |
|
| PatientContactCustom_Nice | bit | 1 | √ | null |
|
|
Contact nice flag - Indicates if contact is nice/pleasant |
|
| PatientContactCustom_TextingNumber | nvarchar | 40 | √ | null |
|
|
Contact texting number - Phone number for text messaging |
|
| PatientContactCustom_Notes | nvarchar | 1073741823 | √ | null |
|
|
Contact custom notes - Additional notes about the contact |
Relationships
Close relationships within degrees of separation
