| This table contains information needed for storing engagements and their data. |
| 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) |