Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| pkID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each patient administration custom backup record |
|
| fkAdmitID | int | 4 | null |
|
|
Admission reference - Links to the patient admission/case (PatientAdministration.AdmitID) |
||
| DateCreated | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the custom backup record was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - UserID of the person who created the custom backup record |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the custom backup record was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last modified the custom backup record |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the custom backup record was soft-deleted |
|
| CallFaxDate | datetime | 16,3 | √ | null |
|
|
Call/fax date - Date when initial contact was made via call or fax |
|
| ReferralSourceName | nvarchar | 510 | √ | null |
|
|
Referral source name - Name of the person or organization that made the referral |
|
| RSFax | nvarchar | 510 | √ | null |
|
|
Referral source fax - Fax number of the referral source |
|
| RSPhone | nvarchar | 510 | √ | null |
|
|
Referral source phone - Phone number of the referral source |
|
| RelationshipToChild | nvarchar | 1000 | √ | null |
|
|
Relationship to child - Referral source’s relationship to the child |
|
| OrganizationAffiliation | nvarchar | 510 | √ | null |
|
|
Organization affiliation - Organization that the referral source is affiliated with |
|
| Address | nvarchar | 510 | √ | null |
|
|
Referral source address - Address of the referral source |
|
| HowAware | nvarchar | 510 | √ | null |
|
|
How became aware - How the referral source became aware of early intervention services |
|
| LegalGuardianship | nvarchar | 510 | √ | null |
|
|
Legal guardianship status - Information about legal guardianship arrangements |
|
| CWS_SWName | nvarchar | 510 | √ | null |
|
|
Child welfare social worker name - Name of the child welfare social worker if applicable |
|
| LegalGuardianPhone | nvarchar | 50 | √ | null |
|
|
Legal guardian phone - Phone number of the legal guardian |
|
| CWS_SWPhone | nvarchar | 50 | √ | null |
|
|
Child welfare social worker phone - Phone number of the child welfare social worker |
|
| CWS_SWFax | nvarchar | 50 | √ | null |
|
|
Child welfare social worker fax - Fax number of the child welfare social worker |
|
| AreasOfConcernDevelopmental | nvarchar | 1000 | √ | null |
|
|
Developmental areas of concern - Specific developmental areas where concerns have been identified |
|
| AreasOfConcernMedical | nvarchar | 1000 | √ | null |
|
|
Medical areas of concern - Specific medical areas where concerns have been identified |
|
| RSDiagnosis | nvarchar | 200 | √ | null |
|
|
Referral source diagnosis - Diagnosis provided by the referral source |
|
| RSICD | nvarchar | 100 | √ | null |
|
|
Referral source ICD code - ICD diagnostic code provided by the referral source |
|
| DevelopmentalMedicalConcerns | nvarchar | 1073741823 | √ | null |
|
|
Developmental and medical concerns - Detailed description of developmental and medical concerns |
|
| ScreeningDone | nvarchar | 1000 | √ | null |
|
|
Screening completed - Information about screenings that have been completed |
|
| AgenciesWorkingWithChild | nvarchar | 1000 | √ | null |
|
|
Agencies working with child - List of other agencies currently working with the child |
|
| PrimaryCaregiverNames | nvarchar | 1000 | √ | null |
|
|
Primary caregiver names - Names of the primary caregivers for the child |
|
| RSRelationshipToChild | nvarchar | 510 | √ | null |
|
|
Referral source relationship to child - Specific relationship between referral source and child |
|
| RSCity | nvarchar | 100 | √ | null |
|
|
Referral source city - City where the referral source is located |
|
| RSState | nvarchar | 10 | √ | null |
|
|
Referral source state - State where the referral source is located |
|
| RSZipcode | nvarchar | 20 | √ | null |
|
|
Referral source zip code - Zip code where the referral source is located |
|
| HoursNeeded | int | 4 | √ | null |
|
|
Hours needed - Number of service hours needed per week or month |
|
| HearingScreeningResultsLeft | bit | 1 | √ | null |
|
|
Left ear hearing screening - Boolean result of hearing screening for left ear |
|
| HearingScreenResultsRight | bit | 1 | √ | null |
|
|
Right ear hearing screening - Boolean result of hearing screening for right ear |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PatientAdministrationCustom | Primary key | Asc | pkID |
