TalentPersonProfilesworkHistorySectionsworkHistoryItems
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
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Group | String | Group |
PersonId | Long | PersonId |
ProfileId | Long | ProfileId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |