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

JDBC Driver for Oracle Fusion Cloud HCM

TalentPersonProfilesworkHistorySectionsworkHistoryItems

Columns