Søg
Brug for hjælp?
Skriv til
data@sa.dk
og få hjælp til at:
finde det, du søger
forstå det, du har fundet
Søgning
»
Katalog af Totaloplysninger
»
CONTACTPERSONSHIST
Katalog af Totaloplysninger
Tabeloversigt
?
FORMULATIONSHIST
TRIALSHIST
COMMONLMS_03_04_24
FORMULATIONS
T_ORGANISATIONPROCESSESHIST
TRIALS
PACKAGESHIST
LMS02
T_ORGANISATIONPROCESSES
PACKAGES
LMS01
INSPECTIONSHIST
INSPECTIONS
ORGANISATIONSHIST
ORGANISATIONS
EMEAACTIVITIESHIST
EXCLUDEDPACKAGESHIST
DOSAGESHIST
EMEAACTIVITIES
EXCLUDEDPACKAGES
COUNTRIESHIST
DOSAGES
MONTHLYACCOUNTSHIST
PSURHIST
INDICATIONSHIST
MONTHLYENTRIESHIST
ADDRESSESHIST
COUNTRIES
EUREGULATIONSHIST
MONTHLYACCOUNTS
PERMISSIONSHIST
PHARMAFORMSHIST
PSUR
SUBSTANCESHIST
COMPOSITIONSUBSTANCESHIST
CONTACTPERSONSHIST
INDICATIONS
MEDHISTEPISODES
MONTHLYENTRIES
MONTHLYENTRYTYPESHIST
PHARMACIESHIST
SUBPROJECTSHIST
ADDRESSES
BASESUBSTANCESHIST
DISPGRPDETAILSHIST
EUREGULATIONS
LMS03
PERMISSIONS
PHARMAFORMS
PROJECTSHIST
ACTIVITYTYPESHIST
ANNUALFEETYPESHIST
CODETABLESHIST
COMPOSITIONSHIST
COMPOSITIONSUBSTANCES
CONTACTPERSONS
DEFINEDDAILYDOSES
DISPGRPSGENHIST
FORMULATIONPACKSIZESHIST
MEASUREUNITSHIST
MONTHLYENTRYTYPES
PACKTYPESHIST
PHARMACIES
PROCESSTYPESHIST
PRODUCTTYPESHIST
PSURCHANGESHIST
QUARANTINEREASONSHIST
REIMBURCLAUSESHIST
REIMBURTYPESHIST
SPECIALISTTYPESHIST
STORAGECONDSHIST
STORAGEINFOSHIST
SUBSTANCES
ANNUALFEESHIST
ATCCODESHIST
BASESUBSTANCES
DISPGRPDETAILS
FEESHIST
FORECASTENTRYTYPESHIST
FORMULATIONSYNONYMSHIST
LMS24
ORGANISATIONTYPESHIST
PRICECHANGESUBMISSIONSHIST
PROJECTS
REGIONSHIST
REIMBURSEMENTINTERVALSHIST
ROUTESOFADMHIST
SPECIALPRODUCTSHIST
SUBPROJECTS
ACTIVITYTYPES
AFTERHOURSPHARMACYTYPES
AFTERHOURSPHARMACYTYPESHIST
ANIMALSHIST
ANIMALTYPESHIST
ANNUALFEETYPES
ATCREVISIONSHIST
CALCTYPESHIST
CODETABLES
COMPOSITIONS
CONTACTPERSONROLESHIST
COUNTIESHIST
DISPGRPSGEN
DRUGDOMAINSHIST
DRUGTYPESHIST
EMEAACTIVITYTYPESHIST
EUREGULATIONTYPESHIST
FORECASTADJUSTMENTENTRIESHIST
FORECASTENTRIESHIST
FORMCOMPRELTYPESHIST
FORMULATIONPACKSIZES
FORMULATIONREGSITUATIONSHIST
GENERALORGANISATIONTYPESHIST
GROUPTYPESHIST
INSPECTIONRESULTTYPESHIST
LMS30
MEASUREUNITS
MONTHLYACCOUNTTYPESHIST
MONTHSHIST
ORGANISATIONRELATIONTYPESHIST
PACKAGEREGSITUATIONSHIST
PACKTYPES
PATIENTTYPESHIST
PERMISSIONREGSITUATIONSHIST
POSTCODESHIST
PRICETYPESHIST
PROCESSTYPES
PRODUCERTYPESHIST
PRODUCTDETAILTYPESHIST
PRODUCTTYPES
PROJECTRESULTSHIST
PROJECTTYPESHIST
PSURCASETYPESHIST
PSURCHANGES
PSURCOMMENTSHIST
PSURINTERVALSHIST
QUALITYSTANDARDSHIST
QUARANTINEREASONS
RECOMMENDATIONLEVELSHIST
REFGOODPRACTICECERTIFICATESHIST
REGISTRATIONDATETYPESHIST
REIMBURCLAUSES
REIMBURTYPES
REMARKSHIST
SOURCESHIST
SPECIALISTTYPES
STORAGECONDS
STORAGEINFOS
STORAGETYPESHIST
SUBSTANCEPLACEMENTSHIST
SUBSTANCETYPESHIST
TRIALARMSHIST
TRIALCONCLUSIONSHIST
TRIALCONTROLGROUPSHIST
TRIALINDICATIONSHIST
TRIALINITIATORSHIST
TRIALPHASESHIST
TRIALTREATMENTSITESHIST
UNITGROUPTYPESHIST
UNREGISTRATIONREASONSHIST
WHOROUTESOFADMHIST
ANNUALFEES
ATCCODES
FEES
FORECASTENTRYTYPES
FORECASTSHIST
FORMCOMPRELSHIST
FORMULATIONSYNONYMS
INSPECTORSHIST
LIFMAXPRICEPACKAGESHIST
ORGANISATIONCONTACTPERSONSHIST
ORGANISATIONSYNONYMSHIST
ORGANISATIONTYPES
PRICECHANGESUBMISSIONS
REFFORMULATIONGROUPSHIST
REFINSPECTIONSHIST
REGIONS
REGISTRATIONDATESHIST
REIMBURSEMENTINTERVALS
ROUTESOFADM
SPECIALPRODUCTS
SUBSTANCESYNONYMSHIST
ANIMALS
ANIMALTYPES
ATCREVISIONS
CALCTYPES
CONTACTPERSONROLES
COUNTIES
DEFERREDUPDATES
DEFERREDUPDATESVALUES
DRUGCLASSESHIST
DRUGDOMAINS
DRUGTYPES
EMEAACTIVITYTYPES
EUDRASEQUENCENUMBERSHIST
EUREGULATIONTYPES
FORECASTADJUSTMENTENTRIES
FORECASTENTRIES
FORMCOMPRELTYPES
FORMULATIONGROUPSHIST
FORMULATIONPACKTYPESHIST
FORMULATIONREGSITUATIONS
GENERALORGANISATIONTYPES
GROUPTYPES
INSPECTIONRESULTTYPES
LMS04
WITHDRAWREASONS
LMS28
MONTHLYACCOUNTTYPES
MONTHS
ORGANISATIONRELATIONSHIST
PACKAGEGROUPSHIST
PACKAGEREGSITUATIONS
PATIENTTYPES
PERMISSIONREGSITUATIONS
POSTCODES
PRICECHANGESTATUS
PRICETYPES
PRODUCERSHIST
PRODUCERTYPES
PRODUCTDETAILTYPES
PRODUCTFAMILIESHIST
PROJECTRESULTS
PROJECTTYPES
PSURCASETYPES
PSURCOMMENTS
PSURGROUPSHIST
PSURINTERVALS
QUALITYSTANDARDS
RECOMMENDATIONLEVELS
REFANIMALSANIMALTYPESHIST
REFCOUNTIESPOSTCODESHIST
REFFORMULATIONATCCODESHIST
REFFORMULATIONSANIMALSHIST
REFFORMULATIONSDOSAGESHIST
REFFORMULATIONSINDICATIONSHIST
REFFORMULATIONSROUTESOFADMHIST
REFFORMULATIONSTRIALSHIST
REFGOODPRACTICECERTIFICATES
REFINSPECTIONSEUREGULATIONSHIST
REFINSPECTIONSSUBSTANCESHIST
REFINSPECTORSHIST
REFORGANISATIONTYPESHIST
REFPACKAGEGROUPSHIST
REFPRODUCERTYPESHIST
REFREGIONSPOSTCODESHIST
REFREIMBURCLAUSESHIST
REFSPECIALISTTYPESHIST
REFSPECIALPRODUCTSHIST
REFSUBPROJECTRESULTSHIST
REFSUBSTANCESBASESUBSTANCESHIST
REGISTRATIONDATETYPES
REMARKS
SOURCES
STORAGETYPES
SUBSTANCEPLACEMENTS
SUBSTANCETYPES
TRIALARMS
TRIALCONCLUSIONS
TRIALCONTROLGROUPS
TRIALINDICATIONS
TRIALINITIATORS
TRIALPHASES
TRIALTREATMENTSITES
UNITGROUPSHIST
UNITGROUPTYPES
UNREGISTRATIONREASONS
WHOROUTESOFADM
DEFINEDDAILYDOSEGROUPSHIST
EUDRAFILENAMES
FORECASTS
FORMCOMPRELS
GOPROUPDATELOG
INSPECTORS
LIFMAXPRICEPACKAGES
LMS29
LMS31
LMS32
ORGANISATIONCONTACTPERSONS
ORGANISATIONSYNONYMS
REFFORMULATIONGROUPS
REFINSPECTIONS
REFORGANISATIONRELATIONTYPESHIST
REGISTRATIONDATES
SUBSTANCESYNONYMS
DRUGCLASSES
EUDRASEQUENCENUMBERS
FORMULATIONGROUPS
FORMULATIONPACKTYPES
LMS25
LMS26
ORGANISATIONPROCESSGROUPSHIST
ORGANISATIONRELATIONS
PACKAGEGROUPS
PRODUCERS
PRODUCTFAMILIES
PSURGROUPS
REFANIMALSANIMALTYPES
REFCOUNTIESPOSTCODES
REFFORMULATIONATCCODES
REFFORMULATIONSANIMALS
REFFORMULATIONSDOSAGES
REFFORMULATIONSINDICATIONS
REFFORMULATIONSROUTESOFADM
REFFORMULATIONSTRIALS
REFINSPECTIONSEUREGULATIONS
REFINSPECTIONSSUBSTANCES
REFINSPECTORS
REFORGANISATIONTYPES
REFPACKAGEGROUPS
REFPRODUCERTYPES
REFREGIONSPOSTCODES
REFREIMBURCLAUSES
REFSPECIALISTTYPES
REFSPECIALPRODUCTS
REFSUBPROJECTRESULTS
REFSUBSTANCESBASESUBSTANCES
UNITGROUPS
DEFINEDDAILYDOSEGROUPS
LMS05
LMS07
LMS09
LMS15
LMS23
REFORGANISATIONRELATIONTYPES
LMS18
LMS27
ORGANISATIONPROCESSGROUPS
LMS10
LMS11
LMS12
LMS14
LMS16
LMS17
LMS19
LMS20
LMS22
OBJECT_REFERENCE
OBJECT_REFERENCE_RELATION
LMS13
LMS21
Tabel
CONTACTPERSONSHIST
Beskrivelse
?
hist: Persons within Organisations
Størrelse (Antal rækker)
?
4562
Indhold (Kolonner/variable)
?
Navn
Indhold
CONTACTPERSONID
Del af Primærnøgle for tabellen CONTACTPERSONSHIST. Ikke databærende.
CONTACTPERSONVID
VersionID for CONTACTPERSONSHIST. (del af Primær nøgle)
GIVENNAME
Fornavn
MIDDLENAME
Mellemnavn
FAMILYNAME
Efternavn
TITLE
Titel
TELEPHONEEXTENSION
Telefon-lokalnummer.
TELEPHONENO
Telefonnummer.
EMAIL
Email adresse.
VALIDFROM
Gældende fra.
VALIDTO
Gældende til.
CREATEDBY
Oprettet af
CREATEDBYSYSTEM
Oprettet af system
ADDRESSID
Fremmed nøgle til tabellen ADDRESSESHIST(ADDRESSID)
DELETEDBY
Slettet af
DELETEDBYSYSTEM
Slettet af system
Top