Dansk Familieambulatorie Database

Tabeloversigt ?
BASISOPLYSNINGER_History
BASISOPLYSNINGER
LaegeUndersoegelser_History
LaegeUndersoegelser
FOEDSELAFSLUTNING_History
FOEDSELAFSLUTNING
PsykUndersoegelser_History
PsykUndersoegelser
BASISOPLYSNINGERBARN_History
BASISOPLYSNINGERBARN
Patient_History
Patient
BESOEG_History
BESOEG
Employee
NeuropsykTest
Indlaeggelser_History
Indlaeggelser
BESOEGBARN_History
BESOEGBARN
BRIEF_History
BRIEF
Bayley_History
Bayley
DataDictionaryTable
arrayUrinscreeningBesoeg1ERus_History
arrayUrinscreeningBesoeg1ERus
arrayBarnAfslFA_History
arrayPartnerAlderNationalitetBasis_History
OrgUnit_History
arrayBarnAfslFA
arrayPartnerAlderNationalitetBasis
OrgUnit
TvaerSektionelleMoeder_History
TvaerSektionelleMoederEfter_History
arrayTidlFoedslerLevendeFoedteBasis_History
TvaerSektionelleMoeder
TvaerSektionelleMoederEfter
WPPSI_History
arrayAktuelInfektionsStatusBesoeg_History
arrayIndlaeggelseBesoeg_History
arrayTidlFoedslerLevendeFoedteBasis
WPPSI
arrayAktuelInfektionsStatusBesoeg
arrayIndlaeggelseBesoeg
arrayTidlFoedslerLevendeFoedtDoedBasis_History
arrayTidlFoedslerLevendeFoedtDoedBasis
VurderingTilknytning_History
arrayForbrugRus_History
VurderingSamspil_History
VurderingTilknytning
arrayBesoegRaekkeBesoegB_History
arrayForbrugRus
arrayTidlForbrugRus_History
VurderingSamspil
arrayBesoegRaekkeBesoeg_History
arrayBesoegRaekkeBesoegB
arrayFoetaleMisBesoeg_History
arrayHenvAndenInstansBesoegB_History
arrayHenvAndenInstansLaegeBesoegB_History
arrayHenvisAndenInstansBesoegB_History
arrayHenvisningAndenInstansBesoegB_History
arrayIUGRBesoeg_History
arrayKompliUnderGraviBesoeg_History
arrayResult_atUndersoegelserBasisB_History
arraySuppUsLaegeBesoegB_History
arraySuppUsPsykBesoegB_History
arrayTidlForbrugRus
arrayTidlSetProfRegiGraviditetBasis_History
dateBehForloebBesoeg_History
dateNedtrapForloebBesoeg_History
dateSubForloebBesoeg_History
TvaersektorielleMoeder_History
arrayAktKontaktPsykBasis_History
arrayBesoegRaekkeBesoeg
arrayFoetaleMisBesoeg
arrayHenvAndenInstansBesoegB
arrayHenvAndenInstansLaegeBesoegB
arrayHenvisAndenInstansBesoegB
arrayHenvisningAndenInstansBesoegB
arrayIUGRBesoeg
arrayKompliUnderGraviBesoeg
arrayQAktuelBehRus_History
arrayResult_atUndersoegelserBasisB
arraySuppUsLaegeBesoegB
arraySuppUsPsykBesoegB
arrayTidlForbrugRusmidlerPartnerRus_History
arrayTidligereSygdomme1BNew_History
arrayTidlKontaktPsykSystemBasis_History
arrayTidlKontaktSomatiskSystemBasis_History
arrayTidlSetProfRegiGraviditetBasis
DataDictionaryField
dateBehForloebBesoeg
dateNedtrapForloebBesoeg
dateSubForloebBesoeg
TvaersektorielleMoeder
arrayAbnormDiagnoseBesoegB_History
arrayAktKontaktPsykBasis
arrayAktuelKontaktPsykSystem1BNew_History
arrayAktuelKontaktSomatiskSystem1BNew_History
arrayAktuelleSygdomme1BNew_History
arrayAnbefalBehovUnderGravTvaerSekUnder_History
arrayBarnefarPartnerSammePersBasis_History
arrayDoedeBoernBasis_History
arrayForbrugRusmidlerPartnerRus_History
arrayFAAnbefalingAfBehForForanstaltningerBesoeg_History
arrayFAAnbefalingBarnFamTvaerBasisB_History
arrayFAAnbefalingHjaelpTvaerBasisB_History
arrayHvadBlevDerSatIVaerkBesoeg_History
arrayHvadBlevSatIvaerkTvaerSekUnder_History
arrayQAktuelBehRus
arraySamtalerMedPsykolog1HUG_History
arrayTidlForbrugForudRus_History
arrayTidlForbrugRusmidlerPartnerRus
arrayTidligereSygdomme1BNew
arrayTidlKontaktPsykSystemBasis
arrayTidlKontaktSomatiskSystemBasis
arrayUdskrivningsdiagnoserIndlaegB_History
arrayAbnormDiagnoseBesoegB
arrayAktuelKontaktPsykSystem1BNew
arrayAktuelKontaktSomatiskSystem1BNew
arrayAktuelleSygdomme1BNew
arrayAnbefalBehovUnderGravTvaerSekUnder
arrayBarnDiagFoedselBasisB_History
arrayBarnefaderTidlForbrugRus_History
arrayBarnefarPartnerSammePersBasis
arrayBFAktForbrugRusmidlerRus_History
arrayDoedeBoernBasis
arrayEksponeretRusBasisB_History
arrayFoedselsDiagBasisB_History
arrayForbrugRusmidlerPartnerRus
arrayFAAnbefalingAfBehForForanstaltningerBesoeg
arrayFAAnbefalingBarnFamBehov_History
arrayFAAnbefalingBarnFamTvaerBasisB
arrayFAAnbefalingHjaelpBehov_History
arrayFAAnbefalingHjaelpTvaerBasisB
arrayHjaelpSatIVaerkAfsl_History
arrayHvadBlevDerSatIVaerkBesoeg
arrayHvadBlevSatIvaerkTvaerSekUnder
arrayHvilkenPraeventionAftaleAfsl_History
arraySamtalerMedPsykolog1HUG
arrayTidlForbrugForudRus
arrayUdskrivningsdiagnoserIndlaegB
arrayVurderingAfBehovAfsl_History
RUSMIDDELFORBRUG_History
arrayBarnDiagFoedselBasisB
arrayBarnefaderTidlForbrugRus
arrayBFAktForbrugRusmidlerRus
arrayEksponeretRusBasisB
arrayFoedselsDiagBasisB
arrayFAAnbefalingBarnFamBehov
arrayFAAnbefalingHjaelpBehov
arrayHjaelpSatIVaerkAfsl
arrayHvilkenPraeventionAftaleAfsl
arrayVurderingAfBehovAfsl
RUSMIDDELFORBRUG
FORLOEB_History
LogEntry
FORLOEB
Classification
DataDictionaryTableField
OrgUnitType
Marsaltabel
Session_
Log4NetLog
DataDictionary
DeploymentTarget
DataDictionaryEnum
DataDictionaryRelation
DataDictionaryTableComputation
Patch
Permission
Profile
EmployeeAssOrgUnit
OrgUnitTable
Param
PatientCheck
SexType
tbllist
AccessModeDenied
AccessModeRead
AccessModeWrite
Cardinality
ClassificationOrigin
DataType
EmployeeProfile
LogAction_Type
MaritalStatus
OrgUnitRelationType
OrgUnitTypeHierarchy
ProfilePermission
ZipCodeNumeric
AV_SygdomsDiagnoseKodeTabel
Tabel

