Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each patient contact custom record |
||||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when this custom contact record was created |
||||
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created this record |
||||
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Last update date - Date when this record was last updated |
||||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this record |
||||
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this record was marked as deleted |
||||
| fkPatientContactID | int | 4 | null |
|
|
Patient contact reference - Links to PatientContact table for the associated contact |
|||||
| Contact | nvarchar | 1073741823 | √ | null |
|
|
Contact information - Additional contact details and information |
||||
| SecondaryPhone | nvarchar | 1073741823 | √ | null |
|
|
Secondary phone - Secondary phone number for the contact |
||||
| PrimaryLanguage | nvarchar | 1073741823 | √ | null |
|
|
Primary language - Primary language spoken by the contact |
||||
| DateofBirth | datetime | 16,3 | √ | null |
|
|
Contact birth date - Date of birth of the contact person |
||||
| Employer | nvarchar | 1073741823 | √ | null |
|
|
Employer name - Name of the contact’s employer |
||||
| EmployerAddress | nvarchar | 1073741823 | √ | null |
|
|
Employer address - Address of the contact’s employer |
||||
| City | nvarchar | 1073741823 | √ | null |
|
|
Contact city - City of residence for the contact |
||||
| State | nvarchar | 1073741823 | √ | null |
|
|
Contact state - State of residence for the contact |
||||
| Zip | nvarchar | 1073741823 | √ | null |
|
|
Contact zip code - Zip code for the contact’s address |
||||
| EmployerPhone | nvarchar | 1073741823 | √ | null |
|
|
Employer phone - Phone number of the contact’s employer |
||||
| TestColumn1 | nvarchar | 510 | √ | null |
|
|
Test column 1 - Test field for development and validation purposes |
||||
| Friendly | bit | 1 | √ | null |
|
|
Friendly flag - Indicates if contact is friendly and cooperative |
||||
| Nice | bit | 1 | √ | null |
|
|
Nice flag - Indicates if contact is nice and pleasant to work with |
||||
| TextingNumber | nvarchar | 40 | √ | null |
|
|
Texting number - Phone number for text messaging communication |
||||
| Notes | nvarchar | 1073741823 | √ | null |
|
|
Contact notes - General notes and observations about the contact |
||||
| Relation | nvarchar | 510 | √ | null |
|
|
Relationship - Relationship of contact to the patient |
||||
| County | nvarchar | 510 | √ | null |
|
|
County - County of residence for the contact |
||||
| EmpCity | nvarchar | 8000 | √ | null |
|
|
Employer city - City where the employer is located |
||||
| EmpState | nvarchar | 510 | √ | null |
|
|
Employer state - State where the employer is located |
||||
| EmpZip | nvarchar | 510 | √ | null |
|
|
Employer zip code - Zip code for the employer’s location |
||||
| ServiceType | nvarchar | 510 | √ | null |
|
|
Service type - Type of service associated with this contact |
||||
| ContactDetails | nvarchar | 2048 | √ | null |
|
|
Contact details - Detailed contact information and preferences |
||||
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when this record was deleted |
||||
| EIODinitial | nvarchar | 510 | √ | null |
|
|
EIOD initial - Early Intervention Outcome Data initial assessment |
||||
| enddate | nvarchar | 510 | √ | null |
|
|
End date - End date for service or contact period |
||||
| frequency | nvarchar | 510 | √ | null |
|
|
Service frequency - Frequency of service delivery |
||||
| Mom | nvarchar | 1073741823 | √ | null |
|
|
Mother information - Information about the patient’s mother |
||||
| Numberofmakeupvisits | nvarchar | 510 | √ | null |
|
|
Number of makeup visits - Count of makeup visits scheduled or completed |
||||
| pagefourservices | nvarchar | 510 | √ | null |
|
|
Page four services - Services listed on page four of documentation |
||||
| Reasonwhyservicestartedlate | nvarchar | 1000 | √ | null |
|
|
Reason service started late - Explanation for delayed service initiation |
||||
| SecondaryEmail | nvarchar | 510 | √ | null |
|
|
Secondary email - Secondary email address for the contact |
||||
| ServiceCoordinatorName | nvarchar | 510 | √ | null |
|
|
Service coordinator name - Name of the assigned service coordinator |
||||
| ServiceStatus | nvarchar | 510 | √ | null |
|
|
Service status - Current status of services for this contact |
||||
| setting | nvarchar | 510 | √ | null |
|
|
Service setting - Setting where services are provided |
||||
| SMPhoneOptions | nvarchar | 510 | √ | null |
|
|
SM phone options - Service management phone communication options |
||||
| stardate | nvarchar | 510 | √ | null |
|
|
Start date - Start date for service or contact period |
||||
| startofservice | nvarchar | 510 | √ | null |
|
|
Start of service - Date when services began |
||||
| TotalnumberofmakeupvisitsperIFSPperiod | nvarchar | 510 | √ | null |
|
|
Total makeup visits per IFSP period - Total count of makeup visits allowed per IFSP period |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PatientContactCustom | Primary key | Asc | pkID |
Relationships
Close relationships within degrees of separation
