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

PACKAGES


Beskrivelse ?

Packages indeholder én formulation i én pakning. Dvs. en formulation kan have ingen, en eller flere pakninger. En pakning indeholder både PackSize+MeasureUnitId og en PackSizeText der oftest er sammensat af disse to felter, men også kan indeholde anden og/eller yderligere information. F.eks. kan PackSize være 500 og MeasureUnitId relatere til ml, og med en PackSizeText "500 ml (5x100 ml)". Teksten anvendes i taksten. Desuden indeholder tabellen information omkring priser, f.eks. AIP (apotekernes indkøbspris)

Størrelse (Antal rækker) ?

39481

Indhold (Kolonner/variable) ?

Navn Indhold
PACKAGEID Primærnøgle for tabellen PACKAGES. Ikke databærende.
PACKAGEVID VersionID for Packages
AIP Apotekets indkøbspris, i øre.
COMMENT Kommentar.
EURAIP EU apotekets indkøbspris i øre.
EURPRICECHANGEDATE Dato for seneste indberetning af EU-gns.pris
MARKETINGDATE Markedsføringstilladelsesdato
NOSUPPLY Flag der indikerer at pakningen er i leveringssvigt.
NUMBEROFDDD Angiver antal Daglig Definerede Doeseringer der findes per pakning
PACKSIZE Numerisk pakningsstørrelse SWEDIS : packs.packsize
PACKSIZETEXTDK Tekst på dansk for PACKAGES
PACKSIZETEXTEN Tekst på engelsk for PACKAGES
PACKSTOPDATE Pakning slettet af taksten, præparat aktivt.
PACKWITHDRAWALDATE Pakning/præparat slettet af specialitetsregister.
PRICECHANGEDATE Dato for sidste prisændring.
PRODUCTNO Produktnummer (nordisk varenummer).
PRODUCTNOPARTPACK Varenummer for delpakning i multipakning.
QUANTITYMULTIPACK Antal delpakninger i multipakning
SEQUENCENO Løbenummer for varenummer (start = 0).
SEQUENCENOPARTPACK Hvis ProductNoPartPack er forskellig fra 0 sættes værdien til 0, ellers null.
SORTINGCODE Sorteringskode.
VALIDFROM Gældende fra.
VALIDTO Gældende til.
CREATEDBY Oprettet af
CREATEDBYSYSTEM Oprettet af system
CALCMETHODID Fremmed nøgle til tabellen CALCMETHODS(CALCMETHODID)
FORMULATIONID Fremmed nøgle til tabellen FORMULATIONS(FORMULATIONID)
ORGANISATIONID Fremmed nøgle til tabellen ORGANISATIONS(ORGANISATIONID)
PACKAGEREGSITUATIONID Fremmed nøgle til tabellen PACKAGEREGSITUATIONS(PACKAGEREGSITUATIONID)
PACKSIZEUNITID Primær nøgle for tabellen Packages. Ikke databærende.
PACKTYPEID Fremmed nøgle til tabellen PACKTYPES(PACKTYPEID)
PRICETYPEID Fremmed nøgle til tabellen PRICETYPES(PRICETYPEID)
WITHDRAWREASONID Fremmed nøgle til tabellen WITHDRAWREASONS(WITHDRAWREASONID)
SUPPLYESTIMATE Producentens seneste indberettet estimat af leveringsevne
SUPPLYPROBLEM Indikerer at producentens seneste estimat af leveringsevne er ikke tilstrækkeligt til at tage pakningen med i beregning af tilskudsprisen
APPLICATIONDATE Ansøgningsdato.
PRODNOREQCOUNTRIES Lande, der parallelimporteres fra, og derfor ikke krævedes stregkode, dengang, kolonnen var i anvendelse i forgængersystemet (Anvendes ikke)
PRODNOREQBARCODENEEDED Status for om stregkode ikke er tilstede på pakning (Anvendes ikke)
PRODNOREQSUPPLIERNUMBER Leveringsevne/-estimat, angivet af MT-indehaver eller dennes repræsentant, benyttet til leveringsevnevurdering
PLANNEDEXPIRATIONDATE Dato for hvornår en pakning er sat til at udgå.
CALCTYPEID Fremmed nøgle til tabellen CALCTYPES(CALCTYPEID)