Table Name | AEICF |
Long Name | Service Locations |
Description | This file contains basic information regarding the unique relationship of a given service provider within a building to a particular class or service. There can be more than one service provider associated to a given class or service and these are differentiated by staff type in the AEAIF. Once all service providers are brought together in the AEICF, actual program costs can be described for each class or service. |
Prefix | IC |
Field Name | Length | Type | Description | Comments |
---|---|---|---|---|
ic_attbldg | 4 | char | Attending Building | |
ic_attdist | 4 | char | Attending District | |
ic_stdate | 10 | char | Service Start Date | |
ic_pgid | 3 | char | Service ID | |
ic_pgseq | 2 | char | Service Sequence Number | |
ic_actcost | 9 | decimal | Actual Program Cost | this is a plase for alot of text |
ic_enddate | 8 | datetime | End Date | |
ic_classft | 5 | decimal | Class FTE | |
ic_actdis | 5 | decimal | Service Disability Type | |
ic_fundsrc | 3 | char | Funding Source | |
ic_aidfte | 5 | decimal | Associate Full Time Equivalency | |
ic_spndist | 4 | char | Sponsor District | |
ic_udate | 8 | datetime | Record Updated (Date) | |
ic_utime | 8 | char | Record Updated (Time) | |
ic_uid | 9 | char | Record Updated (User ID) | |
ic_limit | 5 | decimal | Class Size Limit | |
ic_type | 1 | char | Service Type | |
ic_comment | 254 | char | Comments | |
ic_region | 4 | char | Region | |
ic_keyicf | 10 | char | AEICF KEY | |
ic_staff | 10 | char | ||
ic_ectp | 10 | char | Early Childhood Type of Program | |
ic_dhspn | 10 | char |