| C_CPR_NO |
The clients personal CPR-number (Centrale Person Register). |
| REFERRAL_DATE |
The date of the referral. |
| MODULE_TYPE_NO |
Unique number of the module types |
| CMH_NO |
key number |
| DISCH_REASON_NO |
disch reason from discharge_reason |
| LAST_REVISION |
date |
| CREATE_INI |
ini from personnel |
| START_DATE |
start date |
| DAY_DISTRICT |
district_no from district |
| PAY_RATE |
pay rate |
| EVENING_DISTRICT |
district_no from district |
| NIGHT_DISTRICT |
district_no from district |
| AID_TYPE |
V = varig, M = midlertidig in homeaid, other modules null |
| INI_DAY |
ini from personnel |
| INI_EVENING |
ini from personnel |
| AID_CLASS |
aid class |
| INI_NIGHT |
ini from personnel |
| DISCH_DATE |
discharge date |
| DISCH_FLAG |
y/n, is client discharged |
| AGREEMENT_TEXT |
service contract |
| AV_DAY |
redundant number of minutes of aid pr. week from aid_given and aid_time, day |
| AV_EVENING |
redundant number of minutes of aid pr. week from aid_given and aid_time, evening |
| AV_NIGHT |
redundant number of minutes of aid pr. week from aid_given and aid_time, night |
| NEXT_VISIT |
next visit date |
| LAST_VISIT |
last visit date |
| CLIENT_PAY |
does client pay for visits? |
| DISCH_DATE_LAST |
disch date last |
| START_DATE_LAST |
start date last |
| ROUTENUMBER |
route number from route, only used in module with tech aids |
| CMH_START |
The day from which the row is valid |
| CMH_END |
The day to which the row is valid 31-12-4712 indicates an open end date |
| SINGLE_AID |
y/n |
| AID_TYPE_DETAIL_NO |
key from aid_type_detail |
| TEMP_GRANT |
temp grant |
| HOUR_PRICE |
hour price |
| INI_CONTACT |
Personnel designated as primary contact for the client |
| IS_UPDATED |
y/n flag shows if the row has been updated during the conversion of client_module_history |
| NEXT_VISIT_INI |
ini of next visit |