Skip to main content
Skip table of contents

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







 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.