HR基本消息导入

API:

 

社会保险 1社会保险 2代码

  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;

 

 

 

叠加音信查询:

 

社会保险 3社会保险 4代码

 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

发表评论

电子邮件地址不会被公开。 必填项已用*标注