| 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 |
| AID_LEVEL |
The aid levels, with numbers 1,2 and 3. |
| AID_NEED_TYPE_NO |
Unique number for need type |
| DATE_FR |
The date the aid started |
| DATE_TO |
The date the need stopped |
| WEEK1 |
This flag tells if the vistit has been done in week 1 This explanation should be repeated for the next 52 attributes |
| WEEK2 |
like week 1 |
| WEEK3 |
like week 1 |
| WEEK4 |
like week 1 |
| WEEK5 |
like week 1 |
| WEEK6 |
like week 1 |
| WEEK7 |
like week 1 |
| WEEK8 |
like week 1 |
| WEEK9 |
like week 1 |
| WEEK10 |
like week 1 |
| WEEK11 |
like week 1 |
| WEEK12 |
like week 1 |
| WEEK13 |
like week 1 |
| WEEK14 |
like week 1 |
| WEEK15 |
like week 1 |
| WEEK16 |
like week 1 |
| WEEK17 |
like week 1 |
| WEEK18 |
like week 1 |
| WEEK19 |
like week 1 |
| WEEK20 |
like week 1 |
| WEEK21 |
like week 1 |
| WEEK22 |
like week 1 |
| WEEK23 |
like week 1 |
| WEEK24 |
like week 1 |
| WEEK25 |
like week 1 |
| WEEK26 |
like week 1 |
| WEEK27 |
like week 1 |
| WEEK28 |
like week 1 |
| WEEK30 |
like week 1 |
| WEEK29 |
like week 1 |
| WEEK31 |
like week 1 |
| WEEK32 |
like week 1 |
| WEEK33 |
like week 1 |
| WEEK34 |
like week 1 |
| WEEK35 |
like week 1 |
| WEEK36 |
like week 1 |
| WEEK37 |
like week 1 |
| WEEK38 |
like week 1 |
| WEEK39 |
like week 1 |
| WEEK40 |
like week 1 |
| WEEK41 |
like week 1 |
| WEEK42 |
like week 1 |
| WEEK43 |
like week 1 |
| WEEK44 |
like week 1 |
| WEEK45 |
like week 1 |
| WEEK46 |
like week 1 |
| WEEK47 |
like week 1 |
| WEEK48 |
like week 1 |
| WEEK49 |
like week 1 |
| WEEK50 |
like week 1 |
| WEEK51 |
like week 1 |
| WEEK52 |
like week 1 |
| WEEK53 |
like week 1 |
| WEEK_CODE |
Char to specify if the aid is given in all weeks, A , no weeks, N , even weeks, E , odd weeks, U , Xth weeks, X , or special weeks, S . The special weeks are specified in the application directly. |
| STANDARD_TIME |
If the time differ from the duration in AID_LEVEL the new standard time is written here. E.g if the CLIENTs house is much bigger than standard . |
| AID_STOPPED |
Flag, the aid is stopped, yes/no. |
| COUNT_DAY |
Total number of minutes during the day hours. |
| COUNT_EVENING |
Total number of minutes during the evening hours. |
| NO_WEEKS |
Number of weeks where the aid is given. |
| COUNT_NIGHT |
Total number of minutes during the night hours. |
| WEEK_INTERVAL |
every x. week, for instance every second or third week |
| COUNT_DAY_PRIV |
average number of times pr. week, day given by a private supplier |
| COUNT_EVENING_PRIV |
average number of times pr. week, evening given by a private supplier |
| COUNT_NIGHT_PRIV |
average number of times pr. week, night given by a private supplier |
| AID_TIME_LEVEL |
The aid level references aid_level in table aid_level |
| XDAY |
All rows that are connect in a x. day has the same number in the column xday |
| CPR_IDX |
Field used for performance index for mass update and delete |