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
