Søgning » CARE omsorgssystem » ORDITION

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

ORDITION


Beskrivelse ?

Tabel: ORDINATION - Lists what ordination an ordinator (DOCTOR) has given.

Størrelse (Antal rækker) ?

50581

Indhold (Kolonner/variable) ?

Navn Indhold
C_CPR_NO The clients personal CPR-number (Centrale Person Register).
ORDINATION_DATE The date of the ordination.
ORDINATION_NO Unique number for every ordination for the CLIENT.
ORDINATOR The name of the ordinator, often a DOCTOR.
DISPENSE_TYPE_NO Is NO longer used
PREPARATION The name of the medicine ordinated.
DOSE The concentration of the medicine.
SEPONATION_DATE The date the treatment stops.
SEPONATOR The person stopping the treatment, often a DOCTOR.
AMOUNT_08 The amount of the medicine to be taken at the time in column TIME_2
DEVELOPMENT If the medicine amount is to be increased or decreased through the period, the way to do it is described here, e.g. Nedtrapning med 1 pille dagligt.
AMOUNT_12 The amount of the medicine to be taken at the time in column TIME_4
AMOUNT_16 The amount of the medicine to be taken at the time in column TIME_6
AMOUNT_20 The amount of the medicine to be taken at the time in column TIME_8
AS_REQUIRED The amount of the medicine to be taken when necessary, e.g. because of pain. Is found in TIME_9
ORDER_PERSON The person who picks up the medicine from the PHARMACY.
PRESCRIBED_DOSE The total prescribed dose
REMARKS Information about the ordination, e.g. known side effects.
MODULE_TYPE_NO Unique number of the module types
TIME_1 Time 1 of the day where the drug should be taken
TIME_2 Time 2 of the day where the drug should be taken
TIME_3 Time 3 of the day where the drug should be taken
TIME_4 Time 4 of the day where the drug should be taken
TIME_5 Time 5 of the day where the drug should be taken
DRUG_ID The unique number identfying the drug
DRUG_CAUSE Why the drug is given
DRUG_GROUP Used to group the clients ordinations
PRIORITY The priorityo of the drug
AMOUNT_06 The amount of the medicine to be taken at the time in column TIME_1
AMOUNT_10 The amount of the medicine to be taken at the time in column TIME_3
AMOUNT_14 The amount of the medicine to be taken at the time in column TIME_5
AMOUNT_18 The amount of the medicine to be taken at the time in column TIME_7
TIME_6 Time 6 of the day where the drug should be taken
TIME_7 Time 7 of the day where the drug should be taken
TIME_8 Time 8 of the day where the drug should be taken
TIME_9 Time 9 of the day where the drug should be taken
DISPENSE_TYPE_DESC The way the medicine is dispensed, i.e. tablets , liquid , spray etc.
CREATE_INI Id for user
SEPONATION_INI Id for user
SUBSTANCE_NAME The active substances name fo the prescribed drug