|
 | Contact Person Id | INTEGER | Null | Person who acts as a contact between IRMAC and the corporation for the purposes of invoicing etc. |
| Creation Date | datetime | Null | The date the record was created. |
| Creation User Name | VARCHAR(15) | Null | The name of the relevant user as used for logging into the system, e.g jtench. |
| Declined Renewal | ENUM('Y','N') | NotNull | Y=explicitly declined to renew the membership |
| Edit Date | datetime | Null | The date the record was last edited. |
| Edit User Name | VARCHAR(15) | Null | The name of the relevant user as used for logging into the system, e.g jtench. |
| Expiry Date | DATETIME | Null | The membership expiry date. |
| Last Invoice Date | DATETIME | Null | No longer used. |
| Membership Status | VARCHAR(10) | Null | Values:
'Active' - Expiry Date before today's date
'Expired' - Expiry Date less than 90 days ago
'Inactive' - Expiry Date more than 90 days ago |
| Membership Status Change Date | DATETIME | Null | No longer used. |