ScClaimCustom


Description

Service coordination claim custom data storing extended custom fields and specialized information for service coordination claims. This table captures additional service coordination details including developmental domains, service types, transition planning, and specialized notes that support comprehensive early intervention service coordination documentation and reporting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkID int identity 4 √ null

Primary key - Unique identifier for each service coordination custom record
fkSclaimID int 4 null

Service coordination claim reference - Links to the parent service coordination claim record
DateCreated datetime 16,3 √ null

Creation date - Date when the custom record was created
CreatedBy int 4 √ null

Created by user - UserID of the person who created the custom record
DateUpdated datetime 16,3 √ null

Update date - Date when the custom record was last modified
UpdatedBy int 4 √ null

Updated by user - UserID of the person who last modified the custom record
DeletedDate datetime 16,3 √ null

Deletion date - Date when the custom record was soft-deleted
GeneralNotes nvarchar 1073741823 √ null

General notes - General notes and comments about the service coordination session
SCType nvarchar 510 √ null

Service coordination type - Type or category of service coordination provided
ServiceTypes nvarchar 1998 √ null

Service types - Types of services discussed or coordinated during the session
MissedSessionChoices nvarchar 510 √ null

Missed session choices - Options or reasons for missed service coordination sessions
ServiceProviderAgency nvarchar 1998 √ null

Service provider agency - Agency or organization providing services
MissedTimePeriod nvarchar 510 √ null

Missed time period - Time period during which sessions were missed
InitialVisitConductedAt nvarchar 510 √ null

Initial visit location - Location where the initial service coordination visit was conducted
ParentName nvarchar 510 √ null

Parent name - Name of the parent or primary caregiver
ChildReferredBy nvarchar 510 √ null

Child referred by - Source of the child’s referral for services
Communication nvarchar 1073741823 √ null

Communication domain notes - Notes about the child’s communication development and needs
Physical nvarchar 1073741823 √ null

Physical domain notes - Notes about the child’s physical development and needs
SocialEmotional nvarchar 1073741823 √ null

Social-emotional domain notes - Notes about the child’s social-emotional development and needs
Cognitive nvarchar 1073741823 √ null

Cognitive domain notes - Notes about the child’s cognitive development and needs
Adaptive nvarchar 1073741823 √ null

Adaptive domain notes - Notes about the child’s adaptive behavior and daily living skills
Insurance nvarchar 510 √ null

Insurance information - Insurance coverage details for the child
Evaluations nvarchar 510 √ null

Evaluation information - Details about evaluations completed or needed
InterimIFSP nvarchar 510 √ null

Interim IFSP information - Details about interim Individualized Family Service Plan
ChildName nvarchar 510 √ null

Child name - Name of the child receiving services
ChildAgeOut nvarchar 510 √ null

Child age out information - Information about the child aging out of services
ParentTransitionChoices nvarchar 1073741823 √ null

Parent transition choices - Parent preferences and choices for transition planning
ST bit 1 √ null

Speech therapy flag - Boolean indicating if speech therapy services are involved
STNotes nvarchar 510 √ null

Speech therapy notes - Notes specific to speech therapy services
OT bit 1 √ null

Occupational therapy flag - Boolean indicating if occupational therapy services are involved
OTNotes nvarchar 510 √ null

Occupational therapy notes - Notes specific to occupational therapy services
Field1 nvarchar 510 √ null

Custom field 1 - Additional custom field for program-specific data
GeneralDate datetime 16,3 √ null

General date - General purpose date field for custom use
InitialReferral nvarchar 1073741823 √ null

Initial referral information - Details about the initial referral for services
IntakeDate datetime 16,3 √ null

Intake date - Date when the child was taken into the service coordination program
ISCorOSC nvarchar 510 √ null

ISC or OSC designation - Indicates whether this is Initial Service Coordination or Ongoing Service Coordination
MoreNotes nvarchar 1073741823 √ null

Additional notes - Additional notes and comments for extended documentation

Indexes

Constraint Name Type Sort Column(s)
PK_ScClaimCustom Primary key Asc pkID
ScClaimCustomSClaimID Performance Asc fkSclaimID

Relationships

Close relationships within degrees of separation