tbl1_EmailTemplates_rp

Description

This table contains the email templates used in the Request Portal application

Footnote

It is recommended that this table be merged with the tbl1_EmailTemplates table

Columns

template_id int(11) NOT NULL

Options

display="true", null="true", search="false", type=""

template_description varchar(255) DEFAULT NULL

Description

These are all the types of templates available in Request Portal This table is set up so that there is a template available for each possible combination of decision/request-type/notification-recipient (ie student, registrar, advising office)

Options

display="true", null="true", search="false", type=""

email_subject_line varchar(255) DEFAULT NULL

Description

Email templates subject line (can have bookmarks)(

Options

display="true", null="true", search="false", type=""

email_body mediumtext DEFAULT NULL

Description

Email template body (can have bookmarks)

Options

display="true", null="true", search="false", type=""

last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Options

display="true", null="true", search="false", type=""