| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 USERID |
nvarchar(100) | Default = '' | ||
| PASSWORD |
nvarchar(4000) | Default = '' | ||
| PASSWORDHASH |
nvarchar(200) | Default = '' | ||
| TYPECODE |
tinyint | Default = 0 | ||
 TYPE |
nvarchar(18) (Computed) |  |
CASE [TYPECODE] WHEN 0 THEN N'Individual' WHEN 1 THEN N'Company' WHEN 2 THEN N'Agent' WHEN 3 THEN N'Bureau' WHEN 4 THEN N'Partnership' WHEN 5 THEN N'Trust' WHEN 6 THEN N'Employer' WHEN 7 THEN N'Government' WHEN 8 THEN N'Acting in Capacity' WHEN 9 THEN N'Other' END | |
| ISTRUSTEE |
bit | Default = 0 | ||
| TRUSTEENAME |
nvarchar(160) | Default = '' | ||
| OFFICIALTITLE |
nvarchar(4) | Default = '' | ||
| OFFICIALFORENAME |
nvarchar(35) | Default = '' | ||
| OFFICIALSURNAME |
nvarchar(35) | Default = '' | ||
| PHONENUMBER |
nvarchar(35) | Default = '' | ||
| ISOVERSEAS |
bit | Default = 0 | ||
| POSTCODE |
nvarchar(8) | Default = '' | ||
| DATEADDED |
datetime | Default = getdate() | ||
| DATECHANGED |
datetime | Default = getdate() | ||
| TS |
timestamp | |||
| TSLONG |
bigint (Computed) | |
CONVERT(bigint, TS) |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 R68ONLINESUBMISSIONSETTINGSID |
uniqueidentifier | R68ONLINESUBMISSIONSETTINGS.ID | ||
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | ||
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_R68ONLINESUBMISSIONSETTINGSSENDERINFO_DATEADDED |
DATEADDED | |
||
 IX_R68ONLINESUBMISSIONSETTINGSSENDERINFO_DATECHANGED |
DATECHANGED | |||
| PK_R68ONLINESUBMISSIONSETTINGSSENDERINFO |
ID | |
|
|
| UIX_R68ONLINESUBMISSIONSETTINGSSENDERINFO_R68ONLINESUBMISSIONSETTINGSID_USERID |
R68ONLINESUBMISSIONSETTINGSID, USERID | |
| Trigger Name | Description |
|---|---|
 TR_R68ONLINESUBMISSIONSETTINGSSENDERINFO_AUDIT_UPDATE |
|
| TR_R68ONLINESUBMISSIONSETTINGSSENDERINFO_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 R68ONLINESUBMISSIONPARAMETERS |
R68ONLINESUBMISSIONSETTINGSSENDERINFOID |