| 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 |
level |
| AID_NEED_TYPE_NO |
Unique number for need type |
| WEEKDAY_NO |
Day in week, 1 = Monday, 2 = Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday, 7=Sunday |
| START_TIME |
Time for aid, 1845 means 6:45 p.m. |
| PERSON_NO |
Usually 1, if two persons needed for help, then the second has person_no = 2 |
| CHG_DATE |
date |
| TYPE |
1= change, 2 = cancellation, 3 = extra aid, 4 = Nødkald , 5 = Dødsfald , 6 = Akut besøg |
| NEW_DURATION |
Contains value of new DURATION if value of field STANDARD_TIME in table AID_TIME_HISTORY has changed. Value of -1 means that value of field STANDARD_TIME in table AID_TIME_HISTORY is to be used instead |
| NEW_INI |
Contains value of new INI if value of field INI in table AID_TIME_HISTORY has changed. Value of -1 means that value of field INI in table AID_TIME_HISTORY is to be used instead |
| NEW_START |
Contains value of new START_TIME if value of field START_TIME in table AID_TIME_HISTORY has changed. Value of -1 means that value of field START_TIME in table AID_TIME_HISTORY is to be used instead |
| NEW_DATE |
Contains value of NEW_DATE if value of calculated DATE from table AID_TIME_HISTORY has changed. Value of -1 means that value of calculated DATE from table AID_TIME_HISTORY is to be used instead |
| WATCH |
Char(1) distinguishing between day - D , evening - E or night visit. |
| CHANGER |
1 = client, 2 = council |
| REASON |
reason |
| WEEK_START |
date of Monday in week |
| WEEK_END |
date of Sunday in week |
| NOTIFIED |
y/n, is the change notified or unexpected. |
| CHG_TYPE |
Describe which type of changes this is |
| EXCHG_AID |
Whether this cahanges is an exhange for an planned aid |
| NO_OF_CHG |
How many times this aid has been changes |
| ORIGIN |
Angiver oprindelse af afvigelse |
| ORIG_INI |
Planned ini from aid_time_history |
| ORIG_DURATION |
Planned duration from aid_history |
| AID_TIME_LEVEL |
The aid level references aid_level in table aid_level |
| CPR_IDX |
Field used for performance index for mass update and delete |