| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP05: Time Accounting and HRM Base |
1 | F0618 | Employee Transaction History | 130 | YT | JBLC | Contract Labor Category | String | UDC | 6 | 0 |
TOP05T: Time Entry |
2 | F06116 | Employee Transaction Detail File | 200 | YT | JBLC | Contract Labor Category | String | UDC | 6 | 0 |
3 | F06116Z1 | Employee Transactions - Batch File | 210 | VL | JBLC | Contract Labor Category | String | UDC | 6 | 0 |
4 | F06116Z2 | ESS Timecard History | 210 | VM | JBLC | Contract Labor Category | String | UDC | 6 | 0 |
TOP18: Resource Scheduling |
5 | F186602 | Labor Rules Tag File | 204 | TF | JBLC | Contract Labor Category | String | UDC | 6 | 0 |
TOP48S: Service Billing |
6 | F48S0618 | Payroll Reclassification Workfile | 130 | YT | JBLC | Contract Labor Category | String | UDC | 6 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 06 / G (Job Type) stock values
| Value | Description | Special Handling Code | Hard Coded |
---|
1 | | . | | N |
2 | #ALLOC | Allocated Tips record | | N |
3 | #SUMM | Summarized Tips record | | N |
4 | 0A-0 | Controller | | N |
5 | 0A-1 | Accounting Manager | | N |
6 | 0A-10 | Purchasing Agent | | N |
7 | 0A-2 | Senior Accountant | | N |
8 | 0A-3 | Financial Analyst | | N |
9 | 0A-4 | Accountant | | N |
10 | 0P-0 | Finance Director | | N |
11 | 0P-1 | Asst Finance Director | | N |
12 | 0P-2 | Accounts Payable Clerk | | N |
13 | 0P-3 | Accounts Receivable Clerk | | N |
14 | 1M-1 | MIS Manager | | N |
15 | 1M-2 | IT Manager | | N |
16 | 1M-3 | System Analyst | | N |
17 | 1M-4 | Programmer Analyst | | N |
18 | 1M-5 | Programmer | | N |
19 | 2H-1 | Human Resources Manager | | N |
20 | 2H-2 | Employment Representative | | N |
21 | 2H-3 | Compensation Specialist | | N |
22 | 2H-4 | Benefits Specialist | | N |
23 | 2H-5 | EEO Specialist | | N |
24 | 2H-6 | Instructor | | N |
25 | 3P-1 | Payroll Manager | | N |
26 | 3P-2 | Payroll Administrator | | N |
27 | 4A-1 | Administrative Assistant | | N |
28 | 4A-2 | Secretary | | N |
29 | 4A-3 | Clerk | | N |
30 | 50PE | Project Engineer | | N |
31 | 50PM | Project Manager | | N |
32 | 50SU | Superintendent | | N |
33 | 5J-1 | City Manager | | N |
34 | 5J-2 | County Supervisor | | N |
35 | 5J-3 | Purchasing Manager | | N |
36 | 5J-4 | Fire Fighter | | N |
37 | 5J-5 | Electrician | | N |
38 | 5J-6 | Junior Engineer | | N |
39 | 5J-7 | Nurse | | N |
40 | 5J-8 | Teacher | | N |
41 | 5J-9 | Journeyman | | N |
42 | 61 | Foreman | | N |
43 | 62 | Foreman | | N |
44 | 63 | Equipment Operator | | N |
45 | 64 | Engineer | | N |
46 | 64-1 | Designer | | N |
47 | 64-5 | Spec Typist | | N |
48 | 65 | Draftsperson | | N |
49 | 66 | Electrician | | N |
50 | 67 | Electrician | | N |
51 | 68 | Technician | | N |
52 | 69 | Driver | | N |
53 | 6G-1 | City Manager | | N |
54 | 6G-2 | Purchasing Manager | | N |
55 | 6G-3 | County Supervisor | | N |
56 | 6G-4 | Fire Fighter | | N |
57 | 6G-5 | Nurse | | N |
58 | 6S-1 | Security Supervisor | | N |
59 | 6S-3 | Security Screener | | N |
60 | 6S-5 | Security Guard | | N |
61 | 7H-0 | Hotel Manager | | N |
62 | 7H-1 | Waiter/Waitress | | N |
63 | 7H-2 | Hostess | | N |
64 | 7H-3 | Housekeeper | | N |
65 | 7H-4 | Service Worker (Bell Stand) | | N |
66 | 7H-5 | Bartender | | N |
67 | 7H-6 | Bus person | | N |
68 | 7H-7 | Chef | | N |
69 | 8M-1 | Maintenance Engineer | | N |
70 | 8M-2 | Distribution Manager | | N |
71 | 8M-3 | Clerk | | N |
72 | 8P-1 | Plant Manager | | N |
73 | 8P-2 | Foreman | | N |
74 | 8P-3 | Lathe Operator | | N |
75 | 8P-4 | Setup Person | | N |
76 | 8P-5 | Production Worker | | N |
77 | 8P-6 | QA Inspector | | N |
78 | 8P-7 | Press Operator | | N |
79 | 8R-1 | Maintenance Mechanic Junior | | N |
80 | 8R-2 | Maintenance Electrician App 2 | | N |
81 | 8R-3 | Maintenance Instruc. Junior | | N |
82 | 999 | Other | | N |
83 | 9S-1 | Sales Management | | N |
84 | 9S-2 | Sales Representative | | N |
85 | A0 | Chief Executive Officer | | N |
86 | A1 | President | | N |
87 | A2 | Vice President | | N |
88 | ADMASS | Administrative Assistant | | N |
89 | BOARD | Board of Directors | | N |
90 | CC200 | Corporate Controller | | N |
91 | CLERK | Clerk | | N |
92 | M1 | Manager | | N |
93 | M200 | Manager | | N |
94 | MX801 | Administrador | | N |
95 | MX802 | Jefe de Operaciones | | N |
96 | MX803 | Asistente Administrativa | | N |
97 | MX804 | Supervisor | | N |
98 | MX810 | Tecnico Especialista | | N |
99 | MX811 | Electricista | | N |
100 | MX812 | Mecanico | | N |
101 | MX813 | Trabajos Generales | | N |
102 | MX820 | Operario - Eventuales | | N |
103 | PB-1 | Planner/Buyer | | N |
104 | PRES | President | | N |
105 | PROG | Associate Programmer | | N |
106 | PROGRA | Programmer | | N |
107 | SALREP | Sales Representative | | N |
108 | SECRE | Secretary | | N |
109 | TRN1 | Trainer | | N |
110 | TRNER | Trainer | | N |
111 | TYPIST | Typist | | N |
112 | VICPRE | Vice President | | N |