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

Employee


Beskrivelse ?

Each row in this table corresponds to an employee/user. Unique identifier for the employee/user

Størrelse (Antal rækker) ?

193

Indhold (Kolonner/variable) ?

Navn Indhold
id Id - increased number
DateCreated Date of creation
DateUpdated Date of updated
DateDeleted Date of deletion
CreatedBy Created by user
UpdatedBy Updated by user
DeletedBy Deleted by user
GUID UniqueIdentifier
NationalityCode ISO country code
CPRnr Personal CPR no
BirthDate Employee date of birth
DeathDate Employee death date
Sex Male, Female
PreferredName Prefferede title name
FirstName First name of employee
LastName Last name of employee
Title Titel of employee
Notes E.g. notes
ProtectedAddress Private adddress of employee
Location Location of employee
Road Road name for employee
HouseNum House number
ZipNum Zip number
ZipString Zip postal string
ZipText Zip Text name
Country Country name
CountryCode Country code ISO
TemporaryRoad Temporary road name of employee
TemporaryHouseNum Temporary house number of employee
TemporaryZipNum Temporary zip for employee
TemporaryZipString Temporare zip string for employee
TemporaryZipText Temporary zip text for employee
TemporaryCountry Temporary country name
TemporaryCountryCode Temporay iso country code
ProtectedContactInfo Protected contact information
PhonePrivate Private phone of employee
PhoneJob Job phone for for employee
MobilePrivate Mobile private for employee
MobileJob Mobile job for employee
FaxPrivate Fax private
FaxJob Fax job
EmailPrivate Private email of employee
EmailJob Job email for employe
alias_ alias name for employee
domain_ Domain name of employee
Username Username of employee
Password Password of employee
PasswordEncrypted Encrypted password
PasswordChangeAtLogon Determe if passwords needs tobe change upon login
PasswordChangedDate Change date of password
LastLogin Last login date
Locked If account is lockd out
Contact Contact person for employee
Hidden If employee is hidden
Inactive If employee is inactive
Classification Classification level for employee
OrgUnitType Organitzation unit
OrgUnitCode Organitzation unit