Import_EIHUB


Description

Early Intervention Hub import table for importing comprehensive child enrollment, authorization, and service coordination data from the New York State Early Intervention Hub system. This table supports data integration between external EI Hub systems and iCentral, facilitating automated import of child demographics, service authorizations, IFSP information, provider assignments, and enrollment tracking for early intervention services.

Columns

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

Primary key - Unique identifier for each EIHUB import record
BillingProvider varchar 255 √ null

Billing provider name - Name of the healthcare provider responsible for billing
EIPProviderID int 4 √ null

EI provider identifier - Early Intervention provider ID from the hub system
EIChildID int 4 √ null

EI child identifier - Early Intervention child ID from the hub system
ChildFirstName varchar 100 √ null

Child first name - First name of the child receiving services
ChildMiddleName varchar 100 √ null

Child middle name - Middle name of the child receiving services
ChildLastName varchar 100 √ null

Child last name - Last name of the child receiving services
DOB date 20 √ null

Date of birth - Child’s date of birth
ChildAddress varchar 255 √ null

Child address - Street address of the child’s residence
ChildCity varchar 100 √ null

Child city - City of the child’s residence
ChildState varchar 100 √ null

Child state - State of the child’s residence
ChildZip varchar 10 √ null

Child ZIP code - ZIP code of the child’s residence
Sex char 1 √ null

Child gender - Gender of the child (M/F)
CountyofResidence varchar 100 √ null

County of residence - County where the child resides
ChildStatus varchar 50 √ null

Child status - Current status of the child in the EI system
DateAgingOut date 20 √ null

Aging out date - Date when the child ages out of early intervention services
ServiceCoordinatorFirstName varchar 100 √ null

Service coordinator first name - First name of the assigned service coordinator
ServiceCoordinatorLastName varchar 100 √ null

Service coordinator last name - Last name of the assigned service coordinator
ServiceCoordinatorCompany varchar 255 √ null

Service coordinator company - Company or agency of the service coordinator
ServiceCoordinatorPhone varchar 15 √ null

Service coordinator phone - Phone number of the service coordinator
ServiceCoordinatorEmail varchar 255 √ null

Service coordinator email - Email address of the service coordinator
EIODFirstName varchar 100 √ null

EIOD first name - First name of the Early Intervention Official Designee
EIODLastName varchar 100 √ null

EIOD last name - Last name of the Early Intervention Official Designee
EIODPhone varchar 15 √ null

EIOD phone - Phone number of the Early Intervention Official Designee
EIODEmail varchar 255 √ null

EIOD email - Email address of the Early Intervention Official Designee
Program varchar 100 √ null

Program type - Type of early intervention program
EnrollmentType varchar 50 √ null

Enrollment type - Type of enrollment in the EI system
EnrollmentStatus varchar 50 √ null

Enrollment status - Current enrollment status
AuthorizationNumber varchar 50 √ null

Authorization number - Authorization number for services
StartDate date 20 √ null

Service start date - Date when services are authorized to begin
EndDate date 20 √ null

Service end date - Date when services are authorized to end
LocationType varchar 100 √ null

Service location type - Type of location where services are provided
SuspendedStartDate date 20 √ null

Suspension start date - Date when services were suspended
SuspendedEndDate date 20 √ null

Suspension end date - Date when suspension ends
Length varchar 50 √ null

Session length - Duration of each service session
Frequency int 4 √ null

Service frequency - Frequency of service delivery
FrequencyUnit varchar 50 √ null

Frequency unit - Unit of measurement for frequency (weekly, monthly, etc.)
TotalSessionsAuthorized int 4 √ null

Total sessions authorized - Total number of sessions authorized
TotalCoVisitUnits int 4 √ null

Total co-visit units - Total number of co-visit units authorized
VisitsPerDay int 4 √ null

Visits per day - Number of visits allowed per day
IFSPID int 4 √ null

IFSP identifier - Individualized Family Service Plan identifier
IFSPSignedDate date 20 √ null

IFSP signed date - Date when the IFSP was signed
IFSPType varchar 50 √ null

IFSP type - Type of Individualized Family Service Plan
IFSPStatus varchar 50 √ null

IFSP status - Current status of the IFSP
IFSPStartDate date 20 √ null

IFSP start date - Start date of the IFSP
IFSPEndDate date 20 √ null

IFSP end date - End date of the IFSP
ExitDate date 20 √ null

Exit date - Date when the child exited the program
TherapistFirstName varchar 100 √ null

Therapist first name - First name of the assigned therapist
TherapistLastName varchar 100 √ null

Therapist last name - Last name of the assigned therapist
TherapistNPI varchar 20 √ null

Therapist NPI - National Provider Identifier of the therapist
ReferringProviderFirstName varchar 100 √ null

Referring provider first name - First name of the referring provider
ReferringProviderLastName varchar 100 √ null

Referring provider last name - Last name of the referring provider
ReferringProviderNPI varchar 20 √ null

Referring provider NPI - National Provider Identifier of the referring provider
LastSessionDate date 20 √ null

Last session date - Date of the most recent service session
NumberofMakeUpSessionsUnitsAuthorized int 4 √ null

Make-up sessions authorized - Number of make-up session units authorized
TotalMakeUpSessionsUnitsUsed int 4 √ null

Make-up sessions used - Total number of make-up session units used
NumberofRemainingUnitsSessions int 4 √ null

Remaining units/sessions - Number of remaining authorized units or sessions
fkFileID int 4 √ null

File reference - Links to import file record
ImportedDate datetime 16,3 √ null

Import date - Date and time when the record was imported
BillingFieldsDifferent bit 1 √ null

Billing fields different flag - Indicates if billing fields differ from existing data
DeletedDate datetime 16,3 √ null

Deletion date - Date when the record was marked as deleted
TotalSessionsUsed int 4 √ null

Total sessions used - Total number of sessions that have been used
MakeUpUnitsRemaining int 4 √ null

Make-up units remaining - Number of make-up units still available
CoVisitUnitsUsed int 4 √ null

Co-visit units used - Number of co-visit units that have been used
CoVisitUnitsRemaining int 4 √ null

Co-visit units remaining - Number of co-visit units still available
NotShowAuthOnTheNotFoundReport bit 1 √ null

Hide auth from not found report - Flag to exclude authorization from not found reports
NotShowCaseOnTheNotFoundReport bit 1 √ null

Hide case from not found report - Flag to exclude case from not found reports
RemovedAuthDate datetime 16,3 √ null

Authorization removal date - Date when authorization was removed from import
RemovedAuthBy int 4 √ null

Authorization removed by - UserID of person who removed the authorization
RemovedCaseDate datetime 16,3 √ null

Case removal date - Date when case was removed from import
RemovedCaseBy int 4 √ null

Case removed by - UserID of person who removed the case
ImportCaseStatus varchar 20 √ null

Import case status - Status of the case import process
ImportCase_ErrorMessage varchar 2147483647 √ null

Import case error message - Error message if case import failed

Relationships

Close relationships within degrees of separation