KJL

CREATE TABLE [dbo].[CKJLEMPID](

	[PayrollGroup] [VARCHAR](20) NOT NULL,

	[Year] [VARCHAR](50) NOT NULL,

	[LastID] [VARCHAR](18) NOT NULL,

	[CreateBy] [VARCHAR](50) NULL,

	[CreateDate] [VARCHAR](18) NULL,

	[ChangeDate] [VARCHAR](18) NULL,

	[ChangeBy] [VARCHAR](50) NULL,

 CONSTRAINT [PK_CKJLEMPID] PRIMARY KEY CLUSTERED 

(

	[PayrollGroup] ASC,

	[Year] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO