| Contact_ID |
Primary key for the table |
| Cosmic_ID |
COSMICs unique ID for the contact |
| Cosmic_Key |
COSMICs unique version ID for the Contact |
| ContactType |
ID for Contacttype |
| ContactType_Name |
Contacttype in plain |
| ContactType_Desc |
Given description for contacttype |
| Status |
ID for the status of the contact |
| Status_Name |
Name for the status of the contact |
| Status_Desc |
Statusdescription for the contact |
| Active |
Indicates with Ja/Nej if contact is active |
| Agreement |
Reference to the agreement |
| PatientFee |
PatientFee for the object in F_CONTACT |
| Identification |
Way of Identification |
| PlanAction |
Reference to the planed action=planningform |
| Acute |
indicates with ja/nej if contact is set as acute |
| VisitLevel |
Visittype |
| Customer |
Customer for the object in F_CONTACT |
| Offer |
Offer for the object in F_CONTACT |
| Creator_ID |
User_ID for who created or made latest change on contact |
| Created_Datetime |
Timestamp for when contact was created/latest changed |
| CustomerUnit |
Customer unit |
| Responsible_Unit_ID |
Responsible unit |
| Responsible_Staff_ID |
Responsible staff |
| Performing_Unit_ID |
Performing unit |
| Performing_Staff_ID |
Performing staff |
| Contact_Start |
Contact start |
| Contact_End |
Contact end |
| SOC_ID |
Reference to the patient |
| SOC_C |
SOC_C for the object in F_CONTACT |
| SOC_G |
Reference to the group which this contact is a part of |
| Commitment_ID |
Reference to the Commitment |
| Amount |
Total amout for patient to pay including goods etc. |
| Active_Trans |
Indicates with Ja/Nej if trasnaction is active. Nej=latest transaction is cancelled |
| TaxeCodeRef |
Reference to the patientfee |
| Trans_Date |
Transaction date |
| Trans_User |
User who made the transaction |
| CashRegisterLocationRef |
Reference to cash register location |
| CashRegister |
Reference to the cashregister |
| Payment_Type |
ID for payment type |
| Payment_Name |
Name for payment type |
| InvoiceNumber |
Invoice number |
| Vat |
VAT |
| T_PatientFee |
Patientfee in money |
| PatientFeeByAction |
PatientFeeByAction for the object in F_CONTACT |
| Discount |
Discount |
| TravelDiscount |
Traveldiscount |
| TravelDiscountCard |
TravelDiscountCard |
| TravelCarTo |
TravelCarTo |
| TravelCarFrom |
TravelCarFrom |
| TravelCarCompensation |
TravelCarCompensation |
| TravelBusFee |
TravelBusFee |
| OwnFee |
OwnFee |
| TravelOther |
TravelOther |
| TravelFeeDiagnosis |
TravelFeeDiagnosis for the object in F_CONTACT |
| UserValue |
Userinduced patientfeechange |
| Sex |
Sex |
| Age |
Age when contact started |
| Geo_ID |
Reference to the geographical instance |
| CA_coordinatedCarePlanning |
CA_coordinatedCarePlanning for the object in F_CONTACT |
| CA_medTreatPayDays |
CA_medTreatPayDays for the object in F_CONTACT |
| CA_medTreatCity |
CA_medTreatCity for the object in F_CONTACT |
| CA_registrationType |
Admissiontype |
| CA_dischargeType |
Dischargetype |
| CA_secrecyType |
Secracytype |
| CA_ongoingComment |
CA_ongoingComment for the object in F_CONTACT |
| CA_passedAway |
Date for deceased if occures before discharge |
| CA_postregArea |
CA_postregArea for the object in F_CONTACT |
| CA_postregInvoiceTxt |
CA_postregInvoiceTxt for the object in F_CONTACT |
| CA_postregCommissionID |
CA_postregCommissionID for the object in F_CONTACT |
| CA_postregOfferPrice |
CA_postregOfferPrice for the object in F_CONTACT |
| CA_medTreatPayDate |
CA_medTreatPayDate for the object in F_CONTACT |
| CA_medTreatCallDate |
CA_medTreatCallDate for the object in F_CONTACT |
| CA_Valuables |
Valuables |
| CA_OverviewPlacement |
Acuteoverview : Placement |
| CA_OverviewPlacementName |
Acuteoverview : Placement name |
| CA_OverviewProblem |
Acuteoverview : Problem |
| CA_OverviewCareProviderDate |
Acuteoverview : Care provider date |
| CA_OverviewAbsence |
Acuteoverview : Absence |
| CA_OverviewAbsenceDate |
Acuteoverview : Absence date |
| CA_OverviewEnd |
Acuteoverview : End |
| CA_OverviewEndDate |
Acuteoverview : End date |
| CA_OverviewReasonForWait |
Acuteoverview : Reason for wait |
| CA_OverviewCommitment |
Acuteoverview : Commitment |
| CA_OverviewOffer |
Acuteoverview : Offer |
| CA_PatientClassification |
CA_PatientClassification for the object in F_CONTACT |
| visitCost |
visitCost for the object in F_CONTACT |
| visitCostRef |
visitCostRef for the object in F_CONTACT |
| cancellationReason |
Cancelation reason |
| Sysdate |
Date when record got loaded/updated in CI |
| Contact_Start_Period |
Reference to the periodical instance |
| Contact_End_Period |
Reference to the periodical instance |
| AdmittedFrom_Unit_ID |
Admitted from unit-reference |
| DischargedTo_Unit_ID |
Discharged to unit-reference |
| DischargeStaff_ID |
DischargeStaff_ID for the object in F_CONTACT |
| GroupContact_ID |
Reference to the Contact |
| ViV_FirstContact |
ViV_FirstContact for the object in F_CONTACT |
| ViV_TreatmentDecision |
ViV_TreatmentDecision for the object in F_CONTACT |
| ViV_DecisionDate |
ViV_DecisionDate for the object in F_CONTACT |
| ViV_Diagnosis |
ViV_Diagnosis for the object in F_CONTACT |
| ViV_PlannedAction |
ViV_PlannedAction for the object in F_CONTACT |
| Continued_Careplan |
Continued careplan |
| Planned |
Indicates with true/false if contact is set as planned |