Table | cm_co_expiration_policies |
|---|---|
Description | Per-CO expiration policies |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
|
co_id | integer, foreign key | CO Record ID | cm_cos:id |
|
description | varchar(256) | Description |
|
|
status | varchar(2) | Expiration policy's status |
|
|
cond_cou_id | integer, foreign key | COU this expiration policy applies to | cm_cous:id | Conditions are AND'd together |
cond_affiliation | varchar(32) | Affiliation this expiration policy applies to | cm_co_person_roles:affiliation |
|
cond_before_expiry | integer | Number of days prior to expiration from which this policy will apply |
| Policy continues to apply until role valid_through |
cond_after_expiry | integer | Number of days after expiration at which point this policy will apply |
|
|
| cond_count | integer | Number of times this policy will be applied | cm_co_expiration_counts:expiration_count | Since v1.1.0 |
cond_status | varchar(2) | Status this expiration policy applies to | cm_co_person_roles:status |
|
cond_sponsor_invalid | boolean | If true, this expiration policy applies to CO Person Roles sponsored by a CO Person who is no longer Active |
|
|
act_affiliation | varchar(32) | CO Person Roles matching this expiration policy will be set to this affiliation, if defined | cm_co_person_roles:affiliation |
|
act_clear_expiry | boolean | CO Person Roles matching this expiration policy will have their valid_through date cleared, if true |
|
|
act_cou_id | integer, foreign key | CO Person Roles matching this expiration policy will be moved to tis COU, if set | cm_cous:id |
|
act_notify_co_admin | boolean | If true, the CO Administrator(s) will be notified when this expiration policy matches |
|
|
act_notify_cou_admin | boolean | If true, the COU Administrator(s) will be notified when this expiration policy matches |
|
|
act_notify_co_group_id | integer, foreign key | If true, the members of the specified CO Group will be notified when this expiration policy matches | cm_co_groups:id |
|
act_notify_co_person | boolean | If true, the CO Person attached to the matching CO Person Role will be notified when this expiration policy matches |
|
|
| act_notify_sponsor | boolean | If true, the Sponsor attached to the matching CO Person Role will be notified when this expiration policy matches | ||
| act_notification_template_id | integer, foreign key | Template for notification email | cm_co_message_templates:id | |
act_notification_subject | varchar(256) | Subject for notification email |
| Deprecated, use message templates instead |
act_notification_body | text | Body for notification email |
| Deprecated, use message templates instead |