HR基本信息导入
API：
代码
1 -- Created on 9/24/2008 by ANSON LOCKSLEY
2 DECLARE
3 -- In/Out variables here
4 l_employee_number VARCHAR2(30) := '98855';
5 -- Out variables here
6 o_person_id per_all_people_f.person_id%TYPE;
7 o_assignment_id per_all_assignments_f.assignment_id%TYPE;
8 o_per_object_version_number per_all_people_f.object_version_number%TYPE;
9 o_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
10 o_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
11 o_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
12 o_full_name per_all_people_f.full_name%TYPE;
13 o_per_comment_id per_all_people_f.comment_id%TYPE;
14 o_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
15 o_assignment_number per_all_assignments_f.assignment_number%TYPE;
16 o_name_combination_warning BOOLEAN;
17 o_assign_payroll_warning BOOLEAN;
18 o_orig_hire_warning BOOLEAN;
19
20 BEGIN
21
22 -- Test statements here
23 hr_employee_api.create_employee(p_validate => FALSE, -- (Required) TRUE/FALSE TRUE数据校验不更新数据库/FALSE数据校验通过后更新数据库
24 p_hire_date => to_date('20101125', 'yyyymmdd'), -- (Required) Hire Date. 雇用日期
25 p_business_group_id => 0, -- (Required) Business group of the person. 人员业务组
26 p_last_name => 'Locksley', -- (Required) Last Name. 姓
27 p_sex => 'M', -- (Required) Legal gender. 法定性别(通过 SEX Lookup Type校验数据)
28 p_person_type_id => 6, -- Type of employee being created. 员工类型ID --如正式员工6
29 p_per_comments => NULL, -- Person comment text. 员工描述文字
30 p_date_employee_data_verified => NULL, -- Date on which the employee data was last verified. 员工数据最新验证日期
31 p_date_of_birth => NULL, -- Date of birth. 出生日期
32 p_email_address => NULL, -- Email address. 电子邮件地址
33 p_employee_number => l_employee_number, -- (Required/Derived) Employee Number. 由当前业务组的员工编号生成方法来决定是输入值或得到值
34 p_expense_check_send_to_addres => NULL, -- Mailing address. 邮件地址
35 p_first_name => NULL, -- First name. 名
36 p_known_as => NULL, -- Preferred name. 其他名称
37 p_marital_status => NULL, -- Marital status.婚姻状况 (通过 MAR_STATUS Lookup Type校验数据)
38 p_middle_names => NULL, -- Middle names. 中间名
39 p_nationality => NULL, -- Nationality. 国籍 (通过 NATIONALITY Lookup Type校验数据)
40 p_national_identifier => '123123123123123123', -- (Required) Number by which a person is identified in a given legislation. 身份证
41 p_previous_last_name => NULL, -- Previous last name. 曾用名
42 p_registered_disabled_flag => NULL, -- Flag indicating whether the person is classified as disabled. 残疾标志
43 p_title => NULL, -- Title. 头衔 (通过 TITLE Lookup Type校验数据)
44 p_vendor_id => NULL, -- Do not use. 不使用
45 p_work_telephone => NULL, -- Do not use. 不使用
46 p_attribute_category => NULL,
47 p_attribute1 => NULL,
48 p_attribute2 => NULL,
49 p_attribute3 => NULL,
50 p_attribute4 => NULL,
51 p_attribute5 => NULL,
52 p_attribute6 => NULL,
53 p_attribute7 => NULL,
54 p_attribute8 => NULL,
55 p_attribute9 => NULL,
56 p_attribute10 => NULL,
57 p_attribute11 => NULL,
58 p_attribute12 => NULL,
59 p_attribute13 => NULL,
60 p_attribute14 => NULL,
61 p_attribute15 => NULL,
62 p_attribute16 => NULL,
63 p_attribute17 => NULL,
64 p_attribute18 => NULL,
65 p_attribute19 => NULL,
66 p_attribute20 => NULL,
67 p_attribute21 => NULL,
68 p_attribute22 => NULL,
69 p_attribute23 => NULL,
70 p_attribute24 => NULL,
71 p_attribute25 => NULL,
72 p_attribute26 => NULL,
73 p_attribute27 => NULL,
74 p_attribute28 => NULL,
75 p_attribute29 => NULL,
76 p_attribute30 => NULL,
77 p_per_information_category => 'CN',
78 p_per_information1 => NULL,
79 p_per_information2 => NULL,
80 p_per_information4 => 1, --户口类型
81 p_per_information5 => 350000, --户口所在地
82 p_per_information6 => NULL, --最高学历
83 p_per_information7 => NULL, --子女数
84 p_per_information8 => 'N', --是否出国
85 p_per_information10 => NULL, --健康状况
86 p_per_information11 => NULL, --免税指示符
87 p_per_information12 => NULL, --免税比例
88 p_per_information14 => NULL,
89 p_per_information15 => NULL,
90 p_per_information16 => NULL, --曾用名
91 p_per_information17 => NULL, --民族
92 p_per_information18 => NULL, --社会保险IC编号
93 p_date_of_death => NULL, -- Date of death. 死亡日期
94 p_background_check_status => NULL, -- 是否进行背景校验
95 p_background_date_check => NULL, -- 背景校验日期
96 p_blood_type => NULL, -- Blood type. 血型
97 p_correspondence_language => 'ZHS', -- 语言种类
98 p_fast_path_employee => NULL, -- Do not use. 不使用
99 p_fte_capacity => NULL, -- Do not use. 不使用
100 p_honors => NULL, -- Honors awarded. 获得荣誉
101 p_internal_location => NULL, -- Internal location of office. 内部地址
102 p_last_medical_test_by => NULL, -- 最近医疗检测医师姓名
103 p_last_medical_test_date => NULL, -- 最近医疗检测时间
104 p_mailstop => NULL, -- Internal mail location. 内部邮件地址
105 p_office_number => NULL, -- Office number. 办公室电话
106 p_on_military_service => NULL, -- 是否服兵役标示
107 p_pre_name_adjunct => NULL, -- 姓的首音节
108 p_projected_start_date => NULL, -- Do not use. 不使用
109 p_resume_exists => NULL, -- 是否有简历
110 p_resume_last_updated => NULL, -- 简历最后更新日期
111 p_second_passport_exists => NULL, -- 是否有第二本护照
112 p_student_status => NULL, -- 学生状态 (通过 STUDENT_STATUS Lookup Type校验数据)
113 p_work_schedule => NULL, -- 工作计划
114 p_suffix => NULL, -- 姓名前缀
115 p_benefit_group_id => NULL, -- 受益组织
116 p_receipt_of_death_cert_date => NULL, -- 收到死亡证明日期
117 p_coord_ben_med_pln_no => NULL,
118 p_coord_ben_no_cvg_flag => NULL,
119 p_coord_ben_med_ext_er => NULL,
120 p_coord_ben_med_pl_name => NULL,
121 p_coord_ben_med_insr_crr_name => NULL,
122 p_coord_ben_med_insr_crr_ident => NULL,
123 p_coord_ben_med_cvg_strt_dt => NULL,
124 p_coord_ben_med_cvg_end_dt => NULL,
125 p_uses_tobacco_flag => NULL, -- 是否吸烟
126 p_dpdnt_adoption_date => NULL, -- 被收养日期
127 p_dpdnt_vlntry_svce_flag => NULL, -- 领养人是否为志愿者
128 p_original_date_of_hire => to_date('20101125', 'yyyymmdd'), -- (Required) Original date of hire. 原始雇用日期
129 p_adjusted_svc_date => NULL, -- 调整服务日期
130 p_town_of_birth => NULL, -- 籍贯
131 p_region_of_birth => NULL, -- 出生地区
132 p_country_of_birth => NULL, -- 出生国家
133 p_global_person_id => NULL, -- Do not use. 不使用
134 p_party_id => NULL,
135 p_person_id => o_person_id, -- (Derived)
136 p_assignment_id => o_assignment_id, -- (Derived)
137 p_per_object_version_number => o_per_object_version_number, -- (Derived)
138 p_asg_object_version_number => o_asg_object_version_number, -- (Derived)
139 p_per_effective_start_date => o_per_effective_start_date, -- (Derived)
140 p_per_effective_end_date => o_per_effective_end_date, -- (Derived)
141 p_full_name => o_full_name, -- (Derived)
142 p_per_comment_id => o_per_comment_id, -- (Derived)
143 p_assignment_sequence => o_assignment_sequence, -- (Derived)
144 p_assignment_number => o_assignment_number, -- (Derived)
145 p_name_combination_warning => o_name_combination_warning, -- (Derived)
146 p_assign_payroll_warning => o_assign_payroll_warning, -- (Derived)
147 p_orig_hire_warning => o_orig_hire_warning); -- (Derived)
148
149 END;
2 DECLARE
3 -- In/Out variables here
4 l_employee_number VARCHAR2(30) := '98855';
5 -- Out variables here
6 o_person_id per_all_people_f.person_id%TYPE;
7 o_assignment_id per_all_assignments_f.assignment_id%TYPE;
8 o_per_object_version_number per_all_people_f.object_version_number%TYPE;
9 o_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
10 o_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
11 o_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
12 o_full_name per_all_people_f.full_name%TYPE;
13 o_per_comment_id per_all_people_f.comment_id%TYPE;
14 o_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
15 o_assignment_number per_all_assignments_f.assignment_number%TYPE;
16 o_name_combination_warning BOOLEAN;
17 o_assign_payroll_warning BOOLEAN;
18 o_orig_hire_warning BOOLEAN;
19
20 BEGIN
21
22 -- Test statements here
23 hr_employee_api.create_employee(p_validate => FALSE, -- (Required) TRUE/FALSE TRUE数据校验不更新数据库/FALSE数据校验通过后更新数据库
24 p_hire_date => to_date('20101125', 'yyyymmdd'), -- (Required) Hire Date. 雇用日期
25 p_business_group_id => 0, -- (Required) Business group of the person. 人员业务组
26 p_last_name => 'Locksley', -- (Required) Last Name. 姓
27 p_sex => 'M', -- (Required) Legal gender. 法定性别(通过 SEX Lookup Type校验数据)
28 p_person_type_id => 6, -- Type of employee being created. 员工类型ID --如正式员工6
29 p_per_comments => NULL, -- Person comment text. 员工描述文字
30 p_date_employee_data_verified => NULL, -- Date on which the employee data was last verified. 员工数据最新验证日期
31 p_date_of_birth => NULL, -- Date of birth. 出生日期
32 p_email_address => NULL, -- Email address. 电子邮件地址
33 p_employee_number => l_employee_number, -- (Required/Derived) Employee Number. 由当前业务组的员工编号生成方法来决定是输入值或得到值
34 p_expense_check_send_to_addres => NULL, -- Mailing address. 邮件地址
35 p_first_name => NULL, -- First name. 名
36 p_known_as => NULL, -- Preferred name. 其他名称
37 p_marital_status => NULL, -- Marital status.婚姻状况 (通过 MAR_STATUS Lookup Type校验数据)
38 p_middle_names => NULL, -- Middle names. 中间名
39 p_nationality => NULL, -- Nationality. 国籍 (通过 NATIONALITY Lookup Type校验数据)
40 p_national_identifier => '123123123123123123', -- (Required) Number by which a person is identified in a given legislation. 身份证
41 p_previous_last_name => NULL, -- Previous last name. 曾用名
42 p_registered_disabled_flag => NULL, -- Flag indicating whether the person is classified as disabled. 残疾标志
43 p_title => NULL, -- Title. 头衔 (通过 TITLE Lookup Type校验数据)
44 p_vendor_id => NULL, -- Do not use. 不使用
45 p_work_telephone => NULL, -- Do not use. 不使用
46 p_attribute_category => NULL,
47 p_attribute1 => NULL,
48 p_attribute2 => NULL,
49 p_attribute3 => NULL,
50 p_attribute4 => NULL,
51 p_attribute5 => NULL,
52 p_attribute6 => NULL,
53 p_attribute7 => NULL,
54 p_attribute8 => NULL,
55 p_attribute9 => NULL,
56 p_attribute10 => NULL,
57 p_attribute11 => NULL,
58 p_attribute12 => NULL,
59 p_attribute13 => NULL,
60 p_attribute14 => NULL,
61 p_attribute15 => NULL,
62 p_attribute16 => NULL,
63 p_attribute17 => NULL,
64 p_attribute18 => NULL,
65 p_attribute19 => NULL,
66 p_attribute20 => NULL,
67 p_attribute21 => NULL,
68 p_attribute22 => NULL,
69 p_attribute23 => NULL,
70 p_attribute24 => NULL,
71 p_attribute25 => NULL,
72 p_attribute26 => NULL,
73 p_attribute27 => NULL,
74 p_attribute28 => NULL,
75 p_attribute29 => NULL,
76 p_attribute30 => NULL,
77 p_per_information_category => 'CN',
78 p_per_information1 => NULL,
79 p_per_information2 => NULL,
80 p_per_information4 => 1, --户口类型
81 p_per_information5 => 350000, --户口所在地
82 p_per_information6 => NULL, --最高学历
83 p_per_information7 => NULL, --子女数
84 p_per_information8 => 'N', --是否出国
85 p_per_information10 => NULL, --健康状况
86 p_per_information11 => NULL, --免税指示符
87 p_per_information12 => NULL, --免税比例
88 p_per_information14 => NULL,
89 p_per_information15 => NULL,
90 p_per_information16 => NULL, --曾用名
91 p_per_information17 => NULL, --民族
92 p_per_information18 => NULL, --社会保险IC编号
93 p_date_of_death => NULL, -- Date of death. 死亡日期
94 p_background_check_status => NULL, -- 是否进行背景校验
95 p_background_date_check => NULL, -- 背景校验日期
96 p_blood_type => NULL, -- Blood type. 血型
97 p_correspondence_language => 'ZHS', -- 语言种类
98 p_fast_path_employee => NULL, -- Do not use. 不使用
99 p_fte_capacity => NULL, -- Do not use. 不使用
100 p_honors => NULL, -- Honors awarded. 获得荣誉
101 p_internal_location => NULL, -- Internal location of office. 内部地址
102 p_last_medical_test_by => NULL, -- 最近医疗检测医师姓名
103 p_last_medical_test_date => NULL, -- 最近医疗检测时间
104 p_mailstop => NULL, -- Internal mail location. 内部邮件地址
105 p_office_number => NULL, -- Office number. 办公室电话
106 p_on_military_service => NULL, -- 是否服兵役标示
107 p_pre_name_adjunct => NULL, -- 姓的首音节
108 p_projected_start_date => NULL, -- Do not use. 不使用
109 p_resume_exists => NULL, -- 是否有简历
110 p_resume_last_updated => NULL, -- 简历最后更新日期
111 p_second_passport_exists => NULL, -- 是否有第二本护照
112 p_student_status => NULL, -- 学生状态 (通过 STUDENT_STATUS Lookup Type校验数据)
113 p_work_schedule => NULL, -- 工作计划
114 p_suffix => NULL, -- 姓名前缀
115 p_benefit_group_id => NULL, -- 受益组织
116 p_receipt_of_death_cert_date => NULL, -- 收到死亡证明日期
117 p_coord_ben_med_pln_no => NULL,
118 p_coord_ben_no_cvg_flag => NULL,
119 p_coord_ben_med_ext_er => NULL,
120 p_coord_ben_med_pl_name => NULL,
121 p_coord_ben_med_insr_crr_name => NULL,
122 p_coord_ben_med_insr_crr_ident => NULL,
123 p_coord_ben_med_cvg_strt_dt => NULL,
124 p_coord_ben_med_cvg_end_dt => NULL,
125 p_uses_tobacco_flag => NULL, -- 是否吸烟
126 p_dpdnt_adoption_date => NULL, -- 被收养日期
127 p_dpdnt_vlntry_svce_flag => NULL, -- 领养人是否为志愿者
128 p_original_date_of_hire => to_date('20101125', 'yyyymmdd'), -- (Required) Original date of hire. 原始雇用日期
129 p_adjusted_svc_date => NULL, -- 调整服务日期
130 p_town_of_birth => NULL, -- 籍贯
131 p_region_of_birth => NULL, -- 出生地区
132 p_country_of_birth => NULL, -- 出生国家
133 p_global_person_id => NULL, -- Do not use. 不使用
134 p_party_id => NULL,
135 p_person_id => o_person_id, -- (Derived)
136 p_assignment_id => o_assignment_id, -- (Derived)
137 p_per_object_version_number => o_per_object_version_number, -- (Derived)
138 p_asg_object_version_number => o_asg_object_version_number, -- (Derived)
139 p_per_effective_start_date => o_per_effective_start_date, -- (Derived)
140 p_per_effective_end_date => o_per_effective_end_date, -- (Derived)
141 p_full_name => o_full_name, -- (Derived)
142 p_per_comment_id => o_per_comment_id, -- (Derived)
143 p_assignment_sequence => o_assignment_sequence, -- (Derived)
144 p_assignment_number => o_assignment_number, -- (Derived)
145 p_name_combination_warning => o_name_combination_warning, -- (Derived)
146 p_assign_payroll_warning => o_assign_payroll_warning, -- (Derived)
147 p_orig_hire_warning => o_orig_hire_warning); -- (Derived)
148
149 END;
附加信息查询：
代码
1 -- SEX Lookup Type 性别编码
2 SELECT *
3 FROM hr_lookups t
4 WHERE t.lookup_type = 'SEX';
5
6 -- MAR_STATUS Lookup Type 婚姻状况编码
7 SELECT *
8 FROM hr_lookups t
9 WHERE t.lookup_type = 'MAR_STATUS';
10
11 -- NATIONALITY Lookup Type 国际编码
12 SELECT *
13 FROM hr_lookups t
14 WHERE t.lookup_type = 'NATIONALITY';
15
16 -- TITLE Lookup Type 头衔编码
17 SELECT *
18 FROM hr_lookups t
19 WHERE t.lookup_type = 'TITLE';
20
21 -- STUDENT_STATUS Lookup Type 学生状态
22 SELECT *
23 FROM hr_lookups t
24 WHERE t.lookup_type = 'STUDENT_STATUS';
25
2 SELECT *
3 FROM hr_lookups t
4 WHERE t.lookup_type = 'SEX';
5
6 -- MAR_STATUS Lookup Type 婚姻状况编码
7 SELECT *
8 FROM hr_lookups t
9 WHERE t.lookup_type = 'MAR_STATUS';
10
11 -- NATIONALITY Lookup Type 国际编码
12 SELECT *
13 FROM hr_lookups t
14 WHERE t.lookup_type = 'NATIONALITY';
15
16 -- TITLE Lookup Type 头衔编码
17 SELECT *
18 FROM hr_lookups t
19 WHERE t.lookup_type = 'TITLE';
20
21 -- STUDENT_STATUS Lookup Type 学生状态
22 SELECT *
23 FROM hr_lookups t
24 WHERE t.lookup_type = 'STUDENT_STATUS';
25
在HRMS 中, 标识类型的快速编码
系统人员类型 （PERSON_TYPE）
适用于中国法规的户口类型 （CN_HUKOU_TYPE）
适用于中国法规的户口所在地 （CN_HUKOU_LOCN）
地址类型 （ADDRESS_TYPE）
人事系统分配状态类型 （PER_ASS_SYS_STATUS）
雇佣类别 （EMP_CAT）
员工类别 （EMPLOYEE_CATG）
查找适用于中国的档案类别 （CN_FILE_ARCHIVE）
查找适用于中国的奖惩类别 （CN_RDP_TYPE）
查找适用于中国的政治面貌 （CN_PARTY_TYPE）
查找适用于中国的政治面貌状况 （CN_PARTY_STATUS）
合同类型 （CONTRACT_TYPE）
缺勤类型类别 （ABSENCE_CATEGORY）
组织类型 （ORG_TYPE）
空缺类别 （VACANCY CATEGORY）
评级标准类型 （RATING_SCALE_TYPE）
鉴定评估状态 （APPRAISAL_ASSESSMENT_STATUS）
评估类型 （APPRAISAL_TYPE）
能力类型 （COMPETENCE_TYPE）
资源类型 （RESOURCE_TYPE）
标识原因的快速编码
对员工分配的更改原因 （EMP_ASSIGN_REASON）
残疾原因 （DISABILITY_REASON）
合同状态原因 （CONTRACT_STATUS_REASON）
合同开始原因 （CONTRACT_START_REASON）
合同终止原因 （CONTRACT_END_REASON）
请假原因 （LEAV_REAS）
更改申请人分配的原因 （APL_ASSIGN_REASON）
原因（用于终止申请）（TERM APL REASON）
活动使用资源的原因 （RESOURCE_USAGE_REASON）
登记状态更改的原因 （ENROLMENT_STATUS_REASON）
学员无法成功完成事件的原因 （DELEGATE_FAILURE_REASON）
称谓 TITLE
组织类型 ： ORG_TYPE
成长
/ | \
学习 总结 分享
QQ交流群：122230156
