Table: Portal_User
Cached portal web service data.
Columns
Name | Type | Constraints | Description
create__changeset_KEY | int | NOT NULL |
update__changeset_KEY | int | NOT NULL |
portal_user_KEY | int | NOT NULL | unique and immutable primary key of this portal which is also used as this table's primary key
login | nvarchar (150) |  | unique but mutable login name
last_modification_date | datetime | NOT NULL | time at which the portal server last updated this portal data
end_date | datetime |  | time at which the portal server was made inactive
first_name | nvarchar (70) |  | first name of person associated with this portal
last_name | nvarchar (256) |  | last name of person associated with this portal
email_address | nvarchar (150) |  | email address associated with this portal
online_bill_pay_enabled | bit |  | whether or not this portal is authorized for online bill pay
mobilecs_enabled | bit |  | whether or not this portal is authorized for mobile cs
portal_user_type_KEY | int | NOT NULL |
registration_date | datetime |  | The time at which this Portal's registration was completed
registration_sent_date | datetime |  | The time at which this Portal's registration email was sent
expiration_date | datetime |  | If a value exists then this portal is a temporary type portal and will expire at this time
firm_id | int | NOT NULL | The firm id in the license file at the time this record was last modified.

Primary key
Name | Columns | Description
PK_Portal_User$portal_user_KEY | portal_user_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Portal_User$portal_user_type_KEY | portal_user_type_KEY | Index supports foreign key FK_Portal_User__Portal_User_Type__portal_user_type_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Portal_User__Portal_User_Type__portal_user_type_KEY | portal_user_type_KEY | Portal_User_Type |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Contact__Portal_User__portal_user_KEY | portal_user_KEY | Contact |
FK_File_Transfer__Portal_User__contact__portal_user_KEY | contact__portal_user_KEY | File_Transfer |
FK_File_Transfer__Portal_User__staff__portal_user_KEY | staff__portal_user_KEY | File_Transfer |
FK_File_Transfer_Event__Portal_User__portal_user_KEY | portal_user_KEY | File_Transfer_Event |