New dataload template: Update Person v101

New dataload template: Update Person v101

This template is using the HR_PERSON_API.UPDATE_PERSON API. Fully tested to update email addresses, but can easily be setup for any other of the API fields:

P_COMMENTS
P_DATE_EMPLOYEE_DATA_VERIFIED
P_DATE_OF_BIRTH
P_EMAIL_ADDRESS
P_EMPLOYEE_NUMBER
P_EXPENSE_CHECK_SEND_TO_ADDRES
P_FIRST_NAME
P_KNOWN_AS
P_MARITAL_STATUS
P_MIDDLE_NAMES
P_NATIONALITY
P_NATIONAL_IDENTIFIER
P_PREVIOUS_LAST_NAME
P_REGISTERED_DISABLED_FLAG
P_SEX
P_TITLE
P_VENDOR_ID
P_WORK_TELEPHONE
P_ATTRIBUTE_CATEGORY
P_ATTRIBUTE1
P_ATTRIBUTE2
P_ATTRIBUTE3
P_ATTRIBUTE4
P_ATTRIBUTE5
P_ATTRIBUTE6
P_ATTRIBUTE7
P_ATTRIBUTE8
P_ATTRIBUTE9
P_ATTRIBUTE10
P_ATTRIBUTE11
P_ATTRIBUTE12
P_ATTRIBUTE13
P_ATTRIBUTE14
P_ATTRIBUTE15
P_ATTRIBUTE16
P_ATTRIBUTE17
P_ATTRIBUTE18
P_ATTRIBUTE19
P_ATTRIBUTE20
P_ATTRIBUTE21
P_ATTRIBUTE22
P_ATTRIBUTE23
P_ATTRIBUTE24
P_ATTRIBUTE25
P_ATTRIBUTE26
P_ATTRIBUTE27
P_ATTRIBUTE28
P_ATTRIBUTE29
P_ATTRIBUTE30
P_PER_INFORMATION_CATEGORY
P_PER_INFORMATION1
P_PER_INFORMATION2
P_PER_INFORMATION3
P_PER_INFORMATION4
P_PER_INFORMATION5
P_PER_INFORMATION6
P_PER_INFORMATION7
P_PER_INFORMATION8
P_PER_INFORMATION9
P_PER_INFORMATION10
P_PER_INFORMATION11
P_PER_INFORMATION12
P_PER_INFORMATION13
P_PER_INFORMATION14
P_PER_INFORMATION15
P_PER_INFORMATION16
P_PER_INFORMATION17
P_PER_INFORMATION18
P_PER_INFORMATION19
P_PER_INFORMATION20
P_PER_INFORMATION21
P_PER_INFORMATION22
P_PER_INFORMATION23
P_PER_INFORMATION24
P_PER_INFORMATION25
P_PER_INFORMATION26
P_PER_INFORMATION27
P_PER_INFORMATION28
P_PER_INFORMATION29
P_PER_INFORMATION30
P_DATE_OF_DEATH
P_BACKGROUND_CHECK_STATUS
P_BACKGROUND_DATE_CHECK
P_BLOOD_TYPE
P_CORRESPONDENCE_LANGUAGE
P_FAST_PATH_EMPLOYEE
P_FTE_CAPACITY
P_HOLD_APPLICANT_DATE_UNTIL
P_HONORS
P_INTERNAL_LOCATION
P_LAST_MEDICAL_TEST_BY
P_LAST_MEDICAL_TEST_DATE
P_MAILSTOP
P_OFFICE_NUMBER
P_ON_MILITARY_SERVICE
P_PRE_NAME_ADJUNCT
P_PROJECTED_START_DATE
P_REHIRE_AUTHORIZOR
P_REHIRE_RECOMMENDATION
P_RESUME_EXISTS
P_RESUME_LAST_UPDATED
P_SECOND_PASSPORT_EXISTS
P_STUDENT_STATUS
P_WORK_SCHEDULE
P_REHIRE_REASON
P_SUFFIX
P_BENEFIT_GROUP_ID
P_RECEIPT_OF_DEATH_CERT_DATE
P_COORD_BEN_MED_PLN_NO
P_COORD_BEN_NO_CVG_FLAG
P_COORD_BEN_MED_EXT_ER
P_COORD_BEN_MED_PL_NAME
P_COORD_BEN_MED_INSR_CRR_NAME
P_COORD_BEN_MED_INSR_CRR_IDENT
P_COORD_BEN_MED_CVG_STRT_DT
P_COORD_BEN_MED_CVG_END_DT
P_USES_TOBACCO_FLAG
P_DPDNT_ADOPTION_DATE
P_DPDNT_VLNTRY_SVCE_FLAG
P_ORIGINAL_DATE_OF_HIRE
P_ADJUSTED_SVC_DATE
P_TOWN_OF_BIRTH
P_REGION_OF_BIRTH
P_COUNTRY_OF_BIRTH
P_GLOBAL_PERSON_ID
P_PARTY_ID
P_NPW_NUMBER
P_FULL_NAME

 

This entry was posted in Dataload, Templates, xls4oracle. Bookmark the permalink.