TalentPersonProfilesworkHistorySectionsworkHistoryItems

Columns


Name	Type	Description
TalentPersonProfilesProfileId [KEY]	Long	Surrogate identifier for the person profile.
WorkhistorysectionsProfileSectionId [KEY]	Long	Surrogate identifier for the work history section.
WorkHistoryId [KEY]	Long	Unique identifier for work history.
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	User who created the work history item.
CreationDate	Datetime	Date and time when the work history item was created.
LastUpdatedBy	String	User who last updated the work history item.
LastUpdateDate	Datetime	Date and time when the work history item was last updated.
JobFunctionMeaning	String	Meaning of the job function of previous employment.

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Group	String	Group
PersonId	Long	PersonId
ProfileId	Long	ProfileId
SysEffectiveDate	String	SysEffectiveDate
Finder	String	finder

ODBC Driver for Oracle Fusion Cloud HCM

TalentPersonProfilesworkHistorySectionsworkHistoryItems

Columns

Pseudo-Columns