Establishing a Connection

Create a connection to Oracle HCM Cloud by navigating to the Connections page in the Sync App application and selecting the corresponding icon in the Add Connections panel. If the Oracle HCM Cloud icon is not available, click the Add More icon to download and install the Oracle HCM Cloud connector from the CData site.

Required properties are listed under the Settings tab. The Advanced tab lists connection properties that are not typically required.

Connecting to Oracle HCM Cloud

You must set the following to authenticate to Oracle HCM Cloud:

Url: The Url of your account.
User: The user of your account.
Password: The password of your account.

Data Model

Overview

This section shows the available API objects and provides more information on executing SQL to Oracle HCM Cloud APIs.

Key Features

The Sync App models Oracle HCM Cloud entities like jobs, tasks, and salaries as relational views, allowing you to write SQL to query Oracle HCM Cloud data.
Stored procedures allow you to execute operations to Oracle HCM Cloud.
Live connectivity to these objects means any changes to your Oracle HCM Cloud account are immediately reflected when using the Sync App.

Views

Views are dynamically obtained to model Oracle HCM Cloud objects.

Stored Procedures

Stored Procedures are function-like interfaces to Oracle HCM Cloud. They can be used to create schemas from Oracle ERP tables.

Views

Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.

Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.

Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.

Oracle HCM Cloud Connector for CData Sync Views

RecruitingCandidateDuplicates

Columns


Name	Type	Description
DupChkLogId [KEY]	String	Unique identifier for the candidate duplicate check.
PersonId	String	Person ID of the candidate for which a duplicate candidate check was done.
DupStrength	String	Match score obtained for the candidate duplicate check.
DupStrengthCount	String	Number of duplicate candidates that have the highest match score.
RequestedBy	String	User who initiated the candidate duplicate check.
RequestedOn	String	Date and time when the candidate duplicate check was initiated.
SubmissionId	String	Job application ID for which a candidate duplicate check was automatically triggered.
StateId	String	State ID when the candidate duplicate check was automatically triggered.
PhaseId	String	Phase ID when the candidate duplicate check was automatically triggered.

RecruitingCEAddressFormats

Columns


Name	Type	Description
TerritoryCode [KEY]	String	Code assigned to the territory in the address format

RecruitingCEAddressFormatsaddressFormatDetails

Columns


Name	Type	Description
RecruitingCEAddressFormatsTerritoryCode	String	Finds the address formats for a given country using a unique ID and the territory code
TerritoryCode	String	Code assigned to the territory in the address format details
Prompt	String	Prompt to assist entering the required address details
AttributeName	String	Name assigned to the attribute to retrieve address details
Maxlength	String	Column with the list of values pertaining to the address details
LovColumn	String	Column with the list of values pertaining to the address details
Uidisplaytype	String	Type of display used as the user interface
DisplaySequence	String	Sequence in which the address is displayed
RequiredFlag	Bool	Indicates if the information is required

RecruitingCEAddressFormatsgeoHierarchies

Columns


Name	Type	Description
RecruitingCEAddressFormatsTerritoryCode	String	Finds the address formats for a given country using a unique ID and the territory code
GeographyName	String	Geography name of the element in the geography hierarchy.
DisplayName	String	Display name of the element in the geography hierarchy.
GeoElement1	String	Geographical element 1 in the geographical hierarchies
GeoElement2	String	Geographical element 2 in the geographical hierarchies
GeoElement3	String	Geographical element 3 in the geographical hierarchies
GeoElement4	String	Geographical element 4 in the geographical hierarchies
GeoElement5	String	Geographical element 5 in the geographical hierarchies
GeoElement6	String	Geographical element 6 in the geographical hierarchies
GeoElement7	String	Geographical element 7 in the geographical hierarchies
GeoElement8	String	Geographical element 8 in the geographical hierarchies
GeoElement9	String	Geographical element 9 in the geographical hierarchies
GeoElement10	String	Geographical element 10 in the geographical hierarchies

RecruitingCEAddressFormatsstateProvinces

Columns


Name	Type	Description
RecruitingCEAddressFormatsTerritoryCode	String	Finds the address formats for a given country using a unique ID and the territory code
GeoElement2	String	Geographical element 2 in the states and provinces information

RecruitingCEApplyFlows

Columns


Name	Type	Description
PrimaryKey [KEY]	String	Primary key for the job application flow.
FlowId	String	Unique identifier for the job application flows.
FlowCode	String	Flow code in the job application flows.
FlowTypeCode	String	Flow type code in the job application flows.
FlowVersionId	String	Flow version ID in the job application flows.
FlowName	String	Flow name for the job application flows.
FlowVersionName	String	Flow version name for the job application flows.
SingleClickApplyFlag	Bool	Indicates if single click apply is enabled.
LegalEnabledFlag	Bool	Indicates that the legal disclaimer is enabled.
EsignEnabledFlag	Bool	Indicates if electronic signature is enabled.
OptinEnabledFlag	Bool	Indicates if TC opt in is enabled.
TCOptinEnabledFlag	Bool	Indicates that the talent community opt-in is enabled.
LegalDescriptionVersionId	String	ID for the legal disclaimer version.
EsignDescriptionVersionId	String	ID for the version of the electronic signature.
OptinDescriptionVersionId	String	ID for OptinDescriptionVersion.
LegalDescriptionStr	String	Description of the specific legal disclaimer version.
EsignDescriptionStr	String	Description of the specific version of the electronic signature.
OptinDescriptionStr	String	Description of the specific opt in.
RequisitionNumber	String	Requisition number for the job application flow.
ProfileVersion	String	Specific version for profile.

RecruitingCEApplyFlowsrequisitionFlexFields

Columns


Name	Type	Description
RecruitingCEApplyFlowsPrimaryKey	String	Primary key and primary key variable find the job application flow.
Prompt	String	Display label of a flexfield.
Value	String	Value of a flexfield.
SequenceNumber	String	Sequence number of a flexfield.
ColumnName	String	Column name of a flexfield.

RecruitingCEApplyFlowssections

Columns


Name	Type	Description
RecruitingCEApplyFlowsPrimaryKey	String	Primary key and primary key variable find the job application flow.
SectionSequence	Int	Unique ID for section.
SectionName	String	Name of a section in job application flow.

RecruitingCEApplyFlowssectionspages

Columns


Name	Type	Description
RecruitingCEApplyFlowsPrimaryKey	String	Primary key and primary key variable find the job application flow.
PageSequence	Int	Unique ID for pages in the job application flow.
PageName	String	Name of pages in the job application flow.

RecruitingCEApplyFlowssectionspagesblocks

Columns


Name	Type	Description
RecruitingCEApplyFlowsPrimaryKey	String	Primary key and primary key variable find the job application flow.
PageBlockId	String	MetadataService in blocks.
BlockCode	String	Unique code for blocks.
BlockSequence	Int	Unique ID for blocks.
HideInMobileFlag	Bool	Indicates if the hide in mobile is enabled.
MetadataService	String	MetadataService in blocks.
ReadWriteService	String	ReadWriteService in blocks.
BlockName	String	Name of the block.
BlockTitle	String	Title of the block.
BlockInstructions	String	Instructions for the block.
BlockProperties	String	Get all blocks of a recruiting secondary application flow

RecruitingCEBackgroundChecks

Columns


Name	Type	Description
RequisitionNumber	String	Job requisition number of the background check.
ProvisioningId [KEY]	String	Provisioning ID of the background check.
BackgroundCheckURL	String	URL of the background check.

RecruitingCECandidateCertificationItems

Columns


Name	Type	Description
Comments	String	Comments for the certification.
CertificationId [KEY]	String	Certification ID of the certification.
RenewalInprogressFlag	Bool	Indicator to show that the renewal of the certification is in progress.
IssueDate	Date	Date on which the certification was issued
TotalAmount	String	Total amount paid for the certification.
CompletedAmount	String	Completed amount of the certification.
EducationalEstablishmentId	String	Unique identifier assigned to the educational establishment.
EducationalEstablishment	String	Educational establishment that issued the certification.
RenewalDate	Date	Date on which the certification was renewed.
Restrictions	String	Restrictions for the certification.
RenewalRequiredFlag	Bool	Indicator to show that the certification needs to be renewed.
StateProvinceId	String	State Province ID specified in the certification.
Title	String	Title of the certification item
CompletedTrainingUnits	String	Number of training units completed for the certification.
CertificationNumber	String	Number assigned to the certification.
VerifiedFlag	Bool	Indicator to show that the certification is verified.
CertificationName	String	Name of the certification.
ContentItemId	String	Unique identifier assigned to each content item.
ExpirationDate	Date	Expiration date of the certification.
CountryId	String	Country ID specified in the certification.
IssuedBy	String	Name of the authority that issued the certification.
LastRenewalDate	Date	Last date for renewal of the certification.
ActualCompletionDate	Date	Actual completion date of the certifications done by the candidate.
SectionId	String	Section ID specified in the certification.
OriginalIssueYear	String	Year when the certification was issued.
Status	String	Indicates the status of the certification item
FlowVersionId	String	This gives the Service Metadata
CertificationURL	String	URL of the certification.
CountryCode	String	Country Code specified in the certification
StateProvinceCode	String	State Province Code specified in the certification.
SubmissionId	String	Unique ID for each candidate's submitted requests

RecruitingCECandidateEducationItems

Columns


Name	Type	Description
EducationId [KEY]	String	ID assigned to the education item.
AcademicStanding	String	Performance of the candidate in education
ActivitySummary	String	Activity Summary in candidate education items.
AreaOfStudy	String	Area of study done by the candidate.
AverageGrade	String	Average grade secured in education by the candidate.
AwardingBody	String	Authority granting recognition in the field of education to the candidate.
City	String	City in which the education was done.
Comments	String	Comments on the candidate education details.
CompletedTraningUnits	String	Completed Training Units in candidate education items.
CompletedAmount	String	Completed Amount in candidate education items.
ContentItemId	String	Unique identifier assigned to the content.
CountryId	String	ID assigned to the country where the education was done.
DateAcquired	Date	Date when the degree was acquired.
DegreeName	String	Name of the education degree earned by the candidate.
Department	String	Department in which the education is acquired.
Description	String	Description of the education item.
Duration	String	Duration of the education.
DurationUnits	String	Unit of the duration of education.
EduLevelCompletedFlag	Bool	Indicates if the education is complete.
EducationLevel	String	Level of the education.
EducationURL	String	URL of the education.
EducationalEstablishment	String	Name of the education establishment.
EducationalEstablishmentId	String	ID assigned to the education establishment.
Educator	String	Educator of the education item.
EndDate	Date	End date of the education item.
Fee	String	Fees of the education item.
FeeCurrency	String	Currency in which the education fees has been paid.
GPA	Double	GPA score of the candidate.
GraduatedFlag	Bool	Indicates if the candidate is a graduate.
HighestEduLevel	String	Highest educational level availed by the candidate.
Major	String	Major subjects in the education availed by the candidate.
Minor	String	Minor subjects in education availed by the candidate.
PartTimeFlag	Bool	Indicates if the education item is part time or not.
ProjectedCompletionDate	Date	Projected completion date of the education item.
Reimbursements	String	Reimbursements that can be availed against an education item.
RequiredFlag	Bool	Indicates if the education item is required or not.
SectionId	String	Section ID assigned to the education item.
StartDate	Date	Start date of the education item.
StateProvinceId	String	Unique identifier assigned to the State Province where the education took place.
Status	String	Status of the education.
Title	String	Title of the education item
TotalAmount	String	Total amount of the education item
TrmnlDegDiscpFlag	Bool	Indicates if the education item is a terminal degree
TuitionMethod	String	Mode of tuition availed during the course of education.
YearAcquired	String	Year in which the education was completed.
FlowVersionId	String	This gives service metadata information
SubmissionId	String	Submission ID generated against the educational details entered by the candidate.
CountryCode	String	Country Code of the location of education.
StateProvinceCode	String	Code assigned to the State Province where the education took place.

RecruitingCECandidateExtraInformationMetadata

Columns


Name	Type	Description
ContextId [KEY]	String	Unique identifier for the extensible flexfield context.
IsMultiRow	String	Defines whether the context is multi row or not.
ContextName	String	Name of the context corresponding to extensible flexfields.

RecruitingCECandidateExtraInformationMetadataattributeList

Columns


Name	Type	Description
RecruitingCECandidateExtraInformationMetadataContextId	String	Finds all the extensible flexfield attributes that match the specific unique key.
Prompt	String	Defines the label to be shown for the attribute.
Name	String	Name of the context corresponding to the extensible flexfield attributes.
Type	String	Defines the type of values accepted by the attribute.
MaximumLength	String	Defines the maximum length this attribute can support.
Dictionary	String	Defines the dictionary using which the list of values can be retrieved for this attribute.
DefaultValue	String	Defines the default value of the attribute.
ControlType	String	Defines what's the control component to be displayed for this attribute.
AttributeId	String	Unique identifier for the extensible flexfield attributes in the metadata service.
ContextId	String	Unique identifier of the context in the metadata attributes.
IsReadOnly	String	Defines whether the attribute is read only or not.
IsRequired	String	Defines whether the attribute is mandatory or not.
ShowValueDescription	String	Defines the description of the attribute value.
DefinitionHelpText	String	Defines the help text that should be shown for the attribute.
IsUpperCaseOnly	String	Defines whether the attribute supports only upper case characters.
MaximumValue	String	Defines the maximum value of the attribute.
MinimumValue	String	Defines the minimum value of the attribute.
Precision	String	Defines the precision of the attribute value.
Scale	String	Defines the scale of the attribute.
CheckedValue	String	Defines what's the value to be saved when the check box attribute is selected.
NonCheckedValue	String	Defines the value to be saved when the attribute isn't selected.
DisplaySequence	String	Defines the order of displaying this attribute.
MultiRowUniqueKey	String	Indicates whether the current attribute is unique or not across different rows.
RightJustifiedZeroFilled	String	Fills the empty spaces with zeroes to the left of an existing value.

