_1188.patients_responsibility_estimates_services

Field Type Null Default Key Extra Comment
prests_id int(11) NO PRI auto_increment
prests_prest_id int(11) NO 0 MUL Patient Responsibility Estimate ID#
prests_cus_id int(11) NO 0 Customer ID#
prests_cli_id int(11) NO 0 Client ID#
prests_spl_id int(11) NO 0 MUL Place of Service ID#
prests_cs_id int(11) NO 0 MUL Code system indicator
prests_cpt_code varchar(15) NO Procedure code
prests_dos_from timestamp YES CURRENT_TIMESTAMP Date of service From
prests_dos_to timestamp YES CURRENT_TIMESTAMP Date of service To
prests_ndc_code varchar(11) NO National Drug Code
prests_ndc_num_units varchar(11) NO National Drug Code Number of Units
prests_ndc_units_of_measure varchar(11) NO National Drug Code Units of Measure
prests_charge decimal(12,2) NO Fee for service
prests_allowed_amount decimal(12,2) NO Service allowed amount
prests_contracted_adj decimal(12,2) NO Service contracted adjustments
prests_deductible decimal(12,2) NO Deductible
prests_co_ins decimal(12,2) NO Co-Insurance
prests_co_pay decimal(12,2) NO Co-pay
prests_pat_adj decimal(12,2) NO Patient Adjustment
prests_est_phy_pmt decimal(12,2) NO Provider Paid
prests_est_pat_resp decimal(12,2) NO Estimated patient responsibility
prests_num_units decimal(12,2) NO Number of units
prests_allowed_units decimal(12,2) NO Allowed number of units
prests_mod1 varchar(2) NO Modifier 1
prests_mod2 varchar(2) NO Modifier 2
prests_mod3 varchar(2) NO Modifier 3
prests_mod4 varchar(2) NO Modifier 4
prests_icd1 varchar(10) NO ICD code 1
prests_icd2 varchar(10) NO ICD code 2
prests_icd3 varchar(10) NO ICD code 3
prests_icd4 varchar(10) NO ICD code 4
prests_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
prests_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
prests_id
TableColumn
_1.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_1.pre_services_adjust_codesprestsac_prests_id
_1.pre_services_line_adjustmentsprestsla_prests_id
_1.pre_services_remark_codesprestsrc_prests_id
_1188.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_1188.pre_services_adjust_codesprestsac_prests_id
_1188.pre_services_line_adjustmentsprestsla_prests_id
_1188.pre_services_remark_codesprestsrc_prests_id
_1218.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_1218.pre_services_adjust_codesprestsac_prests_id
_1218.pre_services_line_adjustmentsprestsla_prests_id
_1218.pre_services_remark_codesprestsrc_prests_id
_1548.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_1548.pre_services_adjust_codesprestsac_prests_id
_1548.pre_services_line_adjustmentsprestsla_prests_id
_1548.pre_services_remark_codesprestsrc_prests_id
_435.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_435.pre_services_adjust_codesprestsac_prests_id
_435.pre_services_line_adjustmentsprestsla_prests_id
_435.pre_services_remark_codesprestsrc_prests_id
_436.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_436.pre_services_adjust_codesprestsac_prests_id
_436.pre_services_line_adjustmentsprestsla_prests_id
_436.pre_services_remark_codesprestsrc_prests_id
_436_archive_testing.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_436_archive_testing.pre_services_adjust_codesprestsac_prests_id
_436_archive_testing.pre_services_line_adjustmentsprestsla_prests_id
_436_archive_testing.pre_services_remark_codesprestsrc_prests_id
_437.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_437.pre_services_adjust_codesprestsac_prests_id
_437.pre_services_line_adjustmentsprestsla_prests_id
_437.pre_services_remark_codesprestsrc_prests_id
_8.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_8.pre_services_adjust_codesprestsac_prests_id
_8.pre_services_line_adjustmentsprestsla_prests_id
_8.pre_services_remark_codesprestsrc_prests_id
_81.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_81.pre_services_adjust_codesprestsac_prests_id
_81.pre_services_line_adjustmentsprestsla_prests_id
_81.pre_services_remark_codesprestsrc_prests_id
_999.patients_responsibility_estimates_dx_mapprestdxm_prests_id
_999.pre_services_adjust_codesprestsac_prests_id
_999.pre_services_line_adjustmentsprestsla_prests_id
_999.pre_services_remark_codesprestsrc_prests_id