Corporate Membership Details
Relationships
Keys
Entity Attribute List
LinkAttribute NameDatatypeNull OptionDefinition
Contact Person IdINTEGERNullPerson who acts as a contact between IRMAC and the corporation for the purposes of invoicing etc.
Creation DatedatetimeNullThe date the record was created.
Creation User NameVARCHAR(15)NullThe name of the relevant user as used for logging into the system, e.g jtench.
Declined RenewalENUM('Y','N')NotNullY=explicitly declined to renew the membership
Edit DatedatetimeNullThe date the record was last edited.
Edit User NameVARCHAR(15)NullThe name of the relevant user as used for logging into the system, e.g jtench.
Expiry DateDATETIMENullThe membership expiry date.
Last Invoice DateDATETIMENullNo longer used.
Membership StatusVARCHAR(10)NullValues: '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 DateDATETIMENullNo longer used.
  • 1 - 10 of 12