_999.patients_enrollments

Field Type Null Default Key Extra Comment
pert_id int(11) NO PRI auto_increment
pert_cus_id int(11) NO 0 MUL Customer ID#
pert_cli_id int(11) NO 0 MUL ClientID#
pert_pat_id int(11) NO 0 MUL PatientID#
pert_ertop_id int(11) NO 0 MUL Enrollment Option ID#
pert_opt_in char(1) NO MUL 1 indicates opt-in patient
pert_opt_out_reason varchar(100) NO Reason for opt-out
pert_notes varchar(100) NO Free comments
pert_start_dt datetime YES Start time of enrollment
pert_end_dt datetime YES End time of enrollment
pert_usr_id_created int(11) NO 0 User ID# of creating user
pert_usr_id_modified int(11) NO 0 User ID# of modifying user
pert_disabled char(1) NO MUL A values of 1 indicates the enrollment is disabled
pert_modified datetime YES CURRENT_TIMESTAMP
pert_created datetime YES CURRENT_TIMESTAMP

References

Local Column References