general:import_external_file

This utility is for districts that update data in State Reporting tables from a text flat file created outside ASCENDER. Each row in the file corresponds to a PEIMS record.

The only record types available for importing are:

Organization-District (010) (10010 - LocalEducationAgencyExtension complex type)
Organization-Campus (020) (10020 - SchoolExtension complex type)
Finance-Budget (030) (20030 - BudgetExtension complex type)
Finance-Actual (032) (20032 - ActualExtension complex type)
Finance-SSA Actual (033) (20033 - SharedServiceArrangementExtension complex type)

All other records are skipped.

File layout

010 Records (10010 - LocalEducationAgencyExtension Complex Type):

Record Type Code	District ID	District Name	blank	Total Num School Board Requests	Total Cost School Board Requests	ARMED-SERVICES-VOC-APT-BATTERY-INDICATOR-CODE	Filler
E0755	E0212	E0213		E1556	E1557	E1625
C042				C200		C217
Cols 1-3	Cols 4-9	Cols 10-43	Cols 44-62	Cols 63-65	Cols 66-71	Cols 72-73	Cols 74-80

020 Records (10020 - SchoolExtension Complex Type):

Input Record Type Code	District/Campus ID	Campus Name	blank	NSLP Code	Bullying Incidents	Cyberbullying Incidents
E0755	E0266	E0267		E1591	E1727	E1728
C042				C212
Cols 1-3	Cols 4-12	Cols 13-46	Cols 47-65	Cols 66-67	Cols 69-73	Cols 74-78

030 Records (20030 - BudgetExtension Complex Type):

Input Record Type Code	District ID	Fund Code	Function Code	Object Code	Organization Code	Fiscal Year	Program Intent Code	Budget Amount	Filler
E0755	E0212	E0316	E0317	E0318	E0319	E0974	E0320	E0321
C042		C145	C146	C159			C147
Cols 1-3	Cols 4-9	Cols 10-12	Cols 13-14	Cols 15-18	Cols 19-21	Col 22	Cols 23-24	Cols 25-35	Cols 36-80

032 Records (20032 - ActualExtension Complex Type):

Input Record Type Code	District ID	Fund Code	Function Code	Object Code	Organization Code	Fiscal Year	Program Intent Code	Actual Amount	Filler
E0755	E0212	E0316	E0317	E0318	E0319	E0974	E0320	E0774
C042		C145	C146	C159			C147
Cols 1-3	Cols 4-9	Cols 10-12	Cols 13-14	Cols 15-18	Cols 19-21	Col 22	Cols 23-24	Cols 25-35	Cols 36-80

033 Records (20033 - SharedServiceArrangementExtension Complex Type):

Input Record Type Code	District ID	Shared Svcs Arr Member Dist ID	Shared-Svcs-Arrangemt-Type-Code	Fund Code	Fiscal Year	Actual Amount	Filler
E0755	E0212	E0981	E0776	E0316	E0974	E0774
C042			C049	C145
Cols 1-3	Cols 4-9	Cols 10-15	Cols 16-17	Cols 18-20	Col 21	Cols 22-32	Cols 33-80