scClaim


Description

Service coordination claims managing detailed service coordination session information and billing data. This table stores comprehensive information about service coordination visits including time tracking, contact codes, case notes, outcome documentation, and billing details, supporting service coordination workflows, documentation requirements, and billing processes for early intervention services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SclaimID int identity 4 √ null
SubclaimCPT.fkSubClaimID FK_SubclaimCPT_scClaim R
SubclaimICD9.fkSubclaimID FK_SubclaimICD9_scClaim R

Primary key - Unique identifier for each service coordination claim
ClaimID int 4 null

Parent claim reference - Links to the main claim record
StartTime datetime 16,3 √ null

Session start time - Date and time when the service coordination session began
EndTime datetime 16,3 √ null

Session end time - Date and time when the service coordination session ended
Minutes int 4 √ (0)

Session duration - Total minutes of service coordination provided
AmountCharged money 21,4 √ null

Charge amount - Amount charged for the service coordination session
BillingUnit int 4 √ null

Billing units - Number of billing units for the session
Contactcode char 15 √ null

Contact code - Code indicating the type of contact or service coordination method
QuickNoteID int 4 √ null

Quick note reference - Links to predefined quick notes for efficient documentation
DateEntered datetime 16,3 √ (getdate())

Entry date - Date when the service coordination claim was entered
source varchar 5 √ null

Data source - Source of the claim data (Manual, Import, etc.)
IFSPchecked varchar 3 √ null

IFSP checked indicator - Indicates if IFSP was reviewed during the session
ClaimBy int 4 √ null

Claimed by user - UserID of the service coordinator who provided the service
billable int 4 √ null

Billable indicator - Indicates if the session is billable
IDcount int 4 √ null

ID count - Count of identifiers or participants in the session
Dateaction datetime 16,3 √ null

Action date - Date when specific actions were taken
VisitCode int 4 √ null

Visit code - Code indicating the type of visit or session
CaseNotes varchar 6000 √ null

Case notes - Detailed notes about the service coordination session
Outcomenotes varchar 1500 √ null

Outcome notes - Notes about outcomes achieved during the session
Actionnotes varchar 500 √ null

Action notes - Notes about specific actions taken during the session
EnteredBy int 4 √ null

Entered by user - UserID of the person who entered the claim
StatusID int 4 √ null

Claim status - Current status of the service coordination claim, references iCS2.dbo.StatusType for centralized status management
DateUpdate datetime 16,3 √ null

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

Updated by user - UserID of the person who last modified the claim
ITemplateID int 4 √ null
iTemplate.TemplateID FK_scClaim_iTemplate R

Template reference - Links to the documentation template used for this session

Indexes

Constraint Name Type Sort Column(s)
PK_scClaim Primary key Asc SclaimID
amountcharged Performance Asc AmountCharged
IX_ClaimID Performance Asc ClaimID
IX_EnteredBy_ClaimBy Performance Asc/Asc EnteredBy + ClaimBy
IX_scClaim_ClaimBy Performance Asc/Asc ClaimBy + EnteredBy
IX_scClaim_ClaimID Performance Asc ClaimID

Relationships

Close relationships within degrees of separation