ClaimCustom


Description

Claim custom fields table for storing extended claim information including session details, participant data, CPSE (Committee on Preschool Special Education) documentation, and specialized assessment information. This table captures detailed session progress notes, objectives addressed, caregiver coaching activities, routine activities, strategies used, and comprehensive documentation required for early intervention services, special education transitions, and regulatory compliance reporting.

Columns

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

Primary key - Unique identifier for each claim custom record
fkClaimID int 4 null

Claim reference - Links to Claim table for the associated claim
DateCreated datetime 16,3 √ null

Creation date - Date when this custom 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
DeletedDate datetime 16,3 √ null

Deletion date - Date when this record was marked as deleted
TestField nvarchar 510 √ null

Test field - Test field for development and validation purposes
SessionParticipants nvarchar 510 √ null

Session participants - List of participants who attended the session
UnableToParticipate nvarchar 510 √ null

Unable to participate - Reasons why participants were unable to participate
SessionProgress nvarchar 1998 √ null

Session progress - Detailed notes about progress made during the session
ObjectivesAddressed nvarchar 1998 √ null

Objectives addressed - Specific objectives that were addressed during the session
RoutineActivities nvarchar 510 √ null

Routine activities - Routine activities incorporated into the session
StrategiesUsed nvarchar 510 √ null

Strategies used - Intervention strategies and techniques used during the session
CoachCaregiver nvarchar 510 √ null

Coach caregiver - Caregiver coaching activities and approaches used
CaregiverCommunicate nvarchar 1998 √ null

Caregiver communication - Communication strategies and methods used with caregivers
CaregiverActivities nvarchar 1998 √ null

Caregiver activities - Activities and strategies provided to caregivers
Haircolor nvarchar 510 √ null

Hair color - Physical description field for identification purposes
Notes nvarchar 1073741823 √ null

General notes - General notes and observations about the session
specify nvarchar 1073741823 √ null

Specify details - Additional specification details for custom fields
ParticipantOther nvarchar 1073741823 √ null

Other participants - Additional participants not listed in standard categories
Additionalinformationaboutthesession nvarchar 1073741823 √ null

Additional session information - Supplementary information about the session
RoutineActivitiesOther nvarchar 1073741823 √ null

Other routine activities - Additional routine activities not in standard list
StrategiesOther nvarchar 1073741823 √ null

Other strategies - Additional strategies not in standard categories
CoachingOther nvarchar 1073741823 √ null

Other coaching - Additional coaching approaches and methods
RelationshipToChild nvarchar 510 √ null

Relationship to child - Participant’s relationship to the child receiving services
ProviderCredentials nvarchar 510 √ null

Provider credentials - Credentials and qualifications of the service provider
GeneralNotes nvarchar 1073741823 √ null

General notes - General notes and comments about the claim
InitialCPSEMeeting nvarchar 6000 √ null

Initial CPSE meeting - Information about initial Committee on Preschool Special Education meeting
AdditionalNotes nvarchar 510 √ null

Additional notes - Additional notes and observations
Classifiedasapreschoolchildwithadisability nvarchar 6000 √ null

Preschool disability classification - Classification status as preschool child with disability
Eligibilityform nvarchar 6000 √ null

Eligibility form - Eligibility form information and status
ChairpersonName nvarchar 510 √ null

Chairperson name - Name of the CPSE meeting chairperson
Services nvarchar 510 √ null

Services - Services recommended or provided
CPSEStartDate nvarchar 510 √ null

CPSE start date - Start date for CPSE services
ExtraNotes nvarchar 6000 √ null

Extra notes - Additional notes and documentation
ExtraNoteSpace nvarchar 6000 √ null

Extra note space - Additional space for extended notes
District nvarchar 510 √ null

School district - School district information
HSAQuestion2 nvarchar 510 √ null

HSA question 2 - Health Services Assessment question 2 response
HSAQuestion1 nvarchar 510 √ null

HSA question 1 - Health Services Assessment question 1 response
HSAQuestion3 nvarchar 510 √ null

HSA question 3 - Health Services Assessment question 3 response
ActivityatCoVisit nvarchar 8000 √ null

Co-visit activity - Activities conducted during co-visit sessions
AdditionalActivityatCoVisit nvarchar 8000 √ null

Additional co-visit activity - Additional activities during co-visit sessions
covisitparticipants nvarchar 4010 √ null

Co-visit participants - Participants involved in co-visit sessions
DiscussionatCoVisit nvarchar 8000 √ null

Co-visit discussion - Discussion topics and outcomes during co-visit
FamilyplanfornexttimeperiodasperIFSP nvarchar 8000 √ null

Family plan next period - Family plan for next time period as per IFSP
Followupbyteamofinterventionists nvarchar 8000 √ null

Team follow-up - Follow-up activities by team of interventionists
Locationofcovisit nvarchar 510 √ null

Co-visit location - Location where co-visit session took place
Provider1Credential nvarchar 8000 √ null

Provider 1 credentials - Credentials of first provider in co-visit
Provider2Credential nvarchar 8000 √ null

Provider 2 credentials - Credentials of second provider in co-visit

Indexes

Constraint Name Type Sort Column(s)
PK_ClaimCustom Primary key Asc pkID
ClaimCustomClaimID Performance Asc fkClaimID

Relationships

Close relationships within degrees of separation