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 |