| TITLE_NO |
Unique number |
| POSTCODE |
Postcode. In Denmark it is always 4 characters. |
| NAME |
First name(s) of the PERSONNEL. |
| SURNAME |
Surname of the PERSONNEL. |
| P_CPR_NO |
CPR-number for the PERSONNEL. |
| ADDR_STRT |
Address : Street, number, floor etc. |
| P_CPR_NO_EXTRA |
Extra cipher used in the end of the PERSONNELs CPR-number. Is used to identify where the PERSONNEL is working. |
| ADDR_PLC_NAME |
Place name. |
| PHONE_NO |
Telephone number of the PERSONNEL. |
| CALL_PHONE_NO |
If the PERSONNEL has a call telephone number, e.g to a mobile telephone. |
| OCCUPATION |
Occupation of the PERSONNEL, Should correspond more or less to EDUCATION, but not neccesarily. |
| START_DATE |
The date the PERSONNEL started working. |
| END_DATE |
IF the PERSONNEL is an ex-employee, then there is an end-date. |
| DISCH_CAUSE |
The reason why the PERSONNEL stopped working, e.g. retired. May be invisible for some local authorities. |
| INI |
A uniqe identifikation of each employee. |
| NOTE |
Notes about the PERSONNEL. |
| TRANSPORT |
What kind of transport the PERSONNEL is using to get to work, e.g. car , bike , by foot etc. |
| LAST_REV |
Revision date, is updated evry time the PERSONNELs conditions are changed. |
| EXTRA_HOURS |
Flag, the person wants extra hours of work, yes/no. |
| WATCH |
Char(1) distinguishing between day - D , evening - E or night visit. |
| REPRESENTATIVE |
The employee can be representative for his or her collegues. |
| WATCH_AUTO_TRANS |
Indicates if the employees data automaticly should be transferred to Kommunedatas scheduling system (y/n) |
| WATCH_TRANS_ST |
Indicates whether the employees data has been transferred or not (y/n) |
| REKV_YES_NO |
Does the employe get cloth rekvisitions |
| ACTIVE_FLAG |
Flag, the personnel is active, yes/no. |
| REKV_DATE |
The date where the employe got the first cloth rekvisition |
| INITIALS |
The employees initials |
| ROUTE |
Sometimes in the table the ini is not a physical person, but a route . Flag, the personnel is a route, yes/no. |
| SECRET_PHONE |
is phonenumber secret (y/n) |
| SECRET_ADDR |
is address secret (y/n) |
| CONTRACTOR |
y/n |
| MEET_FROM |
meeting hour start |
| MEET_TO |
meeting hour end |
| WORK_PHONE_NO |
work phone number |
| PERS_DISCH_NO |
discharge reson from pers_disch_reason |
| SUBSTITUTE |
ini from personnel |
| OFFICE_HOURS |
office hours |
| SERVICE_GROUP |
A new layer for personel (groups) |
| PRIV_SUPPL_NO |
Unique number from PRIVATE_SUPPLIER, only for routes |
| PEN_ID |
ID of pen used for identifying personnel using interface PEN_til_CARE |
| MUNICIPALITY_NO |
municipality number |
| ADDR_NAME |
Name to be displayed on correspondance |
| EMAIL |
Personnels email-address |
| PDC_PERSONID |
Unique identifier from PDC within the municipality |
| VP_INITIALS |
Unique identifier from PDC within the municipality |
| KMD_PAYTYPE |
KMD VP - payment-type (corresponds to aflonningsform) |
| NO_MOTOR_TRANSPORT |
Personnel only uses means of transportation without motors, e.g. bike, (y/n) |
| AVG_SPEED |
Average speed of personnel when using non-motorised transportation |