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

CLIENT


Beskrivelse ?

Tabel: CLIENT - Basic data table for the client.

Størrelse (Antal rækker) ?

16632

Indhold (Kolonner/variable) ?

Navn Indhold
C_CPR_NO The clients personal CPR-number (Centrale Person Register).
BIRTH_DATE The birthdate of the client. If the CPR-number starts with 9 it is not a valid number, and the birthdate is set to 24-12-1900.
PHARMACY_NO Unique number for every pharmacy.
AREA_NO Unique number for every area
DOCTOR_NO Unique number for every doctor.
GENDER The sex of the client. M is male, F female.
MARITAL_STAT_NO Unique number of the marital status
INSTIT_NO Unique number for the institutions
INI ini from personnel
ADR_POSTCODE Postcode. In Denmark it is always 4 characters.
NAME First name of the client
SURNAME last name of the client
ADDR_CO_NAME If there is a c/o address, then the c/o name is written here.
ADDR_STRT The address of the client including street, number, floor (optional) etc.
ADDR_PLACE_NAME The place name (optional).
PHONE_NO Telephone number
WORK_PHONE_NO Work telephone number
RES_ADDR_STRT Residence address
RES_ADDR_CO_NAME If the CLIENT has a residence other than his home address, the c/o address name is found here. E.g. a very ill client staying with family.
RES_ADDR_PLC_NAME Residence place name
RES_PHONE_NO Residence telephone number
EMERG_PHONE_NO Emergency telephone number.
ENTRANCE_NOTE Entrance notes, e.g the key is under the mat
PARTNER_CPR_NO The partners cpr-number
PARTNER_NAME The full name of the partner
INSURANCE_DENMARK Flag, the client member of the private insurance Danmark , yes/no
MEDICAL_CARD Flag, the CLIENT has a medical card, yes/no
PERS_ADD_PER Personlig tillægsprocent . Between 1 and 100.
PUBLIC_SUP_GRP Is presently not in use.
PUBLIC_INSU_GRP All persons living in Denmark are member of the National Insurance. One can be in group 1 or 2.
WORK_DESC Present or past occupation of the CLIENT.
CAVE If the client is allergic to anything, e.g. some types of medicin.
CREATION_DATE Date the CLIENT was enrolled in the system
KEY_NO The CLIENT has a key number.
INSTIT_REQ_DATE The date of a request of being transferred to an institution
INSTIT_ACC_DATE The date the CLIENT will or have been transferred to the institution.
EMERG_KEY The CLIENT has an extra emergency key number.
DISTRICT_NO Unique number for the districts.
MEDICIN_STORAGE A field describing the place the medicine is kept.
RES_POSTCODE Postcode. In Denmark it is always 4 characters.
INSTIT_VISIT_NO key from institution
UPDATE_FLAG Flag, if the address of the client is changed in LPR_TAB, the the update_flag is set to y , otherwise it is n .
AGE The age of the client. Is updated every morning.
SEC_PHONE_NO Flag indicating that the client has a secret phone number (y/n)
RES_ELD Flag that indicates if the client stays at residential home
RES_ELD_DATE The date where the client moved to the residential home
ENT_KEY The number of the entry phone
EMERG_KEY_REASON The reason why the emergcy call was given to the client
PHONE_SUB Does the client have a dedicated phone for aid (y/n)
PHONE_SUB_REASON The reason why a dedicated phone was given to the client
MED_DELIVERY The place where the clients medicine is delivered
WAIT_CLEAN_DATE The date where the client was put on a waitinglist for housecleaning
BANKACCOUNT The bankaccount number of the client
PART_NR Contain the partition number for client. The partitions are defined in user_partition.
SPC_DOCTOR_NAME special doctor name
SPC_DOCTOR_PHONE_NO special doctor phone number
LIVES_ALONE y/n
RES_TYPE_NO residence type
SECRET_ADDR y/n to secret adress
PHONE_MOBILE cell phone number
EMAIL email
CLIENT_NO client number
DEATHDATE death date
SPC_DOCTOR2_NAME special doctor name for second doctor
SPC_DOCTOR2_PHONE_NO special doctor phone number for second doctor
ALLOW_DATA_EXCHANGE y/n
DRUG_RESPONSIBLE ini from personnel
EMERG_KEY_SERIAL sertial number
EUREF89_EAST GIS data
EUREF89_NORTH GIS data
ZONE_NO zone number
PARTNER_MARITAL_STAT_NO The partners marital status
CERT_ID_NO Certificate id number
PEN_CARD_ID ID of pen-card used for identifying client using interface PEN_til_CARE
MUNICIPALITY_NO municipality_no when coorporation
ADDR_NAME Name to be displayed on correspondance
PENSION_NO Pension type
SECURITY_AGREEMENT Indicates whether a security agreement exists at clients house
MEDICINE_NOTE Note about clients medicine
TERMINAL_START Start date of terminal care
TERMINAL_END End date of terminal care