RecruitingCECandidateLanguageItems

Columns


Name	Type	Description
AbleToTeachFlag	Bool	Indicates if the candidate can teach the language.
LanguageId [KEY]	String	ID assigned to the language known to the candidate.
ReadingModelId	String	ID assigned to the reading model of the language.
SpeakingModelId	String	ID assigned to the speaking model of the language.
WritingLevelId	String	ID assigned to the language writing proficiency.
EvaluatedOn	Date	Date of evaluation of the language item.
Language	String	Language known to the candidate.
NativeSpeakerFlag	Bool	Indicates if the candidate is a native speaker of the language.
ReadingLevelId	String	ID assigned to the language reading proficiency.
SpeakingLevelId	String	ID assigned to the language speaking proficiency.
AbleToTranslateFlag	Bool	Indicates if the candidate can translate the language.
WritingModelId	String	ID assigned to the writing model of the language.
ContentItemId	String	Content Item ID in for the language items.
SectionId	String	Section ID in candidate language items.
FlowVersionId	String	FlowVersionId is used for all the services to return the corresponding service metadata information.
Comments	String	Comments on the language items.
EvaluationLocation	String	Location of evaluation of the language item.
SubmissionId	String	Unique ID which gets generated after the candidate submits a job request.

RecruitingCECandidatePIIMetadata

Columns


Name	Type	Description
AttributeName [KEY]	String	Name assigned to each block attribute.
RequiredFlag	Bool	Indicates if the metadata is required.
DisplaySequence	String	Sequence of display.
MaximumLength	Long	Maximum length.
Type	String	Type of attribute.
Prompt	String	UI prompt.
Dictionary	String	Dictionary service used.

RecruitingCECandidatePreferences

Columns


Name	Type	Description
CandidateNumber [KEY]	String	Number for a candidate.
OptInMarketingEmailFlag	Bool	Indicates that a candidate has opted to receive the recruitment marketing emails.
CampaignCode	String	Code for a campaign.
Mode	String	Mode of a candidate preference.

RecruitingCECandidatePreviousExpItems

Columns


Name	Type	Description
EmployerName	String	Employer name in the candidate previous experience items.
PreviousEmploymentId [KEY]	String	Previous employment ID in the candidate previous experience items.
JobTitle	String	Job title in the candidate previous experience items.
StartDate	Date	Start date in candidate previous experience items.
EndDate	Date	End date in the candidate previous experience items.
CurrentJobFlag	Bool	Indicates that it is the current job of the candidate.
EmployerCountryId	String	Employer country ID in the candidate previous experience items.
EmployerCity	String	Employer city in the candidate previous experience items.
Responsibilities	String	Responsibilities in the candidate previous experience items.
FullTimeCode	String	Indicates if the previous experience was a full time job.
InternalFlag	Bool	Indicates if the previous experience was an internal job.
BusinessType	String	Business type in the candidate previous experience items.
EmployerPhone	String	Employer phone in the candidate previous experience items.
Department	String	Department in the candidate previous experience items.
JobFamilyId	String	Job family Id in the candidate previous experience items.
JobFunction	String	Job function in the candidate previous experience items.
OtherJobFunction	String	Other job function in the candidate previous experience items.
Achievements	String	Achievements mentioned in the candidate previous experience items.
DirectReports	String	Direct Reports in candidate previous experience items.
StartingPosition	String	Starting position in the candidate previous experience items.
SupervisorName	String	Supervisor name in the candidate previous experience items.
SupervisorTitle	String	Supervisor title in the candidate previous experience items.
SupervisorEmail	String	Supervisor email in the candidate previous experience items.
SupervisorPhone	String	Supervisor phone in the candidate previous experience items.
ContactSupervisorFlag	Bool	Indicates that the supervisor needs to be contacted.
LeavingReason	String	Reason for leaving the previous job.
AdditionalInformation	String	Additional information in the candidate previous experience items.
StartCompensation	Double	Start compensation in candidate previous experience items.
EndCompensation	Double	End compensation in the candidate previous experience items.
OtherCompensation	String	Other compensation in the candidate previous experience items.
CompanyURL	String	Company URL in the candidate previous experience items.
SectionId	String	Section ID in candidate previous experience items.
FlowVersionId	String	Flow version ID in the candidate previous experience items.
EmployerStateId	String	Employer state ID in the candidate previous experience items.
SubmissionId	String	Submission ID in the candidate previous experience items.
CountryCode	String	Country code in the candidate previous experience items.
StateProvinceCode	String	State province code in the candidate previous experience items.

RecruitingCECandidateProfileBlocksMetadata

Columns


Name	Type	Description
SectionId	String	Section ID in the candidate profile blocks meta data.
ContentTypeId	String	Content type ID in the candidate profile blocks meta data.
AttributeName	String	Attribute name in the candidate profile blocks meta data.
KeyFlag	Bool	Indicates whether the candidate profile block metadata attribute is a key attribute. This attribute does not have a default value.
RequiredFlag	Bool	Indicates if the candidate profile blocks meta data is required.
UIHiddenFlag	Bool	Indicates if the candidate profile blocks meta data is hidden in the UI.
ReadOnlyFlag	Bool	Indicates if the candidate profile blocks meta data is read only.
Type	String	Type in the candidate profile blocks meta data.
MaximumLength	Long	Maximum length in the candidate profile blocks meta data.
DisplaySequence	Long	Display sequence in the candidate profile blocks meta data.
Prompt	String	Attribute to determine which properties should be prompted on the administrators UI pages for an easy understanding of the property description.
DefaultValue	String	Default value in the candidate profile blocks meta data.
Dictionary	String	Dictionary in the candidate profile blocks meta data.
FlowVersionId	String	Flow version ID in the candidate profile blocks meta data.

RecruitingCECandidateProfileImports

Columns


Name	Type	Description
ProfileId [KEY]	String	Profile ID of the candidate resume.
ProfileType	String	Profile type of the candidate resume.
ProviderToken	String	Provider token of the candidate resume.
AttachmentId	String	Attachment ID of the candidate resume.
FirstName	String	First name in the candidate resume.
LastName	String	Last name in the candidate resume.
MiddleNames	String	Middle name in the candidate resume.
Title	String	Title of the candidate resume.
Suffix	String	Suffix in the candidate resume.
PreNameAdjunct	String	Previous name adjunct in the candidate resume.
DisplayName	String	Display name in the candidate resume.
MilitaryRank	String	Military rank in the candidate resume.
AddressLine1	String	First address line in the candidate resume.
AddressLine2	String	Second address line in the candidate resume.
City	String	City in the candidate resume.
Region1	String	Region 1 in the candidate resume.
Region2	String	Region 2 in the candidate resume.
Region3	String	Region 3 in the candidate resume.
Country	String	Country in the candidate resume.
PostalCode	String	Postal code of the candidate address in the candidate resume.
Email	String	Email ID in the candidate resume.
MobilePhoneCountryCode	String	Mobile phone number country code in the candidate resume.
MobilePhoneAreaCode	String	Mobile phone number area code in the candidate resume.
MobilePhoneNumber	String	Mobile phone number in the candidate resume.
MockParam	String	Mock parameter in the candidate resume
FlowVersionId	String	Flow version ID of the candidate resume.

RecruitingCECandidateProfileImportsattachments

Columns


Name	Type	Description
RecruitingCECandidateProfileImportsProfileId	String	Finds a candidate by the ID and the profile ID
Id	String	Unique ID of the attachment in the candidate resume.
ProfileId	String	Profile ID of the attachment in the candidate resume.
Category	String	Category of the attachment in the candidate resume.
Type	String	Type of attachment in the candidate resume.
Title	String	Title of the attachment in the candidate resume.
Description	String	Description of the attachment in the candidate resume.
Attachment	String	Attachment in the candidate resume.
FileContents	String	File Contents of the attachment in the candidate resume.

RecruitingCECandidateProfileImportseducations

Columns


Name	Type	Description
RecruitingCECandidateProfileImportsProfileId	String	Finds a candidate by the ID and the profile ID
ContentTypeId	String	Content type ID of the education in the candidate resume.
ProfileId	String	Profile ID for education in the candidate resume.
StartDate	String	Start date for education in the candidate resume.
EndDate	String	End date for the completion of education in the candidate resume.
ContentItemId	String	Content item ID of the education in the candidate resume.
Major	String	Education major in the candidate resume.
EducationalEstablishmentId	String	Education establishment ID in the candidate resume.
EducationalEstablishment	String	Name of the education establishment in the candidate resume.
GraduatedFlag	Bool	Indicates that the candidate is a graduate.
ProfileItemId	String	Profile item ID for education in the candidate resume.
DegreeName	String	Degree name for education in the candidate resume.
StateProvinceCode	String	State province code of the educational establishment in the candidate resume.
CountryCode	String	Country code for education in the candidate resume.

RecruitingCECandidateProfileImportslanguages

Columns


Name	Type	Description
RecruitingCECandidateProfileImportsProfileId	String	Finds a candidate by the ID and the profile ID
ContentTypeId	String	Content type ID of the languages in the candidate resume.
ProfileId	String	Profile ID for languages in the candidate resume.
ProfileItemId	String	Profile item ID for languages in the candidate resume.
ContentItemId	String	Content item ID of the languages in the candidate resume.
Language	String	Language in the candidate resume.
NativeSpeakerFlag	Bool	Indicates that it's the native language of the candidate.
AbleToTranslateFlag	Bool	Indicates that the candidate can translate the language.
AbleToTeachFlag	Bool	Indicates that the candidate can teach the language.
ReadingLevelId	Long	ID assigned to the language reading proficiency.
WritingLevelId	Long	ID assigned to the language writing proficiency.
SpeakingLevelId	Long	ID assigned to the language speaking proficiency.

RecruitingCECandidateProfileImportslicensesAndCertifications

Columns


Name	Type	Description
RecruitingCECandidateProfileImportsProfileId	String	Finds a candidate by the ID and the profile ID
ContentTypeId	String	Content type ID of the certifications in the candidate resume.
ProfileId	String	Profile ID of the licenses and certifications in the candidate resume.
IssueDate	String	Issue date of the licenses and certifications in the candidate resume.
ExpirationDate	String	Expiration date of the licenses in the candidate resume.
Title	String	Title of the licenses and certifications in the candidate resume.
Comments	String	Comments on the licenses and certifications in the candidate resume.
ProfileItemId	String	Profile item ID for licenses and certifications in the candidate resume.
IssuedBy	String	Authority that has issued the licenses and certifications in the candidate resume.
CertificationNumber	String	Certification number for the licenses and certifications in the candidate resume.

RecruitingCECandidateProfileImportsskills

Columns


Name	Type	Description
RecruitingCECandidateProfileImportsProfileId	String	Finds a candidate by the ID and the profile ID
ProfileItemId	String	Profile item ID for skills in the candidate resume.
ProfileId	String	Profile ID for skills in the candidate resume.
ContentTypeId	String	Content type ID of the skills in the candidate resume.
YearsOfExperience	String	Years of experience of the skills in the candidate resume.
Description	String	Description of the skills in the candidate resume.
DateAchieved	Date	Achieved date of the skills in the candidate resume.
ProjectName	String	Project name of the skills in the candidate resume
Speciality	String	Speciality of the skills in the candidate resume.
Comments	String	Comments on the skills in the candidate resume.
Skills	String	Name of the skills in the candidate resume.

RecruitingCECandidateProfileImportsworkExperiences

Columns


Name	Type	Description
RecruitingCECandidateProfileImportsProfileId	String	Finds a candidate by the ID and the profile ID
ContentTypeId	String	Content type ID for the work experiences in the candidate resume.
ProfileId	String	Profile ID for the work experiences in the candidate resume.
StartDate	String	Start date of the work experience mentioned in the candidate resume.
EndDate	String	End date of the work experiences in the candidate resume.
CurrentJobFlag	Bool	Indicates that it's the current job of the candidate as per their work experiences.
EmployerName	String	Employer name of the work experiences in the candidate resume.
JobTitle	String	Job title for the work experiences in the candidate resume.
ProfileItemId	String	Profile item ID for the work experiences in the candidate resume.
BusinessType	String	Business type of the work experiences of the candidate resume.
Achievements	String	Achievements in the work experience in the candidate resume.

RecruitingCECandidateProfileImportsworkPreferences

Columns


Name	Type	Description
RecruitingCECandidateProfileImportsProfileId	String	Finds a candidate by the ID and the profile ID
ContentTypeId	String	Content type ID for the work preferences in the candidate resume.
ProfileId	String	Profile ID for the work preferences in the candidate resume.
TempAssignFlag	Bool	Indicates a temporary assignment for the candidate as per their work preferences.
MinimumPay	String	Minimum pay for the work preferences in the candidate resume.
PartAssignFlag	Bool	Indicates that the candidate has opted for part payment as per their work preferences.
NatTravelFlag	Bool	Indicates that the candidate is ready for domestic travel as per their work preferences.
NatTravelFrequenc	String	Nat travel frequency for work preferences in the candidate resume.
RelocateFlag	Bool	Indicates the candidate is ready to relocate as per their work preferences.
CurrencyCode	String	Currency code for the work preferences in the candidate resume.
PayFrequency	String	Pay frequency for the work preferences in the candidate resume.

RecruitingCECandidates

Columns


