Personnel system-personnel subsystem: basic data

1. Departmental Organizational Structure setup

CREATE TABLE ocostcenter (cccode varchar) not  null  --Department Code ccname varchar (,--) department name Hrcode varchar,-- The person in charge of the work number Deputyuser varchar (5),--owner name rowID varchar (6),--identification Treecontrol varchar (,--identification Tree parentrowid varchar (6),-- Parent identity (the parent is empty) isworkint--default 0 enabled, 1 deactivated) declare @xxxx rowidexec p_sysxxxxrowid @xxxx outputinsert into ocostcenter values (' JX01 ', ' Ministry of Information ', ' jx45 ', ' Zhang Sanfeng ', @xxxx, @xxxx, ', 0)

2. Post Grading Setup

CREATE TABLE hrpositionlevel (positionlevel int not null PRIMARY key,--level idpositinolevelname nvarchar,--level name Memo nvarchar (100)--description)

3. Separation category Settings

CREATE TABLE Ms_leavetype (leavetype varchar () not NULL PRIMARY key,leavename varchar (50), Memo varchar)

4. Company award and Punishment type setting

CREATE TABLE Ms_rewardtype (rewardid varchar () not NULL PRIMARY key,rewardidname varchar (50) Remark varchar

5. Compensation category Settings

CREATE TABLE Ms_salarytype (emptype varchar () not NULL PRIMARY key,emptypename varchar (255), Memo VARCHAR (50))

6. Employment Category

CREATE TABLE Ms_employeetype (employeetype varchar () not NULL PRIMARY key,employeetypename varchar (255), Memo VARCHAR ( 50))

7. Category of educational attainment

CREATE TABLE ms_education (educationid varchar () not NULL PRIMARY key,dducationname varchar (50), Memo varchar)

8. Technical Title setting

Personnel system-personnel subsystem: basic data