Absence System
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Absence or Authority Location |
ABSENCES |
ABS_OR_AUTH_LOC_CODE |
This field allows users to select and/or display either the absence or absence or authorizer location. *The same report can be used for both authorizer and absence locations. Size: 4 |
|
Absence or Authority Location |
ABSENCES |
ABS_OR_AUTH_LOC_NAME |
A detailed explanation of the absence location or authorizing absence location Size: 30 |
|
Authorizer Location |
ABSENCES |
AUTH_LOCATION |
Size: 10 |
|
Authorizer Location Name |
ABSENCES |
AUTH_LOCATION_NAME |
Size: 30 |
|
Date of Absence |
ABSENCES |
ABSENCE_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
Days of the absence |
ABSENCES |
DAYS |
Size: 10 Format: ######.#### |
|
Hours of the absence |
ABSENCES |
HOURS |
Size: 10 Format: ######.#### |
|
Leave Application Comment |
ABSENCES |
LEAVE_APPLICATION_COMMENT |
Size: 50 |
|
Leave Approval Comment |
ABSENCES |
LEAVE_APPROVAL_COMMENT |
Size: 80 |
|
Location Code of Absence |
ABSENCES |
LOCATION |
Size: 4 |
|
Location Type Description |
ABSENCES |
LOCATION_TYPE_DESC |
i.e. A=Adult Education, E=Elementary, etc. Size: 30 |
|
Name of Customer |
ABSENCES |
CUSTOMER_NO |
Size: 50 |
|
Name of Location |
ABSENCES |
LOCATION_NAME |
Detailed Explanation of code. Size: 30 |
|
Payroll ID |
ABSENCES |
PAYROLL_ID |
i.e. TEAC, SUPP, SUBS, TOC, CASU Size: 6 |
|
Sub-Ledger Account Number |
ABSENCES |
SL_ACCT_NO |
Size: 10 |
|
Total Absences for Locations with Type A |
ABSENCES |
LOC_TYPE_A_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type B |
ABSENCES |
LOC_TYPE_B_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type C |
ABSENCES |
LOC_TYPE_C_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type D |
ABSENCES |
LOC_TYPE_D_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type E |
ABSENCES |
LOC_TYPE_E_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type F |
ABSENCES |
LOC_TYPE_F_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type G |
ABSENCES |
LOC_TYPE_G_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type H |
ABSENCES |
LOC_TYPE_H_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type I |
ABSENCES |
LOC_TYPE_I_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type J |
ABSENCES |
LOC_TYPE_J_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type K |
ABSENCES |
LOC_TYPE_K_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type L |
ABSENCES |
LOC_TYPE_L_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type M |
ABSENCES |
LOC_TYPE_M_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type N |
ABSENCES |
LOC_TYPE_N_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type O |
ABSENCES |
LOC_TYPE_O_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type P |
ABSENCES |
LOC_TYPE_P_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type Q |
ABSENCES |
LOC_TYPE_Q_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type R |
ABSENCES |
LOC_TYPE_R_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type S |
ABSENCES |
LOC_TYPE_S_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type T |
ABSENCES |
LOC_TYPE_T_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type U |
ABSENCES |
LOC_TYPE_U_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type V |
ABSENCES |
LOC_TYPE_V_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type W |
ABSENCES |
LOC_TYPE_W_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type X |
ABSENCES |
LOC_TYPE_X_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type Y |
ABSENCES |
LOC_TYPE_Y_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences for Locations with Type Z |
ABSENCES |
LOC_TYPE_Z_ABSENCES |
Location Type Codes that are created within the database (10,1,3,19) will be represented for selection in this data table Size: 5 Format: #########.# |
|
Total Absences in April |
ABSENCES |
APRIL_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in August |
ABSENCES |
AUGUST_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in December |
ABSENCES |
DECEMBER_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in February |
ABSENCES |
FEBRUARY_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in January |
ABSENCES |
JANUARY_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in July |
ABSENCES |
JULY_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in June |
ABSENCES |
JUNE_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in March |
ABSENCES |
MARCH_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in May |
ABSENCES |
MAY_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in November |
ABSENCES |
NOVEMBER_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in October |
ABSENCES |
OCTOBER_ABSENCES |
Size: 5 Format: #########.# |
|
Total Absences in September |
ABSENCES |
SEPTEMBER_ABSENCES |
Size: 5 Format: #########.# |
|
Type of Location |
ABSENCES |
LOCATION_TYPE |
i.e. A=Adult Education, E=Elementary, etc. Size: 8 |
|
Type of employee |
ABSENCES |
HOURS_OR_FTE |
Internal Lookup: H=Hours, F=F.T.E. Based on the type of employee the absence will display hours or FTE Size: 10 |
|
Was Absence Date filled? |
ABSENCES |
IS_ABSENCE_DATE_FILLED_YN |
Internal Lookup: Y=Yes, N=No, Size: 10 |
|
Week Ending Date |
ABSENCES |
AUTH_WEEK_END_DATE |
Week-ending date used in the Attendance Management System/atrieveAttendance Size: 12 Format: DD-MMM-YYYY |
|
Will report on all employees (with or without absences) when selection on main absence/detail fields i.e. absence code, position, location (HR_ABSENCE_DETAIL or HR_DISPATCH_DETAIL). |
ABSENCES |
ABSENCE_DATE_(NO_ABSENCES) |
This only works if you select the ABSENCE_DATE (NO_ABSENCES) or DISPATCH_DATE (NO_DISPATCHES) options. Also, this will only work if you use the SELECTION as opposed to RANGE option. Size: 11 Format: DD-MMM-YYYY |
|
Year of absence |
ABSENCES |
ABSENCE_YEAR |
Size: 4 |
Abs/Dis Authorization
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
01=Location |
LOCATION_AUTHORIZER |
LOCATION_NAME |
Detailed Explanation of code. Size: 30 |
|
01=Location |
LOCATION_AUTHORIZER |
LOCATION_NO |
Size: 10 |
|
04=Authorizer |
LOCATION_AUTHORIZER |
AUTHORIZER_CODE |
Size: 10 |
|
04=Authorizer |
LOCATION_AUTHORIZER |
AUTHORIZER_CODE_DESC |
Detailed Explanation of code. Size: 30 |
Absence Information
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
02=Abs Code |
ABSENCES |
ABSENCE_CODE |
Size: 4 |
|
02=Abs Code |
ABSENCES |
ABSENCE_CODE_DESC |
Detailed Explanation of code. Size: 30 |
|
04=Need Rep |
ABSENCES |
NEED_REPLACEMENT |
Internal Lookup: Y=Yes, N=No, Size: 8 |
Absence and Dispatches
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
01=Employee |
ABSENCES_AND_DISPATCHES |
ABS_EMPLOYEE_NAME |
Size: 30 |
|
01=Employee (Name and Number) |
ABSENCES_AND_DISPATCHES |
ABS_EMP_NAME_AND_NO |
Size: 30 |
|
02=Abs Code |
ABSENCES_AND_DISPATCHES |
ABS_ABSENCE_CODE |
Size: 4 |
|
02=Abs Code |
ABSENCES_AND_DISPATCHES |
ABS_ABSENCE_CODE_DESC |
Detailed Explanation of code. Size: 30 |
|
02=Employee |
ABSENCES_AND_DISPATCHES |
ABS_EMPLOYEE_NO |
This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
|
03=Comment |
ABSENCES_AND_DISPATCHES |
ABS_COMMENT |
Size: 30 |
|
06=Start Date |
ABSENCES_AND_DISPATCHES |
ABS_START_TIME |
Size: 5 |
|
07=End Date |
ABSENCES_AND_DISPATCHES |
ABS_END_TIME |
Size: 5 |
|
13=GL |
ABSENCES_AND_DISPATCHES |
ABS_GL |
Size: 20 |
|
15=Position |
ABSENCES_AND_DISPATCHES |
ABS_POSITION_CODE |
Size: 8 |
|
15=Position |
ABSENCES_AND_DISPATCHES |
ABS_POSITION_DESC |
Detailed Explanation of code. Size: 30 |
|
18=Tentative |
ABSENCES_AND_DISPATCHES |
ABS_TENTATIVE |
Internal Lookup: Y=Yes, N=No, Size: 3 |
|
ADS Absence ID |
ABSENCES_AND_DISPATCHES |
ABSENCE_ID |
Size: 10 |
|
Total Hours: |
ABSENCES_AND_DISPATCHES |
ABS_HOURS |
Size: 10 Format: ########.## |
Absence and Dispatches - Rep Abs
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Dispatch Absence |
ABSENCES_AND_DISPATCHES |
DIS_ABSENCE_YN |
Yes/No Size: 3 |
|
Pay Code |
ABSENCES_AND_DISPATCHES |
DIS_ABSENCE_PAYCODE |
Size: 2 |
Employee Location
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
End Date (08,11,14,17,20,23) |
JOB_SHARE |
END_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
Job Share Partners (06,09,12,15,18,21) |
JOB_SHARE |
JOB_SHARE_EMPLOYEE_NAME |
Detailed Explanation of code. Size: 30 |
|
Job Share Partners (06,09,12,15,18,21) |
JOB_SHARE |
JOB_SHARE_EMPLOYEE_NO |
This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
|
Start Date (07,10,13,16,19,22) |
JOB_SHARE |
START_DATE |
Size: 11 Format: DD-MMM-YYYY |
Entitlements
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
01=Employee |
ENTITLEMENTS |
*EMPLOYEE_NO |
This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
|
01=Employee No |
ENTITLEMENTS |
*EMPLOYEE_NO |
This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 |
|
02=Absence Code |
ENTITLEMENTS |
ABSENCE_CODE |
Size: 10 |
|
02=Absence Code |
ENTITLEMENTS |
ABSENCE_CODE_DESC |
Detailed Explanation of code. Size: 30 |
|
03=Year Code |
ENTITLEMENTS |
*VAC_YEAR |
Size: 6 |
|
03=Year Code |
ENTITLEMENTS |
YEAR |
Size: 6 |
|
04=Table Units |
ENTITLEMENTS |
TABLE_UNITS_01 |
Size: 10 Format: ######.#### |
|
05=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_01 |
Size: 10 Format: ######.#### |
|
06=Table Units |
ENTITLEMENTS |
TABLE_UNITS_02 |
Size: 10 Format: ######.#### |
|
07=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_02 |
Size: 10 Format: ######.#### |
|
08=Table Units |
ENTITLEMENTS |
TABLE_UNITS_03 |
Size: 10 Format: ######.#### |
|
11=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_04 |
Size: 10 Format: ######.#### |
|
12=Table Units |
ENTITLEMENTS |
TABLE_UNITS_05 |
Size: 10 Format: ######.#### |
|
13=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_05 |
Size: 10 Format: ######.#### |
|
14=Table Units |
ENTITLEMENTS |
TABLE_UNITS_06 |
Size: 10 Format: ######.#### |
|
15=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_06 |
Size: 10 Format: ######.#### |
|
16=Table Units |
ENTITLEMENTS |
TABLE_UNITS_07 |
Size: 10 Format: ######.#### |
|
17=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_07 |
Size: 10 Format: ######.#### |
|
18=Table Units |
ENTITLEMENTS |
TABLE_UNITS_08 |
Size: 10 Format: ######.#### |
|
19=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_08 |
Size: 10 Format: ######.#### |
|
20=Table Units |
ENTITLEMENTS |
TABLE_UNITS_09 |
Size: 10 Format: ######.#### |
|
21=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_09 |
Size: 10 Format: ######.#### |
|
22=Table Units |
ENTITLEMENTS |
TABLE_UNITS_10 |
Size: 10 Format: ######.#### |
|
23=Entitlements |
ENTITLEMENTS |
ENTITLEMENT_10 |
Size: 10 Format: ######.#### |
|
24=Carry |
ENTITLEMENTS |
CARRY_FORWARD_AMOUNT |
Size: 10 Format: ######.#### |
|
25=Used |
ENTITLEMENTS |
DAYS_USED |
Size: 10 Format: ######.#### |
|
Amount Paid Out |
ENTITLEMENTS |
PAID_OUT_AMOUNT |
Size: 10 Format: ######.#### |
|
From Date |
ENTITLEMENTS |
VAC_FROM_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
Prior or Next Date |
ENTITLEMENTS |
VAC_PRIOR_OR_NEXT_YEAR |
Size: 10 |
|
Remaining |
ENTITLEMENTS |
CARRY_OVER_AMOUNT |
Size: 10 Format: ######.#### |
|
To Date |
ENTITLEMENTS |
VAC_TO_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
Vacation Advance |
ENTITLEMENTS |
VAC_ADVANCE_OR_CONT |
Size: 10 |
|
Vacation Days |
ENTITLEMENTS |
VAC_DAY_AMOUNT |
Size: 10 Format: ########.## |
|
Vacation Dollar Amount |
ENTITLEMENTS |
VAC_DOLLARS |
Size: 10 Format: ########.## |
Timesheet Entry
|
Field in atrieveERP |
Report Writer Table |
Report Writer Field |
Field Information |
|---|---|---|---|
|
Authorizing Location |
EMPLOYEE_TIMESHEET |
AUTH_LOC_CODE |
Size: 4 |
|
Authorizing Location Name |
EMPLOYEE_TIMESHEET |
AUTH_LOC_NAME |
Size: 30 |
|
Authorizing User |
EMPLOYEE_TIMESHEET |
AUTH_USER_NO |
Size: 10 |
|
Comment |
EMPLOYEE_TIMESHEET |
COMMENT |
Size: 80 |
|
Comment |
EMPLOYEE_TIMESHEET |
SYSTEM_COMMENT |
Size: 80 |
|
Date when timesheet submitted |
EMPLOYEE_TIMESHEET |
TIMESTAMP_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
Entry Approved |
EMPLOYEE_TIMESHEET |
ENTRY_APPROVED_YN |
By Authorizing User Size: 8 |
|
Entry Date of Timesheet |
EMPLOYEE_TIMESHEET |
ENTRY_DATE |
Size: 11 Format: DD-MMM-YYYY |
|
Inactive? |
EMPLOYEE_TIMESHEET |
SOFT_DELETED_YN |
Size: 3 |
|
Location Code |
EMPLOYEE_TIMESHEET |
LOCATION_CODE |
Size: 4 |
|
Name of Location |
EMPLOYEE_TIMESHEET |
LOCATION_NAME |
Size: 30 |
|
Number of Hours Worked |
EMPLOYEE_TIMESHEET |
HOURS_WORKED |
Size: 10 Format: ########.## |
|
Pay Batch Number |
EMPLOYEE_TIMESHEET |
PAY_BATCH_NO |
Size: 15 |
|
Pay Period |
EMPLOYEE_TIMESHEET |
PAY_PERIOD |
Size: 8 |
|
Payroll Category |
EMPLOYEE_TIMESHEET |
PAY_CATEGORY_CODE |
Size: 10 |
|
Payroll ID |
EMPLOYEE_TIMESHEET |
PAYROLL_ID |
i.e. TEAC/SUPP/CASU/SUBS/TOC Size: 6 |
|
Payroll ID |
EMPLOYEE_TIMESHEET |
PAYROLL_ID_DESC |
i.e. TEAC/SUPP/CASU/SUBS/TOC Size: 30 |
|
Position |
EMPLOYEE_TIMESHEET |
POSITION |
Size: 30 |
|
Position Code |
EMPLOYEE_TIMESHEET |
POSITION_CODE |
Size: 8 |
|
Sequence No. |
EMPLOYEE_TIMESHEET |
SEQUENCE NO |
Size: 6 |
|
Time when timesheet submitted |
EMPLOYEE_TIMESHEET |
TIMESTAMP_TIME |
Size: 11 |
|
Timesheet Amended? |
EMPLOYEE_TIMESHEET |
AMENDED_YN |
Internal Lookup: Y=Yes, N=No, Size: 90 |
|
User No that entered timesheet |
EMPLOYEE_TIMESHEET |
ENTRY_USER_NO |
Size: 10 |