Name	Type	Description
CandidateNumber [KEY]	String	Candidate Number in recruitingCECandidates.
PreferredLanguage	String	Preferred language in recruitingCECandidates.
LastName	String	Last Name in recruitingCECandidates.
MiddleNames	String	Middle Names in recruitingCECandidates.
FirstName	String	First Name in recruitingCECandidates.
Title	String	Title in recruitingCECandidates.
Suffix	String	Suffix in recruitingCECandidates.
PreNameAdjunct	String	Previous name adjunct as entered by the candidate.
KnownAs	String	Attribute to represent a candidate's name also KnownAs.
PreviousLastName	String	Previous last name in recruitingCECandidates.
Honors	String	Honors in recruitingCECandidates.
MilitaryRank	String	Military Rank in recruitingCECandidates.
NamInformation1	String	NamInformation 1 is a configurable attribute in recruitingCECandidates.
NamInformation2	String	NamInformation 2 is a configurable attribute in recruitingCECandidates.
NamInformation3	String	NamInformation 3 is a configurable attribute in recruitingCECandidates.
NamInformation4	String	NamInformation 4 is a configurable attribute in recruitingCECandidates.
NamInformation5	String	NamInformation 5 is a configurable attribute in recruitingCECandidates.
NamInformation6	String	NamInformation 6 is a configurable attribute in recruitingCECandidates.
NamInformation7	String	NamInformation 7 is a configurable attribute in recruitingCECandidates.
NamInformation8	String	NamInformation 8 is a configurable attribute in recruitingCECandidates.
NamInformation9	String	NamInformation 9 is a configurable attribute in recruitingCECandidates.
NamInformation10	String	NamInformation 10 is a configurable attribute in recruitingCECandidates.
NamInformation11	String	NamInformation 11 is a configurable attribute in recruitingCECandidates.
NamInformation12	String	NamInformation 12 is a configurable attribute in recruitingCECandidates.
NamInformation13	String	NamInformation 13 is a configurable attribute in recruitingCECandidates.
NamInformation14	String	NamInformation 14 is a configurable attribute in recruitingCECandidates.
NamInformation15	String	NamInformation 15 is a configurable attribute in recruitingCECandidates.
NamInformation16	String	NamInformation 16 is a configurable attribute in recruitingCECandidates.
NamInformation17	String	NamInformation 17 is a configurable attribute in recruitingCECandidates.
NamInformation18	String	NamInformation 18 is a configurable attribute in recruitingCECandidates.
NamInformation19	String	NamInformation 19 is a configurable attribute in recruitingCECandidates.
NamInformation20	String	NamInformation 20 is a configurable attribute in recruitingCECandidates.
NamInformation21	String	NamInformation 21 is a configurable attribute in recruitingCECandidates.
NamInformation22	String	NamInformation 22 is a configurable attribute in recruitingCECandidates.
NamInformation23	String	NamInformation 23 is a configurable attribute in recruitingCECandidates.
NamInformation24	String	NamInformation 24 is a configurable attribute in recruitingCECandidates.
NamInformation25	String	NamInformation 25 is a configurable attribute in recruitingCECandidates.
NamInformation26	String	NamInformation 26 is a configurable attribute in recruitingCECandidates.
NamInformation27	String	NamInformation 27 is a configurable attribute in recruitingCECandidates.
NamInformation28	String	NamInformation 28 is a configurable attribute in recruitingCECandidates.
NamInformation29	String	NamInformation 29 is a configurable attribute in recruitingCECandidates.
NamInformation30	String	NamInformation 30 is a configurable attribute in recruitingCECandidates.
DisplayName	String	Display Name in recruitingCECandidates.
ListName	String	List Name in recruitingCECandidates.
Email	String	Email in recruitingCECandidates.
MobilePhoneCountryCode	String	Mobile Phone Country Code in recruitingCECandidates.
MobilePhoneAreaCode	String	Mobile Phone Area Code in recruitingCECandidates.
MobilePhoneNumber	String	Mobile Phone Number in recruitingCECandidates.
AddressLine1	String	Address Line 1 in recruitingCECandidates.
AddressLine2	String	Address Line 2 in recruitingCECandidates.
AddressLine3	String	Address Line 3 in recruitingCECandidates.
City	String	City in recruitingCECandidates.
Region1	String	Region 1 in recruitingCECandidates.
Region2	String	Region 2 in recruitingCECandidates.
Region3	String	Region 3 in recruitingCECandidates.
Country	String	Country in recruitingCECandidates.
PostalCode	String	Postal code in recruitingCECandidates.
LongPostalCode	String	Long Postal Code in recruitingCECandidates.
Building	String	Building in recruitingCECandidates.
FloorNumber	String	Floor Number in recruitingCECandidates.
AddlAddressAttribute1	String	Additional address attribute 1 in recruitingCECandidates.
AddlAddressAttribute2	String	Additional address attribute 2 in recruitingCECandidates.
AddlAddressAttribute3	String	Additional address attribute 3 in recruitingCECandidates.
AddlAddressAttribute4	String	Additional address attribute 4 in recruitingCECandidates.
AddlAddressAttribute5	String	Additional address attribute 5 in recruitingCECandidates.
Action	String	Action in recruitingCECandidates.
PreviousEmail	String	Previous email ID in recruitingCECandidates.
NewEmail	String	New email ID in recruitingCECandidates.
EmailChangeRequested	String	Email Change Requested in recruitingCECandidates.
EmailChangeConfirmed	String	Email Change Confirmed in recruitingCECandidates.
SiteNumber	String	Site Number in recruitingCECandidates.
ExWorkerFlag	Bool	Indicates if the candidate is an ex worker in recruitingCECandidates.
DateOfBirth	Date	Date of birth in recruitingCECandidates
CwkCandidateFlag	Bool	Indicates if it's a contingent worker candidate in recruitingCECandidates
EmailVerificationRequested	String	Indicates that the candidate has requested for an email verification.
PhoneVerificationRequested	String	Indicates that the candidate has requested for a phone verification.
EmailPreferredFlag	Bool	Indicates that the candidate has selected email as the preferred communication channel.
PhonePreferredFlag	Bool	Indicates that the candidate has selected phone as the preferred communication channel.
EmailVerifiedFlag	Bool	Indicates that the email ID is verified.
PhoneVerifiedFlag	Bool	Indicates that the phone number is verified.
NewPhone	String	Phone number specified by the candidate in the event of a change in the existing phone number.
PreviousPhone	String	Previous phone number specified by the candidate before the change in the number.
AddressLine4	String	Value of line 4 of the candidate's address.
PreferredTimezone	String	Preferred time zone of the external candidate.

RecruitingCECandidatesattachments

Columns


Name	Type	Description
RecruitingCECandidatesCandidateNumber	String	Finds recruitingCECandidates by a unique ID and the candidate number
Id	String	ID assigned to the recruitingCECandidates attachments.
Category	String	Category in recruitingCECandidates attachments.
Type	String	Type of recruitingCECandidates attachments.
Title	String	Title of the the recruitingCECandidates attachments.
Description	String	Description in recruitingCECandidates attachments.
Attachment	String	Attachment in the recruitingCECandidates attachments.
FileContents	String	File Contents in recruitingCECandidates attachments.
SourceAttachmentId	String	ID assigned to the source attachment in the recruitingCECandidates attachments.
MimeType	String	Mime type in the recruitingCECandidates attachments.

RecruitingCECandidatescandidateExtraInformation

Columns


Name	Type	Description
RecruitingCECandidatesCandidateNumber	String	Finds recruitingCECandidates by a unique ID and the candidate number
DataId	String	Unique identifier for the person.
CandidateNumber	String	Unique identifier for the candidate.
ContextName	String	Unique identifier for the extra information data of the candidate.
ContextLink	String	Name of the extra information context.

RecruitingCECandidatesCandidatePIIData

Columns


Name	Type	Description
RecruitingCECandidatesCandidateNumber	String	Finds recruitingCECandidates by a unique ID and the candidate number
Id	String	ID for Candidate PII data
NationalIdentifierNumber	String	National identifier number in the recruiting candidate PII data.
NationalIdentifierType	String	National identifier type in the recruiting candidate PII data.
IssueDate	Date	Date of issue in the recruiting candidate PII data.
ExpirationDate	Date	Expiration date in the recruiting candidate PII data.
LegislationCode	String	Legislation code in the recruiting candidate PII data.
PlaceOfIssue	String	Place of issue in the recruiting candidate PII data.

RecruitingCECandidateSitePreferences

Columns


Name	Type	Description
CandidateNumber [KEY]	String	Candidate number in candidate site preferences.
Action	String	Action in candidate site preferences.
Context	String	Context in the candidate site preferences.
OptInMarketingEmailFlag	Bool	Indicates whether a candidate opted to receive recruitment marketing emails. The default value is 0.
CampaignCode	String	Campaign code in the candidate site preferences.
CandidateCountry	String	Country of the candidate in the candidate site preferences.
SiteNumber	String	Site number in the candidate site preferences.

RecruitingCECandidateSitePreferencessiteTCPreferences

Columns


Name	Type	Description
RecruitingCECandidateSitePreferencesCandidateNumber	String	Finds candidate site preference using a unique ID and candidate number
SiteNumber	String	Site number in candidate site TCP preferences.
FlowVersionId	String	Flow version ID in candidate site TCP preferences.
LegalDescriptionVersionId	String	Legal description Version Id in candidate site TCP preferences.
OptInJobAlertFlag	Bool	Opt in job alert indicator in candidate site TC preferences.

RecruitingCECandidateSitePreferencessiteTCPreferencespreferredJobFamilies

Columns


Name	Type	Description
RecruitingCECandidateSitePreferencesCandidateNumber	String	Finds candidate site preference using a unique ID and candidate number
SitetcpreferencesSiteNumber	String	Finds candidate site TCP preference using a unique ID and site number
JobFamilyId	String	Job family ID in preferred job families in candidate site TCP preferences.

RecruitingCECandidateSitePreferencessiteTCPreferencespreferredJobFunctions

Columns


Name	Type	Description
RecruitingCECandidateSitePreferencesCandidateNumber	String	Finds candidate site preference using a unique ID and candidate number
SitetcpreferencesSiteNumber	String	Finds candidate site TCP preference using a unique ID and site number
JobFunctionCode	String	Job function ID of a preferred job function of a candidate from the Talent Community Pool preferences.

RecruitingCECandidateSitePreferencessiteTCPreferencespreferredLocations

Columns


Name	Type	Description
RecruitingCECandidateSitePreferencesCandidateNumber	String	Finds candidate site preference using a unique ID and candidate number
SitetcpreferencesSiteNumber	String	Finds candidate site TCP preference using a unique ID and site number
GeographyId	String	Geography ID in preferred locations in candidate site TCP preferences.

RecruitingCECandidateSkillItems

Columns


Name	Type	Description
FlowVersionId	String	ID assigned to the skill's flow version.
SkillId [KEY]	String	ID assigned to the skill of the candidate.
Skills	String	Skills of the candidate.
DateAchieved	Date	Date achieved for the skill.
ProjectName	String	Project name or activities for the skill.
YearsOfExperience	String	Years of experience for the skill.
SectionId	String	Section ID in candidate skill items.
ProfileId	String	Profile ID in candidate skill items.
Description	String	Description for the skill.
ContentTypeId	String	ID assigned to the content type of the skill.
SubmissionId	String	Submission ID for the skill.
Speciality	String	Speciality or skill type for the skill.
Comments	String	Comments for the skill.

RecruitingCECandidateWorkPreferences

Columns


Name	Type	Description
AllLocationsFlag	Bool	Indicates that the candidate has selected all locations.
WorkPreferenceId [KEY]	String	Work preference ID in the candidate work preferences.
Comments	String	Comments in the candidate work preferences.
ContentItemId	String	ContentItemId in the candidate work preferences.
CurrencyCode	String	Currency code in the candidate work preferences.
DateFrom	Date	Date from in the candidate work preferences.
DateTo	Date	Date to in the candidate work preferences.
FlexibleWorkFlag	Bool	Indicates that the candidate has opted for flexible work hours.
MinimumPay	String	Minimum pay in candidate work preferences.
IntlTravelFlag	Bool	Indicates that the candidate has opted for international travel.
NatTravelFrequency	String	National travel frequency in the candidate work preferences.
NatTravelFlag	Bool	Indicates that the candidate has opted for domestic travel.
FullTimeEquivalent	Double	Full time equivalent in the candidate work preferences.
IntlTravelRequiredFlag	Bool	Indicates that the candidate is ready for international travel.
IntlTravelFrequency	String	International Travel Frequency in candidate work preferences.
NatTravelRequiredFlag	Bool	Indicates that the candidate is ready for domestic travel.
PartAssignFlag	Bool	Indicates that the candidate has opted for part payment.
PayFrequency	String	Pay frequency in the candidate work preferences.
PayRange	String	Pay range in the candidate work preferences.
RelocateDuration	String	Duration required by the candidate to relocate.
RelocateFlag	Bool	Indicates that the candidate is ready to relocate.
RelocationReason	String	Relocation reason in the candidate work preferences.
SectionId	String	Section ID in the candidate work preferences.
TempAssignFlag	Bool	Indicates temporary assignment in the candidate work preferences.
WorkDays	String	Work days in the candidate work preferences.
WorkHours	String	Work hours in the candidate work preferences.
WorkMonths	String	Work months in the candidate work preferences.
WorkYears	String	Work years in the candidate work preferences.
FlowVersionId	String	Flow version ID in the candidate work preferences.
ExcludedLocationId1	String	Excluded Location Id 1 in the candidate work preferences.
ExcludedLocationId2	String	Excluded Location Id 2 in the candidate work preferences.
ExcludedLocationId3	String	Excluded Location Id 3 in the candidate work preferences.
ExcludedLocationId4	String	Excluded Location Id 4 in the candidate work preferences.
PreferredLocationId1	String	Preferred location Id 1 in the candidate work preferences.
PreferredLocationId2	String	Preferred location Id 2 in the candidate work preferences.
PreferredLocationId3	String	Preferred location Id 3 in the candidate work preferences.
PreferredLocationId4	String	Preferred location Id 4 in the candidate work preferences.
SubmissionId	String	Submission ID in the candidate work preferences.

