Søgning » CARE omsorgssystem » CLIMOOLE

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

CLIMOOLE


Beskrivelse ?

Tabel: CLIENT_MODULE - After a referral the CLIENT can be connected to a MODULE_TYPE, and get a AID_GIVEN. When a CLIENT is discharged from a MODULE_TYPE he/she automatically gets a discharge date.

Størrelse (Antal rækker) ?

28042

Indhold (Kolonner/variable) ?

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