VALUES(11149,'個(gè)人信息','查看個(gè)人的信息','個(gè)人辦公','普通',16)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11150,'車輛預(yù)訂','對(duì)可預(yù)見的用車時(shí)間進(jìn)行約定','個(gè)人辦公','普通',6)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11420,'滾動(dòng)消息管理','管理個(gè)人的滾動(dòng)消息','個(gè)人辦公','普通',11)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11426,'公告板查詢','查詢公告板信息','個(gè)人辦公','普通',12)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11160,'個(gè)人工資福利保險(xiǎn)','統(tǒng)計(jì)個(gè)人的工資福利保險(xiǎn)信息','個(gè)人辦公','普通',17)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11161,'個(gè)人通信錄','管理個(gè)人的通信錄','個(gè)人辦公','普通',18)
;

---***********
---通信       *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10694,'公告板','發(fā)布個(gè)人的公告信息','通信','普通',20)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10695,'留言板','發(fā)布留言的場(chǎng)所','通信','普通',22)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10696,'消息板','發(fā)布消息的場(chǎng)所','通信','普通',23)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11164,'討論區(qū)','自由發(fā)表意見的場(chǎng)所','通信','普通',21)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11165,'討論區(qū)管理','管理討論區(qū)，需有討論區(qū)管理員權(quán)限','通信','普通',24)
;


---***********
---檔案管理   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(3001,'檔案管理','管理日常工作的各種文檔資料','檔案','普通',25)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(3002,'借閱管理','管理文檔資料的借閱情況','檔案','普通',26)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11162,'歸還管理','管理文檔資料的歸還情況','檔案','普通',27)
;

---***********
---領(lǐng)導(dǎo)查詢     *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11140,'信息查詢','公司領(lǐng)導(dǎo)查詢各部門發(fā)布的信息','領(lǐng)導(dǎo)查詢','普通',28)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11141,'信息維護(hù)','維護(hù)各部門發(fā)布的供領(lǐng)導(dǎo)查詢的信息','領(lǐng)導(dǎo)查詢','普通',29)
;

---***********
---人事管理   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(1000,'組織結(jié)構(gòu)與職位','管理公司組織結(jié)構(gòu)與職位，設(shè)置權(quán)限','人力資源','普通',30)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(1001,'權(quán)限說(shuō)明','對(duì)權(quán)限的描述','人力資源','普通',31)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10681,'工資項(xiàng)目設(shè)置','設(shè)置員工的工資結(jié)構(gòu)','人力資源','普通',34)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10682,'員工培訓(xùn)','管理員工的培訓(xùn)信息','人力資源','普通',36)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11144,'員工信息','管理在職員工的個(gè)人信息','人力資源','普通',32)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11145,'離職員工信息','管理離職員工的個(gè)人信息','人力資源','普通',33)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11146,'薪酬統(tǒng)計(jì)','查詢員工的薪酬信息','人力資源','普通',35)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11167,'員工培訓(xùn)統(tǒng)計(jì)','統(tǒng)計(jì)員工的培訓(xùn)信息','人力資源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11500,'部門考勤時(shí)間設(shè)置','部門考勤時(shí)間設(shè)置','人力資源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(20001,'','指定日期考勤統(tǒng)計(jì)','人力資源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(20002,'','指定員工考勤統(tǒng)計(jì)','人力資源','普通',37)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(20003,'','所有員工考勤統(tǒng)計(jì)','人力資源','普通',37)
;
--****************
--部門考勤時(shí)間設(shè)置
--****************
INSERT INTO T_DIV_ATT_MODE (ON_DUTY_MODE,OFF_DUTY_MODE)
VALUES( 'MIN','MAX')



---***********
---辦公室     *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(2001,'收發(fā)文管理','辦公室收文,發(fā)文的管理','辦公室','普通',39)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11163,'固定資產(chǎn)管理','管理公司的固定資產(chǎn)','辦公室','普通',38)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(2002,'公用信息維護(hù)','維護(hù)公司及各部門發(fā)布的規(guī)章制度,辦事指南,內(nèi)部發(fā)行的刊物,客戶通信錄','辦公室','普通',40) 
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11143,'會(huì)議室管理','管理公司會(huì)議室信息','辦公室','普通',47)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11148,'會(huì)議室預(yù)定查詢','查詢預(yù)定會(huì)議室情況','辦公室','普通',48)
;

INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11151,'車輛管理','管理公司車輛信息','辦公室','普通',42)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11155,'車輛預(yù)定管理','管理公司車輛預(yù)訂信息','辦公室','普通',43)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11156,'司機(jī)管理','管理公司司機(jī)','辦公室','普通',44)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES (11157,'車輛出勤登記','登記公司車輛出勤情況','辦公室','普通',45)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11158,'車輛行使費(fèi)用','管理公司車輛行使信息','辦公室','普通',46)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11421,'員工通信組維護(hù)','維護(hù)公司員工通信組','辦公室','普通',41)
;


