Global_Contact - Contain all contacts across all systems participating in the Global Service Desk
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Timestamp indicating the last time this record was updated |
| remote_sys_id | integer | not null | Regional system id |
| remote_id | byte(16) | not null | Regional contact id |
| last_name | nvarchar(100) | with null | Contact's last name |
| first_name | nvarchar(100) | with null | Contact's first name |
| middle_name | nvarchar(100) | with null | Contact's middle name |
| userid | nvarchar(100) | with null | Contact's userid |
| contact_num | nvarchar(30) | with null | Contact num |
| pri_phone_number | nvarchar(32) | with null | Phone number |
| email_address | nvarchar(120) | with null | Email address |
| org_id | byte(16) | with null | Organization id |
| loc_id | byte(16) | with null | Location id |
Product Name: Unicenter Service Desk
Table Type: Table