Søgning » Cambio Cosmic » FC_CONTACT_BILLING
Tabel

FC_CONTACT_BILLING


Beskrivelse ?

FC_CONTACT_BILLING - Fact child table for procedure coding

Størrelse (Antal rækker) ?

16574

Indhold (Kolonner/variable) ?

Navn Indhold
Billing_ID Primary key for the table
Action_ID COSMICs unique ID for the procedure coding
f_Date f_Date for the object in FC_CONTACT_BILLING
Contact_ID Reference to the Contact
Agreement_Key Reference to agreement
Admin_Status Adminstatus for the procedure coding
Commission_Name Commisson name
Company_Name Company name
Patient_Name Patient surname
Customer_Name Customer name
Customer_ID ID for customer unit
Family_Name Patient family name
Invoice_Text Invoice text
Offer_Name Name for offer
Offer_Key Key for offer
Offer_ID ID for offer
Org_Number Org_Number for the object in FC_CONTACT_BILLING
Patient_ID Reference to the patient
PerformingStaff_ID Referens to performing staff
PerformingUnit_ID Referens to performing unit
PostReg_Value Post registration value
PostReg_ID Post registration ID
Volume Number of priced hours
Price Pris on offer
Sum Sum
Report_Type Report type
Status Namn for the status of the procedure coding
SOC_ID Reference to the patient
SOC_C SOC_C for the object in FC_CONTACT_BILLING
Sysdate Date when record got loaded/updated in CI
Action_Status Actionstatus of the actionreporting
Active_TimeReport Active_TimeReport for the object in FC_CONTACT_BILLING
PreBillingStatus Billingstatus of the procedure coding
Billed Is post registration billed