TalentPersonProfilesworkHistorySectionsworkHistoryItems

Columns


Name	Type	SupportedFinders	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	PrimaryKey	Surrogate identifier for the person profile.
SectionId	Long	FindLatestProfileItemForORC	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	FindCareerAmbassadorsBySkillGroup	Group of TalentPersonProfilesworkHistorySectionsworkHistoryItems
PersonId	Long	FindEligibleSections, findLatestProfileItemForORC, findByPersonId	PersonId of TalentPersonProfilesworkHistorySectionsworkHistoryItems
SysEffectiveDate	String	FindEligibleSections, findLatestProfileItemForORC, findByPersonId, findCareerAmbassadorsBySkillGroup	SysEffectiveDate of TalentPersonProfilesworkHistorySectionsworkHistoryItems

JDBC Driver for Oracle Fusion Cloud HCM

TalentPersonProfilesworkHistorySectionsworkHistoryItems

Columns