| C_CPR_NO |
The clients personal CPR-number (Centrale Person Register). |
| BIRTH_DATE |
The birthdate of the client. If the CPR-number starts with 9 it is not a valid number, and the birthdate is set to 24-12-1900. |
| PHARMACY_NO |
Unique number for every pharmacy. |
| AREA_NO |
Unique number for every area |
| DOCTOR_NO |
Unique number for every doctor. |
| GENDER |
The sex of the client. M is male, F female. |
| MARITAL_STAT_NO |
Unique number of the marital status |
| INSTIT_NO |
Unique number for the institutions |
| INI |
ini from personnel |
| ADR_POSTCODE |
Postcode. In Denmark it is always 4 characters. |
| NAME |
First name of the client |
| SURNAME |
last name of the client |
| ADDR_CO_NAME |
If there is a c/o address, then the c/o name is written here. |
| ADDR_STRT |
The address of the client including street, number, floor (optional) etc. |
| ADDR_PLACE_NAME |
The place name (optional). |
| PHONE_NO |
Telephone number |
| WORK_PHONE_NO |
Work telephone number |
| RES_ADDR_STRT |
Residence address |
| RES_ADDR_CO_NAME |
If the CLIENT has a residence other than his home address, the c/o address name is found here. E.g. a very ill client staying with family. |
| RES_ADDR_PLC_NAME |
Residence place name |
| RES_PHONE_NO |
Residence telephone number |
| EMERG_PHONE_NO |
Emergency telephone number. |
| ENTRANCE_NOTE |
Entrance notes, e.g the key is under the mat |
| PARTNER_CPR_NO |
The partners cpr-number |
| PARTNER_NAME |
The full name of the partner |
| INSURANCE_DENMARK |
Flag, the client member of the private insurance Danmark , yes/no |
| MEDICAL_CARD |
Flag, the CLIENT has a medical card, yes/no |
| PERS_ADD_PER |
Personlig tillægsprocent . Between 1 and 100. |
| PUBLIC_SUP_GRP |
Is presently not in use. |
| PUBLIC_INSU_GRP |
All persons living in Denmark are member of the National Insurance. One can be in group 1 or 2. |
| WORK_DESC |
Present or past occupation of the CLIENT. |
| CAVE |
If the client is allergic to anything, e.g. some types of medicin. |
| CREATION_DATE |
Date the CLIENT was enrolled in the system |
| KEY_NO |
The CLIENT has a key number. |
| INSTIT_REQ_DATE |
The date of a request of being transferred to an institution |
| INSTIT_ACC_DATE |
The date the CLIENT will or have been transferred to the institution. |
| EMERG_KEY |
The CLIENT has an extra emergency key number. |
| DISTRICT_NO |
Unique number for the districts. |
| MEDICIN_STORAGE |
A field describing the place the medicine is kept. |
| RES_POSTCODE |
Postcode. In Denmark it is always 4 characters. |
| INSTIT_VISIT_NO |
key from institution |
| UPDATE_FLAG |
Flag, if the address of the client is changed in LPR_TAB, the the update_flag is set to y , otherwise it is n . |
| AGE |
The age of the client. Is updated every morning. |
| SEC_PHONE_NO |
Flag indicating that the client has a secret phone number (y/n) |
| RES_ELD |
Flag that indicates if the client stays at residential home |
| RES_ELD_DATE |
The date where the client moved to the residential home |
| ENT_KEY |
The number of the entry phone |
| EMERG_KEY_REASON |
The reason why the emergcy call was given to the client |
| PHONE_SUB |
Does the client have a dedicated phone for aid (y/n) |
| PHONE_SUB_REASON |
The reason why a dedicated phone was given to the client |
| MED_DELIVERY |
The place where the clients medicine is delivered |
| WAIT_CLEAN_DATE |
The date where the client was put on a waitinglist for housecleaning |
| BANKACCOUNT |
The bankaccount number of the client |
| PART_NR |
Contain the partition number for client. The partitions are defined in user_partition. |
| SPC_DOCTOR_NAME |
special doctor name |
| SPC_DOCTOR_PHONE_NO |
special doctor phone number |
| LIVES_ALONE |
y/n |
| RES_TYPE_NO |
residence type |
| SECRET_ADDR |
y/n to secret adress |
| PHONE_MOBILE |
cell phone number |
| EMAIL |
email |
| CLIENT_NO |
client number |
| DEATHDATE |
death date |
| SPC_DOCTOR2_NAME |
special doctor name for second doctor |
| SPC_DOCTOR2_PHONE_NO |
special doctor phone number for second doctor |
| ALLOW_DATA_EXCHANGE |
y/n |
| DRUG_RESPONSIBLE |
ini from personnel |
| EMERG_KEY_SERIAL |
sertial number |
| EUREF89_EAST |
GIS data |
| EUREF89_NORTH |
GIS data |
| ZONE_NO |
zone number |
| PARTNER_MARITAL_STAT_NO |
The partners marital status |
| CERT_ID_NO |
Certificate id number |
| PEN_CARD_ID |
ID of pen-card used for identifying client using interface PEN_til_CARE |
| MUNICIPALITY_NO |
municipality_no when coorporation |
| ADDR_NAME |
Name to be displayed on correspondance |
| PENSION_NO |
Pension type |
| SECURITY_AGREEMENT |
Indicates whether a security agreement exists at clients house |
| MEDICINE_NOTE |
Note about clients medicine |
| TERMINAL_START |
Start date of terminal care |
| TERMINAL_END |
End date of terminal care |