Specs for 4408 AVLs
School Age AVL FILE SPECS
4408 - Summer
11/07/02
This is the file that is sent to districts participating in the Summer electronic AVL process. It is also the file that the districts return to SED to make their AVL claim. When SED sends this file to the districts, the file will contain one record for every service line printed on the paper AVL. When the file is returned to SED, the file should contain every record that was sent to the district. By processing this file with district’s own database of records, the district can fill in the fields that SED needs to process your claims. These fields begin with AVL-RET-. After these fields are filled in, this file can be returned to SED. All fields not updated by the district should be returned to SED with the same values that were sent to the district. (Note: If you fill in AVL-RET-VERIFICATION with "N" (meaning you’re not claiming the record), then no other AVL-RET- fields need be filled in.
- AVL-CSE - 12 character code value for your district.
- AVL-REF-NUM - This is the AVL’s reference number. The first two characters will = the beginning school year of the AVL, and the last two characters will = the number of the AVL. For example, the third AVL form the 1997-98 school year would have a reference number of "9703".
- AVL-SERVICE-ID - The first six characters of this 10 character field are the STAC_ID, a numeric, unique ID assigned to each child in the STAC system. Each child should have only 1 STAC-ID throughout his/her entire STAC history. The next two characters (columns 9-10) represent the Record-Number. This 2 digit numeric field along with the STAC-ID and School-Year uniquely identify a service. The last two characters (columns 11-12) represent the Amendment-Number. A service may have several amendments, each one representing a change in the service record. We only deal with the most current amendment.
- AVL-LAST - Last-Name consist of alpha characters only. No numbers, special characters or imbedded spaces are allowed.
- AVL-FIRST - First-Name consist of alpha characters only. No numbers, special characters or imbedded spaces are allowed.
- AVL-MI - Middle Initial consist of alpha characters only. No numbers, special characters or imbedded spaces are allowed.
- AVL-PROVIDER - This is SED’s 12 character Provider-Code. This code can be found on SED’s Program-File (aka Agency-File) which can downloaded from STAC’s web site at http://stacnt5.nysed.gov/stacunit/viewdata.htm.
- AVL-PROGRAM-CODE - The program code will consist of 2 characters for the 1995-96 and prior school years, and 4 characters for the 1996-97 and after school years.
- AVL-STAC-CODE - This one character code is used for the 1996-97 school years and after. Along with AVL-PROVIDER and AVL-PROGRAM-CODE, it will uniquely identify programs on SED’s Program-File.
- AVL-CD-RDCNTY - County of Residence.
- AVL-ICF-IRA - Leave as spaces. A 12 digit ICF/IRA code. For Chapters use only.
- AVL-AUTHORIZATION - Leave as spaces. For Chapters use only.
- AVL-ISPEC - A five character code representing the type Service. For Summer AVLS, this field will = "HSUMR" (summer school), "HSSRL" (summer school related services) or "HSSOS" (summer school state supported/state operated)
- AVL-TYP-FUND - A five character field indicating the fund source of the service. This field will = (4408 ).
- AVL-SERV-TYPE - Four character code representing the type of service. EDUC = Education, MAIN = Maintenance, TRAN = transportation.
- AVL-FROM-DATE - Begin Service date in CCYYMMDD format.
- AVL-TO-DATE - End Service date in CCYYMMDD format
- AVL-FTE - Full time Equivalence. Cannot exceed 1, goes to 3 decimal places. Calculated by dividing the Number-Of-Weeks of Service attended by the total weeks of the program. Contact the STAC unit or check out STAC’s WEB site for details as to how the number of weeks are calculated. (For related services this field will = the number of sessions (as a whole number), and for maintenance this field will = the number of days (as a whole number)).
- AVL-APP-RATE - This is the rate for the full length of the program.
::### NOTE: AVL-PRO-COST may be updated by the district - but for Transportation only - AVL-PRO-COST - Prorated-Cost. FTE * Rate.
- AVL-YTD-PAID - Year-to-Date paid for the service at 100%.
- AVL-YTD-FTE - FTE claimed to date.
- AVL-YTD-SESS - Related-Service sessions claimed to date.
- AVL-AMT-AVAIL - Amount available for the district to claim on this AVL.
- AVL-ISSUE-DATE - This is the date that the AVL was generated in CCYYMMDD format.
- AVL-DATE-RETURN - This is the date (in CCYYMMDD format) by which the AVL must be returned to SED in order to be reimbursed for the payment cycle.
**************** FIELDS THAT THE DISTRICT MAY UPDATE ******************
- AVL-RET-VERIFICATION - enter "Y" if you are claiming payment for this service, otherwise enter an "N". For Withdraws/Recoups (AVL-RCP-WTHD-STATUS.= "R" or "W"), leave this field blank.
- AVL-RET-FROM-DATE - Enter either AVL-FROM-DATE (field # 16) or your modified From-Date. The date must be equal to or greater than the program From-Date. The date must be equal to or less than the AVL-RET-TO-DATE.
- AVL-RET-TO-DATE - Enter either AVL-TO-DATE (field # 17) or your modified To-Date. The date must be equal to or < than the program To-Date. The date must be equal to or greater than the AVL-RET-FROM-DATE.
- AVL-RET-SESSIONS - Enter number of sessions for Related Services. Enter number of days for maintenance. Must be whole numbers, no decimals.
- AVL-RET-RATE - Not used for Summer AVLs. Leave as zeros.
- AVL-RET-AMT-PAID - Not used for Summer AVLs. Leave as zeroes.
- AVL-RET-ICF-IRA-FLAG - Not used for Summer AVLs. Leave as spaces.
- AVL-RET-USERID - Required for all records returned. This eight character field must be a valid userid established with the STAC unit as the user responsible for this record. UserID is comprised of the first initial of the first name followed by the next seven characters of the last name. The corresponding AVL-CSE on this record must match the CSE-Code that the STAC unit has recorded for this UserID.
************************************************************************
- AVL-RCP-WTHD-STATUS - If the record has been withdrawn, this field will = a "W". If this transaction is a recoup (AVL-AMT-AVAIL is negative), then this field will = "R". Otherwise this field will be blank. For withdraws or Recoups, do not change any data on the record.
- AVL-PAGE - This will = the page number from the paper AVL.
- AVL-OCCURRENCE - This will = the occurrence that this service is printed on the page of the paper AVL.
- AVL-OUTSIDE-ID - If an outside agency’s ID is stored on the STAC system, then that value will be in this field.
- AVL-HALF-TIME-FLAG - Not applicable to Summer School, will = "N" .
- AVL-DATE-OF-BIRTH - Child’s Date of Birth in CCYYMMDD format.
- END-OF-REC-MARKER - Always = 0 (zero).