# | Database,A,8 | Field,A,25 | Field Description,A,40 | DataType,A,20 | Size,S,2
|
---|
1 | ATTEND | Attend Description | Details of particular attendance | Memo | 12 |
2 | ATTEND | Attendence Mode | Type of absence signified | String | 1 |
3 | ATTEND | Day attendance | Date when member of staff away | Date | 0 |
4 | ATTEND | Employee ID | | String | 9 |
5 | BUSTYPE | Business type | Different types of business | String | 20 |
6 | CATEGORY | Category | | String | 25 |
7 | CODEDESC | Code | General code identifier for interviews | String | 2 |
8 | CODEDESC | Description | Description of code. | Memo | 12 |
9 | COMPANY | Address | Address of company | Memo | 12 |
10 | COMPANY | Business type | Type category of your business | String | 20 |
11 | COMPANY | Company Postcode | Company Address Postcode | String | 12 |
12 | COMPANY | Fax | Company Fax | String | 12 |
13 | COMPANY | Name | Name of company | String | 40 |
14 | COMPANY | Number of Contract Empl. | Number of current contract workers. | Small Integer | 0 |
15 | COMPANY | Number of FT Employees | Number of full time employees | Small Integer | 0 |
16 | COMPANY | Number of PT Employees | Number of part time employees | Small Integer | 0 |
17 | COMPANY | Telephone | Company main line Telephone | String | 12 |
18 | COMPCONT | Category | | String | 25 |
19 | COMPCONT | CompanyPostcode | | String | 12 |
20 | COMPCONT | Description | | Memo | 12 |
21 | COMPCONT | Item number | | Float | 0 |
22 | COMPCONT | Necessity | | Boolean | 0 |
23 | COMPCONT | Require | | Boolean | 0 |
24 | COMPCONT | Sub-category | | String | 35 |
25 | COMPCONT | Sub-sub-category | | String | 35 |
26 | CONTRACT | Category | | String | 25 |
27 | CONTRACT | Description | | Blob | 0 |
28 | CONTRACT | Item number | | Float | 0 |
29 | CONTRACT | Necessity | | Boolean | 0 |
30 | CONTRACT | Require | | Boolean | 0 |
31 | CONTRACT | Sub-category | | String | 35 |
32 | CONTRACT | Sub-sub-category | | String | 35 |
33 | EFFECT | Description | Description of effect code | Memo | 12 |
34 | EFFECT | Effect | Effect of interview on employee | String | 2 |
35 | EMPLCONT | Condition Record | Type of employee contract | Small Integer | 0 |
36 | EMPLCONT | Description | Individual employee contracts. | Blob | 1 |
37 | EMPLCONT | Employee ID | | String | 9 |
38 | EMPLJOB | Boss First Names | Employee's direct Supervisor first names | String | 35 |
39 | EMPLJOB | Boss Surname | Employee's direct Supervisor surname | String | 25 |
40 | EMPLJOB | Code | | String | 2 |
41 | EMPLJOB | Department | Employee's department work in. | String | 30 |
42 | EMPLJOB | Employee ID | | String | 9 |
43 | EMPLJOB | Job Title | Job Title for individual employee | String | 30 |
44 | EMPLJOB | Job end date | The date when employee ended this job | Date | 0 |
45 | EMPLJOB | Job start date | The date when employee started this job | Date | 0 |
46 | EMPLJOB | Section | Employee's Section work in. | String | 30 |
47 | EMPLJOB | Status point in grade | Current pay point on grade scale. | Float | 0 |
48 | EMPLJOB | Work Phone number | Employee's work telephone. | String | 15 |
49 | EMPLOYEE | Address | Current Employee address. | Memo | 12 |
50 | EMPLOYEE | Check | | Boolean | 0 |
51 | EMPLOYEE | Company Name | Your company name for this employee | String | 40 |
52 | EMPLOYEE | Company Postcode | Your company postcode for this employee | String | 12 |
53 | EMPLOYEE | Date of Birth | Employee's date of birth | Date | 0 |
54 | EMPLOYEE | Doctor | Employee's Doctor name | String | 35 |
55 | EMPLOYEE | Doctor Address | Employee's Doctor address | Memo | 12 |
56 | EMPLOYEE | Employee ID | | String | 9 |
57 | EMPLOYEE | Fax | Employee Home Fax Number | String | 15 |
58 | EMPLOYEE | First Names | Employee First Names | String | 35 |
59 | EMPLOYEE | Fridayfinish | Finish Time | Time | 0 |
60 | EMPLOYEE | Fridayhours | Hours worked in day | Small Integer | 0 |
61 | EMPLOYEE | Fridaystart | Starting time | Time | 0 |
62 | EMPLOYEE | Fridaywork | Whether works on this day | Boolean | 0 |
63 | EMPLOYEE | Job Title | Employee's current job title | String | 30 |
64 | EMPLOYEE | Mondayfinish | Finish Time | Time | 0 |
65 | EMPLOYEE | Mondayhours | Hours worked in day | Small Integer | 0 |
66 | EMPLOYEE | Mondaystart | Starting time | Time | 0 |
67 | EMPLOYEE | Mondaywork | Whether works on this day | Boolean | 0 |
68 | EMPLOYEE | NI code | Employee National Insurance code | String | 9 |
69 | EMPLOYEE | Next of kin | Name of next of kin to employee | String | 45 |
70 | EMPLOYEE | Next of kin address | Employee's next of kin address | Memo | 12 |
71 | EMPLOYEE | Picture | Photograph of employee | Graphic | 0 |
72 | EMPLOYEE | Postcode | Current Employee Postcode | String | 10 |
73 | EMPLOYEE | Principal location | Company base location for employee | Memo | 12 |
74 | EMPLOYEE | Report To | Who employee directly reports to | String | 9 |
75 | EMPLOYEE | Revision Date | Date of last change in employee file | Date | 0 |
76 | EMPLOYEE | Saturdayfinish | | Time | 0 |
77 | EMPLOYEE | Saturdayhours | | Small Integer | 0 |
78 | EMPLOYEE | Saturdaystart | | Time | 0 |
79 | EMPLOYEE | Saturdaywork | | Boolean | 0 |
80 | EMPLOYEE | Sex | Male/Female | String | 1 |
81 | EMPLOYEE | Sundayfinish | | Time | 0 |
82 | EMPLOYEE | Sundayhours | | Small Integer | 0 |
83 | EMPLOYEE | Sundaystart | | Time | 0 |
84 | EMPLOYEE | Sundaywork | | Boolean | 0 |
85 | EMPLOYEE | Surname | Employee surname | String | 25 |
86 | EMPLOYEE | Tax code | Employee tax code | String | 6 |
87 | EMPLOYEE | Telephone | Employee Home Telephone Number | String | 15 |
88 | EMPLOYEE | Thursdayfinish | | Time | 0 |
89 | EMPLOYEE | Thursdayhours | | Small Integer | 0 |
90 | EMPLOYEE | Thursdaystart | | Time | 0 |
91 | EMPLOYEE | Thursdaywork | | Boolean | 0 |
92 | EMPLOYEE | Title | Employee Title (Mr, Mrs, Ms, etc.) | String | 4 |
93 | EMPLOYEE | Totalhoursperweek | Contracted normal working week hours. | Small Integer | 0 |
94 | EMPLOYEE | Tuesdayfinish | | Time | 0 |
95 | EMPLOYEE | Tuesdayhours | | Small Integer | 0 |
96 | EMPLOYEE | Tuesdaystart | | Time | 0 |
97 | EMPLOYEE | Tuesdaywork | | Boolean | 0 |
98 | EMPLOYEE | Wednesdayfinish | | Time | 0 |
99 | EMPLOYEE | Wednesdayhours | | Small Integer | 0 |
100 | EMPLOYEE | Wednesdaystart | | Time | 0 |
101 | EMPLOYEE | Wednesdaywork | | Boolean | 0 |
102 | FORM | Database | | String | 12 |
103 | FORM | Field | | String | 25 |
104 | FORM | Form Name | Form Name on Database | String | 8 |
105 | FORM | Height | | Small Integer | 0 |
106 | FORM | Number | | Small Integer | 0 |
107 | FORM | PageNumber | | Small Integer | 0 |
108 | FORM | Panel | | Small Integer | 0 |
109 | FORM | Picture | | Blob | 0 |
110 | FORM | Width | | Small Integer | 0 |
111 | FORM | X position | | Small Integer | 0 |
112 | FORM | Y Position | | Small Integer | 0 |
113 | FORMIMAG | Form Name | | String | 8 |
114 | FORMIMAG | Image Name | | String | 50 |
115 | FORMIMAG | PageNumber | | Small Integer | 0 |
116 | FORMIMAG | Text Control Master | | Blob | 0 |
117 | FRMIMGS | Form Name | | String | 8 |
118 | FRMIMGS | Height | | Small Integer | 0 |
119 | FRMIMGS | Number | | Small Integer | 0 |
120 | FRMIMGS | PageNumber | | Small Integer | 0 |
121 | FRMIMGS | Panel | | Blob | 0 |
122 | FRMIMGS | Picture | | Graphic | 0 |
123 | FRMIMGS | Width | | Small Integer | 0 |
124 | FRMIMGS | X position | | Small Integer | 0 |
125 | FRMIMGS | Y Position | | Small Integer | 0 |
126 | GENERAL | Access Code | | String | 3 |
127 | GENERAL | Description | | Blob | 12 |
128 | HOLIDAY | Employee ID | | String | 9 |
129 | HOLIDAY | Holiday finish | Date holiday finished | Date | 0 |
130 | HOLIDAY | Holiday period | Number of days holiday | Float | 0 |
131 | HOLIDAY | Holiday start | Date holiday started | Date | 0 |
132 | INTRVIEW | Code | Nature of interview code | String | 2 |
133 | INTRVIEW | Effect | The effect on employee record code | String | 2 |
134 | INTRVIEW | Employee ID | Employee being interviewed | String | 9 |
135 | INTRVIEW | Interview date | When interview takes place | Date | 0 |
136 | INTRVIEW | Outcome code | What was outcome of interview - coded. | String | 2 |
137 | JOB | Attainments - D | Person Spec. discretionary success req. | Memo | 8 |
138 | JOB | Attainments - M | Person Spec. mandatory attainment req. | Memo | 8 |
139 | JOB | Circumstances - D | Person Spec. discretionary circumstances | Memo | 8 |
140 | JOB | Circumstances - M | Person Spec. mandatory circumstance req. | Memo | 8 |
141 | JOB | Department | Where job is based | String | 30 |
142 | JOB | Disposition - D | Person Spec. discretionary disposition | Memo | 8 |
143 | JOB | Disposition - M | Person Spec. mandatory disposition req. | Memo | 8 |
144 | JOB | Grade | Current grade in pay scales | String | 4 |
145 | JOB | Holiday entitlement/year | How many days for holiday allowed | Float | 0 |
146 | JOB | Intelligence - D | Person Spec. discretionary intelligence | Memo | 8 |
147 | JOB | Intelligence - M | Person Spec. mandatory intelligence req. | Memo | 8 |
148 | JOB | Interest types - D | Person Spec. discretionary interest type | Memo | 8 |
149 | JOB | Interest types - M | Person Spec. mandatory interests req. | Memo | 8 |
150 | JOB | Job Title | Job Title | String | 30 |
151 | JOB | Key Duties | Job Description Duties | Memo | 8 |
152 | JOB | Key Objectives | Job Description Objectives | Memo | 8 |
153 | JOB | Key Responsibilities | Job Description Responsibilities | Memo | 8 |
154 | JOB | Period of Pay | When job requires payment | String | 1 |
155 | JOB | Physical - D | Person Spec. discretionary physical req. | Memo | 8 |
156 | JOB | Physical - M | Person Spec. mandatory physical req. | Memo | 8 |
157 | JOB | Section | Where job is based | String | 30 |
158 | JOB | Special Aptitudes - D | Person Spec. discretionary aptitudes | Memo | 8 |
159 | JOB | Special Aptitudes - M | Person Spec. mandatory aptitudes req. | Memo | 8 |
160 | JOB | Weekly Hours | Job hours contracted for | Float | 0 |
161 | JOBDESC | Company Importance | | Small Integer | 0 |
162 | JOBDESC | Department | | String | 30 |
163 | JOBDESC | Element | | String | 25 |
164 | JOBDESC | Importance | | Small Integer | 0 |
165 | JOBDESC | Job Title | | String | 30 |
166 | JOBDESC | Number | | Small Integer | 0 |
167 | JOBDESC | Section | | String | 30 |
168 | JOBDESC | Sub Element | | String | 25 |
169 | JOBELEM | Description | | Memo | 8 |
170 | JOBELEM | Number | | Small Integer | 0 |
171 | JOBELEM | Section | | String | 25 |
172 | JOBELEM | Sub Section | | String | 25 |
173 | OUTCOME | Outcome code | | String | 2 |
174 | OUTCOME | Outcome description | | Memo | 12 |
175 | OUTCOME. | Outcome code | What was outcome of interview - coded | String | |
176 | OUTCOME. | Outcome description | Description of code outcome. | Memo | |
177 | PAY | Bottom Pay | Lowest point pay per year/month/etc. | Currency | 0 |
178 | PAY | Grade | Grade code | String | 4 |
179 | PAY | Overtime Rate/Hour | Rate for this grade. | Currency | 0 |
180 | PAY | Points on Scale | The number of points for this grade | Small Integer | 0 |
181 | PAY | Top Pay | Top point pay per year/month/etc. | Currency | 0 |
182 | SICK | Certification received | Yes/No. | Boolean | 0 |
183 | SICK | Employee ID | | String | 9 |
184 | SICK | Sick description | Employee's statement of sickness | Memo | 12 |
185 | SICK | Sick end date | Date returned to work | Date | 0 |
186 | SICK | Sick period | Days away | Float | 0 |
187 | SICK | Sick start date | First day of sickness | Date | 0 |
188 | TRAIN | Actual Training Cost | per employee | Currency | 0 |
189 | TRAIN | Actual Training Outcome | Measure of outcome | String | 15 |
190 | TRAIN | Code | Training Type | String | 2 |
191 | TRAIN | Employee ID | | String | 9 |
192 | TRAIN | Estimated Training Cost | per employee | Currency | 0 |
193 | TRAIN | Expected Training Outcome | Estimate of outcome | String | 15 |
194 | TRAIN | Training description | Details of training taken. | Memo | 12 |
195 | TRAIN | Training finish | Date training due to finish | Date | 0 |
196 | TRAIN | Training review rating | Relative value of training against cost | Float | 0 |
197 | TRAIN | Training start | Date training started | Date | 0
|