Substitute Management System Flat File Formats

SFE/SFE3

SmartFindExpress 
Use SFE for pre-1.3 version of SFE clients. Use SFE3 for version 1.3 and above.
PYHR/SUBCNTRL: Value: SFE or SFE3
Record Length: 979 (SFE) or 990 (SFE3)

Format Details

The only difference between the SFE (pre-1.3) and SFE3 (1.3 and beyond) formats is the addition of elements 56 and 57 (see below). 

AESOP/AESOPID

Automated Educational Substitute Operator Program by Frontline Placement Technologies. The difference between AESOP and AESOPID is where it gets the Abs and Sub IDs:

• AESOP:
• Absentee ID comes from characters 9,17
• Substitute ID comes from characters 168,176
• AESOPID:
• Absentee ID comes from characters 736,755
• Substitute ID comes from characters 716,735

PYHR/SUBCNTRL: Value: AESOP or AESOPID
Record Length: 1517

Format Details

AESOP07/AESOP07ID

Newest AESOP Format. Automated Educational Substitute Operator Program by Frontline Education. The difference between AESOP and AESOPID is where it gets the Abs and Sub IDs:

• AESOP07:
• Absentee ID comes from characters 9,17
• Substitute ID comes from characters 168,176
• AESOP07ID:
• Absentee ID comes from characters 736,755
• Substitute ID comes from characters 716,735

PYHR/SUBCNTRL: Value: AESOP07 or AESOP07ID
Record Length: 1517

Fields Used by STUTLF

• Absence Date 313, 320
• Abs & Sub import IDs. If common code PYHR/SUBCNTRL Associated Code 05 (format) has "AESOP07ID":

Absid = 736, 755
SubId = 716, 735
else
Absid = 9, 17
SubId = 168, 176
end if

• Abs and Sub Hours. Based on common code PYHR/AESOPHR, Assoc Value 01:

//Option 1: (Default) Calculate Hours
If Assoc Value 01 set to 1:
start time = 299, 303
end time = 304, 308
Both AbsHours and SubsHours = end - start;
//Option 2: Get Days instead of hours
If Assoc Value 01 set to 2:
Both AbsHours and SubHours come from 380, 382
They represent days, not hours
//Option 3: Use Abs and Sub Hours from file
AbsHours = 1059, 1064
SubHours = 1488, 1491
If common code not set up or set up with something other than 1,2,3 in Assoc value 01:
//Option 1: (Default) Calculate Hours
If Assoc Value 01 set to 1:
start = 299, 303
end = 304, 308
Both AbsHours and SubHours = end - start;

• Account = 388, 417
• AbsRate = 1480, 1487
• Rate = 1464, 1471
• Reason = 972, 977
• Site = 383, 387
• AbsMisc1 = 88, 117
• AbsMisc2 = 864, 893
• Position = 796, 825
• JobID is a sequential number generated by the import
• Datasource = "AESOP07"

Format Details