_8.daily_close_calculations
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| dcc_id | int(11) | NO | PRI | auto_increment | ||
| dcc_cus_id | int(11) | NO | 0 | Customer ID# | ||
| dcc_cli_id | int(11) | NO | 0 | Client ID# | ||
| dcc_ecp_id | int(11) | NO | MUL | Encounters CPT ID# | ||
| dcc_led_id | int(11) | NO | MUL | Ledger ID# | ||
| dcc_enc_id | int(11) | NO | MUL | Encounter ID# | ||
| dcc_pat_id | int(11) | NO | MUL | Patient ID# | ||
| dcc_phy_id | int(11) | YES | MUL | Provider ID# | ||
| dcc_loc_id | int(11) | YES | MUL | Location ID# | ||
| dcc_revc_id | int(11) | YES | MUL | Revenue Center ID# | ||
| dcc_spl_id | int(11) | YES | Service Place ID# | |||
| dcc_bil_id | int(11) | YES | Billing Code ID# | |||
| dcc_rcron_id | int(11) | YES | Running Cron ID# | |||
| dcc_clpd_id | int(11) | NO | MUL | Daily Closed Period ID# | ||
| dcc_begin_clpd_id | int(11) | YES | Daily Closed Period Beginning ID# | |||
| dcc_ins_id | int(11) | YES | MUL | Insurance ID# | ||
| dcc_ic_id | int(11) | YES | MUL | Insurance Class ID# | ||
| dcc_led_led_id | int(11) | YES | Applied Ledger ID# | |||
| dcc_epay_id | int(11) | YES | MUL | Encounter Payments ID# | ||
| dcc_clp_id | int(11) | YES | MUL | Closed Period ID# | ||
| dcc_cpt_id | int(11) | YES | MUL | CPT ID# | ||
| dcc_found_unapplied_payment | int(1) | YES | 0 | |||
| dcc_report_type | int(11) | YES | ||||
| dcc_next_payer | varchar(40) | YES | MUL | |||
| dcc_days_aging | varchar(15) | YES | MUL | |||
| dcc_balance | decimal(12,2) | YES | 0.00 | MUL | ||
| dcc_last_payment_date | varchar(8) | YES | ||||
| dcc_last_payment_amount | decimal(12,2) | YES | 0.00 | |||
| dcc_next_payer_bill_type | int(11) | YES | 3 | MUL | ||
| dcc_next_payer_name | varchar(256) | YES | MUL | |||
| dcc_next_payer_level | int(3) | YES | ||||
| dcc_next_payer_ins_class | varchar(256) | YES | ||||
| dcc_bil_code | varchar(15) | YES | ||||
| dcc_bil_desc | varchar(40) | YES | ||||
| dcc_bil_type | varchar(50) | YES | ||||
| dcc_bil_cash | char(1) | YES | ||||
| dcc_bil_credit | char(1) | YES | ||||
| dcc_bil_check | char(1) | YES | ||||
| dcc_bil_negative_amount | char(1) | YES | ||||
| dcc_bil_positive_amount | char(1) | YES | ||||
| dcc_bil_patient_payment | char(1) | YES | ||||
| dcc_bil_patient_menu | char(1) | YES | ||||
| dcc_bil_insurance_menu | char(1) | YES | ||||
| dcc_bil_allowed | tinyint(1) | YES | ||||
| dcc_led_date | varchar(8) | YES | ||||
| dcc_led_amount | decimal(12,2) | YES | 0.00 | MUL | ||
| dcc_led_orig_amount | decimal(12,2) | YES | 0.00 | MUL | ||
| dcc_led_note | text | YES | ||||
| dcc_led_created | timestamp | YES | 0000-00-00 00:00:00 | |||
| dcc_enc_encounter_num | varchar(20) | YES | ||||
| dcc_enc_date_of_service | varchar(8) | YES | ||||
| dcc_enc_bill_type | char(1) | YES | ||||
| dcc_ecp_code | varchar(15) | YES | MUL | |||
| dcc_ecp_desc | varchar(40) | YES | ||||
| dcc_ecp_date_of_service | varchar(8) | YES | ||||
| dcc_ecp_num_units | varchar(5) | YES | ||||
| dcc_rev_code | varchar(4) | YES | ||||
| dcc_ecp_created | timestamp | NO | 0000-00-00 00:00:00 | |||
| dcc_patient_name | varchar(256) | YES | ||||
| dcc_provider_name | varchar(256) | YES | ||||
| dcc_location_name | varchar(256) | YES | ||||
| dcc_revc_name | varchar(256) | YES | ||||
| dcc_service_place_name | varchar(256) | YES | ||||
| dcc_created | timestamp | YES | CURRENT_TIMESTAMP |
References
| Local Column | References |
|---|