Table: dbo.Engagement_Binder
This table contains information needed for storing engagements and their data.
Columns
NameTypeConstraintsDescription
engagement_binder_KEYint (4)NOT NULLPrimary key. This points to the engagement binder data.
engagement_binder_guiduniqueidentifier (16)NOT NULLThe unique identifier for the engagement binder
engagement_binder_namenvarchar (150)NOT NULLThe name of the engagement binder.
engagement_binder_status_KEYint (4)NOT NULLThe status of the engagement binder.
gl_period_KEYint (4)NOT NULLThe current posting period key of the selected client which can used by word or excel as a variable.
start_datesmalldatetime (4)The date the staff started the audit process. It is not mandatory that they fill this field.
end_datesmalldatetime (4)The date the staff finished the audit process. It is not mandatory that they fill this field.
engagement_type_KEYint (4)NOT NULLIndicates the type of engagement
client_KEYint (4)NOT NULLThe client to which this engagement binder belongs.
report_release_datesmalldatetime (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_entitybit (1)NOT NULLTrue 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_datesmalldatetime (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
NameColumnsDescription
PK_Engagement_Binderengagement_binder_KEY
Unique constraints
NameColumnsDescription
UK_Engagement_Binder$client_KEY$engagement_binder_nameclient_KEY, engagement_binder_name
UK_Engagement_Binder$engagement_binder_guidengagement_binder_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Engagement_Binder__Client__client_KEYclient_KEYClient (client_KEY)
FK_Engagement_Binder__Engagement_Binder_Status__engagement_binder_status_KEYengagement_binder_status_KEYEngagement_Binder_Status (engagement_binder_status_KEY)
FK_Engagement_Binder__Engagement_Type__engagement_type_KEYengagement_type_KEYEngagement_Type (engagement_type_KEY)
FK_Engagement_Binder__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement_Binder_N_Staff__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYEngagement_Binder_N_Staff
FK_Folder__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYFolder
FK_Recorded_Event_Object_N_Engagement_Binder__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYRecorded_Event_Object_N_Engagement_Binder
FK_PPC_Smart_Engagement__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYPPC_Smart_Engagement
FK_Workpaper__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYWorkpaper
FK_Engagement_Item_Note__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYEngagement_Item_Note
FK_Engagement_Binder_Tree_Item__Engagement_Binder__engagement_binder_KEYengagement_binder_KEYEngagement_Binder_Tree_Item

Schema diagram