Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| SubmittedData_pkID | int identity | 4 | √ | null |
|
|
Submitted data primary key - Unique auto-incrementing identifier for each submitted data record |
|
| pk_ID | int | 4 | null |
|
|
Primary key reference - Links to the primary Import_EIHUB table record |
||
| BillingProvider | varchar | 255 | √ | null |
|
|
Billing provider - Name of the provider responsible for billing |
|
| EIPProviderID | int | 4 | √ | null |
|
|
EI provider identifier - Early Intervention provider ID in the external system |
|
| EIChildID | int | 4 | √ | null |
|
|
EI child identifier - Early Intervention child ID in the external system |
|
| ChildFirstName | varchar | 100 | √ | null |
|
|
Child first name - First name of the child receiving early intervention 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 |
|
|
Child date of birth - Date of birth of the child receiving services |
|
| 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 will age 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 program |
|
| EnrollmentStatus | varchar | 50 | √ | null |
|
|
Enrollment status - Current status of enrollment |
|
| AuthorizationNumber | varchar | 50 | √ | null |
|
|
Authorization number - Authorization number for services |
|
| StartDate | date | 20 | √ | null |
|
|
Service start date - Start date of authorized services |
|
| EndDate | date | 20 | √ | null |
|
|
Service end date - End date of authorized services |
|
| LocationType | varchar | 100 | √ | null |
|
|
Service location type - Type of location where services are provided |
|
| SuspendedStartDate | date | 20 | √ | null |
|
|
Suspension start date - Start date of service suspension if applicable |
|
| SuspendedEndDate | date | 20 | √ | null |
|
|
Suspension end date - End date of service suspension if applicable |
|
| Length | varchar | 50 | √ | null |
|
|
Session length - Duration of individual service sessions |
|
| Frequency | int | 4 | √ | null |
|
|
Service frequency - Frequency of service delivery |
|
| FrequencyUnit | varchar | 50 | √ | null |
|
|
Frequency unit - Unit of measurement for service 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 - Maximum number of visits allowed per day |
|
| IFSPID | int | 4 | √ | null |
|
|
IFSP identifier - Individualized Family Service Plan ID |
|
| 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 |
|
|
Program 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 provider who made the referral |
|
| ReferringProviderLastName | varchar | 100 | √ | null |
|
|
Referring provider last name - Last name of the provider who made the referral |
|
| 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 sessions/units authorized |
|
| TotalMakeUpSessionsUnitsUsed | int | 4 | √ | null |
|
|
Make-up sessions used - Total number of make-up sessions/units used |
|
| NumberofRemainingUnitsSessions | int | 4 | √ | null |
|
|
Remaining units/sessions - Number of remaining authorized units or sessions |
|
| fkFileID | int | 4 | √ | null |
|
|
File reference - Links to the import file that contained this data |
|
| ImportedDate | datetime | 16,3 | √ | null |
|
|
Import date - Date when this data was imported into the system |
|
| 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 this 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 |
|
| ProgramName | varchar | 2147483647 | √ | null |
|
|
Program name - Full name of the early intervention program |
|
| CaseStatus | varchar | 20 | √ | null |
|
|
Case status - Current status of the case |
|
| NumOfMinute | int | 4 | √ | null |
|
|
Number of minutes - Duration in minutes for sessions |
|
| ModifierId | varchar | 100 | √ | null |
|
|
Modifier identifier - Identifier for service modifiers |
|
| Weeks | varchar | 100 | √ | null |
|
|
Weeks - Number of weeks for service delivery |
|
| Comments | varchar | 100 | √ | null |
|
|
Comments - Additional comments about the submitted data |
|
| SessionType | varchar | 100 | √ | null |
|
|
Session type - Type of service session |
|
| fkImportedId | int | 4 | √ | null |
|
|
Imported record reference - Links to the imported record in the system |
Relationships
Close relationships within degrees of separation
