ScClaim_ScClaimCustom_vw


Description

Comprehensive service coordination claims with custom data view providing a unified view of service coordination claims, patient information, custom claim fields, and detailed claim processing data. This view consolidates data from Patient, ScClaimCustom, scClaim, and Claim_VW tables to support comprehensive service coordination claims reporting, billing analysis, custom documentation requirements, and detailed claim management for early intervention and special education service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Patient_PatientID int 4 null

Patient identifier - Unique identifier for each patient/client in the system
Patient_FirstName varchar 50 √ null

Patient first name - Patient’s given name for identification and communication
Patient_MiddleName varchar 50 √ null

Patient middle name - Patient’s middle name or initial for complete identification
Patient_LastName varchar 50 √ null

Patient last name - Patient’s surname for identification and alphabetical sorting
Patient_Sex varchar 20 √ null

Patient gender - Patient’s gender for demographic reporting and appropriate care matching
Patient_DateOfBirth datetime 16,3 √ null

Patient birth date - Patient’s date of birth for age calculations and eligibility determination
Patient_Address varchar 50 √ null

Patient primary address - Patient’s street address for service delivery and communication
Patient_City varchar 50 √ null

Patient city - City of patient’s primary residence
Patient_State varchar 50 √ null

Patient state - State/province of patient’s primary residence
Patient_ZipCode varchar 10 √ null

Patient postal code - ZIP/postal code for patient’s address
Patient_Telephone varchar 30 √ null

Patient phone number - Primary telephone number for patient contact
Patient_Ethnicity varchar 20 √ null

Patient ethnicity - Patient’s ethnic background for demographic reporting and cultural considerations
Patient_InsuranceID int 4 √ null

Patient insurance reference - Links to Insurance table for primary insurance coverage
Patient_DateEntered datetime 16,3 √ null

Patient enrollment date - Date when patient was first entered into the system
Patient_DatePrescription datetime 16,3 √ null

Patient prescription date - Date of medical prescription or referral for services
Patient_AgencyID int 4 √ null

Patient agency reference - Links to Agency table for the healthcare provider serving this patient
Patient_ForestCareID int 4 √ null

ForestCare identifier - External system identifier for ForestCare integration
Patient_Comments varchar 500 √ null

Patient comments - General comments and notes about the patient
Patient_District int 4 √ null

Patient district - School or administrative district for the patient
Patient_Borough char 20 √ null

Patient borough - Borough or administrative region for the patient
Patient_RxDate datetime 16,3 √ null

Prescription date - Date of medical prescription or referral
Patient_BillingType int 4 √ null

Patient billing type - Type of billing arrangement for the patient
Patient_DateAnnualMedical datetime 16,3 √ null

Annual medical date - Date of annual medical examination
Patient_DateAudiological datetime 16,3 √ null

Audiological assessment date - Date of hearing/audiological evaluation
Patient_DateVisionTest datetime 16,3 √ null

Vision test date - Date of vision screening or examination
Patient_DateSCConsent datetime 16,3 √ null

Service coordination consent date - Date when service coordination consent was obtained
Patient_DateReleaseInfoConsent datetime 16,3 √ null

Information release consent date - Date when consent to release information was obtained
Patient_DateEvalConsent datetime 16,3 √ null

Evaluation consent date - Date when evaluation consent was obtained
Patient_DateFamilyInfoWorksheet datetime 16,3 √ null

Family information worksheet date - Date when family information worksheet was completed
Patient_DateMedicalInfoWorksheet datetime 16,3 √ null

Medical information worksheet date - Date when medical information worksheet was completed
Patient_Date45DayLimit datetime 16,3 √ null

45-day timeline date - Date related to 45-day service timeline requirements
Patient_DateChildInfoChange datetime 16,3 √ null

Child information change date - Date when child information was last changed
Patient_DateSurrogacyForm datetime 16,3 √ null

Surrogacy form date - Date when surrogacy form was completed
Patient_DateClosureForm datetime 16,3 √ null

Closure form date - Date when case closure form was completed
Patient_OtherInsurance char 5 √ null

Other insurance flag - Indicates if patient has additional insurance coverage
Patient_MedicalID varchar 50 √ null

Medical record ID - Medical record number or identifier
Patient_DateHIPAAPrivacyReceived datetime 16,3 √ null

HIPAA privacy notice date - Date when HIPAA privacy notice was received
Patient_SignatureOnFile varchar 1 √ null

Signature on file flag - Indicates if patient signature is on file
Patient_DateSigned datetime 16,3 √ null

Signature date - Date when consent forms were signed
Patient_Age int 4 √ null

Patient current age - Patient’s current age (calculated field)
Patient_MaritalStatus varchar 3 √ null

Patient marital status - Patient’s marital status (for adult patients)
Patient_DateOfDeath datetime 16,3 √ null

Patient death date - Date of death if applicable
Patient_EmploymentStatus varchar 3 √ null

Patient employment status - Employment status (for adult patients)
Patient_CreatedBy int 4 √ null

Patient record created by - UserID of the person who created this patient record
Patient_DateUpdated datetime 16,3 √ null

Patient record last update date - Timestamp of the most recent patient record update
Patient_UpdatedBy int 4 √ null

Patient record updated by - UserID of the person who last modified this patient record
Patient_Pregnancy varchar 1 √ null

Patient pregnancy status - Pregnancy status indicator
Patient_SiteID int 4 √ null

Patient site reference - Links to AgencySite table for primary service location
Patient_patientStatus varchar 30 √ null

Patient status - Current status of the patient in the system
Patient_source varchar 2 √ null

Patient data source - Source of patient data entry
Patient_Address2 varchar 50 √ null

Patient address line 2 - Additional address information (apartment, suite, etc.)
Patient_InternalID int 4 √ null

Patient internal ID - Internal system identifier
Patient_Email varchar 100 √ null

Patient email address - Patient or guardian email for communication
Patient_ImportID int 4 √ null

Patient import identifier - Reference ID for data migration and import tracking
Patient_ProfileImage nvarchar 1073741823 √ null

Patient profile image - Patient profile photo or image
Patient_ListClassrooms nvarchar 1073741823 √ null

Patient classroom list - List of classrooms associated with the patient
ScClaimCustom_pkID int 4 √ null

Service coordination claim custom primary key - Unique identifier for each custom service coordination claim record
ScClaimCustom_fkSclaimID int 4 √ null

Service coordination claim reference - Links to scClaim table for the associated service coordination claim
ScClaimCustom_DateCreated datetime 16,3 √ null

SC claim custom creation date - Timestamp when the custom service coordination claim record was created
ScClaimCustom_CreatedBy int 4 √ null

SC claim custom created by - UserID of the person who created this custom service coordination claim record
ScClaimCustom_DateUpdated datetime 16,3 √ null

SC claim custom last update date - Timestamp of the most recent custom service coordination claim record update
ScClaimCustom_UpdatedBy int 4 √ null

SC claim custom updated by - UserID of the person who last modified this custom service coordination claim record
ScClaimCustom_DeletedDate datetime 16,3 √ null

SC claim custom deletion date - Soft delete timestamp for audit trail purposes
ScClaimCustom_GeneralNotes nvarchar 1073741823 √ null

SC general notes - General notes and observations for the service coordination claim
ScClaimCustom_SCType nvarchar 510 √ null

Service coordination type - Type of service coordination provided
ScClaimCustom_ServiceTypes nvarchar 1998 √ null

Service types - Types of services coordinated during the session
ScClaimCustom_MissedSessionChoices nvarchar 510 √ null

Missed session choices - Options selected when session was missed
ScClaimCustom_ServiceProviderAgency nvarchar 1998 √ null

