| C_CPR_NO |
The clients personal CPR-number (Centrale Person Register). |
| MODULE_TYPE_NO |
Unique number of the module types |
| DISCH_REASON_NO |
Unique no the disharge reason |
| REFERRAL_DATE |
The date of the referral. |
| LAST_REVISION |
Date of the newest revision. |
| CREATE_INI |
Initials of the employee. Are used to identify the PERSONNEL. Four characters long. |
| START_DATE |
The date from which the CLIENT starts in the module. |
| DAY_DISTRICT |
Unique number for the districts |
| PAY_RATE |
Percentage the CLIENT pays himself. |
| EVENING_DISTRICT |
Unique number for the districts |
| NIGHT_DISTRICT |
Unique number for the districts |
| AID_TYPE |
Char(1) distinguishing between permanent (v) or temporarily (m) aid. |
| INI_DAY |
Initials of the personnel working the day, e.g 8-16. |
| INI_EVENING |
Initials of the personnel working the evening, e.g. 16-24. |
| AID_CLASS |
Meassure for the level of the aid need, not well defined |
| INI_NIGHT |
Initials of the personnel working the night, e.g 24-8. |
| DISCH_DATE |
Date the CLIENT was discharged from the system, e.g because of death, acceptance to an institution etc. |
| DISCH_FLAG |
Flag, the CLIENT is discharged, yes/no. |
| AGREEMENT_TEXT |
Text that explains why the CLIENT is connected to the client module. |
| AGREEMENT_TEXT_1 |
ext that explains why the CLIENT is connected to the client module. |
| AV_DAY |
Number of minutes per week the CLIENT receives aid, visiterede timer , for the given module_type, during the day.. |
| AV_EVENING |
Number of minutes per week the CLIENT receives aid, visiterede timer , for the given module_type, during the evening. |
| AV_NIGHT |
Number of minutes per week the CLIENT receives aid, visiterede timer , for the given module_type, during the night. |
| NEXT_VISIT |
Date for when next survey visit should be carried out skal udføres |
| LAST_VISIT |
The last date there has been a visit to determine what help the client should get. |
| CLIENT_PAY |
Does the client pay for homeaid benefits (y/n) |
| DISCH_DATE_LAST |
Contains the previous discharge date (for interfaces) |
| START_DATE_LAST |
Contains the previous start date (for interfaces) |
| ROUTENUMBER |
number of the standard delevering route for technical aids |
| SINGLE_AID |
y/n |
| INI_DAY_WEEKEND |
ini from personnel |
| INI_EVE_WEEKEND |
ini from personnel |
| INI_NIG_WEEKEND |
ini from personnel |
| APV |
Arbejdspladsvurdering made |
| APV_NOTE |
Arbejdspladsvurdering made |
| APV_NOTE_1 |
Arbejdspladsvurdering made |
| AID_TYPE_DETAIL_NO |
key from aid_type_detail |
| TEMP_GRANT |
temp grant |
| HOUR_PRICE |
hour price |
| PREV_NOTE |
geneel not about client used in module preventive |
| NEXT_VISIT_INI |
ini from personnel |
| INI_CONTACT |
Personnel designated as primary contact for the client |