Table: dbo.Engagement_Binder
This table contains information needed for storing engagements and their data.
Columns
Name | Type | Constraints | Description
engagement_binder_KEY | int (4) | NOT NULL | Primary key. This points to the engagement binder data.
engagement_binder_guid | uniqueidentifier (16) | NOT NULL | The unique identifier for the engagement binder
engagement_binder_name | nvarchar (150) | NOT NULL | The name of the engagement binder.
engagement_binder_status_KEY | int (4) | NOT NULL | The status of the engagement binder.
gl_period_KEY | int (4) | NOT NULL | The current posting period key of the selected client which can used by word or excel as a variable.
start_date | smalldatetime (4) |  | The date the staff started the audit process. It is not mandatory that they fill this field.
end_date | smalldatetime (4) |  | The date the staff finished the audit process. It is not mandatory that they fill this field.
engagement_type_KEY | int (4) | NOT NULL | Indicates the type of engagement
client_KEY | int (4) | NOT NULL | The client to which this engagement binder belongs.
report_release_date | smalldatetime (4) |  | The report release date for the binder. That is the date that the auditor issues the final audit report for the binder. This is not a mandatory field.
is_public_entity | bit (1) | NOT NULL | True if the binder is public entity. This field determines if the current binder is public or private entity. This field will determine the completion date of binder.
completion_date | smalldatetime (4) |  | The point in time in which the engagement binder should be finalized (locked down) so that further edits cannot be made. Can be NULL if report_release_date is NULL (user has not specified a report release date)

Primary key
Name | Columns | Description
PK_Engagement_Binder | engagement_binder_KEY |
Unique constraints
Name | Columns | Description
UK_Engagement_Binder$client_KEY$engagement_binder_name | client_KEY, engagement_binder_name |
UK_Engagement_Binder$engagement_binder_guid | engagement_binder_guid |

Foreign keys
Name | Columns | Referenced table | Description
FK_Engagement_Binder__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Engagement_Binder__Engagement_Binder_Status__engagement_binder_status_KEY | engagement_binder_status_KEY | Engagement_Binder_Status (engagement_binder_status_KEY) |
FK_Engagement_Binder__Engagement_Type__engagement_type_KEY | engagement_type_KEY | Engagement_Type (engagement_type_KEY) |
FK_Engagement_Binder__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Engagement_Binder_N_Staff__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Engagement_Binder_N_Staff |
FK_Folder__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Folder |
FK_Recorded_Event_Object_N_Engagement_Binder__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Recorded_Event_Object_N_Engagement_Binder |
FK_PPC_Smart_Engagement__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | PPC_Smart_Engagement |
FK_Workpaper__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Workpaper |
FK_Engagement_Item_Note__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Engagement_Item_Note |
FK_Engagement_Binder_Tree_Item__Engagement_Binder__engagement_binder_KEY | engagement_binder_KEY | Engagement_Binder_Tree_Item |