Service provider agency - Agency providing the coordinated services
ScClaimCustom_MissedTimePeriod nvarchar 510 √ null

Missed time period - Time period when session was missed
ScClaimCustom_InitialVisitConductedAt nvarchar 510 √ null

Initial visit location - Location where initial visit was conducted
ScClaimCustom_ParentName nvarchar 510 √ null

Parent name - Name of parent or guardian involved in service coordination
ScClaimCustom_ChildReferredBy nvarchar 510 √ null

Child referred by - Source of referral for the child
ScClaimCustom_Communication nvarchar 1073741823 √ null

Communication assessment - Assessment of child’s communication development and needs
ScClaimCustom_Physical nvarchar 1073741823 √ null

Physical assessment - Assessment of child’s physical development and needs
ScClaimCustom_SocialEmotional nvarchar 1073741823 √ null

Social emotional assessment - Assessment of child’s social and emotional development
ScClaimCustom_Cognitive nvarchar 1073741823 √ null

Cognitive assessment - Assessment of child’s cognitive development and abilities
ScClaimCustom_Adaptive nvarchar 1073741823 √ null

Adaptive assessment - Assessment of child’s adaptive behavior and daily living skills
ScClaimCustom_Insurance nvarchar 510 √ null

Insurance information - Insurance-related information for service coordination
ScClaimCustom_Evaluations nvarchar 510 √ null

Evaluations - Evaluations conducted or coordinated
ScClaimCustom_InterimIFSP nvarchar 510 √ null

Interim IFSP - Interim Individualized Family Service Plan information
ScClaimCustom_ChildName nvarchar 510 √ null

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

Child age out - Information about child aging out of services
ScClaimCustom_ParentTransitionChoices nvarchar 1073741823 √ null

Parent transition choices - Parent choices for transition planning
ScClaimCustom_ST bit 1 √ null

Speech therapy flag - Indicates if speech therapy services are involved
ScClaimCustom_STNotes nvarchar 510 √ null

Speech therapy notes - Notes about speech therapy services
ScClaimCustom_OT bit 1 √ null

Occupational therapy flag - Indicates if occupational therapy services are involved
ScClaimCustom_OTNotes nvarchar 510 √ null

Occupational therapy notes - Notes about occupational therapy services
scClaim_SclaimID int 4 null

Service coordination claim ID - Unique identifier for each service coordination claim
scClaim_ClaimID int 4 null

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

Service start time - Start time of the service coordination session
scClaim_EndTime datetime 16,3 √ null

Service end time - End time of the service coordination session
scClaim_Minutes int 4 √ null

Service minutes - Duration of service coordination session in minutes
scClaim_AmountCharged money 21,4 √ null

Amount charged - Amount charged for the service coordination session
scClaim_BillingUnit int 4 √ null

Billing units - Number of billing units for the service coordination session
scClaim_Contactcode char 15 √ null

Contact code - Code indicating type of contact during service coordination
scClaim_QuickNoteID int 4 √ null

Quick note reference - Links to QuickNote table for predefined notes
scClaim_DateEntered datetime 16,3 √ null

SC claim entry date - Date when service coordination claim was entered into the system
scClaim_source varchar 5 √ null

SC claim source - Source of service coordination claim data entry
scClaim_IFSPchecked varchar 3 √ null

IFSP checked flag - Indicates if Individualized Family Service Plan was reviewed
scClaim_ClaimBy int 4 √ null

SC claimed by user - UserID of the service coordinator who performed the service
scClaim_billable int 4 √ null

SC billable flag - Indicates if the service coordination session is billable
scClaim_IDcount int 4 √ null

ID count - Count identifier for the service coordination claim
scClaim_Dateaction datetime 16,3 √ null

SC action date - Date when service coordination action was taken
scClaim_VisitCode int 4 √ null

SC visit code - Code indicating type of service coordination visit
scClaim_CaseNotes varchar 6000 √ null

