_999.patient_amendments

Field Type Null Default Key Extra Comment
pa_id int(11) NO PRI auto_increment
pa_cus_id int(11) NO MUL
pa_cli_id int(11) NO MUL
pa_pat_id int(11) NO MUL
pa_comments text NO
pa_desc text NO
pa_creator_usr_id int(11) NO
pa_apprv_usr_id int(11) NO
pa_approved char(1) NO
pa_request_ts varchar(16) NO
pa_decision_ts varchar(16) NO
pa_enc_id int(11) NO MUL
pa_requestor varchar(45) NO
pa_modified datetime YES CURRENT_TIMESTAMP
pa_created datetime YES CURRENT_TIMESTAMP

References

Local Column References
pa_id
TableColumn
_1.auditsaud_pa_id
_1.audits_archiveaud_pa_id
_1.patient_amendments_codespac_pa_id
_1188.auditsaud_pa_id
_1188.audits_archiveaud_pa_id
_1188.patient_amendments_codespac_pa_id
_1218.auditsaud_pa_id
_1218.audits_archiveaud_pa_id
_1218.patient_amendments_codespac_pa_id
_1548.auditsaud_pa_id
_1548.audits_archiveaud_pa_id
_1548.patient_amendments_codespac_pa_id
_435.auditsaud_pa_id
_435.audits_archiveaud_pa_id
_435.patient_amendments_codespac_pa_id
_436.auditsaud_pa_id
_436.audits_archiveaud_pa_id
_436.patient_amendments_codespac_pa_id
_436_archive_testing.auditsaud_pa_id
_436_archive_testing.audits_archiveaud_pa_id
_436_archive_testing.patient_amendments_codespac_pa_id
_437.auditsaud_pa_id
_437.audits_archiveaud_pa_id
_437.patient_amendments_codespac_pa_id
_8.auditsaud_pa_id
_8.audits_archiveaud_pa_id
_8.patient_amendments_codespac_pa_id
_81.auditsaud_pa_id
_81.audits_archiveaud_pa_id
_81.patient_amendments_codespac_pa_id
_999.auditsaud_pa_id
_999.audits_archiveaud_pa_id
_999.patient_amendments_codespac_pa_id