| Table Name: | person |
| Table Number: | 350 |
| Group: | Sales Mgr |
| Description: | Person supertype object. Reserved; not used |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| birthday | CLK_TIME | datetime | Person's birthday | |||||
| comments | CHAR | varchar | 255 | Comments about the person | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| family_info | CHAR | varchar | 255 | Information about the person's relatives | ||||
| first_name | CHAR | varchar | 15 | 30 | Person's first name | |||
| last_name | CHAR | varchar | 14 | 30 | Person's last name | |||
| middle_name | CHAR | varchar | 30 | Person's middle name | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | |||
| phone | CHAR | varchar | 20 | Person's phone number which includes area code, number, and extension | ||||
| salutation | CHAR | varchar | 25 | Salutation for the person | ||||
| suffix | CHAR | varchar | 25 | Suffix for the person | ||||
| title | CHAR | varchar | 80 | Primary title of the person | ||||
| title_cat | CHAR | varchar | 25 | Title category; e.g., executive, middle manager. This is a user-defined pop up |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| person2bus_per_role | OTM | bus_per_role | bus_per_role2person | Business organization roles for the person. Reserved | |||
| person2cam_per_role | OTM | cam_per_role | cam_role2person | Campaign roles for the person | |||
| person2contact | OTOP | contact | contact2person | If the person is a contact, the related contact object | |||
| person2cr_person_role | OTM | cr_person_role | cr_person_role2person | Contract roles for the person | |||
| person2employee | OTOP | employee | empl2person | If the person is an employee, the related employee object | |||
| person2lst_per_role | OTM | lst_per_role | list_role2person | Mailing list roles for the person | |||
| person2per_addr_role | OTM | per_addr_role | per_addr_role2person | Address roles for the person | |||
| person2per_opp_role | OTM | per_opp_role | opp_role2person | Opportunities involving the person | |||
| role_for2per_per_role | OTM | per_per_role | role_for2person | Roles received from other persons | |||
| player2per_per_role | OTM | per_per_role | player2person | Roles played for other persons | |||
| person2per_prt_role | OTM | per_prt_role | per_prt_role2person | Installed part roles for the person | |||
| person2per_sce_role | OTM | per_sce_role | sce_role2person | Lead source roles for the person | |||
| person2per_site_role | OTM | per_site_role | per_site_role2person | Site roles for the person | |||
| person2per_ter_role | OTM | per_ter_role | terr_role2person | Territories involving the person |
| Index Name | Fields | Flags |
|---|---|---|
| name_index | first_name:last_name:phone | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| name_index | first_name, last_name, phone | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|
| person | |||