SC case notes - Detailed case notes for the service coordination session
scClaim_Outcomenotes varchar 1500 √ null

SC outcome notes - Notes about outcomes achieved during service coordination
scClaim_Actionnotes varchar 500 √ null

SC action notes - Notes about actions taken during service coordination
scClaim_EnteredBy int 4 √ null

SC entered by user - UserID of the person who entered the service coordination claim
scClaim_StatusID int 4 √ null

SC status reference - Links to StatusType table for service coordination claim status
scClaim_DateUpdate datetime 16,3 √ null

SC claim update date - Date when service coordination claim was last updated
scClaim_UpdatedBy int 4 √ null

SC updated by user - UserID of the person who last updated the service coordination claim
scClaim_ITemplateID int 4 √ null

SC template reference - Links to iTemplate table for service coordination documentation template
Claim_VW_ClaimID int 4 null

Claim view identifier - Unique identifier for each claim in the view
Claim_VW_DateEntered datetime 16,3 √ null

Claim view entry date - Date when claim was entered into the system
Claim_VW_DateService datetime 16,3 √ null

Claim view service date - Date when the service was provided
Claim_VW_DateCycle datetime 16,3 √ null

Claim view billing cycle date - Date of billing cycle for the claim
Claim_VW_DateUpdate datetime 16,3 √ null

Claim view update date - Date when claim was last updated
Claim_VW_AmountCharged money 21,4 √ null

Claim view amount charged - Amount charged for the service
Claim_VW_AgencyID int 4 √ null

Claim view agency reference - Links to Agency table for the healthcare provider
Claim_VW_InvoiceID varchar 30 √ null

Claim view invoice reference - Invoice identifier for billing
Claim_VW_PatientID int 4 √ null

Claim view patient reference - Links to Patient table for the patient receiving service
Claim_VW_ClaimTypeID int 4 √ null

Claim view claim type reference - Links to ClaimType table for type of claim
Claim_VW_SiteID int 4 √ null

Claim view site reference - Links to AgencySite table for service location
Claim_VW_ICN varchar 50 √ null

Claim view internal control number - Internal control number for claim tracking
Claim_VW_LineNumber varchar 3 √ null

Claim view line number - Line number on the claim form
Claim_VW_Enteredby int 4 √ null

Claim view entered by user - UserID of the person who entered the claim
Claim_VW_StatusID int 4 √ null

Claim view status reference - Links to StatusType table for claim status
Claim_VW_AmountPaid money 21,4 √ null

Claim view amount paid - Amount paid by insurance or payer
Claim_VW_DatePaid datetime 16,3 √ null

Claim view payment date - Date when payment was received
Claim_VW_DateBilled datetime 16,3 √ null

Claim view billing date - Date when claim was billed
Claim_VW_ActionID int 4 √ null

Claim view action reference - Links to ClaimAction table for claim action
Claim_VW_ProcedureID int 4 √ null

Claim view procedure reference - Links to ProcCode table for procedure performed
Claim_VW_ModifierID int 4 √ null

Claim view modifier reference - Links to Modifier table for procedure modifier
Claim_VW_ServiceTypeID int 4 √ null

Claim view service type reference - Links to ServiceType table for type of service
Claim_VW_ClearingHouseErrorID int 4 √ null

Claim view clearing house error reference - Links to ClearingHouseError table for processing errors
Claim_VW_RuleError varchar 10 √ null

Claim view rule error - Business rule error code
Claim_VW_Comments varchar 500 √ null

Claim view comments - Comments and notes about the claim
Claim_VW_UpdateBy int 4 √ null

Claim view updated by user - UserID of the person who last updated the claim
Claim_VW_ClaimBy int 4 √ null

Claim view claimed by user - UserID of the service provider who performed the service
Claim_VW_DateAction datetime 16,3 √ null

Claim view action date - Date when claim action was taken
Claim_VW_TransType int 4 √ null

