Table Definitions - Absence System
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 |