PatientAdministrationCustomBak


Description

Patient administration custom backup data storing backup copies of extended patient administration information including referral details, caregiver information, and developmental concerns. This backup table preserves historical custom data for patient cases, supporting data recovery, audit trails, and compliance with data retention requirements for early intervention services.

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

Relationships