PowerSchool ERP Table: aesattend

The Load Aesop Attendance program imports the records from the Aesop export file into the PowerSchool ERP Aesop interface table (aesattend). The following table lists the fields in the aesattend table and provides the mapping and processing of the records in the Aesop export file.

Field Descriptions	Field Name	Format	Source (Aesop file, input field, etc.)
Employee Number	empl_no	INTEGER	Worked Identification number
Pay Code	pay_code	CHAR(3)	If first 3 characters in Aesop file Field 10 - Entitlement Description are numeric, use Aesop file Field 10. If first 3 characters are not numeric, use first 3 characters of Aesop file Field 22 - External Absence Entitlement Code. If resulting pay code is not numeric, use value in Aesop file Field 10 - Entitlement Description to look up the absence pay code in the Aesop Pay Code Crosswalk reference table.
Start Date	start_date	DATE	Aesop file Field 11 - Absence Date
End Date	end_date	DATE	Aesop file Field 11 - Absence Date
Leave hours (units)	lv_hrs	DECIMAL(8,4)	Start with Aesop file Field 24 - Absence Duration; if the value is > 5, then set to 1.0; if the value > 0, set to.5; otherwise, set to 0. A custom processing option is available to use Aesop file Field 15 - Shift Number of Days. Contact PowerSchool to implement this option. (Note: earlier versions used start and end timesand various conversion methods.)
Remarks	remarks	CHAR(21)	Text “AESOP #” plus Aesop file Field 1 - Absence Confirmation Number Custom option available to use Aesop file Field 22 -Entitlement Description. Contact PowerSchool to implement this option.
Check Date	check_date	DATE	NULL
Status Flag	status_flg	CHAR(1)	Set to “A” (Add)
Leave Code	lv_code	CHAR(1)	Select paytable.lv_add[1,1] for Pay Code
Pay Run	pay_run	CHAR(3)	NULL
Post Flag (attendance)	post_flag	CHAR(1)	Set to “U” (Unposted)
Substitute Employee Number	sub_id	INTEGER	Aesop file Field 7 - Substitute ID Number
Substitute Pay Code	sub_pay_code	CHAR(3)	Select payrate.pay_cd from substitute’s primary pay rate
Substitute Pay Class	sub_pay_class	CHAR(4)	Select payrate.classify from substitute’s primary pay rate
Substitute Pay Hours	sub_hours	DECIMAL(8,4)	Start with Aesop file Field 23 - Substitute Hours (units) Worked;If the value is > 5, then set to 1.0; if the value > 0, set to.5; otherwise, set to 0. A custom processing option is available to use Aesop file Field 15 - Shift Number of Days. Contact PowerSchool to implement this option. (Note: Earlier versions used start and end times and various conversion formulas.)
Substitute Pay Rate	sub_pay_rate	DECIMAL(10,5)	Select payrate.rate from the substitute’s pay rate where the Class matches the Substitute Pay Class. If no match, select payrate.rate from substitute’s primary pay rate.
Substitute Pay Amount	sub_amt_paid	DECIMAL(10,2)	Calculated: sub_hours times sub_pay_rate
Substitute Location Code	sub_loc	CHAR(4)	Select person.location for absentee
Substitute Tax Indicator	sub_tax_ind	CHAR(1)	NULL
Substitute Budget Unit	sub_orgn	CHAR(16)	Default: NULL If Sub Budget Unit Mask is selected on the Load Aesop Attendance page: Start with distribution for the absentee’s primary pay rate and apply the masking rule defined in the Aesop Budget Unit and Account Mask reference table (aesmask) for the absence pay code. A custom processing option is available to use Aesop file Field 6 - Employee Budget External ID is used to set custom values for the sub organization. Contact PowerSchool to implement this option.
Substitute Account	sub_acct	CHAR(8)	Default: NULL If Sub Budget Unit Mask is selected on the Load Aesop Attendance page: Start with the distribution for the absentee’s primary pay rate and apply the masking rule defined in the Aesop Budget Unit and Account Mask reference table (aesmask) for the absence pay code. A custom processing option is available for using Aesop file Field 6 - Employee Budget External ID to set custom values for the sub account code. Contact PowerSchool to implement this option.
Calendar Validated	cal_val	CHAR(1)	“Y” if Check Calendar is selected on the Load Aesop Attendance page; otherwise, “N”
Aesop ID	aes_id	CHAR(1)	Aesop file Field 1 - Absence Confirmation Number
Aesop Post Flag	aes_post_flag	CHAR(1)	“Y” for records that are error free and will be posted when running the Post option; otherwise, “N” for records with errors that will not be posted
Aesop Run Number	aes_run	CHAR(4)	Run Number on Load Aesop Attendance page.