ODBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

TalentPersonProfilesworkHistorySectionsworkHistoryItems

TalentPersonProfilesworkHistorySectionsworkHistoryItems

Columns

Name Type Description
TalentPersonProfilesProfileId [KEY] Long TalentPersonProfilesProfileId of TalentPersonProfilesworkHistorySectionsworkHistoryItems
WorkhistorysectionsProfileSectionId [KEY] Long WorkhistorysectionsProfileSectionId of TalentPersonProfilesworkHistorySectionsworkHistoryItems
WorkHistoryId [KEY] Long WorkHistoryId of TalentPersonProfilesworkHistorySectionsworkHistoryItems
JobTitle String Title of the Job.
EmployerName String Name of the employer.
StartDate Date Start date of the profile item record.
EndDate Date End date of the profile item record.
CurrentJob String Indicates whether the job is current. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
EmployerCountry String Country of the employer. Valid values are defined in the hcmCountriesLOV.
EmployerStateOrProvince String State or province of the employer. Valid values are defined in the hcmAddressesLOV.
EmployerCity String City of the employer.
Responsibilities String Responsibilities in the previous employment.
PartTime String Indicates whether the employment was part time. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
Internal String Indicates whether the work history item is internal. Valid values are Y and N. Valid values are defined in the commonLookupsLOV.
TypeofBusiness String Type of business of the employer.
EmployerPhone String Phone number of the employer.
DepartmentOrDivisionOrPost String Department, division, or post attributed to the previous employment.
JobFamilyId Long Job family associated with the previous employment.
JobFamilyCode String Code of the job family the previous employment is associated with. Valid values are defined in the jobFamiliesLOV.
JobFunction String Job function of the previous employment. Valid values are defined in the commonLookupsLOV.
OtherJobFunction String Other job functions associated with the previous employment.
Achievements String Achievements in the previous employment.
DirectReports Long Number of direct reports in the previous employment.
StartingPosition String Starting position in the previous employment.
SupervisorName String Name of the supervisor.
SupervisorTitle String Title of the supervisor.
SupervisorEmail String Email of the supervisor.
SupervisorPhone String Phone number of the supervisor.
OkToContactSupervisor String Indicates whether the supervisor can be contacted. Valid values are Y and N. Valid values are defined in commonLookupsLOV.
ReasonforLeaving String Reason for leaving the previous employment.
AdditionalInformation String Additional information on the previous employment.
StartingCompensation Double Starting compensation in the previous employment.
EndingCompensation Double Ending compensation at previous employment.
OtherCompensation String Other form of compensation.
CompanyURL String URL linked to the previous employment.
CreatedBy String CreatedBy of TalentPersonProfilesworkHistorySectionsworkHistoryItems
CreationDate Datetime CreationDate of TalentPersonProfilesworkHistorySectionsworkHistoryItems
LastUpdatedBy String LastUpdatedBy of TalentPersonProfilesworkHistorySectionsworkHistoryItems
LastUpdateDate Datetime LastUpdateDate of TalentPersonProfilesworkHistorySectionsworkHistoryItems
ProfileId Long Surrogate identifier for the person profile.
SectionId Long Unique identifier of the content section.
JobFunctionMeaning String Meaning of the job function of previous employment.
Source String Source of TalentPersonProfilesworkHistorySectionsworkHistoryItems
SourceType String Code representing the source of work history item.
Finder String Finder of TalentPersonProfilesworkHistorySectionsworkHistoryItems
Group String Group of TalentPersonProfilesworkHistorySectionsworkHistoryItems
PersonId Long PersonId of TalentPersonProfilesworkHistorySectionsworkHistoryItems
SysEffectiveDate String SysEffectiveDate of TalentPersonProfilesworkHistorySectionsworkHistoryItems

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062