Claim view transaction type - Type of transaction for the claim
Claim_VW_PriorAuth varchar 50 √ null

Claim view prior authorization - Prior authorization number
Claim_VW_RemittIDNumber int 4 √ null

Claim view remittance ID - Remittance advice identifier
Claim_VW_CheckNumber int 4 √ null

Claim view check number - Payment check number
Claim_VW_RA_ID int 4 √ null

Claim view remittance advice ID - Links to remittance advice record
Claim_VW_VoidID int 4 √ null

Claim view void reference - Links to VoidReason table if claim is voided
Claim_VW_source varchar 2 √ null

Claim view source - Source of claim data entry
Claim_VW_Dateoriginalbilled smalldatetime 16 √ null

Claim view original billing date - Date when claim was originally billed
Claim_VW_TransmitType int 4 √ null

Claim view transmission type - Type of claim transmission (electronic, paper, etc.)
Claim_VW_ppdID int 4 √ null

Claim view PPD reference - Links to PPD data for claim processing
Claim_VW_Borough int 4 √ null

Claim view borough - Borough or administrative region for the claim
Claim_VW_ActivePayroll int 4 √ null

Claim view active payroll - Indicates if claim is part of active payroll
Claim_VW_AmountAdjusted money 21,4 √ null

Claim view amount adjusted - Amount adjusted on the claim
Claim_VW_AmountVoid money 21,4 √ null

Claim view amount voided - Amount voided on the claim
Claim_VW_DateAdjusted datetime 16,3 √ null

Claim view adjustment date - Date when claim was adjusted
Claim_VW_DateVoid datetime 16,3 √ null

Claim view void date - Date when claim was voided
Claim_VW_fkAdmitID int 4 √ null

Claim view case reference - Links to PatientAdministration table for the case
Claim_VW_PaySourceID varchar 30 √ null

Claim view payment source - Payment source identifier
Claim_VW_AttCode varchar 10 √ null

Claim view attendance code - Attendance code for the service
Claim_VW_fkAuthID int 4 √ null

Claim view authorization reference - Links to Authorization table for service authorization
Claim_VW_OnHold int 4 √ null

Claim view on hold flag - Indicates if claim is on hold
Claim_VW_OrigAmountCharged money 21,4 √ null

Claim view original amount charged - Original amount charged before adjustments
Claim_VW_Outstanding money 21,4 √ null

Claim view outstanding amount - Outstanding amount on the claim
Claim_VW_Minutes int 4 √ null

Claim view service minutes - Duration of service in minutes
Claim_VW_importID int 4 √ null

Claim view import reference - Reference ID for data import tracking
Claim_VW_fkCPID int 4 √ null

Claim view claim type program reference - Links to claim type program configuration
Claim_VW_StartTime varchar 20 √ null

Claim view service start time - Start time of the service
Claim_VW_EndTime varchar 20 √ null

Claim view service end time - End time of the service
Claim_VW_BillingUnit decimal 6,2 √ null

Claim view billing units - Number of billing units for the service
Claim_VW_deptID int 4 √ null

Claim view department reference - Department identifier for the service
Claim_VW_ImportDate varchar 30 √ null

Claim view import date - Date when claim data was imported
Claim_VW_OrigBillingUnit decimal 7,2 √ null

Claim view original billing units - Original billing units before adjustments
Claim_VW_CPTCode varchar 50 √ null

Claim view CPT code - Current Procedural Terminology code for the service
Claim_VW_DateUpdated datetime 16,3 √ null

Claim view last update date - Timestamp of the most recent claim update
Claim_VW_ClaimTypeName varchar 100 √ null

Claim view claim type name - Name of the claim type
Claim_VW_ModifierName varchar 50 √ null

Claim view modifier name - Name of the procedure modifier
Claim_VW_StatusCode varchar 50 √ null

Claim view status code - Status code for the claim
Claim_VW_ActionStatus varchar 50 √ null

