home *** CD-ROM | disk | FTP | other *** search

---

/ Computer Buyer 1998 July / dpcb0798.bin / Business / Persdesk / _SETUP.1 / DATAFLDS.DB (.txt)

< prev

next >

Wrap

Paradox Database Table  |  1998-04-20  |  23KB  |  198 rows

---

#	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