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;
叠加音信查询:
代码
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
在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)
联系人类型 CONTACT
称谓 TITLE
社团项目 : ORG_TYPE