Name | Physical Object Name | Type | Description |
|---|
Script | | ServiceCallEquipment | jxServiceCallEquipment | View | Comma-separated list of equipment by service call |
jxServiceCallEquipment.sql |
| ServiceCallEmployees | jxServiceCallEmployees | View | A list of assigned employees by service call appointment |
jxServiceCallEmployees.sql | PCEXTRAS (LONG Building) | PCEXTRAS | View | *Sample data needed to support the jxPayCodeLabor (LONG Building) view | PCEXTRAS-view.sql |
PayCodeLabor (LONG Building) | jxPayCodeLabor | View | * All active non-expense pay codes with Activity Type mapping | jxPayCodeLabor-LONG-Building.sql |
| PayCodeLabor | jxPayCodeLabor | View | All active non-expense pay codes |
jxPayCodeLabor.sql |
| PayCodeExpense | jxPayCodeExpense | View | All active expense pay codes |
jxPayCodeExpense.sql | JobProjectManagers | jxJobProjectManagers | View | v2 A list of Job assigned Project ManagersJobEmployees | jxJobEmployees | View | v2 A list of assigned employees by job appointment | jxJobEmployees.sql |
jxJobProjectManagers.sql | | JobCostCodes | jxJobCostCodes | View | A list of assigned cost codes by job |
jxJobCostCodes.sql |
| Equipment | jxEquipmentGLAccount | View | All open Service Call Equipment |
jxEquipmentGLAccount.sql |
| EmployeePayCodeLabor | jxEmployeePayCodeLabor | View | All active employee non-expense pay codes |
jxEmployeePayCodeLabor.sql |
| EmployeePayCodeExpense | jxEmployeePayCodeExpense | View | All active employee expense pay codes |
jxEmployeePayCodeExpense.sql |
| Employee | jxEmployee | View | All active GP employees setup as TT_Active under TimeTrack Registered Users |
jxEmployee.sql |
| CostCodeLabor | jxCostCodeLabor | View | All active labor cost codes |
jxCostCodeLabor.sql |
| CostCodeExpense | jxCostCodeExpense | View | All active expense cost codes |
jxCostCodeExpense.sql | (Appointments)jxActivity (v2.5) | ViewActivities | All active Job Appointments, open Service Call Appointments OR completed Service Calls within the last 90 days, and Activities | jxActivity.sql | | jxJobServiceCall | View | All active Jobs, open Service Calls OR completed Service Calls within the last 90 days, and Activities |
jxJobServiceCall.sql