RecruitingCEContactInformationMetadata

Columns


Name	Type	Description
LegislationCode	String	Legislation code of the candidate contact information.
AttributeName	String	Attribute name of the candidate contact information.
RequiredFlag	Bool	Indicates whether the candidate contact information is mandatory or optional.
DisplaySequence	Long	Display sequence of the candidate contact information.
Length	String	Length of the candidate contact information.
Dictionary	String	Dictionary of the candidate contact information.
Prompt	String	Prompt of the candidate contact information.

RecruitingCEDictionaries

Columns


Name	Type	Description
Title	String	Title of a dictionary.
Attachment	String	Attachment for a dictionary.
EducationEstablishment	String	Education establishments included in a dictionary.
EducationLevels	String	Levels of education defined in the recruiting CE dictionaries.
Territory	String	Territory of a dictionary.
PhoneCountryCodeAttribute	String	Country code for a phone number.
ProfileRatingLevel	String	Level of profile rating in a dictionary
ProfileLocation	String	Location of a profile in a dictionary.
ProfileCurrency	String	Currency of a profile in a dictionary.
ProfileJobFamily	String	Job family of a profile in a dictionary.
GenericLookup	String	Generic look up for CE recruiting dictionaries.
ProfileContentItem	String	Item in the profile content of a dictionary.
StateOrProvince	String	State or province of a dictionary.
ProfileCountry	String	Country profile in a dictionary.

RecruitingCEExtraInformationDictionary

Columns


Name	Type	Description
DictionaryId [KEY]	String	ID assigned to each extra information dictionary.
ResourceName	String	Name of the resource used to retrieve the extra information dictionary details.

RecruitingCEExtraInformationDictionarylistOfValues

Columns


Name	Type	Description
RecruitingCEExtraInformationDictionaryDictionaryId	String	Find details of the dictionary by a unique dictionary ID
ListId	String	ID assigned to each candidate extra information dictionary value.
DictionaryId	String	ID assigned to each candidate extra information dictionary.
LookupCode	String	Lookup code for each value in the candidate extra information dictionary.
Meaning	String	Display value for the dictionary element in the application.

RecruitingCEInterviewActions

Columns


Name	Type	Description
InterviewId	String	ID assigned to the Interview.
InterviewRequestId	String	ID assigned to the Requested Interview.
ActionType	String	Interview action type, such as schedule, reschedule or cancel interview.
SubmissionId	String	ID variable assigned to the job application.
Message	String	Message for the interview actions.

RecruitingCEInterviewDetails

Columns


Name	Type	Description
InterviewId [KEY]	String	ID assigned to the interview attended by the candidate.
ScheduleId	String	Id assigned to the interview
StartDate	Datetime	Start date of the interviews.
EndDate	Datetime	End date of the interview schedule.
IsScheduled	String	Indicates if the interview is scheduled for the candidate.
SubmissionId	String	ID assigned to the interview submissions.
LocationType	String	Type of location for the interview.
WebConferenceLink	String	Link used for the web conference.
FormattedPhoneNumber	String	Formatted phone number of the candidates.
FormattedMultiLineAddress	String	Formatted multiline address of the candidates.
FormattedSingleLineAddress	String	Formatted single line address of the candidates.
JobTitle	String	Job title for which the interview was conducted.
PostScheduleDetails	String	Post interview schedule details.
CandidateNotes	String	Notes taken by the candidate.
CanCancel	String	Indicates if the interview can be canceled.
CanSchedule	String	Indicates if the interview can be scheduled.
CanReschedule	String	Indicates if the interview can be rescheduled.
InterviewRequestId	String	ID assigned to the interview request.
PhoneNumberPasscode	String	Passcode for the phone number used for the interview.
RemainingRescheduleCount	String	Indicates the number of times candidate can reschedule the interview.
LocationDetails	String	Job location of the candidate.

RecruitingCEInterviewDetailsScheduleInterviewParticipants

Columns


Name	Type	Description
RecruitingCEInterviewDetailsInterviewId	String	Finds the interview details using an unique identifier and the InterviewId variable
PersonId	String	PersonId
ParticipantId	String	ID assigned to interview participant.
PartObjectVersionNumber	Int	PartObjectVersionNumber
ParticipantType	String	Type of participant for whom the interview is schedules
DisplayName	String	Display name of the participants scheduled for the interview.
PersonNameId	String	PersonNameId
EffectiveStartDate	Date	EffectiveStartDate
EffectiveEndDate	Date	EffectiveEndDate
PersonNameObjectVersionNumber	Int	PersonNameObjectVersionNumber
ListName	String	Name of the participant list scheduled for interview.
ScheduleInterviewId	String	ScheduleInterviewId
SubmissionId	String	SubmissionId

RecruitingCEInterviewScheduleDetails

Columns


Name	Type	Description
ScheduleId [KEY]	String	Id assigned to the interview schedule.
InterviewType	String	Type of the interview conducted for the candidate.
ScheduleTitle	String	Title assigned to the interview schedule.
ScheduleType	String	Type of the interview schedule.
Status	String	Status of the interview schedule.
JobTitle	String	Job title for which the interview schedule was created.
RequisitionId	String	ID assigned to the job requisition.
PreScheduleDetails	String	Details of the interview before the schedule.
PostScheduleDetails	String	Details of the interview post the schedule.
AllowSameDayScheduling	String	Indicates if same day schedule is allowed for the interview.
HasVisibilityRange	String	Indicates if the candidate had the required visibility.
IntervwsVisibilityRangeCode	String	Code assigned to the visibility range of the interview
SubmissionId	String	Value that uniquely identifies the job application.

RecruitingCEInterviewScheduleDetailsInterviews

Columns


Name	Type	Description
RecruitingCEInterviewScheduleDetailsScheduleId	String	Finds interview schedule details using a unique identifier and the ScheduleId variable
InterviewId	String	ID assigned to the interview attended by the candidate.
ScheduleId	String	Id assigned to the interview
StartDate	Datetime	Start date of the interviews.
EndDate	Datetime	End date of the interview schedule.
IsScheduled	String	Indicates if the interview is scheduled for the candidate.
SubmissionId	String	ID assigned to the interview submissions.
LocationType	String	Type of location for the interview.
WebConferenceLink	String	Link used for the web conference.
FormattedPhoneNumber	String	Formatted phone number of the candidates.
FormattedMultiLineAddress	String	Formatted multiline address of the candidates.
FormattedSingleLineAddress	String	Formatted single line address of the candidates.
JobTitle	String	Job title for which the interview was conducted.
PostScheduleDetails	String	Post interview schedule details.
CandidateNotes	String	Notes taken by the candidate.
CanCancel	String	Indicates if the interview can be canceled.
CanSchedule	String	Indicates if the interview can be scheduled.
CanReschedule	String	Indicates if the interview can be rescheduled.
InterviewRequestId	String	ID assigned to the interview request.
PhoneNumberPasscode	String	Passcode for the phone number used for the interview.
RemainingRescheduleCount	String	Indicates the number of times candidate can reschedule the interview.
LocationDetails	String	Job location of the candidate.

RecruitingCEJobApplicationDrafts

Columns


Name	Type	Description
APPDraftId [KEY]	String	Unique identifier for each job application draft.
AreaCode	String	Area code for the candidate phone number of the job application draft.
CandidateNumber	String	Candidate number of the job application draft.
Content	String	Content of the job application draft.
EmailAddress	String	Email address of the candidate who created the job application draft.
PhoneNumber	String	Phone number of candidate related to the job application draft.
CountryCode	String	Country code for candidate phone number of the job application draft.
RequisitionNumber	String	Job requisition number of the job application draft.
ObjectStatus	String	Status of the job application draft.
SiteNumber	String	Site Number of the job application draft.
LastUpdateDate	Datetime	Date and time when the job application draft was updated.
CandLastModifiedDate	Datetime	Candidate last modification date of the job application draft.
LegalDescriptionVersionId	String	Description version ID of the job application draft.
CustomAction	String	Custom action used to update the job application draft.
ContentLanguage	String	Language for the job application draft.
CreatedBy	String	Login of user who created the job application draft.
CreationDate	Datetime	Date and time when the job application draft was created.
LastJobExecutionDate	Datetime	Date and time when notification for job was sent for the job application draft.
LastUpdateLogin	String	User login who updated the job application draft.
LastUpdatedBy	String	Name of user who updated the job application draft.
ObjectVersionNumber	Int	Version number of the job application draft.
ProposedCandidateNumber	String	Proposed candidate number for a new candidate.
PreferredChannel	String	Preferred channel of communication with the candidate.
ModificationDate	Datetime	Last modification date of the draft job application submitted by the candidate.
StepActionUsageId	String	Identifier of the step of the draft job application.
SubmissionId	String	Identifier of the job application of the draft job application.
FlowId	String	Identifier of the request information flow.

RecruitingCEJobApplicationDraftsattachments

Columns


Name	Type	Description
RecruitingCEJobApplicationDraftsAPPDraftId	String	Internal identifier for each draft
CandidateNumber	String	Candidate number associated with the attachment of the job application draft.
Id	String	Unique identifier for the attachment of the job application draft.
Category	String	Category of attachment of the job application draft.
Type	String	Type of attachment of the job application draft.
Title	String	Title of attachment of the job application draft.
Description	String	Description of attachment of the job application draft.
Attachment	String	Attachment of the job application draft.
FileContents	String	File content of attachment of the job application draft.
SourceAttachmentId	String	Source attachment ID of the attachment of the job application draft.
MimeType	String	Mime type of attachment of the job application draft.
Action	String	Action for attachment of the job application draft.
APPDraftId	String	Identifier of attachment of the job application draft.

RecruitingCEJobRequisitionDetails

Columns


Name	Type	Description
Id	String	ID assigned to the job requisitions and pertains to a published job.
Title	String	Title associated with the job requisition that pertains to a published job.
Category	String	Category of the job requisition and pertains to a published job.
RequisitionType	String	Type of the job requisition that pertains to a published job.
JobGrade	String	Grade of the job requisition that pertains to a published job.
RequisitionId [KEY]	String	ID assigned to each job requisition.
ExternalPostedStartDate	Datetime	Start date of the external posting of the job requisition and pertains to a published job.
JobLevel	String	Level of the job requisition that pertains to a published job.
JobSchedule	String	Schedule of the job requisition that pertains to a published job.
JobShift	String	Shift associated with the job requisition that pertains to a published job.
StudyLevel	String	Education level mentioned in the job requisition that pertains to a published job.
DomesticTravelRequired	String	Indicates if domestic travel is required as per the job requisition and pertains to a published job.
InternationalTravelRequired	String	Indicates if international travel is required for the job posting and pertains to a published job.
ExternalContactName	String	External contact name of the candidate in the job requisition and pertains to a published job.
ExternalContactEmail	String	External email of the candidate in the job requisition and pertains to a published job.
ContractType	String	Type of contract of the job requisition and pertains to a published job.
ExternalPostedEndDate	Datetime	End date of the external posting of the job requisition and pertains to a published job.
JobFamilyId	String	ID assigned to the job family the job requisition belongs to and pertains to a published job.
GeographyId	String	Geography ID assigned to the job requisitions and pertains to a published job.
GeographyNodeId	String	Geography node ID assigned to the job requisitions and pertains to a published job.
ExternalDescriptionStr	String	External description string of the job requisition.
CorporateDescriptionStr	String	Corporate description of the job requisition and pertains to a published job.
OrganizationDescriptionStr	String	Description string for the organization in the job requisition that pertains to a published job.
ShortDescriptionStr	String	Short description string of the job requisition that pertains to a published job.
ContentLocale	String	Location of the content of the job requisition and pertains to a published job.
PrimaryLocation	String	Primary location of the job requisition that pertains to a published job.
PrimaryLocationCountry	String	Country of the primary location of the job requisition that pertains to a published job.
ObjectVerNumberProfile	String	Object version number assigned to the profile in the job requisition that pertains to a published job.
ApplyWhenNotPostedFlag	Bool	Indicates when a job requisition isn't posted and pertains to a published job.
ExternalQualificationsStr	String	External qualifications string of the job requisition.
InternalQualificationsStr	String	Internal qualifications string of the job requisition.
InternalResponsibilitiesStr	String	Internal responsibilities string of the job requisition.
ExternalResponsibilitiesStr	String	External responsibilities string of the job requisition.
JobFunctionCode	String	Job function code of the published job requisition.

RecruitingCEJobRequisitionDetailsmedia

Columns


Name	Type	Description
RecruitingCEJobRequisitionDetailsRequisitionId	String	Finds job requisition details using ById and Id pertaining to a published job
Id	String	ID for the requisition template details previews media.
Type	String	Type of the requisition template details previews media.
URL	String	URL of the requisition template details previews media.
ThumbURL	String	Thumb URL for the requisition template details previews media.
Priority	String	Priority for the requisition template details previews media.
Title	String	Title for the requisition template details previews media.

RecruitingCEJobRequisitionDetailsotherWorkLocations

Columns


Name	Type	Description
RecruitingCEJobRequisitionDetailsRequisitionId	String	Finds job requisition details using ById and Id pertaining to a published job
RequisitionWorkLocationId	String	Name for other work locations of the requisition template details previews.
LocationId	String	Location ID of other work locations of the requisition template details previews.
LocationName	String	Location name of other work locations of the requisition template details previews.
AddressLine1	String	Address line 1 for other work locations of the requisition template details previews.
AddressLine2	String	Address line 2 for other work locations of the requisition template details previews.
AddressLine3	String	Address line 3 for other work locations of the requisition template details previews.
AddressLine4	String	Address line 4 for other work locations of the requisition template details previews.
Building	String	Building of other work locations of the requisition template details previews.
TownOrCity	String	Town or City of other work locations of the requisition template details previews.
PostalCode	String	Postal code of other work locations of the requisition template details previews.
Country	String	Country of other work locations of the requisition template details previews.
Region1	String	Region 1 of other work locations of the requisition template details previews.
Region2	String	Region 2 of other work locations of the requisition template details previews.
Region3	String	Region 3 of other work locations of the requisition template details previews.
Latitude	String	Latitude of other work locations of the requisition template details previews.
Longitude	String	Longitude of other work locations of the requisition template details previews.

