Søgning » Cambio Cosmic » F_CONTACT
Tabel

F_CONTACT


Beskrivelse ?

F_CONTACT - Facttable for contacts

Størrelse (Antal rækker) ?

81218

Indhold (Kolonner/variable) ?

Navn Indhold
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