LogEntry


Beskrivelse ?

This table holds entries for logged events in the user interface.

Størrelse (Antal rækker) ?

352377

Indhold (Kolonner/variable) ?

Navn Indhold
id Internal auto generated unique id for the log entry
Action_ Identifies the event type.
DateTime The date and time for logging the event
DateTimeStop The date and time the event ended if applicable. Mostly used in connection with long running events such as import of data.
Milliseconds The duration of the event if applicable
UserId Id of the logged in user that performed the action
EmployeeId Id of the employee being created/updated/deleted
PatientId Id of the patient associated with the event if applicable
TableName Name of the datadictionary table(dynamic table) associated with the event if applicable.
RecordId Id of the datadictonary (dynamic table) record associated with the event if applicable
OrgUnitType Type of organizational unit associated with the event if applicable
OrgUnitCode Code of organizational unit associated with the event if applicable
ImportType Type of import associated to the event. Applies only to import of data.
ImportFilename Name of file containing data for import associated to the event.Applies only to import of data.
Result_Type Type of result associated to the event if applicable. Applies mostly to import of data.
Result_Code Code of result associated to the event if applicable. Applies mostly to import of data.
Parameters_ Parameters associated with the event if applicable. Often usen in connection with searching for or importing data
Description Additional information in connection to the event if applicable.Often used in connection with creating new reords.
IPAddress IPAddress of the web request initiating the event. Depending on network configuration (routers, firewalls, DHCP, etc.), this may identy the client PC that initiated the event.
Session_Id Id of the session in which the event took place.