RecruitingCEJobRequisitionDetailsprimaryLocationCoordinates

Columns


Name	Type	Description
RecruitingCEJobRequisitionDetailsRequisitionId	String	Finds job requisition details using ById and Id pertaining to a published job
GeographyNodeId	String	Geography ID of primary location coordinates of the requisition details.
GeographyId	String	Geography ID of primary location coordinates of the requisition details.
Latitude	String	Latitude of primary location coordinates of the requisition details.
Longitude	String	Longitude of primary location coordinates of the requisition details.
CountryCode	String	Country code of the primary location coordinates of the requisition details.

RecruitingCEJobRequisitionDetailsrecruitingCEJobRequisitionDetails

Columns


Name	Type	Description
RecruitingCEJobRequisitionDetailsRequisitionId	String	Finds job requisition details using ById and Id pertaining to a published job

RecruitingCEJobRequisitionDetailsrequisitionFlexFields

Columns


Name	Type	Description
RecruitingCEJobRequisitionDetailsRequisitionId	String	Finds job requisition details using ById and Id pertaining to a published job
Prompt	String	Prompt of flexfields of the requisition details.
Value	String	Value of flexfields of the requisition details.
ControlType	String	Control type of flexfields of the requisition details.
SequenceNumber	String	Sequence number of flexfields of the requisition details.

RecruitingCEJobRequisitionDetailssecondaryLocations

Columns


Name	Type	Description
RecruitingCEJobRequisitionDetailsRequisitionId	String	Finds job requisition details using ById and Id pertaining to a published job
RequisitionLocationId	String	Name for other work locations of the requisition template details previews.
GeographyNodeId	String	Geography node ID for the secondary location of the requisition template details previews.
GeographyId	String	Geography ID for the secondary location of the requisition template details previews.
Name	String	Name for other work locations of the requisition template details previews.
CountryCode	String	Country code for the secondary location of the requisition template details previews.
Latitude	String	Latitude of other work locations of the requisition details.
Longitude	String	Longitude of other work locations of the requisition details.

RecruitingCEJobRequisitionDetailsworkLocation

Columns


Name	Type	Description
RecruitingCEJobRequisitionDetailsRequisitionId	String	Finds job requisition details using ById and Id pertaining to a published job
LocationId	String	Location ID of work locations of the requisition template details previews.
LocationName	String	Location name of work locations of the requisition template details previews.
AddressLine1	String	Address line 1 of work locations of the requisition template details previews.
AddressLine2	String	Address line 2 of work locations of the requisition template details previews.
AddressLine3	String	Address line 3 of work locations of the requisition template details previews.
AddressLine4	String	Address line 4 of work locations of the requisition template details previews.
Building	String	Building of work locations of the requisition template details previews.
TownOrCity	String	Town or City of work locations of the requisition template details previews.
PostalCode	String	Postal code of work locations of the requisition template details previews.
Country	String	Country of work locations of the requisition template details previews.
Region1	String	Region 1 of other locations of the requisition template details previews.
Region2	String	Region 2 of other locations of the requisition template details previews.
Region3	String	Region 3 of other locations of the requisition template details previews.
Longitude	String	Longitude of work locations of the requisition template details previews.
Latitude	String	Latitude of work locations of the requisition template details previews.

RecruitingCEJobRequisitions

Columns


Name	Type	Description
SearchId [KEY]	String	Name for other work locations of the requisition template details previews.
Keyword	String	Keyword used to search for job requisitions.
Location	String	Location of the job requisition
LocationId	String	ID assigned to the location of the job requisition.
Radius	String	Radius of the job requisition.
RadiusUnit	String	Unit of the radius of the job requisition.
SelectedTitlesFacet	String	Facet of the selected title of job requisitions.
SelectedCategoriesFacet	String	Facet of the selected categories of the job requisitions.
SelectedPostingDatesFacet	String	Facet of the selected dates of job posting.
SelectedLocationsFacet	String	Facet of the selected locations of the job requisitions.
LastSelectedFacet	String	Last selected facet for retrieving job requisitions.
Facets	String	Facets of the job requisitions.
Offset	String	Offset of the job requisition
Limit	String	Limit of the job requisition.
SortBy	String	Sort by attribute for the job requisition.
TotalJobsCount	String	Total job count for the job requisition.
Latitude	String	Latitude of the location of job requisition.
Longitude	String	Longitude of the location of the job requisition
SiteNumber	String	Site number of the job requisition.
JobFamilyId	String	ID assigned to the job family.
PostingStartDate	String	Start date of the job posting.
PostingEndDate	String	End date of the job posting.
SelectedWorkLocationsFacet	String	Facet of the selected work locations.
RequisitionId	String	ID assigned to the similar job
CandidateNumber	String	ID assigned to each candidate
WorkLocationZipCode	String	ZIP code of the work location.
WorkLocationCountryCode	String	Country code of the work location.
SelectedFlexFieldsFacets	String	Facets of the selected job requisitions flexfields.
OrganizationId	String	Organization ID for a job requisition.
SelectedOrganizationsFacet	String	Facet of the selected organizations of the job requisitions.

RecruitingCEJobRequisitionscategoriesFacet

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Id	String	ID assigned to the categories facet.
Name	String	Name assigned to the categories facet.
TotalCount	String	Total count of the categories facet.

RecruitingCEJobRequisitionsflexFieldsFacet

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Name	String	Name assigned to the flexfields facet.
Label	String	Label assigned to the flexfields facet.

RecruitingCEJobRequisitionsflexFieldsFacetvalues

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
FlexfieldsfacetName	String	Finds job flexfields facet using a unique ID and ID
Id	String	ID assigned to the flexfield facet value.
Name	String	Name assigned to the flexfields facet value.
TotalCount	String	Total count of the flexfields facet values.

RecruitingCEJobRequisitionslocationsFacet

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Id	String	ID assigned to the locations facet.
Name	String	Name assigned to the locations facet.
TotalCount	String	Total count of the locations facet.

RecruitingCEJobRequisitionsorganizationsFacet

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Id	String	ID assigned to the organizations facet.
Name	String	Name assigned to the organizations facet.
TotalCount	String	Total count of the organizations facet.

RecruitingCEJobRequisitionspostingDatesFacet

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Id	String	ID assigned to the facet of the job posting.
Name	String	Name assigned to the facet of the job posting.
TotalCount	String	Total count of the facet of the job posting.

RecruitingCEJobRequisitionsrequisitionList

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Id	String	ID assigned to the job requisition list.
Title	String	Title of the requisition list.
ShortDescription	String	Short description of the requisition list.
PostedDate	Datetime	Date of posting of the requisition list.
MediaThumbURL	String	Media thumb URL for the job requisition list.
ShortDescriptionStr	String	Short description string of the requisition list.
PrimaryLocation	String	Primary location of the requisition list.
PrimaryLocationCountry	String	Country of the primary location of the requisition list.
Distance	String	Total distance from the center of a radius search.

RecruitingCEJobRequisitionsrequisitionListotherWorkLocations

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
LocationId	String	Location ID of other work locations of the requisition template details previews.
RequisitionWorkLocationId	String	Name for other work locations of the requisition template details previews.
LocationName	String	Location name of other work locations of the requisition template details previews.
AddressLine1	String	Address line 1 for other work locations of the requisition template details previews.
AddressLine2	String	Address line 2 for other work locations of the requisition template details previews.
AddressLine3	String	Address line 3 for other work locations of the requisition template details previews.
AddressLine4	String	Address line 4 for other work locations of the requisition template details previews.
Building	String	Building of other work locations of the requisition template details previews.
TownOrCity	String	Town or City of other work locations of the requisition template details previews.
PostalCode	String	Postal code of other work locations of the requisition template details previews.
Country	String	Country of other work locations of the requisition template details previews.
Region1	String	Region 1 of other work locations of the requisition template details previews.
Region2	String	Region 2 of other work locations of the requisition template details previews.
Region3	String	Region 3 of other work locations of the requisition template details previews.
Latitude	Long	Latitude of other work locations of the requisition template details previews.
Longitude	Long	Longitude of other work locations of the requisition template details previews.

RecruitingCEJobRequisitionsrequisitionListprimaryLocationCoordinates

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Latitude	Long	Latitude of primary location coordinates of the requisition details.
Longitude	Long	Longitude of primary location coordinates of the requisition details.
CountryCode	String	Country code of the primary location coordinates of the requisition details.
GeographyId	String	Geography ID of primary location coordinates of the requisition details.
GeographyNodeId	String	Geography ID of primary location coordinates of the requisition details.

RecruitingCEJobRequisitionsrequisitionListsecondaryLocations

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
RequisitionLocationId	String	Name for other work locations of the requisition template details previews.
GeographyNodeId	String	Geography node ID for the secondary location of the requisition template details previews.
GeographyId	String	Geography ID for the secondary location of the requisition template details previews.
Name	String	Name for other work locations of the requisition template details previews.
CountryCode	String	Country code for the secondary location of the requisition template details previews.
Latitude	Long	Latitude of other work locations of the requisition details.
Longitude	Long	Longitude of other work locations of the requisition details.

RecruitingCEJobRequisitionsrequisitionListworkLocation

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
LocationId	String	Location ID of work locations of the requisition template details previews.
LocationName	String	Location name of work locations of the requisition template details previews.
AddressLine1	String	Address line 1 of work locations of the requisition template details previews.
AddressLine2	String	Address line 2 of work locations of the requisition template details previews.
AddressLine3	String	Address line 3 of work locations of the requisition template details previews.
AddressLine4	String	Address line 4 of work locations of the requisition template details previews.
Building	String	Building of work locations of the requisition template details previews.
TownOrCity	String	Town or City of work locations of the requisition template details previews.
PostalCode	String	Postal code of work locations of the requisition template details previews.
Country	String	Country of work locations of the requisition template details previews.
Region1	String	Region 1 of other locations of the requisition template details previews.
Region2	String	Region 2 of other locations of the requisition template details previews.
Region3	String	Region 3 of other locations of the requisition template details previews.
Latitude	Long	Latitude of work locations of the requisition template details previews.
Longitude	Long	Longitude of work locations of the requisition template details previews.

RecruitingCEJobRequisitionsrequisitionLocationsCoordinates

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
RequisitionNumber	String	Requisition number of the requisition locations coordinates.
RequisitionTitle	String	Requisition title of the requisition locations coordinates.

RecruitingCEJobRequisitionsrequisitionLocationsCoordinateslocationCoordinates

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
LocationId	String	Location ID of the requisition locations coordinates.
LocationType	String	Location type of the requisition locations coordinates.
Latitude	String	Latitude of the requisition locations coordinates.
Longitude	String	Longitude of the requisition locations coordinates.
AddressLine1	String	Address line 1 of the requisition locations coordinates.
Building	String	Building of the requisition locations coordinates.
Country	String	Country of the requisition locations coordinates.
Name	String	Name of the requisition locations coordinates.
PostalCode	String	Postal code of the requisition locations coordinates.
Region1	String	Region 1 of the requisition locations coordinates.
Region2	String	Region 2 of the requisition locations coordinates.
Region3	String	Region 3 of the requisition locations coordinates.
TownOrCity	String	Town or city of the requisition locations coordinates.

RecruitingCEJobRequisitionstitlesFacet

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Id	String	ID assigned to the facet of titles.
Name	String	Name assigned to the facet of titles.
TotalCount	String	Total count of the facet of titles.

RecruitingCEJobRequisitionsworkLocationsFacet

Columns


Name	Type	Description
RecruitingCEJobRequisitionsSearchId	String	Finds job requisitions using a search ID and a primary key
Id	String	ID of the work location facet.
Name	String	Name of the work location facet.
TotalCount	String	Total count of the work location facet.

RecruitingCENameStyles

Columns


Name	Type	Description
LegislationCode	String	Legislation code of the name styles.
AttributeName	String	Attribute name of the name style.
RequiredFlag	Bool	Indicates if the name style is required.
DisplaySequence	Int	Display sequence of the name styles.
Length	String	Length of the name style.
Dictionary	String	Dictionary of the name styles.
Prompt	String	Prompt used in the name styles.

RecruitingCEOfferDetails

Columns


Name	Type	Description
OfferId [KEY]	String	Unique number of the job offer.
OfferName	String	Name of the job offer.
Comments	String	Necessary comments related to the job offer.
AcceptedOnBehalf	String	Indicates that the job offer was accepted on behalf of the candidate.
AcceptedOnBehalfBy	String	Name of the person who accepted the job offer on behalf of the candidate.
AcceptedOnBehalfDate	Datetime	Date when the job offer was accepted on behalf of the candidate.
Phase	String	Phase of the job offer.
State	String	State of the job offer.
RequisitionNumber	String	Number of the job requisition associated with the job offer.
FullName	String	Full name of the candidate.
SigneeIpAddress	String	IP address of the candidate who accepted the job offer.
SignatureDate	Datetime	Date when the candidate signed the job offer.
HiringManagerName	String	Name of the hiring manager.
DisplayMode	String	Display mode.
CandidateNumber	String	Number of the candidate.
CandidateDisplayName	String	Display name of the candidate.
Description	String	Detailed description of the job offer provided by the offer creator.
ESignatureInstructions	String	Instructions for the e-signature.
RecCandidateType	String	Candidate type, that's external or internal.
SubmissionLanguageCode	String	Code of the language used for the candidate job application.
DeclineReasonsEnabledFlag	Bool	Indicates whether or not candidates can provide comments while declining the job offer.
PostAcceptMessage	String	Message shown to candidates after they accept the job offer.

