CREATE TABLE [dbo].[ATD_EMARK_DOC_TEMPLATE] (
    [InstanceId]             INT            NULL,
    [DocumentId]             INT            NULL,
    [RevNum]                 INT            NULL,
    [RevStatus]              VARCHAR (255)  NULL,
    [DOC_TYPE_ID]            INT            NULL,
    [DOC_TYPE_NAME]          NVARCHAR (50)  NULL,
    [DOC_ID]                 INT            NULL,
    [DOC_NUMBER]             NVARCHAR (15)  NULL,
    [DOC_DATE]               DATETIME       NULL,
    [INSTITUTE_ID]           INT            NULL,
    [INSTITUTE_ABRNAME]      NVARCHAR (15)  NULL,
    [ACADEMIC_YEAR_ID]       INT            NULL,
    [ACADEMIC_YEAR_NAME]     NVARCHAR (15)  NULL,
    [YEAR_SEMESTER_ID]       INT            NULL,
    [YEAR_SEMESTER_NAME]     NVARCHAR (15)  NULL,
    [STUDENT_EDULEVEL_ID]    INT            NULL,
    [STUDENT_EDULEVEL_NAME]  NVARCHAR (25)  NULL,
    [STUDENT_GROUP]          NVARCHAR (15)  NULL,
    [SUBJECT_ID]             INT            NULL,
    [SUBJECT_NAME]           NVARCHAR (50)  NULL,
    [TEACHER_ID]             INT            NULL,
    [TEACHER_NAME]           NVARCHAR (50)  NULL,
    [TEACHER_DEPARTMENT_ID]  INT            NULL,
    [TEACHER_DEPARTMENT]     NVARCHAR (50)  NULL,
    [TEACHER_USERID]         NVARCHAR (50)  NULL,
    [TEACHER_EMAIL]          NVARCHAR (50)  NULL,
    [REQUEST_DATE]           DATETIME       NULL,
    [SIGNED_DATE]            DATETIME       NULL,
    [SIGNATORY_ID]           INT            NULL,
    [SIGNATORY_NAME]         NVARCHAR (50)  NULL,
    [SIGNATORY_INSTITUTE_ID] INT            NULL,
    [SIGNATORY_INSTITUTE]    NVARCHAR (50)  NULL,
    [SIGNATORY_USERID]       INT            NULL,
    [SIGNATORY_EMAIL]        NVARCHAR (50)  NULL,
    [DOC_COMMENTS]           NVARCHAR (512) NULL
);

