Create Table CT_ATT_AttendanceExceptionLog ( FFivouchered INT DEFAULT 0,CFPushResult VARCHAR(2000),CFPushType VARCHAR(100),CFMessageResponse CLOB(2000),CFMessageRequest CLOB(2000),CFDataPushResponse CLOB(2000),CFDataPushRequest CLOB(2000),CFPushStatus INT DEFAULT 1,FNumber NVARCHAR(80),FBizDate DateTime,FHandlerID VARCHAR(44),FDescription VARCHAR(255),FHasEffected INT,FAuditorID VARCHAR(44),FSourceBillID VARCHAR(80),FSourceFunction VARCHAR(80),FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44),FID VARCHAR(44) DEFAULT '' NOT NULL ,CFMessageId NVARCHAR(255),CONSTRAINT PK_AttendanceExcep PRIMARY KEY (FID));

Create Table CT_ATT_CenterLRE ( FID VARCHAR(44) DEFAULT '' NOT NULL ,FSeq INT DEFAULT 0 NOT NULL ,FParentID VARCHAR(44) DEFAULT '' NOT NULL ,CFSeq INT,CFPersonID VARCHAR(44),CONSTRAINT CPK_ATT_CenterLg0n PRIMARY KEY (FID));

Create Table CT_ATT_CenterLeaderRelation ( FCreatorID VARCHAR(44),FCreateTime DateTime,FLastUpdateUserID VARCHAR(44),FLastUpdateTime DateTime,FControlUnitID VARCHAR(44),FNumber NVARCHAR(80),FBizDate DateTime,FHandlerID VARCHAR(44),FDescription NVARCHAR(80),FHasEffected INT,FAuditorID VARCHAR(44),FSourceBillID NVARCHAR(80),FSourceFunction NVARCHAR(80),FID VARCHAR(44) DEFAULT '' NOT NULL ,CFDepartmentID VARCHAR(44),CFNotifyOrgLeader INT,CFPersonIds NVARCHAR(2000),CFPersonNames NVARCHAR(2000),CFPersonNumbers NVARCHAR(2000),CONSTRAINT CPK_ATT_CenterLrce PRIMARY KEY (FID));