RecruitingCEOfferDetailsassignment

Columns


Name	Type	Description
RecruitingCEOfferDetailsOfferId	String	Finds a job offer using the primary key attribute of offer ID
AssignmentName	String	Name of a job assignment.
ProjectedStartDate	Date	Projected start date of an assignment.
DepartmentName	String	Name of a department.
SupervisorDisplayName	String	Display name of the supervisor.
GradeName	String	Name of the grade of job offered to the candidate.
JobTitle	String	Title of the job offered to the candidate.
BusinessUnitName	String	Name of a business unit.
LocationName	String	Location of the job assignment.
FormattedMultiLineAddress	String	Candidate's address in a multiple lines format.
FormattedSingleLineAddress	String	Candidate's address in a single line format.

RecruitingCEOfferDetailsattachments

Columns


Name	Type	Description
RecruitingCEOfferDetailsOfferId	String	Finds a job offer using the primary key attribute of offer ID
AttachedDocumentId	String	The unique identifier of the attached document.
LastUpdateDate	Datetime	The date when the record was last updated.
LastUpdatedBy	String	The user who last updated the record.
DatatypeCode	String	A value that indicates the data type.
FileName	String	The file name of the attachment.
DmFolderPath	String	The folder path from which the attachment is created.
DmDocumentId	String	The document ID from which the attachment is created.
DmVersionNumber	String	The document version number from which the attachment is created.
Url	String	The URL of a web page type attachment.
CategoryName	String	The category of the attachment.
UserName	String	The login credentials of the user who created the attachment.
Uri	String	The URI of a Topology Manager type attachment.
FileUrl	String	The URI of the file.
UploadedText	String	The text content for a new text attachment.
UploadedFileContentType	String	The content type of the attachment.
UploadedFileLength	String	The size of the attachment file.
UploadedFileName	String	The name to assign to a new attachment file.
ContentRepositoryFileShared	Bool	Indicates whether the attachment is shared
Title	String	The title of the attachment.
Description	String	The description of the attachment.
ErrorStatusCode	String	The error code, if any, for the attachment.
ErrorStatusMessage	String	The error message, if any, for the attachment.
CreatedBy	String	The user who created the record.
CreationDate	Datetime	The date when the record was created.
FileContents	String	The contents of the attachment.
ExpirationDate	Datetime	The expiration date of the contents in the attachment.
LastUpdatedByUserName	String	The user name who last updated the record.
CreatedByUserName	String	The user name who created the record.
AsyncTrackerId	String	Attribute provided for the exclusive use by the Attachment UI components to assist in uploading files.
FileWebImage	String	The base64 encoded image of the file displayed in .png format if the source is a convertible image.
DownloadInfo	String	JSON object represented as a string containing information used to programmatically retrieve a file attachment.

RecruitingCEOfferDetailsmediaLinks

Columns


Name	Type	Description
RecruitingCEOfferDetailsOfferId	String	Finds a job offer using the primary key attribute of offer ID
Type	String	Type of media link.
URL	String	URL of the media link.
ThumbURL	String	Thumb URL of the media links.
Priority	Int	Priority of media links.
Title	String	Title of the media link defining the purpose of the URL.
Language	String	Type of language used in the media links.

RecruitingCEOfferDetailsofferDeclineReasons

Columns


Name	Type	Description
RecruitingCEOfferDetailsOfferId	String	Finds a job offer using the primary key attribute of offer ID
ReasonId	String	ID of the reason selected by candidates while declining the job offer.
ReasonName	String	Name of the reason selected by candidates while declining the job offer.

RecruitingCEOfferDetailsofferLetter

Columns


Name	Type	Description
RecruitingCEOfferDetailsOfferId	String	Finds a job offer using the primary key attribute of offer ID
OfferId	String	ID assigned to an offer letter.
PDF	String	PDF format of the job offer letter.
HTML	String	Html format of the job offer letter.

RecruitingCEProfileImportAttachments

Columns


Name	Type	Description
CategoryName	String	Category Name for the profile import attachments.
DatatypeCode	String	Code assigned to the data type for the profile import attachments.
Title	String	Title for the profile import attachments.
FileContents	String	File Contents for the profile import attachments.
DocumentId	String	Document ID for the profile import attachments.
AttachedDocumentId [KEY]	String	Attached Document Id for the profile import attachments.

RecruitingCEProfileImportConfigs

Columns


Name	Type	Description
Provider [KEY]	String	Provider for the profile import configurations.
OauthService	String	Open authentication service for the profile import configurations.
ClientId	String	Client ID for profile import configurations.
ActiveFlag	Bool	Active indicator for the profile import configurations.
IntegrationContext	String	Integration Context for the profile import configurations.

RecruitingCEProspects

Columns


Name	Type	Description
CandidateNumber	String	Number of prospective candidates.
RequisitionNumber	String	Requisition number of the prospective candidate.
Action	String	Type of action for the prospective candidate.

RecruitingCEQuestions

Columns


Name	Type	Description
RequisitionNumber	String	Requisition number in questions.
QuestionnaireId	String	Questionnaire ID.
QstnrVersionNumber	String	Questionnaire version number.
RequiredFlag	Bool	Indicates if the question is required to be answered.
AttributeName [KEY]	String	Attribute Name in questions.
MinimumLength	String	Minimum Length in questions.
MaximumLength	String	Maximum Length in questions.
MinimumDate	Date	Minimum date in questions.
MaximumDate	Date	Maximum date in questions.
MinimumSelections	String	Minimum Selections in questions.
MaximumSelections	String	Maximum Selections in questions.
Prompt	String	Prompt in questions.
UIDisplayType	String	UI display type in questions.
ConditionQuestionId	String	ID assigned to the question which entails an additional questionnaire.
ConditionQstnVersionNumber	String	Version number assigned to the additional questionnaire associated with the answer.
ConditionAnswerId	String	ID assigned to the answer which entails an additional questionnaire.
ConditionDisplay	String	Indicates if an additional questionnaire is associated with the answer.
Type	String	Type in questions.

RecruitingCEQuestionsanswers

Columns


Name	Type	Description
RecruitingCEQuestionsAttributeName	String	Finds details of the questionnaire row by a unique ID and a requisition number
Meaning	String	Meaning of answers in questions.
LookupCode	String	Lookup code in answers in questions.

RecruitingCEQuestionsResponses

Columns


Name	Type	Description
RequisitionNumber	String	The job requisition number associated with the job application
QuestionnaireId	String	The ID of the questionnaire which contains the questions and answers
QstnrVersionNumber	String	The version number of the questionnaire which contains the questions and answers
DQResponses	String	Responses provided by the candidate for the questions asked while applying for a job

RecruitingCEReferralHits

Columns


Name	Type	Description
RequisitionNumber [KEY]	String	Requisition number for the requisition clicks.
ShareId	String	Share ID for requisition clicks.
Source	String	Source for referral clicks for a candidate.
RequisitionHitId	String	ID assigned to each requisition click.
ReferralId	String	Referral ID for requisition clicks.

RecruitingCEReferrals

Columns


Name	Type	Description
Status	String	Status of candidate referral.
RequisitionId	String	Requisition ID for candidate referral.
ReferralId	String	Referrer ID for candidate referral.
RefererName	String	Referrer Name for candidate referral.
CandidateName	String	Candidate Name for candidate referral.

RecruitingCEReferralsattachments

Columns


Name	Type	Description
RecruitingCEReferralsReferralId	String	Finds a candidate referral using a unique ID and a referral ID
RecruitingCEReferralsRequisitionId	String	Finds a candidate referral using a unique ID and a requisition ID
AttachmentName	String	Attachment Name for attachments in candidate referral.
DocumentId	String	ID assigned to candidate referral attachment.
Type	String	Type for attachments in candidate referral.
AttachmentId	String	Attachment ID for attachments in candidate referral.
AttachmentContents	String	Attachment Contents for attachments in candidate referral.
Category	String	Category for attachments in candidate referral.
MimeType	String	Mime type for attachments in candidate referral.

RecruitingCERegulatoryResponses

Columns


Name	Type	Description
RequisitionNumber	String	A number specific to requisition.
RegulatoryResponses	String	Response for a regulatory.
Status	String	Status of a regulatory response.

RecruitingCESearchAutoSuggestions

Columns


Name	Type	Description
Id	String	ID in auto suggestions on search
Name [KEY]	String	Name in auto suggestions on search
Level	Long	Level in auto suggestions on search
City	String	City in auto suggestions on search
State	String	State in auto suggestions on search
Country	String	Country in auto suggestions on search

RecruitingCESecondaryApplyFlows

Columns


Name	Type	Description
PrimaryKey [KEY]	String	Primary key of the recruiting secondary application flow.
FlowId	String	ID assigned to the recruiting secondary application flow.
FlowCode	String	Code assigned to the recruiting secondary application flow.
FlowTypeCode	String	Code assigned to the type of recruiting secondary application flow.
FlowVersionId	String	ID assigned to the version of recruiting secondary application flow.
FlowName	String	Name assigned to the recruiting secondary application flow.
FlowVersionName	String	Name assigned to the version of recruiting secondary application flow.
SingleClickApplyFlag	Bool	Indicates whether the one page application flow is enabled or disabled for the recruiting secondary application flow.
EsignEnabledFlag	Bool	Indicates whether the electronic signature is enabled or disabled for the recruiting secondary application flow.
OptinEnabledFlag	Bool	Indicates whether campaign opt in is enabled or disabled for the recruiting secondary application flow.
TCOptinEnabledFlag	Bool	Indicates whether Talent Community opt in is enabled or disabled for the recruiting secondary application flows.
SubmissionId	String	ID assigned when the recruiting secondary application is submitted.
EsignDescriptionVersionId	String	E-Signature version of the recruiting secondary application flow.
OptinDescriptionVersionId	String	Campaign opt in version of the recruiting secondary application flow.
EsignDescriptionStr	String	E-Signature option of the recruiting secondary application flow.
OptinDescriptionStr	String	Campaign opt in option of the recruiting secondary application flow.
ProfileVersion	String	Profile version of the recruiting secondary application flow.

RecruitingCESecondaryApplyFlowsrequisitionFlexFields

Columns


Name	Type	Description
RecruitingCESecondaryApplyFlowsPrimaryKey	String	Primary key and primary key variable to find recruiting secondary application flows.
Prompt	String	Display label of a flexfield.
Value	String	Value of a flexfield.
SequenceNumber	String	Sequence number of a flexfield.
ColumnName	String	Column name of a flexfield.

RecruitingCESecondaryApplyFlowssections

Columns


Name	Type	Description
RecruitingCESecondaryApplyFlowsPrimaryKey	String	Primary key and primary key variable to find recruiting secondary application flows.
SectionSequence	Int	Section sequence of the recruiting secondary application flow.
SectionName	String	Section name of the recruiting secondary application flow.

RecruitingCESecondaryApplyFlowssectionspages

Columns


Name	Type	Description
RecruitingCESecondaryApplyFlowsPrimaryKey	String	Primary key and primary key variable to find recruiting secondary application flows.
PageSequence	Int	Page sequence of the recruiting secondary application flow.
PageName	String	Page name of the recruiting secondary application flow.

RecruitingCESecondaryApplyFlowssectionspagesblocks

Columns


Name	Type	Description
RecruitingCESecondaryApplyFlowsPrimaryKey	String	Primary key and primary key variable to find recruiting secondary application flows.
PageBlockId	String	ID assigned to the block of the recruiting secondary application flow.
BlockCode	String	Code assigned to the block of the recruiting secondary application flow.
BlockSequence	Int	Sequence of the blocks of the recruiting secondary application flow.
HideInMobileFlag	Bool	Indicates whether the block is displayed or hidden in mobile.
MetadataService	String	Metadata services associated with the blocks of the recruiting secondary application flow.
ReadWriteService	String	Read and write services for the blocks of the recruiting secondary application flow.
BlockName	String	Name of the block of the recruiting secondary application flow.
BlockTitle	String	Title of the block of the recruiting secondary application flow.
BlockInstructions	String	Instructions for the block of the recruiting secondary application flow.
BlockProperties	String	Properties of the block of the recruiting secondary application flow.

RecruitingCESites

Columns


Name	Type	Description
SiteId	String	Unique ID assigned to each site.
SiteName	String	Name assigned to the recruitingCESites.
SiteCode	String	Code assigned to the recruitingCESites.
ThemeId	String	Unique ID assigned to each site theme.
Language	String	Language opted on the recruitingCESites.
DefaultLang	String	Default Language of the recruitingCESites.
SequenceNumber	String	Sequence number for the recruitingCESites.
StatusCode	String	Status code assigned to the recruitingCESites.
ThemeNumber	String	Number assigned to the theme of the recruitingCESites.
SiteNumber	String	Number assigned to the recruitingCESites.
TemplateNumber	String	Number assigned to the template of the recruitingCESites.
CustomAction	String	Custom action defined on the recruitingCESites.
ReplacementSiteNumber	String	Replacement site number for the recruitingCESites.
EmailTemplateId	String	ID assigned to each HTML email template for the career site.
OgImageSrc	String	Image source used as Open Graph Image when sharing the page on social platforms.

RecruitingCESitescookieConsent

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
CookieId	String	Cookie Id.
SiteId	String	Unique ID assigned to each site of the cookie consent.
AcceptButtonLabel	String	Label of the accept button on the cookie consent page.
DeclineButtonLabel	String	Label assigned to the decline cookie button on the cookie consent page.
PopUpMessage	String	Pop up message defined on the cookie consent page.
PolicyMessage	String	Policy details on the cookie consent page.
CookieMessageEnabledFlag	Bool	Indicates that the cookie is enabled on the page.
DeclineButtonEnabledFlag	Bool	Indicates that the decline cookies button is enabled on the page.
Language	String	Language of the cookie consent page.

