_436.patients_responsibility_estimates

Field Type Null Default Key Extra Comment
prest_id int(11) NO PRI auto_increment
prest_cus_id int(11) NO 0 Customer ID#
prest_cli_id int(11) NO 0 Client ID#
prest_pat_id int(11) NO 0 MUL Patient ID#
prest_phy_id int(11) NO 0 MUL Rendering Provider ID#
prest_loc_id int(11) NO 0 MUL Billing Office Name
prest_sty_id int(11) NO 0 MUL Service type
prest_irep1_id int(11) NO 0 MUL Primary Insurance Repository ID#
prest_irep2_id int(11) NO 0 MUL Secondary Insurance Repository ID#
prest_irep3_id int(11) NO 0 MUL Tertiary Insurance Repository ID#
prest_cs_id int(11) NO 0 MUL Code system indicator
prest_fname varchar(20) NO
prest_mname varchar(20) NO
prest_lname varchar(20) NO
prest_ssn varchar(11) NO
prest_dob varchar(8) NO
prest_sex varchar(7) NO
prest_charge decimal(12,2) NO Total Charges
prest_allowed_amount decimal(12,2) NO Total allowed amount
prest_contracted_adj decimal(12,2) NO Total contracted adjustments
prest_deductible decimal(12,2) NO Deductible
prest_co_ins decimal(12,2) NO Co-Insurance
prest_co_pay decimal(12,2) NO Co-pay
prest_est_phy_pmt decimal(12,2) NO Total Estimated Provider Payment
prest_est_pat_resp decimal(12,2) NO Total Estimated Patient Responsibility
prest_status varchar(20) NO
prest_disabled tinyint(1) NO Disabled
prest_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
prest_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
prest_id
TableColumn
_1.patients_responsibility_estimates_dx_codesprestdx_prest_id
_1.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_1.patients_responsibility_estimates_servicesprests_prest_id
_1188.patients_responsibility_estimates_dx_codesprestdx_prest_id
_1188.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_1188.patients_responsibility_estimates_servicesprests_prest_id
_1218.patients_responsibility_estimates_dx_codesprestdx_prest_id
_1218.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_1218.patients_responsibility_estimates_servicesprests_prest_id
_1548.patients_responsibility_estimates_dx_codesprestdx_prest_id
_1548.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_1548.patients_responsibility_estimates_servicesprests_prest_id
_435.patients_responsibility_estimates_dx_codesprestdx_prest_id
_435.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_435.patients_responsibility_estimates_servicesprests_prest_id
_436.patients_responsibility_estimates_dx_codesprestdx_prest_id
_436.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_436.patients_responsibility_estimates_servicesprests_prest_id
_436_archive_testing.patients_responsibility_estimates_dx_codesprestdx_prest_id
_436_archive_testing.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_436_archive_testing.patients_responsibility_estimates_servicesprests_prest_id
_437.patients_responsibility_estimates_dx_codesprestdx_prest_id
_437.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_437.patients_responsibility_estimates_servicesprests_prest_id
_8.patients_responsibility_estimates_dx_codesprestdx_prest_id
_8.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_8.patients_responsibility_estimates_servicesprests_prest_id
_81.patients_responsibility_estimates_dx_codesprestdx_prest_id
_81.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_81.patients_responsibility_estimates_servicesprests_prest_id
_999.patients_responsibility_estimates_dx_codesprestdx_prest_id
_999.patients_responsibility_estimates_dx_mapprestdxm_prest_id
_999.patients_responsibility_estimates_servicesprests_prest_id