How Do I Create a New Person Entity?

To create a new entity in Advance, you first need to establish that the entity does not already exist in the database. For this reason, the “Add Person” and “Add Organization” links are located on the Lookups Page Tree. Once you perform a lookup using various criteria, e.g., name, address, phone, etc., for the entity you would like to add, and establish they are not currently in Advance, you may proceed to enter the new entity.

 

After you click Save to create the new entity using the Add Person or Add Organization form, when you save the record, the Entity Detail form (ENT) will appear with the information you just entered. Many of the attributes on the Entity Details form cannot be modified directly on the Entity Detail form since those attributes are maintained in other places, including Address and Employment attributes, which are maintained on the Address and Employment forms, respectively. On the top of the Entity Detail form is helpful text that allows you to quickly access Address, Record Type, Bio Detail, Degrees, Email, Employment, Marital Info, or Telephone information.

 

To add a New Person entity:

 

  1. Select 'Add Person' from the Page Tree when you are on the Lookups, Gift/Transaction, or Entity Profile application.

  2. On the Entity (New) application, fill in all of the required fields.

  3. Fill in all of the additional fields for which you have data.

  4. Click Save on the Add Person Form Header to add the entity to the database.

  5. After the system has successfully created the entity, the Detail application will appear and display the ID number that has been assigned to the entity. If there is additional information you may do so, or you may close the application.

 

Please note the following:

 

Data Fields:

 

Entity ID

The ID Number you wish to manually assign to the Entity. This field only appears when system option 15 is enabled. When system option 15 disabled Advance will automatically assign the Entity ID number and this field will not appear.

Last

Last name of this entity. Required

First

First name of this entity.

Middle

Middle name of this entity.

Prefix

Personal prefix for this entity.

Suffix

Personal suffix for this entity.

Professional Suffix

Professional suffix for this entity.

Type

Drop-down list of entity record type. Values in this drop-down list are validated against the the tms_record_type table. Note: Modifications to this column must be made on the entity’s Record Type Form. Required

Rebuild Name Fields

After a new person entity record is created, this check box appears on the Entity Detail form and allows you to indicate whether you want the Mail Name, Report Name, and Salutation values to be re-built automatically if a change is made to the name fields on the form. This aims to help save the steps of blanking out the name fields manually, especially if the prior names were automatically generated and not manually entered.

Salutation

A general salutation used when addressing this person entity. This is the salutation that is normally used for letters (ex:  Mr. Smith, John, etc.). It is a required value, but it will default for a person entity from the Prefix + Last Name.  (If there is no prefix, it will not default.) The defaulted value can be overridden.

Mail Name

The name used for mailings to this entity. This is a required value, but it will default (if it is left blank) based on System Option 17. The defaulted value can be overridden.

Report Name

This is the report name stored for this entity. It may be edited here or automatically created by the system (if left blank). The default for a person entity is Last Name + Suffix + Professional Suffix + comma + First Name + Middle Name.

Status

Drop-down list of entity status. Values in this drop-down list are validated against the the tms_record_status table. Entities with any record status other than A will have their record type displayed in the upper right corner of the Entity Overview Application.  Required

Preferred Address

Drop-down list for address type of preferred mailing address. Validated against the tms_address_type table. This address will be accessed as the default address in the system. If System Option #16 is set to Y and this is a business address type, then a message will tell you to go to the Addresses Form to enter a business address.

When an address type is linked to a record type (via tms_record_type), and a new address is added for a person or organization entity, Advance will default the address type from tms_record_type.address_type_default. If the entity has multiple record types, Advance will default the address type associated with the entity’s primary record type.

Address 1-4

Address for this entity.

City

City of preferred mailing address for this entity.

State

Drop-down list of state codes for the preferred address for this entity. Values in this drop-down list are validated against the tms_states table.

Zip

Zip code for the preferred address for this entity; validated against the zip_city table.

Zip Suffix

Additional characters for the entity's zip code, i.e., zip+4

Country

Drop-down list of countries. Values in this drop-down list are validated against the tms_country table. This field is only used if the country is a country other than the United States.

Note: If you save the address details in the Addresses form with an invalid combination of state and country, a warning message appears: “The selected state is not located in the selected Country.”

County  

The county in which the entity resides.

Addr Src

This is the source from which the address record originated. Values in this drop-down are validated against tms_addr_src (FN).

Addr Start

This is the date on which the address begins.

Call Code

This view-only value is the country call code corresponding to the country within which the Telephone is located. The number in this field is retrieved from tms_country (AE) based on the country value entered on the form. This number must match the preceding digits of the phone number entered or an error message displays indicating a mismatch.

Preferred Phone

This check box indicates whether this number is the preferred telephone number. Only one Telephone record can have this check box checked at any given time. When a new Telephone record is added and this check box is checked, if there was a previous preferred record , the previous Telephone record’s preferred check box is automatically unchecked.

