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) |