Søgning » Katalog af Totaloplysninger » COMMONLMS_03_04_24

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

COMMONLMS_03_04_24


Beskrivelse ?

Til internt brug. Tabellen indeholder udtræksdata fra KAT databasen som danner basis for beregninger i LMS03, LMS04, LMS24

Størrelse (Antal rækker) ?

52614078

Indhold (Kolonner/variable) ?

Navn Indhold
COMMONLMS_03_04_24ID Primærnøgle for tabellen COMMONLMS_03_04_24. Ikke databærende.
PRODUCTNO Varenummer SWEDIS : packs.nvnr
AIP Apotekets indkøbspris, i øre.
EURAIP EU apotekets indkøbspris
CALCMETHODCODE Beregningskode AIP -> reg.pris. Tilhørende klartekst i LMS13 SWEDIS : packs.ctype
FINISHINGFEE Færdigfremstillingsgebyr SWEDIS : rpextemp.nvnr
PACKSIZE Numerisk pakningsstørrelse SWEDIS : packs.packsize
REIMBURTYPECODE Sygesikringskode, tilhørende klartekst i LMS16 SWEDIS : packs.reimburs
DISPGRPDETAILCODE Udleveringsbestemmelse, kode. Tilhørende klartekst i LMS18 SWEDIS : packpres.ppres
FORMULATIONREGSITUATIONCODE Kode, svarende til registreringssituation (regsit),talkoder der angiver en status for en formulation
PACKAGEREGSITUATIONCODE talkoder der angiver markedsføringsforhold for en pakning
PACKAGEGROUPNO Substitutionsgruppenummer for pakninger.
FORMULATIONGROUPNO Lægemidlets subst.gruppe SWEDIS : gensub.gengrp
DRUGNAME Lægemiddel navn
DRUGID DrugID er et unikt ID på 11 cifre for et lægemiddel, sammensat af formuleringens type, markedsføringstilladelsesnummer og to cifre for årstal. F.eks. 2810324300
DOSAGEDISPENSING Egnet til dosisdispensering, Værdier: if DosageDispensering == 1 -> D ellers blank SWEDIS : drugs.dosdisp
REGISTERPRICE Pakningens registerpris beregnes ud fra den indtastede AIP (apoteksindkøbspris). Det foregår ud fra beregningsformler, som er fastlagt af Sundhedsministeriet i en bekendtgørelse.
ESP_TOTALPRICE ekspeditionens samlede pris (ESP) ESP (Ekspeditionsprisen) = registerpris + recepturgebyr og evt. færdigbehandlingsgebyr De 2 gebyrer er fastlagt af Sundhedsministeriet i en bekendtgørelse
EU_ESP_EURAVGPRICE EU-gennemsnitspris (EU-ESP) Europæisk "ekspeditionspris" beregnes på samme måde som den danske ESP, men grundlaget for beregningen er pakningens europæiske AIP.
TSP_REIMBURPRICE Tilskudspris. Udfyldes kun for pakninger i tilskuds-system. Se specifikation for tilskudsprissystemet for beregning.
IBP_REPORTPRICE indberetningspris (IBP) For pakninger med en defineret TSP
BGP_CALCPRICE beregningsgrundlagspris (BGP) Er identisk med IBP (LMS03, felt 06)
HOSPPRICE Leverancepris til hospitaler (pt.blank)
VETPRICE leverancepris til dyrlæger
NOREIMBURSEAMOUNT pris på ikke-tilskudsberettiget del af pakningen
ALPHASEQUENCE 1. Seks bogst + index (001,002 osv)
PRODUCTCODE Kode for billigste pakning
BESTPRICEDPRODUCTNO Varenummer for billigste pakning
AIP_MINUNITPRICE Laveste AIP/PackSize per DrugID - LMS24
REGISTER_MINUNITPRICE mindste registerpris pr. enhed (ERP)
BGP_MINUNITPRICE beregningsgrundlagspris pr. enhed (EBP)
DRUGCODE kode for billigste Drugid
BESTPRICEDDRUGID Henvisning til billigste Drugid
FORMULATIONID Primær nøgle for tabellen CommonLMS_03_04_24. Ikke databærende. Fremmed nøgle til tabellen FORMULATIONS(FORMULATIONID)
PACKAGEID Primær nøgle for tabellen CommonLMS_03_04_24. Ikke databærend, Fremmed nøgle til tabellen PACKAGES(PACKAGEID)
DAYSSINCESTOP brugt internt
DAYSSINCEWITHDRAW brugt internt
ATCCODE ATC kode. Tilhørende klartekst i LMS12
NOSUPPLY angiver hvorvidt pakningen er gået i leveringssvigt
PRICETYPECODE angiver om prisen er Dansk, Eur, Parallel Import eller Parallel Distrib.
TAKSTPRODUCTIONID Fremmed nøgle til tabellen TAKSTPRODUCTIONS(TAKSTPRODUCTIONID)
NUMBEROFDDD Angiver antal Daglig Definerede Doeseringer der findes per pakning
SUPPLYESTIMATE Et tal angivet af pakningens distributør ifbm. pris- eller sortimentsændring som angiver hvor mange pakninger vedkommende forventer at kunne leverer i den kommende takst periode
SUPPLYPROBLEM Resultat af en beregning af producentens leveringsevne estimat og LØK-STATs statistikker over efterspørgsel på markedet. Skulle producenten ikke kunne levere pakninger i tilstrækkelige mængder, indgår deres prisindmelding IKKE i tilskudsprisberegninger.
PLANNEDEXPIRATIONDATE Dato for hvornår en pakning er sat til at udgå. (I de foregående tre prisperioder før PlannedExpirationDate bliver der ikke foretaget leveringsevnevurdering af denne pakning.)