Søgning » CARE omsorgssystem » PERSNNEL

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

PERSNNEL


Beskrivelse ?

Tabel: PERSONNEL - Basic table for all employees

Størrelse (Antal rækker) ?

4974

Indhold (Kolonner/variable) ?

Navn Indhold
TITLE_NO Unique number
POSTCODE Postcode. In Denmark it is always 4 characters.
NAME First name(s) of the PERSONNEL.
SURNAME Surname of the PERSONNEL.
P_CPR_NO CPR-number for the PERSONNEL.
ADDR_STRT Address : Street, number, floor etc.
P_CPR_NO_EXTRA Extra cipher used in the end of the PERSONNELs CPR-number. Is used to identify where the PERSONNEL is working.
ADDR_PLC_NAME Place name.
PHONE_NO Telephone number of the PERSONNEL.
CALL_PHONE_NO If the PERSONNEL has a call telephone number, e.g to a mobile telephone.
OCCUPATION Occupation of the PERSONNEL, Should correspond more or less to EDUCATION, but not neccesarily.
START_DATE The date the PERSONNEL started working.
END_DATE IF the PERSONNEL is an ex-employee, then there is an end-date.
DISCH_CAUSE The reason why the PERSONNEL stopped working, e.g. retired. May be invisible for some local authorities.
INI A uniqe identifikation of each employee.
NOTE Notes about the PERSONNEL.
TRANSPORT What kind of transport the PERSONNEL is using to get to work, e.g. car , bike , by foot etc.
LAST_REV Revision date, is updated evry time the PERSONNELs conditions are changed.
EXTRA_HOURS Flag, the person wants extra hours of work, yes/no.
WATCH Char(1) distinguishing between day - D , evening - E or night visit.
REPRESENTATIVE The employee can be representative for his or her collegues.
WATCH_AUTO_TRANS Indicates if the employees data automaticly should be transferred to Kommunedatas scheduling system (y/n)
WATCH_TRANS_ST Indicates whether the employees data has been transferred or not (y/n)
REKV_YES_NO Does the employe get cloth rekvisitions
ACTIVE_FLAG Flag, the personnel is active, yes/no.
REKV_DATE The date where the employe got the first cloth rekvisition
INITIALS The employees initials
ROUTE Sometimes in the table the ini is not a physical person, but a route . Flag, the personnel is a route, yes/no.
SECRET_PHONE is phonenumber secret (y/n)
SECRET_ADDR is address secret (y/n)
CONTRACTOR y/n
MEET_FROM meeting hour start
MEET_TO meeting hour end
WORK_PHONE_NO work phone number
PERS_DISCH_NO discharge reson from pers_disch_reason
SUBSTITUTE ini from personnel
OFFICE_HOURS office hours
SERVICE_GROUP A new layer for personel (groups)
PRIV_SUPPL_NO Unique number from PRIVATE_SUPPLIER, only for routes
PEN_ID ID of pen used for identifying personnel using interface PEN_til_CARE
MUNICIPALITY_NO municipality number
ADDR_NAME Name to be displayed on correspondance
EMAIL Personnels email-address
PDC_PERSONID Unique identifier from PDC within the municipality
VP_INITIALS Unique identifier from PDC within the municipality
KMD_PAYTYPE KMD VP - payment-type (corresponds to aflonningsform)
NO_MOTOR_TRANSPORT Personnel only uses means of transportation without motors, e.g. bike, (y/n)
AVG_SPEED Average speed of personnel when using non-motorised transportation