RecruitingCESitescookieConsenttranslations

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
CookieconsentCookieId	String	Find cookie consent in recruitingCESites by unique ID and CookieId
CookieId	String	Unique ID assigned to each cookie for the consent translations.
Language	String	Language of the translations on the cookie consent site.
SourceLang	String	Source language of the translations on the cookie consent site.
AcceptButtonLabel	String	Label of the accept button for cookie consent.
DeclineButtonLabel	String	Label of the decline button for cookie consent.
PolicyMessage	String	Policy message in the cookie consent translations.
PopUpMessage	String	Message that pops up in the cookie consent translations.

RecruitingCESitescustomFonts

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
FontName	String	Name of the font.
CustomFontId	String	ID assigned to each custom font.
FontNumber	String	Size of the font.

RecruitingCESitescustomFontscustomFontsSettings

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
CustomfontsCustomFontId	String	Find custom fonts in recruitingCESites by a primary key and Custom Font Id
SettingId	String	ID assigned to each setting of the custom fonts.
Style	String	Style of the custom font.
Weight	String	Weight of the custom font.
SettingNumber	String	Number assigned to each setting of the custom fonts.
FontNumber	String	Size of the font in custom font settings.
ObjectVersionNumber	Int	Number assigned to each version of the custom font setting.

RecruitingCESitescustomFontscustomFontsSettingscustomFontsFiles

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
CustomfontsCustomFontId	String	Find custom fonts in recruitingCESites by a primary key and Custom Font Id
CustomfontssettingsSettingId	String	Find custom font settings by Primary Key and the SettingId variable
FileId	String	ID assigned to the file of the custom font setting.
ObjectVersionNumber	Int	Number assigned to each version of the custom font files.
Type	String	Type of the custom font file.
FileNumber	String	Number assigned to the file of the custom font setting.
SettingNumber	String	Number assigned to each setting of the custom font files.
URL	String	URL of the custom font file.

RecruitingCESitesfilters

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
ObjectCtxId	String	ID assigned to the filters pertaining to the candidate experience.
DimensionTypeCode	String	Code assigned to the type of dimensions in the filters.
GeographyNodeId	String	ID assigned to the geographical node selected in the filters.
GeographyId	String	ID assigned to the geography selected in filters.
JobFamilyId	String	ID assigned to the job family in the filters.
JobFunctionCode	String	Job function code assigned to the filters.
OrganizationId	String	Organization ID assigned to the filters.
RecruitingTypeCode	String	Recruiting type code assigned to the filters.
DimensionKey	String	Key assigned to the dimension in filters.

RecruitingCESitesfooterLinks

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
LinkId	String	Unique ID assigned to each footer link.
LinkNumber	String	Number of the footer links in the recruitingCESites.
LinkOrder	String	Order of the footer links in the recruitingCESites.
LinkText	String	Test of the footer links in the recruitingCESites.
LinkTypeCode	String	Code assigned to the URL of the footer links in the recruitingCESites.
LinkURL	String	URL of the footer links in the recruitingCESites.
ParentLinkNumber	String	Number of the parent of the footer links in the recruitingCESites.
LinkName	String	Name of the footer links in the recruitingCESites.
VisibleOnMobile	Bool	Visibility of the footer links in the recruitingCESites, on mobile devices.
Language	String	Language of the footer links in the recruitingCESites.

RecruitingCESitesfooterLinkssublinks

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
FooterlinksLinkId	String	Find recruiting CE Sites Footer Link by a primary key and the LinkID variable
LinkId	String	Unique ID assigned to each header sublink.
LinkNumber	String	Number of the child links.
LinkOrder	String	Order of the child links.
LinkText	String	Text of the child links.
LinkTypeCode	String	Code assigned to the type of child links.
LinkURL	String	URL of the child links.
ParentLinkNumber	String	Number assigned to the parent of the child links.
LinkName	String	Name of the child links.
VisibleOnMobile	Bool	Indicates if the child links are visible on mobile.
Language	String	Language of the child links.

RecruitingCESitesfooterLinkssublinkstranslations

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
FooterlinksLinkId	String	Find recruiting CE Sites Footer Link by a primary key and the LinkID variable
SublinksLinkId	String	Finds the recruitingCESites header sublinks by primary key and the LinkID variable
LinkId	String	Unique ID assigned to each header link translation.
Language	String	Language of the header translation.
SourceLang	String	Source language of the header translation.
LinkName	String	Link name of the header translation.
LinkText	String	Link text of the header translation.
LinkURL	String	Link URL of the header translation.

RecruitingCESitesfooterLinkstranslations

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
FooterlinksLinkId	String	Find recruiting CE Sites Footer Link by a primary key and the LinkID variable
LinkId	String	Unique ID assigned to each header link translation.
Language	String	Language of the header translation.
SourceLang	String	Source language of the header translation.
LinkName	String	Link name of the header translation.
LinkText	String	Link text of the header translation.
LinkURL	String	Link URL of the header translation.

RecruitingCESitesheaderLinks

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
LinkId	String	Unique ID assigned to each header link.
LinkNumber	String	Number of the header links
LinkOrder	String	Order of the header links.
LinkText	String	Text of the header links.
LinkTypeCode	String	Code assigned to the type of header links.
LinkURL	String	URL of the header links.
ParentLinkNumber	String	Number assigned to the parent of the header link.
LinkName	String	Name of the header links.
VisibleOnMobile	Bool	Indicates if the header link is visible on mobile.
Language	String	Language of the header links.

RecruitingCESitesheaderLinkssublinks

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
HeaderlinksLinkId	String	Finds the recruitingCESites header link by primary key and the LinkID variable
LinkId	String	Unique ID assigned to each header sublink.
LinkNumber	String	Number of the child links.
LinkOrder	String	Order of the child links.
LinkText	String	Text of the child links.
LinkTypeCode	String	Code assigned to the type of child links.
LinkURL	String	URL of the child links.
ParentLinkNumber	String	Number assigned to the parent of the child links.
LinkName	String	Name of the child links.
VisibleOnMobile	Bool	Indicates if the child links are visible on mobile.
Language	String	Language of the child links.

RecruitingCESitesheaderLinkssublinkstranslations

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
HeaderlinksLinkId	String	Finds the recruitingCESites header link by primary key and the LinkID variable
SublinksLinkId	String	Finds the recruitingCESites header sublinks by primary key and the LinkID variable
LinkId	String	Unique ID assigned to each header link translation.
Language	String	Language of the header translation.
SourceLang	String	Source language of the header translation.
LinkName	String	Link name of the header translation.
LinkText	String	Link text of the header translation.
LinkURL	String	Link URL of the header translation.

RecruitingCESitesheaderLinkstranslations

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
HeaderlinksLinkId	String	Finds the recruitingCESites header link by primary key and the LinkID variable
LinkId	String	Unique ID assigned to each header link translation.
Language	String	Language of the header translation.
SourceLang	String	Source language of the header translation.
LinkName	String	Link name of the header translation.
LinkText	String	Link text of the header translation.
LinkURL	String	Link URL of the header translation.

RecruitingCESiteslanguages

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
SiteId	String	Site ID of the language.
SiteLanguage	String	Language of the site where the pages are published.

RecruitingCESitespages

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
PageId	String	Unique ID assigned to each page.
PageCode	String	Code assigned to the pages in the recruitingCESites.
SeoDescription	String	Description of the search engine optimization used on the pages.
SiteNumber	String	Number of the parent resource for page assigned to the recruitingCESites.
StatusCode	String	Code assigned to the status of the pages.
Title	String	Title assigned to the pages in the recruitingCESites.
OgDescription	String	Organization description.
OgImageSrc	String	Organization image source.
PublishedDate	Datetime	Date of publishing of the pages in the recruitingCESites.
ElementId	String	Unique ID assigned to each element in the page.
ElementNumber	String	Element number assigned to the pages in the recruitingCESites.
Language	String	Language used in the pages on the recruitingCESites.
CreationDate	Datetime	Date of creation of the pages in the recruitingCESites.
SiteCode	String	Code assigned to the recruitingCESites on which the pages are published.
CustomAction	String	Custom action that can be done on pages defined on the recruitingCESites.

RecruitingCESitessettings

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
SettingId	String	Unique ID assigned to each setting in recruitingCESites.
SettingKey	String	Code assigned to the settings.
SettingValue	String	Value assigned to the settings.

RecruitingCESitessiteFavicon

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
FaviconId	String	Unique ID assigned to each favorite icon.
FaviconImg	String	Favorite icon image.
ImgType	String	Type of a favorite icon image.
SiteId	String	ID assigned to multiple favorite icons.

RecruitingCESitestalentCommunitySignUp

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
ButtonLabel	String	Label of the buttons on the talent community sign up site.
SiteId	String	Site ID in talent community sign up.
Description	String	Description of the sign up in the talent community site.
Title	String	Title assigned to each of the sign up in the talent community in the recruitingCESites.
Language	String	Language used in the sign up in the talent community on the recruitingCESites..
ShowAtSearchResultsFlag	Bool	Indicates when search results appear on a site.
ShowWhenNoSearchResultsFoundFlag	Bool	Indicates when no results come up during a search executed on the recruitingCESites.
Id	String	ID assigned to each sign up in the talent community.

RecruitingCESitestalentCommunitySignUptranslations

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
TalentcommunitysignupSiteId	String	Find talent community sign up in recruitingCESites by primary key and the Site ID variable
ButtonLabel	String	Label of the button in talent community sign up.
SiteId	String	Site ID in talent community sign up translation.
Language	String	Language of the talent community sign up.
Description	String	Description of the talent community sign up.
Title	String	Title of the talent community sign up.
SourceLang	String	Source language of the talent community sign up translation.

RecruitingCESitestranslations

Columns


Name	Type	Description
RecruitingCESitesSiteId	String	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId	String	Finds Recruiting CE Site by a unique Theme ID and the primary key
Language	String	Language of the site translation.
SiteId	String	Unique ID assigned to each site translation.
SiteName	String	Name of the site.
SourceLang	String	Source language of the site translation.

RecruitingCESourceTrackings

Columns


Name	Type	Description
SourceTrackingId [KEY]	String	Source Tracking ID in recruitingCESourceTrackings.
SourceLevel	String	SourceLevel
Source	String	Source
SourceMedium	String	SourceMedium
CampaignCode	String	CampaignCode
ReferrerHeader	String	ReferrerHeader
SourceInternalInfo	String	SourceInternalInfo
RequisitionNumber	String	RequisitionNumber
TokenId	String	TokenId
SubmissionId	String	SubmissionId
ReferralId	String	ReferralId
RecruiterId	String	RecruiterId
PoolId	String	PoolId
CandidateNumber	String	CandidateNumber
ShareId	String	ShareId
VerificationToken	String	VerificationToken
ParentSourceTrackingId	String	ParentSourceTrackingId
SiteNumber	String	SiteNumber
CampaignPostId	String	CampaignPostId

RecruitingCETaxCredits

Columns


Name	Type	Description
RequisitionNumber [KEY]	String	Number assigned to each job requisition with a tax credit.
TaxCreditURL	String	Tax credit URL in the recruiting candidate tax credits.
FlowVersionId	String	Unique identifier for the version of the application flow used for the job application.
DraftId	String	Unique identifier for a draft job application.
TaxCreditConfiguredFlag	Bool	Indicates whether the application flow is configured for tax credit screening.
TaxCreditCompletedFlag	Bool	Indicates whether the candidate completed the tax credit screening.
InlineTaxCreditFlag	Bool	Indicates whether the application flow is configured for an inline tax credit screening.
SubmissionBlockedFlag	Bool	Indicates whether the job application is blocked.

RecruitingCEThemes

Columns


Name	Type	Description
HeaderMode	Int	Header mode in themes in recruitingCETemplates.
FooterMode	Int	Footer mode in themes in recruitingCETemplates.
ThemeNumber	String	Theme number in themes in recruitingCETemplates.
ThemeName	String	Theme name in themes in recruitingCETemplates.
SplashPageCode	String	Splash page code in themes in recruitingCETemplates.
TemplateNumber	String	Template number in themes in recruitingCETemplates.
SiteNumber	String	Site number in themes in recruitingCETemplates.
MainCallForAction	String	Main call for action in themes in recruitingCETemplates.
WelcomeText	String	Welcome text in themes in recruitingCETemplates.
SplashPageNumber	String	Splash page number in themes in recruitingCETemplates.
CustomJsEnabledFlag	Bool	Indicates that custom jobs are enabled in the themes in recruitingCETemplates.
GeneratedCustomCSS	String	Generated custom CSS containing cascading style sheet custom variables.

RecruitingCEThemesbrands

Columns


Name	Type	Description
BrandingId	String	Branding ID in brands in recruitingCEThemes.
FrontImageURL	String	Front image URL in brands in recruitingCEThemes.
LogoImageURL	String	Logo image URL in brands in recruitingCEThemes.
MobileFrontImageURL	String	Mobile front image URL in brands in recruitingCEThemes.
MobileLogoImageURL	String	Mobile logo image URL in brands in recruitingCEThemes.
CustomCSSCLOB	String	Custom CSSCLOB in brands in recruitingCEThemes.
FooterHTMLCLOB	String	Footer HTMLCLOB in brands in recruitingCEThemes.
HeaderHTMLCLOB	String	Header HTMlCLOB in brands in recruitingCEThemes.
Language	String	Language in brands in recruitingCEThemes.
HeaderHTML	String	Header HTML in brands in recruitingCEThemes.
FooterHTML	String	Footer HTML in brands in recruitingCEThemes.
CustomCSS	String	Custom CSS in brands in recruitingCEThemes.
CustomJSCLOB	String	Custom JSCLOB in brands in recruitingCEThemes.
CustomJS	String	Custom jobs in brands in recruitingCEThemes.

