Brug for hjælp?
Skriv til data@sa.dk og få hjælp til at:

finde det, du søger
forstå det, du har fundet

Søgning » Cambio Cosmic » DC_PAT_ADDRESS

Cambio Cosmic

Tabeloversigt ?

F_CONTACT
F_REQUEST
F_OMREQUEST
F_JOURNALNOTE
FC_CONTACT
SYNSREGISTERET
FC_OMINVESTIGATION
D_AGREEMENT
FC_CONTACT_BILLING
SO_SYNSREGISTER
D_PRODUCTCLASS
F_OMREPORT
F_OMRESULT
DC_AGR_PRICE
DC_PRODUCTCLASS_PERIOD
D_OFFER
D_PERIOD
FC_JOURNALRECORD
F_COMMITMENT
D_KEYWORD
D_STAFF
FC_CONTACT_PRODUCTCLASS
FE_CONTACT_PRODUCTSTATUS
SO_PATIENTDATA
D_CASHREGISTER
D_ORGANISATION
FC_CODES
D_PATIENT
DC_ORG_ADDRESS
DC_PAT_ADDRESS
DV_TERM
D_SERVICE
D_TERM
D_JOURNALFORM
D_TYPE
FC_OMMEDINFO
FC_CONTACT_CANCELLATION
FC_CONTACT_CARECOST
DC_ORG_ID
DC_ORG_PHONE
DC_PAT_EMAIL
DC_PAT_ID
DC_PAT_PHONE
DC_STAFF_EMAIL
DC_STAFF_UNIT_RELATION
FC_CONTACT_FURLOUGH
DC_ORG_EMAIL
D_FIXEDVALUE
D_CONCEPT
D_PROFESSION
SO_OEJENDIAGNOSER
EXTERNAL_FILES
SO_ALMENDIAGNOSER
SUPERMAX_JOURNALER
FE_CONTACT_RELATION
MAP_USER_ID_TO_COSMIC_ID

Tabel

DC_PAT_ADDRESS

Beskrivelse ?

DC_PAT_ADDRESS - Dimension child table with patientaddresses

Størrelse (Antal rækker) ?

123332

Indhold (Kolonner/variable) ?

Navn	Indhold
DC_Pat_ID	Primary key for the table
Cosmic_ID	COSMICs unique ID for the patient
Type	ID for type of address
Co	Care of address in plain.
Street_Address	Street address in plain.
Postal_Code	Postal code in plain.
City	City in plain.
Country_Code	Country code in plain.
Country_Name	Country Name in plain.
Label	Several identifiers of the same type will have different labels.
Comment	Possible comment to current address
Type_Name	Name for type of address
Sysdate	Date when record got loaded/updated in CI