_437.patients_statements

Field Type Null Default Key Extra Comment
pst_id int(11) NO PRI auto_increment
pst_cus_id int(11) NO MUL
pst_cli_id int(11) NO MUL
pst_usr_id int(11) NO
pst_usr_id_committed_by int(11) YES The ID of the user that committed the batch
pst_phy_id int(11) NO
pst_status char(1) NO 0 MUL
pst_type char(1) NO 0
pst_estatements_include tinyint(1) NO 0 Indicates if eStatements patients are included in a statement batch
pst_due_date date YES Date used for due date on statement
pst_message varchar(256) NO Short message to display on patient statements
pst_pstmsg_id int(11) YES patient statement message ID#
pst_path_pdf varchar(100) NO
pst_path_txt varchar(100) NO
pst_path_rmpdf varchar(100) NO
pst_path_rmtxt varchar(100) NO
pst_generate_dt datetime YES generation date used for patient statement6s cron
pst_last_sent_dt datetime YES Last date statements were sent to MMS
pst_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
pst_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References
pst_id
TableColumn
_1.encounters_batchesebat_pst_id
_1.patients_statements_billing_providers_mappstbpm_pst_id
_1.patients_statements_mappstm_pst_id
_1.patients_statements_options_mappsom_pst_id
_1188.encounters_batchesebat_pst_id
_1188.patients_statements_billing_providers_mappstbpm_pst_id
_1188.patients_statements_mappstm_pst_id
_1188.patients_statements_options_mappsom_pst_id
_1218.encounters_batchesebat_pst_id
_1218.patients_statements_billing_providers_mappstbpm_pst_id
_1218.patients_statements_mappstm_pst_id
_1218.patients_statements_options_mappsom_pst_id
_1548.encounters_batchesebat_pst_id
_1548.patients_statements_billing_providers_mappstbpm_pst_id
_1548.patients_statements_mappstm_pst_id
_1548.patients_statements_options_mappsom_pst_id
_435.encounters_batchesebat_pst_id
_435.patients_statements_billing_providers_mappstbpm_pst_id
_435.patients_statements_mappstm_pst_id
_435.patients_statements_options_mappsom_pst_id
_436.encounters_batchesebat_pst_id
_436.patients_statements_billing_providers_mappstbpm_pst_id
_436.patients_statements_mappstm_pst_id
_436.patients_statements_options_mappsom_pst_id
_436_archive_testing.encounters_batchesebat_pst_id
_436_archive_testing.patients_statements_billing_providers_mappstbpm_pst_id
_436_archive_testing.patients_statements_mappstm_pst_id
_436_archive_testing.patients_statements_options_mappsom_pst_id
_437.encounters_batchesebat_pst_id
_437.patients_statements_billing_providers_mappstbpm_pst_id
_437.patients_statements_mappstm_pst_id
_437.patients_statements_options_mappsom_pst_id
_8.encounters_batchesebat_pst_id
_8.patients_statements_billing_providers_mappstbpm_pst_id
_8.patients_statements_mappstm_pst_id
_8.patients_statements_options_mappsom_pst_id
_81.encounters_batchesebat_pst_id
_81.patients_statements_billing_providers_mappstbpm_pst_id
_81.patients_statements_mappstm_pst_id
_81.patients_statements_options_mappsom_pst_id
_999.encounters_batchesebat_pst_id
_999.patients_statements_billing_providers_mappstbpm_pst_id
_999.patients_statements_mappstm_pst_id
_999.patients_statements_options_mappsom_pst_id