common.clients_enrollments_map

Field Type Null Default Key Extra Comment
cem_id int(11) NO PRI auto_increment
cem_cus_id int(11) NO 0 MUL Customer ID#
cem_cli_id int(11) NO 0 MUL Client ID#
cem_ertop_id int(11) NO 0 MUL Enrollment Option ID#
cem_default_apply_on_pat_create tinyint(1) YES Indicates enrollment should be applied as opt in when patient is created in client
cem_no_optout_reason tinyint(1) NO 0 Indicates whether opt out reason is required by an enrollment
cem_no_end_date tinyint(1) NO 0 Indicates whether an enrollment has an end date
cem_default_optin_on_pat_create char(1) NO Indicates enrollment should be applied as opt in when patient is created in client
cem_modified timestamp YES CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
cem_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References