Claim view action status - Status of the claim action
Claim_VW_ActionNotes varchar 5000 √ null

Claim view action notes - Notes about the claim action
Claim_VW_ModifierDes varchar 100 √ null

Claim view modifier description - Description of the procedure modifier
Claim_VW_ProcCode varchar 30 √ null

Claim view procedure code - Procedure code for the service
Claim_VW_ProcName varchar 30 √ null

Claim view procedure name - Name of the procedure performed
Claim_VW_ServiceType varchar 10 √ null

Claim view service type - Type of service provided
Claim_VW_servicetypedesc varchar 100 √ null

Claim view service type description - Description of the service type
Claim_VW_isOnhold varchar 3 null

Claim view is on hold - Indicates if claim is currently on hold
Claim_VW_hold varchar 3 null

Claim view hold status - Hold status of the claim
Claim_VW_code varchar 10 √ null

Claim view code - General code for the claim
Claim_VW_visitcodedesc varchar 255 √ null

Claim view visit code description - Description of the visit code
Claim_VW_VisitCode varchar 255 √ null

Claim view visit code - Code indicating type of visit
Claim_VW_ServiceDesc varchar 100 √ null

Claim view service description - Description of the service provided
Claim_VW_provider varchar 102 √ null

Claim view provider - Name of the service provider
Claim_VW_userTitle varchar 50 null

Claim view user title - Title of the user who provided the service
Claim_VW_errorCode1 int 4 √ null

Claim view error code 1 - First error code for claim processing
Claim_VW_errorCode2 int 4 √ null

Claim view error code 2 - Second error code for claim processing
Claim_VW_errorCode3 int 4 √ null

Claim view error code 3 - Third error code for claim processing
Claim_VW_errorCode4 int 4 √ null

Claim view error code 4 - Fourth error code for claim processing
Claim_VW_CompanyName varchar 50 √ null

Claim view company name - Name of the company or agency
Claim_VW_ClientID varchar 15 √ null

Claim view client ID - Client identifier for the claim
Claim_VW_errorDesc1 varchar 100 √ null

Claim view error description 1 - Description of first error
Claim_VW_errorDesc2 varchar 100 √ null

Claim view error description 2 - Description of second error
Claim_VW_errorDesc3 varchar 100 √ null

Claim view error description 3 - Description of third error
Claim_VW_errorDesc4 varchar 100 √ null

Claim view error description 4 - Description of fourth error
Claim_VW_RuleErrorDesc varchar 100 √ null

Claim view rule error description - Description of business rule error
Claim_VW_voucher varchar 30 √ null

Claim view voucher - Voucher number for the claim
Claim_VW_ReasonDesc varchar 50 √ null

Claim view reason description - Description of reason for claim action
Claim_VW_VoidDesc varchar 500 √ null

Claim view void description - Description of reason for voiding claim
Claim_VW_currICN char 13 √ null

Claim view current ICN - Current internal control number
Claim_VW_currLineNum char 5 √ null

Claim view current line number - Current line number on claim
Claim_VW_NYEISID varchar 30 √ null

Claim view NYEIS ID - New York Early Intervention System identifier
Claim_VW_NPI varchar 30 √ null

Claim view NPI - National Provider Identifier
Claim_VW_ICDCodes varchar 100 √ null

Claim view ICD codes - International Classification of Diseases codes
Claim_VW_CPTCode1 varchar 100 √ null

Claim view CPT code 1 - First Current Procedural Terminology code
Claim_VW_CPTCode2 varchar 100 √ null

Claim view CPT code 2 - Second Current Procedural Terminology code
Claim_VW_CPTCode3 varchar 100 √ null

Claim view CPT code 3 - Third Current Procedural Terminology code
Claim_VW_CPTCode4 varchar 100 √ null

Claim view CPT code 4 - Fourth Current Procedural Terminology code

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views