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 » COMPOSITIONSUBSTANCESHIST

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

COMPOSITIONSUBSTANCESHIST


Beskrivelse ?

hist: For en given komposition angiver denne tabel de substanser der indgår. Mængden angives i WeightVolume og substansen via relationen til Substances tabellen. For en formulation af panodil fås f.eks: 571142, STEARINSYRE 1039027, PARACETAMOL 77321858, VAND, RENSET 90033980, POVIDON 148079667, TALCUM 246346156, KALIUMSORBAT 9900007560, MAJSSTIVELSE 9900007606, STIVELSE, PREGELATINERET Første kolonne er casNo / lmsCasNo for de to sidste substanser

Størrelse (Antal rækker) ?

358256

Indhold (Kolonner/variable) ?

Navn Indhold
COMPOSITIONSUBSTANCEID Del af Primærnøgle for tabellen COMPOSITIONSUBSTANCESHIST. Ikke databærende.
COMPOSITIONSUBSTANCEVID VersionID for COMPOSITIONSUBSTANCESHIST. (del af Primær nøgle)
COMMENT Kommentar
WEIGHTVOLUME Vægt eller volumen for én substans i kompositionen. Anvendes i sammenhæng med relationen til MeasureUnit. Denne værdi er i forhold til Compositions.DeclarationWeightVolume.
VALIDFROM Gældende fra.
VALIDTO Gældende til.
CREATEDBY Oprettet af
CREATEDBYSYSTEM Oprettet af system
COMPOSITIONID Fremmed nøgle til tabellen COMPOSITIONSHIST(COMPOSITIONID)
SUBSTANCEPLACEMENTID Fremmed nøgle til tabellen SUBSTANCEPLACEMENTSHIST(SUBSTANCEPLACEMENTID)
SUBSTANCEID Fremmed nøgle til tabellen SUBSTANCESHIST(SUBSTANCEID)
QUALITYSTANDARDID Fremmed nøgle til tabellen QUALITYSTANDARDSHIST(QUALITYSTANDARDID)
SUBSTANCETYPEID Fremmed nøgle til tabellen SUBSTANCETYPESHIST(SUBSTANCETYPEID)
MEASUREUNITID Fremmed nøgle til tabellen MEASUREUNITSHIST(MEASUREUNITID)
DELETEDBY Slettet af
DELETEDBYSYSTEM Slettet af system