RecruitingCEThemesfooterLinks

Columns


Name	Type	Description
LinkNumber	String	Link number in footer links in recruitingCEThemes.
LinkOrder	String	Link order in footer links in recruitingCEThemes.
Text	String	Text in footer links in recruitingCEThemes.
URL	String	URL in footer links in recruitingCEThemes.
ParentLinkNumber	String	Parent link number in footer links in recruitingCEThemes.
LinkName	String	Link name in footer links in recruitingCEThemes.
VisibleOnMobile	Bool	Visible on mobile in footer links in recruitingCEThemes.
Language	String	Language in footer links in recruitingCEThemes.

RecruitingCEThemesfooterLinkstranslations

Columns


Name	Type	Description
Language	String	Language in translations in recruitingCEThemes.
LinkName	String	Link name in translations in recruitingCEThemes.
LinkText	String	Link text in translations in recruitingCEThemes.
LinkURL	String	Link URL in translations in recruitingCEThemes.
SourceLang	String	Source language in translations in recruitingCEThemes.

RecruitingCEThemesheaderLinks

Columns


Name	Type	Description
LinkNumber	String	Link number in header links in recruitingCEThemes.
LinkOrder	String	Link order in header links in recruitingCEThemes.
Text	String	Text in header links in recruitingCEThemes.
URL	String	URL in header links in recruitingCEThemes.
ParentLinkNumber	String	Parent link number in header links in recruitingCEThemes.
LinkName	String	Link name in header links in recruitingCEThemes.
VisibleOnMobile	Bool	Visible on mobile in header links in recruitingCEThemes.
Language	String	Language in header links in recruitingCEThemes.

RecruitingCEThemesheaderLinkstranslations

Columns


Name	Type	Description
Language	String	Language in translations in recruitingCEThemes.
LinkName	String	Link name in translations in recruitingCEThemes.
LinkText	String	Link text in translations in recruitingCEThemes.
LinkURL	String	Link URL in translations in recruitingCEThemes.
SourceLang	String	Source language in translations in recruitingCEThemes.

RecruitingCEThemesstyles

Columns


Name	Type	Description
BackgroundColor	String	Background color in styles in recruitingCEThemes.
LineHeight	Double	Line height in styles in recruitingCEThemes.
FontSize	Double	Font size in styles in recruitingCEThemes.
FontWeight	String	Font weight in styles in recruitingCEThemes.
StyleSelector	String	Style selector in styles in recruitingCEThemes.
FontName	String	Font name in styles in recruitingCEThemes.
FontColor	String	Font color in styles in recruitingCEThemes.

RecruitingCEThemestranslations

Columns


Name	Type	Description
Language	String	Language in translations in recruitingCETemplates.
MainCallForAction	String	Main call for action in translations in recruitingCETemplates.
SourceLang	String	Source language in translations in recruitingCETemplates.
TemplateName	String	Template name in translations in recruitingCETemplates.
WelcomeText	String	Welcome text in translations in recruitingCETemplates.

RecruitingCEUserTrackings

Columns


Name	Type	Description
UserId [KEY]	String	ID assigned to the user whose tracking have been recorded.
CandidateNumber	String	Number assigned to the candidate whose tracking are recorded.
TemporaryUserId	String	Temporary ID assigned to the user whose tracking have been recorded.
Content	String	Content of the user tracking.

RecruitingCEVerificationTokens

Columns


Name	Type	Description
TokenId [KEY]	String	Token ID in the verification token.
Token	String	Token in the verification token.
Email	String	Email in the verification token.
Phone	String	Phone number in the verification token.
Mode	String	Mode in the verification token.
AccessCode	String	Access Code in the verification token.
CandidateNumber	String	Candidate Number in the verification token.
RequisitionNumber	String	Requisition Number in the verification token.
SiteNumber	String	Site Number in the verification token.
SourceTrackingId	String	Source Tracking ID in the verification token.
ResendFlag	Bool	Resend indicator in the verification token.
ConsumerResponse	String	Consumer Response in the verification token.
Target	String	Target URL after the shortened URL is resolved
URLShortCode	String	Shortened URL to resolve on CE.
ShortCode	String	Short code for verification.
ChallengeFlag	Bool	Indicates a short code challenge is required for verification.
CookieId	String	ID assigned to each cookie identifying the user.
CookieMatchedFlag	Bool	Indicates that the cookie matched with expected value for the user.
LastName	String	Last Name of the user.
AttemptsRemaining	String	Number of attempts remaining to validate the short code.
PersistAccessFlag	Bool	Indicates whether the request to keep the user signed in across sessions is enabled or disabled.
AccessCodeExpirationDate	Datetime	Expiration date of the access code.

RecruitingHierarchyLocations

Columns


Name	Type	Description
GeographyId	String	Geography ID in hierarchy locations.
GeographyNodeId	String	Geography node ID in hierarchy locations.
GeographyFlatName	String	Geography flat name in hierarchy locations.
GeographyShortName	String	Geography short name in hierarchy locations.
GeographyLevel	String	Geography level in hierarchy locations.

RecruitingJobFamilies

Columns


Name	Type	Description
JobFamilyId [KEY]	String	Job family ID.
JobFamilyName	String	Job family name.
ActiveStatus	String	Job family active status.

RecruitingLinkedInEventNotifications

Columns


Name	Type	Description
Id	String	Unique ID assigned to each LinkedIn notification.
Type	String	Type of LinkedIn notification.
ExpiresAt	String	Time when the LinkedIn notification will expire. If not provided, the notification will never expire.

RecruitingLocationsLOV

Columns


Name	Type	Description
LocationFQN [KEY]	String	Location attribute Name.

Connection String Options

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider. Click the links for further details.

For more information on establishing a connection, see Establishing a Connection.

Authentication

Property	Description
URL	The Oracle HCM Cloud URL.
User	The Oracle HCM Cloud user account used to authenticate.
Password	The password used to authenticate the user.

SSL

Property	Description
SSLServerCert	The certificate to be accepted from the server when connecting using TLS/SSL.

Firewall

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

Proxy

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Logging

Property	Description
LogModules	Core modules to be included in the log file.

Schema

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Miscellaneous

Property	Description
APIVersion	The API Version of Oracle ERP that the user wants to use.
IncludeCustomChildObjects	Whether or not to include the Custom Child Objects.
IncludeCustomObjects	Property to include the Custom Objects.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

Authentication

This section provides a complete list of the Authentication properties you can configure in the connection string for this provider.

Property	Description
URL	The Oracle HCM Cloud URL.
User	The Oracle HCM Cloud user account used to authenticate.
Password	The password used to authenticate the user.

URL

The Oracle HCM Cloud URL.

Remarks

The Oracle HCM Cloud URL.

User

The Oracle HCM Cloud user account used to authenticate.

Remarks

Together with Password, this field is used to authenticate against the Oracle HCM Cloud server.

Password

The password used to authenticate the user.

Remarks

The User and Password are together used to authenticate with the server.

SSL

This section provides a complete list of the SSL properties you can configure in the connection string for this provider.

Property	Description
SSLServerCert	The certificate to be accepted from the server when connecting using TLS/SSL.

SSLServerCert

The certificate to be accepted from the server when connecting using TLS/SSL.

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.

This property can take the following forms:


Description	Example
A full PEM Certificate (example shortened for brevity)	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate	C:\cert.cer
The public key (example shortened for brevity)	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated)	ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated)	34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine is accepted.

Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.

Firewall

This section provides a complete list of the Firewall properties you can configure in the connection string for this provider.

Property	Description
FirewallType	The protocol used by a proxy-based firewall.
FirewallServer	The name or IP address of a proxy-based firewall.
FirewallPort	The TCP port for a proxy-based firewall.
FirewallUser	The user name to use to authenticate with a proxy-based firewall.
FirewallPassword	A password used to authenticate to a proxy-based firewall.

FirewallType

The protocol used by a proxy-based firewall.

Remarks

This property specifies the protocol that the Sync App will use to tunnel traffic through the FirewallServer proxy. Note that by default, the Sync App connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.


Type	Default Port	Description
TUNNEL	80	When this is set, the Sync App opens a connection to Oracle HCM Cloud and traffic flows back and forth through the proxy.
SOCKS4	1080	When this is set, the Sync App sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5	1080	When this is set, the Sync App sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.

FirewallServer

The name or IP address of a proxy-based firewall.

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the Sync App uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.

FirewallPort

The TCP port for a proxy-based firewall.

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.

FirewallUser

The user name to use to authenticate with a proxy-based firewall.

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.

FirewallPassword

A password used to authenticate to a proxy-based firewall.

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.

Proxy

This section provides a complete list of the Proxy properties you can configure in the connection string for this provider.

Property	Description
ProxyAutoDetect	This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.
ProxyServer	The hostname or IP address of a proxy to route HTTP traffic through.
ProxyPort	The TCP port the ProxyServer proxy is running on.
ProxyAuthScheme	The authentication type to use to authenticate to the ProxyServer proxy.
ProxyUser	A user name to be used to authenticate to the ProxyServer proxy.
ProxyPassword	A password to be used to authenticate to the ProxyServer proxy.
ProxySSLType	The SSL type to use when connecting to the ProxyServer proxy.
ProxyExceptions	A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

ProxyAutoDetect

This indicates whether to use the system proxy settings or not. This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

Remarks

This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.

ProxyServer

The hostname or IP address of a proxy to route HTTP traffic through.

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The Sync App can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the Sync App uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.

ProxyPort

The TCP port the ProxyServer proxy is running on.

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.

ProxyAuthScheme

The authentication type to use to authenticate to the ProxyServer proxy.

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the Sync App will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

BASIC: The Sync App performs HTTP BASIC authentication.
DIGEST: The Sync App performs HTTP DIGEST authentication.
NEGOTIATE: The Sync App retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
PROPRIETARY: The Sync App does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.

ProxyUser

A user name to be used to authenticate to the ProxyServer proxy.

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:

user@domain
domain\user

ProxyPassword

A password to be used to authenticate to the ProxyServer proxy.

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the Sync App uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.

ProxySSLType

The SSL type to use when connecting to the ProxyServer proxy.

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:


AUTO	Default setting. If the URL is an HTTPS URL, the Sync App will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYS	The connection is always SSL enabled.
NEVER	The connection is not SSL enabled.
TUNNEL	The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

ProxyExceptions

A semicolon separated list of destination hostnames or IPs that are exempt from connecting through the ProxyServer .

Remarks

The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the Sync App uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

Logging

This section provides a complete list of the Logging properties you can configure in the connection string for this provider.

Property	Description
LogModules	Core modules to be included in the log file.

LogModules

Core modules to be included in the log file.

Remarks

Only the modules specified (separated by ';') will be included in the log file. By default all modules are included.

See the Logging page for an overview.

Schema

This section provides a complete list of the Schema properties you can configure in the connection string for this provider.

Property	Description
Location	A path to the directory that contains the schema files defining tables, views, and stored procedures.
BrowsableSchemas	This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.
Tables	This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.
Views	Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Location

A path to the directory that contains the schema files defining tables, views, and stored procedures.

Remarks

The path to a directory which contains the schema files for the Sync App (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is "%APPDATA%\\CData\\OracleHCM Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:

BrowsableSchemas

This property restricts the schemas reported to a subset of the available schemas. For example, BrowsableSchemas=SchemaA,SchemaB,SchemaC.

Remarks

Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.

Tables

This property restricts the tables reported to a subset of the available tables. For example, Tables=TableA,TableB,TableC.

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Views

Restricts the views reported to a subset of the available tables. For example, Views=ViewA,ViewB,ViewC.

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the Sync App.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Miscellaneous

This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.

Property	Description
APIVersion	The API Version of Oracle ERP that the user wants to use.
IncludeCustomChildObjects	Whether or not to include the Custom Child Objects.
IncludeCustomObjects	Property to include the Custom Objects.
MaxRows	Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
Other	These hidden properties are used only in specific use cases.
PseudoColumns	This property indicates whether or not to include pseudo columns as columns to the table.
Timeout	The value in seconds until the timeout error is thrown, canceling the operation.
UserDefinedViews	A filepath pointing to the JSON configuration file containing your custom views.

APIVersion

The API Version of Oracle ERP that the user wants to use.

Remarks

The API Version of Oracle ERP that the user wants to use.

IncludeCustomChildObjects

Whether or not to include the Custom Child Objects.

Remarks

Whether or not to include the Custom Child Objects.

IncludeCustomObjects

Property to include the Custom Objects.

Remarks

Property to include the Custom Objects.

MaxRows

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Other

These hidden properties are used only in specific use cases.

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Integration and Formatting


DefaultColumnSize	Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMT	Determines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename	Records the underlying socket data transfer to the specified file.

PseudoColumns

This property indicates whether or not to include pseudo columns as columns to the table.

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".

Timeout

The value in seconds until the timeout error is thrown, canceling the operation.

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the Sync App throws an exception.

UserDefinedViews

A filepath pointing to the JSON configuration file containing your custom views.

Remarks

User Defined Views are defined in a JSON-formatted configuration file called UserDefinedViews.json. The Sync App automatically detects the views specified in this file.

You can also have multiple view definitions and control them using the UserDefinedViews connection property. When you use this property, only the specified views are seen by the Sync App.

This User Defined View configuration file is formatted as follows:

Each root element defines the name of a view.
Each root element contains a child element, called query, which contains the custom SQL query for the view.

For example:

{
	"MyView": {
		"query": "SELECT * FROM RecruitingCESites WHERE MyColumn = 'value'"
	},
	"MyView2": {
		"query": "SELECT * FROM MyTable WHERE Id IN (1,2,3)"
	}
}

Use the UserDefinedViews connection property to specify the location of your JSON configuration file. For example:

"UserDefinedViews", "C:\\Users\\yourusername\\Desktop\\tmp\\UserDefinedViews.json"