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

Patient


Beskrivelse ?

Each row in the patient table holds general data about one patient.

Størrelse (Antal rækker) ?

5960

Indhold (Kolonner/variable) ?

Navn Indhold
id The id uniquely identifies one patient
DateCreated The date and time on which the patient was created
DateUpdated The date and time on which the patient was last updated
DateDeleted The date and time on which the patient was logically deleted
CreatedBy Refers to the user that created the patient
UpdatedBy Refers to the user that was the last one to update the patient
DeletedBy Refers to the user that logically deleted the patient
GUID GUID
NationalityCode Refers to an organizational unit in the OrgUnit table that corresponds to a country.
CPRnr Unique id for the patient (central person register id). Can be expanded to hold other types of identifiers.
BirthDate The patients birth date
DeathDate The patients death date
Sex The patients sex. Refers to the SexType table.
PreferredName The patients preferred name
FirstName The patients first name
LastName The patients last name
Title The patients title
Notes Notes about the patient
ProtectedAddress Whether the patients address is protected
Location The location part of the patients address.
Road The road part of the patients address.
HouseNum The house number part of the patients address.
ZipNum For holding numeric zip codes. ZipCode text can be found in lookup table ZipCodeNumeric if it exists. If this is not the case the ZipText table is used for holding the zipcode text.
ZipString For holding non numeric zip codes. ZipCode text can be stored in lookup table or in ZipText column.
ZipText If no lookup table exists for finding text for ZipNum or ZipString, ZipText can be used for holding this text.
Country The full name of the patients country of origin
CountryCode A code referring to a row in the OrgUnit table holding the patients country of origin
TemporaryRoad The road part of the patients temporary address
TemporaryHouseNum The house number part of the patients temporary address
TemporaryZipNum The numeric zip code part of the patients temporary address
TemporaryZipString The non numeric zip code part of the patients temporary address
TemporaryZipText The zip code text part of the patients temporary address
TemporaryCountry The patients temporary country of origin
TemporaryCountryCode Refers to row in OrgUnit holding the patients temporary country of origin
ProtectedContactInfo Whether the patients contatct info is protected
PhonePrivate The patients private phone number
PhoneJob The patients work phone number
MobilePrivate The patients private mobile phone number
MobileJob The patients work mobile phone number
FaxPrivate The patients private fax number
FaxJob The patients work fax number
EmailPrivate The patients private email address
EmailJob The patients work email address
ConsentDate The date the patient gave consent that data about the patient can be used.
Password The patients password
PasswordEncrypted The patients encrypted password
PasswordChangeAtLogon Whether the patient should change the password at next logon
PasswordChangedDate Date for last password change
OrgUnit_TYPE Part of patient address. Refers (together with OrgUnit_CODE) to a row in the OrgUnit table
OrgUnit_CODE Part of patient address. Refers (together with OrgUnit_TYPE) to a row in the OrgUnit table
OrgUnit2_TYPE NOT USED
OrgUnit2_CODE NOT USED
TemporaryOrgUnit_TYPE Part of patient temporary address. Refers (together with TemporaryOrgUnit_Code) to a row in the OrgUnit table
TemporaryOrgUnit_CODE Part of patient temporary address. Refers (together with TemporaryOrgUnit_Code) to a row in the OrgUnit table
MaritalStatus The patients marital status
CoverageGroup The patients coverage group
GPReferenceNumber The patients general practitioner reference number
GPName The patients general practitioner name
GPPhone The phone number of the patients general practitioner
GPRoad The road part of the patients general practitioner address
GPHouseNum The house number part of the patients general practitioner address
GPZipNum The numeric zip code part of the patients general practitioner address