Søgning » Katalog af Totaloplysninger » REFFORMULATIONATCCODESHIST

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

REFFORMULATIONATCCODESHIST


Beskrivelse ?

hist: Referencetabel Relaterer en formulation med en ellere flere ATCCodes OBS! Der er p.t. nogen uenighed omkring hvor mange ATC-koder der kan tilknyttes en Formulation. Swedis anvender kun en, og der findes kun en i taksten. Derimod findes der andre organisationer der anvender flere ATC koder på samme Formulation. Der bør ikke tilknyttes mere end en ATC kode til samme Formulation uden at det er afklaret hvordan dette behandes i taksten.

Størrelse (Antal rækker) ?

318507

Indhold (Kolonner/variable) ?

Navn Indhold
REFFORMULATIONATCCODEID Del af Primærnøgle for tabellen REFFORMULATIONATCCODESHIST. Ikke databærende.
REFFORMULATIONATCCODEVID VersionID for REFFORMULATIONATCCODESHIST. (del af Primær nøgle)
VALIDFROM Gældende fra.
VALIDTO Gældende til.
CREATEDBY Oprettet af
CREATEDBYSYSTEM Oprettet af system
FORMULATIONID Fremmed nøgle til tabellen FORMULATIONSHIST(FORMULATIONID)
ATCCODEID Fremmed nøgle til tabellen ATCCODESHIST(ATCCODEID)
DELETEDBY Slettet af
DELETEDBYSYSTEM Slettet af system