Søgning » CARE omsorgssystem » AIDHISRY

CARE omsorgssystem

Tabeloversigt ?
CLIENT
AIDGIGEN
AIDHISRY
LPRTAB
PERSNNEL
COUNCIL
CLIMOOLE
ORDITION
CLIMOSRY
REFDA_TA
ANALYSE
AIDCHAED
VISAIDID
VISPCDCK
RESIENCE
HOUSIAON
AIDNE_PE
DISTRICT
VISINAID
VISINALT
AREA
MAINROUP
NOTICE
PLACE
PACKAGE
REPCHOEN
SPENE_ED
VISITION
CLIHISRY
CLIREAVE
DOCTOR
REFUSAL
SPESESUP
SUPPLIER
VISIVICE
WEENOMEV
CLIMOEOG
ORDRE_TA
PERSLTAB
PREVIVIT
USENA_ME
ADMREERT
AIDTISRY
CLIJOUAL
DRUG
PERREAVE
TECHAID
TECHTOCK
CLIABSCE
PP_REG
SERVICE
EDIREIER
LETTY_PE
RESCA_SE
AID_TIME
COURSE
DRUPACNG
INJURY
PRISUPER
REPAIR
ROUTE
UCLIENT
VISAIEIL
ACTGRGUP
ALTESPEC
ALTEDARD
CLIABURE
KOMGAAND
LANDLORD
PHARMACY
PROWI_EP
STOCK
VISPCEIL
WAITLIST
"ACTION"
ACTSESON
ACTWA_ST
AIDLELEL
BUDGINFO
CLIPACGE
CONTRACT
EDISE_ND
EVALTION
EVAHISRY
MENU
ORDREOER
PROBLEM
"RESULT"
SERAGENT
SETDYSES
SUBSTUTE
TECHORTS
USEPAION
ALTEOUSE
CALENDER
CODSESUP
DIAINNRM
DISSTTET
GISADDSS
JOUHEDNE
OBJETIVE
PTIME
REPASPEC
SERAGTTF
STANSPEC
TECHLIER
USERVICE
USEAD_DE
USEGR_NU
CLIJOUAL_342_UDDRAG
ACTCLLNT
ACTTY_PE
AIDAC_DE
AIDMANRP
AIDNIE_2
BUDGSPEC
CLIADTDD
CLIMU_ST
CL_JOECH
DELPE_RS
DISCRGED
DRUSUAES
EDITY_PE
ITEM
PACPRPCE
PART
PHAOUTES
PREEXTET
REPAMENT
RESMA_PE
RESSUBPE
SUBGRP
SUPLTACT
ACTION_342_UDDRAG
OBJETIVE_342_UDDRAG
ORDITION_342_UDDRAG
RESULT_342_UDDRAG
ACTGRAON
ACTPEOEL
ADD_CODE
AIDNIE_1
AIDTYEIL
ANASUEUB
BENEFIT
DELAIDID
DISMOLRE
DS_REERT
EVATA_BS
HONTRTST
INTRLINK
JOUSEECH
MODTY_PE
MUNILITY
RESRE_DE
SCRLEEND
SETDYWES
SPEFUTNS
STDNU_AN
STDNUERY
STOCOUNT
TECHTYPE
PROBLEM_342_UDDRAG
STDNUERY_342_UDDRAG
ABSREEON
AIDCH_PE
AIDNEAAF
ANAGRERP
ARERARIO
CLIRE_SE
CLIWAGST
CLORE_KV
DIAGOSIS
DISREEON
DISRARIO
DRUDOOGE
DRUGRGUP
EDUWA_NT
FINTY_PE
INTEVIEW
ISOGOTER
ISOGDDLE
LINKEWER
MARSTTUS
PACAIEID
PARVIFIS
PENTY_PE
PHAOU_AS
PLAPRRES
REFTY_PE
RELTY_PE
RESCOOTY
RESSTTUS
ROOMCODE
SPEPAGPH
SPERE_GI
SUBJNDEX
TOTCLCSS
WAIDEEIL
WAISESUP
WAIRE_DE
JOUHEDNE_342_UDDRAG
AIDREEON
AIDLA_DE
ALTEMAIN
BENTY_PE
CLEREEON
COUPROTY
COUTY_PE
DRUPA_PE
DRUPAUTS
DRUSTOED
DRUSTUTS
DS_RE_SC
EDUCTION
EDUTY_PE
GISSTTET
HEALTH
HEATY_PE
HMI_TAGS
HOMREEON
HONTR_PE
INIHISRY
INJTY_PE
INSTTION
ITETY_PE
JOUTY_PE
LABCO_DE
LINKOUPS
M10REEON
M11REEON
M12REEON
M4_REEON
MINREEON
"MODULE"
NOTFU_PE
NOTSE_EN
NOTTY_PE
NURREFEA
PAUSE
PERDIEON
POSTCODE
PREV_REF
PRERETUS
PRERE_PE
PRIORITY
PROWIIRD
PTITY_PE
REFERRAL
RENTY_PE
REPSO_RT
RESREEON
RESTY_PE
RETREEON
SERVROUP
SERGRGUP
SINAIDIS
SPECTYPE
SPEFU_PE
TECHSPEC
TECLELEL
TOTCL_PE
USEGRGUP
USEGROLE
"ZONE"
NOTICE_342_UDDRAG
STDNU_AN_342_UDDRAG
Kodetabel_ACTCLLNT_STATUS
ACTMOOLE
Kodetabel_ACTPEOEL_STATUS
Kodetabel_AIDCHAED_WEEKDAY_NO
Kodetabel_AIDCHAED_TYPE
Kodetabel_AIDCHAED_CHANGER
Kodetabel_AIDGIGEN_WEEK_CODE
Kodetabel_AIDHISRY_WEEK_CODE
Kodetabel_AID_TIME_WEEKDAY_NO
Kodetabel_AIDTISRY_WEEKDAY_NO
ANSWER
AREMOEEL
BILLTYPE
CLISUPER
CPRSUPON
DRUACAES
DRUDO_DE
DRUINAON
DRUIN_DE
DSBFI_PE
DSBREBPE
HEAINNRM
INTREERP
ISOGADER
MODMEUEL
NOTFU_NK
REPDIHEA
REPMOEEL
REPRE_PE
RESRE_PE
STATTYPE
TITLE
UNITTYPE
USEDICSS
USEGRPEL
VISAIRDS
VISAIWCH
VISPCRDS
VISPCWCH
WEEK_DAY
WIZUSREL
Kodetabel_Lagringsform
Tabel

AIDHISRY


Beskrivelse ?

Tabel: AID_HISTORY - Contains the history about performed visits.

Størrelse (Antal rækker) ?

535993

Indhold (Kolonner/variable) ?

Navn Indhold
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