/**Begin D:\PDM_UPGRADE\PDM1\HAOS_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HAOS_DIMSTAFFREPORT') 
 CREATE TABLE T_HAOS_DIMSTAFFREPORT (
FID BIGINT DEFAULT 0 NOT NULL,
FSTAFFID BIGINT DEFAULT 0 NOT NULL,
FYEAR DATETIME,
FMONTH DATETIME,
FADMINORGID BIGINT DEFAULT 0 NOT NULL,
FSTAFFCOUNT INT DEFAULT 0 NOT NULL,
FDUTYWORKROLEID BIGINT DEFAULT 0 NOT NULL,
FJOBID BIGINT DEFAULT 0 NOT NULL,
FLABORRELTYPEID BIGINT DEFAULT 0 NOT NULL,
FSTAFFDIMENSIONID BIGINT DEFAULT 0 NOT NULL,
FCREATETIME DATETIME
);


IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_HAOS_ORGSTAFFREPORT') 
 CREATE TABLE T_HAOS_ORGSTAFFREPORT (
FID BIGINT DEFAULT 0 NOT NULL,
FSTAFFID BIGINT DEFAULT 0 NOT NULL,
FYEAR DATETIME,
FMONTH DATETIME,
FADMINORGID BIGINT DEFAULT 0 NOT NULL,
FSTAFFCOUNT INT DEFAULT 0 NOT NULL,
FSTAFFCOUNTWITHSUB INT DEFAULT 0 NOT NULL,
FCREATETIME DATETIME
);



/**End D:\PDM_UPGRADE\PDM1\HAOS_table.sql **/
