The Aesop application produces the file format described in this section. While the Load Aesop Attendance page provides a choice of file formats, the recommended file format is pipe-delimited. For information about other file formats, contact PowerSchool. The Aesop delimited export file should have the following characteristics:
-
Fields are terminated by the pipe (or comma) delimiter.
-
Blank or empty fields are represented by inserting the chosen delimited. No space exists between the delimiters that represent the blank field.
-
Decimal points in fields defined as decimal in type are explicit.
-
Integer fields can contain digits only.
-
A leading negative sign indicates negative values.
-
Dates must be formatted MM/DD/YYYY.
The standard fields in the Aesop export file are listed in the table below. For information on fields available for custom processing, contact PowerSchool.
|
Aesop Export Fields |
PowerSchool ERP Program Record Fields |
Field Order |
Format |
Notes |
|---|---|---|---|---|
|
Absence confirmation number |
abs_confrm_no |
1 |
CHAR(9) |
New field length = 9 |
|
Worker identification number |
empl_no |
2 |
INTEGER(9) |
Employee Number |
|
Worker first name |
empl_fname |
3 |
CHAR(30) |
First name |
|
Worker last name |
empl_lname |
4 |
CHAR(30) |
Last Name |
|
Worker type description |
empl_desc |
5 |
CHAR(30) |
Not used by standard program. Various custom uses to determine absence hours and sub units worked. |
|
Employee budget external ID |
empl_bud_code |
6 |
CHAR(30) |
Not used by standard program. Various custom uses for setting sub_orgn and acct. |
|
Substitute ID number |
sub_id |
7 |
INTEGER(9) |
Substitute employee number |
|
Substitute first name |
sub_fname |
8 |
CHAR(30) |
First name |
|
Substitute last name |
sub_lname |
9 |
CHAR(30) |
Last name |
|
Entitlement description |
pay_code, lev_desc |
10 |
CHAR(3)/(20) |
Aesop leave description |
|
Absence start time |
abs_strt_time |
11 |
HH:MM |
Not used |
|
Absence end time |
abs_end_time |
12 |
HH:MM |
Not used |
|
Absence date |
abs_date |
13 |
MM/DD/YYYY |
Date absence |
|
Shift description |
shift_desc |
14 |
CHAR(30) |
Not used; available for site custom |
|
Shift number of days |
shift_no_days |
15 |
CHAR(3) |
Not used; available for site custom |
|
School number |
school_no |
16 |
CHAR(5) |
Not used; available for site custom |
|
Substitute budget code |
sub_bud_code |
17 |
CHAR(30) |
Not used; available for site custom |
|
Substitute budget description |
sub_bud_desc |
18 |
CHAR(30) |
Not used; available for site custom |
|
User-defined |
abs_notes |
19 |
CHAR(255) |
Not used; available for site custom |
|
Substitute pay code |
sub_paycode |
20 |
CHAR(20) |
Not used; available for site custom |
|
Substitute full day pay rate (extended) |
sub_payrate |
21 |
DEC(999.999) |
Not used; available for site custom |
|
External absence entitlement code (alternate pay code) |
absence code |
22 |
CHAR(3) |
Program reads the first 3 characters of Aesop file Field – 22 if Field 10 is not numeric |
|
Substitute hours worked from absence record |
sub_hours_worked |
23 |
DEC(99.99) |
|
|
Absence duration calculation |
abs_duration |
24 |
DEC(99.999) |
|