Unlisted

Check box indicating whether this phone number is unlisted.

Phone

This is the domestic or foreign Telephone number for the person or organization entity. If the Foreign Phone indicator in tms_country is set to ‘N’ for the default country or the country selected on the form,  an area code field will display prior to the phone field.

Extension

Phone extension for this phone number for this entity.

Phone Type

This is the type of Telephone record. Values in this drop-down are validated against tms_telephone_type (PT).

Txt Msg Allowed

This field indicates whether a text message is allowed for the Telephone; valid values are Yes, No and Unknown.

Phone Src

This is the source from which the telephone record originated. Values in this drop-down are validated against tms_data_source (YI).

Phone Start

This is the date on which the telephone begins.

Phone Start

This is the date on which the telephone begins.

Email Address

This is the email address of the person or organization entity, which must be entered using a valid email address format.

Pref Email

This check box indicates whether the email is the preferred email. Only one email record can have this check box checked at any given time. The preferred email appears on the Primary Address form of the Entity Overview below the physical home address. If the entity does not have a preferred email, the Primary Address form displays text indicating there is no preferred email address. If the entity is deceased, the preferred email does not appear on the Primary Address form. If this check box is checked on one email record, and you check this box for a second email record, the system will automatically uncheck this box on the first record when you save the second record.

Email Type

This is the type of email address. Values in this drop-down are validated against tms_email_type (WI). Required when email address is entered.

Email Status

This is the status of the email address. By default, new email records will have a status of Active. Values in this drop-down are validated against tms_email_status (WG). Required when email address is entered.

Email Format

 The format associated with the body of the email. Typically, this option is specified by the entity based on the requirements of their email client. When a new email record is entered, this value defaults to H (HTML). Values in this drop-down are validated against tms_email_format_code (WF). Required when email address is entered.

Email Source

This is the source from which the email record originated. Values in this drop-down are validated against tms_email_source (WK).

eContact

This is the specific eContact name or address of the person or organization entity. If the eContact type selected on the form displays a website address with the token /[1] next to it, you do not enter the website address into the eContact field. Instead, only enter the entity’s eContact information for that site.

eContact Type

This is the type of eContact record. Values in this drop-down are validated against tms_econtact_type (EC).  Required if eContact is entered.

eContact Status

This is the status of the eContact record. By default, new eContact records will have a status of Active. Values in this drop-down are validated against tms_econtact_status (EF). Required if eContact is entered.

Pref eContact

This check box indicates whether the contact method is the preferred contact method. Only one eContact record per eContact type can have this check box checked at any given time. When a new eContact record is added and this check box is checked, if there was a previous preferred record of the same type, the previous eContact record’s preferred check box is automatically unchecked.

Business

This check box indicates if the eContact method is a business contact method.

Employer

When the selected Address Type is a Business address (tms_address_type.business_ind = Y), this is the name of the organization employing this entity. This value should match the employer name in the employment record if the employment record is linked via the ‘Empt Link’ field. This field does not appear on the form when the selected Address Type has the business indicator set to N.

Title

When the selected Address Type is a Business address (tms_address_type.business_ind = Y), this is the entity’s job title. This value should match the job title in the employment record if the employment record is linked via the ‘Empt Link’ field. This field does not appear on the form when the selected Address Type has the business indicator set to N.

Gender

A drop-down list to identify the gender of this entity.

School

Drop-down list of preferred school for this entity. Values display from the tms_school table. Note: If the "Required" switch is set for School on this entity’s record type, School is required. Also, after a new entity is added to Advance, School is maintained on the Entity Record Type Form (the field will be display-only on the Entity Form.)

Class

Preferred class year for this entity. Note: If the "Required" switch is set for Class on this entity’s record type, Class is required. Otherwise, it is optional. Also, if System Option #66 is set to N, any valid number (not necessarily a 4-digit year). may be entered. If System Option #66 is set to Y only years between 1700 and 2100 may be entered.

Source

Drop-down list of the source of the request that this entity be added to the database. Values in this drop-down list are validated against the tms_entity_source table.

Year End Tax Receipt

Check box indicating whether the donor requested a year-end consolidated tax receipt. Used with the Canadian Tax Receipt functionality. When this check box is checked, additional Start and Stop Date fields will appear below. The start and stop dates indicate when the year-end tax receipt check box will default on the Gift Entry ledger. When the gift entry operator creates a gift, the preference to receive a year-end receipt will default on the gift entry ledger if the date of record is within the start and stop dates for this donor making the gift. Since these are partial date fields, you may choose to enter a month and day and leave the year blank. Doing so will indicate the entity wishes to receive a year end tax receipt every year.

Deleted

Check box indicating whether this entity has been 'virtually deleted'. If it is marked, a lookup will access this entity only if the 'Include Deleted' check box is marked on the lookup prompt.

Comment

A general comment about this entity.