---***********
---財(cái)務(wù)       *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11126,'項(xiàng)目維護(hù)','管理公司各部門的項(xiàng)目費(fèi)用預(yù)算','財(cái)務(wù)','普通',49)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11132,'統(tǒng)計(jì)查看','匯總或查看各部門預(yù)算的使用情況','財(cái)務(wù)','普通',50)
;


---***********
---公用信息   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10704,'規(guī)章制度','查看公司及各部門發(fā)布的規(guī)章制度','公用信息','普通',53)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10705,'辦事指南','查看公司為員工提供的辦事指南','公用信息','普通',54)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10706,'外部通訊錄','查看公司客戶通信錄','公用信息','普通',52)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10707,'內(nèi)部刊物','查看公司內(nèi)部發(fā)行的刊物','公用信息','普通',55)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11168,'員工通信錄','查看公司員工通信錄','公用信息','普通',51)
;

---***********
---系統(tǒng)管理   *
---***********
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(6001,'數(shù)據(jù)字典管理','管理系統(tǒng)數(shù)據(jù)字典','系統(tǒng)管理','普通',56)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(11391,'系統(tǒng)參數(shù)設(shè)置','設(shè)置系統(tǒng)參數(shù)','系統(tǒng)管理','普通',57)
;
INSERT INTO T_PRIVILEGE(PRIVILEGE_ID,PRIVILEGE_NAME,DESCRIPTION,GROUP_NAME,TYPE,SEQUENCE)
 VALUES(10689,'標(biāo)準(zhǔn)工作流模板維護(hù)','管理標(biāo)準(zhǔn)工作流模板','系統(tǒng)管理','普通',58)
;



---------------------
--組織結(jié)構(gòu)模塊數(shù)據(jù)初始化-
---------------------
INSERT INTO T_DIRECTORIES
(DIRECTORY_ID,DIRECTORY_NAME,SUPER_DIRECTORY_ID,OWNER_ID,IS_LEAF,
 CREATE_DATE,WRITE_CONTROL,READ_CONTROL,TYPE)
 VALUES(1,'root',NULL,10000,0,NULL,1,0,0)
;

INSERT INTO T_DIVISION
(DIVISION_ID,P_DIVISION_ID,DIVISION_NAME,LOCATION,TELEPHONE,
 FAX,ZIP_CODE,PROVINCE,CITY,MANAGER_ID,DIVISION_DUTY,EMAIL,DIVISION_TYPE)
 VALUES(1,NULL,'鐵通總公司','','','','','','',10000,'','','')
;
INSERT INTO T_DIVISION
(DIVISION_ID,P_DIVISION_ID,DIVISION_NAME,LOCATION,TELEPHONE,FAX,ZIP_CODE,
PROVINCE,CITY,MANAGER_ID,DIVISION_DUTY,EMAIL,DIVISION_TYPE) 
 VALUES(2,1,'人事部','','','','','','',10000,'','','')
;
--**********************************************************
-- Creating the "Administrator" account of Net-Office System.
--**********************************************************
INSERT INTO T_EMP(EMP_ID,TITLE,NAME,USERNAME,DIVISION_ID,PASSWORD) VALUES(10000,'','管理員','Administrator',2,'b59c67bf196a4758191e42f76670ceba')

;
---------------------
--職位權(quán)限模塊數(shù)據(jù)初始化-
---------------------
INSERT INTO T_DUTY(DUTY_ID,DIVISION_ID,DUTY_TITLE,CURRENT_NUMBER) VALUES(10000,2,'人事部門經(jīng)理',1)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,1000,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,1001,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11144,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11145,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11146,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,10681,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,10682,10000)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11167,10000)
;
INSERT INTO T_EMP_X_DUTY(EMP_ID,DUTY_ID,ASSIGNMENT_DATE,ASSIGNER_ID,IS_MAIN_DUTY) VALUES(10000,10000,getDate(),10000,1)
;
INSERT INTO T_DUTY_X_PRIVILEGE(DUTY_ID,PRIVILEGE_ID,ASSIGNER_NO) VALUES(10000,11500,10000)
;

---------------------
--分類模塊數(shù)據(jù)初始化-
---------------------
INSERT INTO T_CATEGORY(CATEGORY_ID,PARENT_ID,ISLEAF,CATEGORY_NAME,CREATOR_ID,CREATE_DATE)
 VALUES(1000,NULL,0,'分類根目錄',NULL,'2001-10-15')
;
INSERT INTO T_CATEGORY (CATEGORY_ID,PARENT_ID,ISLEAF,CATEGORY_NAME,CREATOR_ID,CREATE_DATE)
 VALUES(2000,1000,0,'固定資產(chǎn)',10000,'2001-10-15')
;
INSERT INTO T_CATEGORY (CATEGORY_ID,PARENT_ID,ISLEAF,CATEGORY_NAME,CREATOR_ID,CREATE_DATE)
 VALUES(3000,1000,0,'文件來(lái)源單位',10000,'2001-10-15')
;