The Post Aesop Attendance option creates records in the attend table for each record in the aesattend table for the entered Aesop Run Number with a Post Flag = Y. Records created in the attend table are described in the table below. All records for the "posted" run number are deleted from the aesattend table, including records with errors that did not post.
|
Field Descriptions |
Field Name |
Format |
Source (aesattend table, input field, etc.) |
|---|---|---|---|
|
Employee Number |
empl_no |
INTEGER |
aesattend.empl_no |
|
Pay Code |
pay_code |
CHAR(3) |
aesattend.pay_code |
|
Start Date |
start_date |
DATE |
aesattend.start_date |
|
End Date |
stop_date |
DATE |
aesattend.end_date |
|
Leave hours (units) |
lv_hrs |
DECIMAL(8,4) |
aesattend.lv_hrs |
|
Remarks |
remarks |
CHAR(21) |
aesattend.remarks |
|
Check Date |
check_date |
DATE |
aesattend.check_date |
|
Status Flag |
status_flg |
CHAR(1) |
aesattend.status_flg |
|
Leave Code |
lv_code |
CHAR(1) |
aesattend.lv_code |
|
Pay Run |
pay_run |
CHAR(3) |
Aesop Run Number on Post page |
|
Post Flag (attendance) |
post_flg |
CHAR(1) |
aesattend.post_flg (Y or N) |
|
Substitute Employee Number |
sub_id |
INTEGER |
aesattend.sub_id |
|
Substitute Pay Code |
sub_pay_code |
CHAR(3) |
aesattend.sub_pay_code |
|
Substitute Pay Class |
sub_pay_class |
CHAR(4) |
aesattend. sub_pay_class |
|
Substitute Pay Rate |
sub_pay_rate |
DECIMAL(10,5) |
aesattend. sub_pay_rate |
|
Substitute Pay Amount |
sub_amt_paid |
DECIMAL(10,2) |
aesattend. sub_amt_paid |
|
Substitute Location Code |
sub_loc |
CHAR(4) |
aesattend. sub_loc |
|
Substitute Tax Indicator |
sub_tax_ind |
CHAR(1) |
aesattend. sub_tax_ind |
|
Substitute Budget Unit |
sub_orgn |
CHAR(16) |
aesattend. sub_orgn |
|
Substitute Account |
sub_acct |
CHAR(8) |
aesattend. sub_acct |
|
Calendar Validated |
cal_val |
CHAR(1) |
Y or N |
|
Row Id |
row_id |
INTEGER |
System generated |
|
Start Date |
sub_start |
DATE |
aesattend.start_date |
|
End Date |
sub_stop |
DATE |
aesattend.end_date |
|
Substitute Pay Hours (units) |
sub_hrs |
DECIMAL(8,4) |
aesattend.sub_hours |