Table: dbo.Record_Status
Generic status table that houses the types that define if a given record is active, inactive or virtually deleted.
Columns
Name | Type | Constraints | Description
record_status_KEY | int (4) | NOT NULL | Primary key for this table
description | nvarchar (40) | NOT NULL | The status of a record. Active, Inactive or Deleted.

Primary key
Name | Columns | Description
PK_Record_Status | record_status_KEY |
Unique constraints
Name | Columns | Description
UK_Record_Status$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client__Record_Status__record_status_KEY | record_status_KEY | Client |
FK_Bank__Record_Status__record_status_KEY | record_status_KEY | Bank |
FK_Client_Benefit__Record_Status__record_status_KEY | record_status_KEY | Client_Benefit |
FK_Client_Billing_Item__Record_Status__record_status_KEY | record_status_KEY | Client_Billing_Item |
FK_Employee__Record_Status__record_status_KEY | record_status_KEY | Employee |
FK_Employee_Tax_Jurisdiction__Record_Status__record_status_KEY | record_status_KEY | Employee_Tax_Jurisdiction |
FK_Eftps_Transaction__Record_Status__record_status_KEY | record_status_KEY | Eftps_Transaction |