接続の確立

Sync App アプリケーションの接続ページに移動し、接続の追加 パネルで対応するアイコンを選択して、Oracle HCM Cloud への接続を作成します。Oracle HCM Cloud アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからOracle HCM Cloud コネクタをダウンロードおよびインストールします。

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

Oracle HCM Cloud への接続

Oracle HCM Cloud への認証には、以下を設定する必要があります。

Url：アカウントのURL。
User：アカウントのユーザー。
Password：アカウントのパスワード。

データモデル

概要

このセクションでは、利用可能なAPI オブジェクトを示し、Oracle HCM Cloud API へのSQL の実行について詳しく説明します。

主要機能

Sync App は、ジョブ、タスク、給与などのOracle HCM Cloud エンティティをリレーショナルビューとしてモデル化し、SQL を記述してOracle HCM Cloud データをクエリできるようにします。
ストアドプロシージャを使用するとOracle HCM Cloud の操作を実行できます。
これらのオブジェクトへのライブ接続により、Sync App を使用するとOracle HCM Cloud アカウントへのあらゆる変更が即座に反映されます。

ビュー

ビューはOracle HCM Cloud オブジェクトをモデル化するために動的に取得されます。

ストアドプロシージャ

ストアドプロシージャは、Oracle HCM Cloud のファンクションライクなインターフェースです。Oracle ERP のテーブルからスキーマを作成するために使用できます。

ビュー

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。

ビューとして公開されるクエリなどの動的ビューや、project_team ワークアイテムの特定の組み合わせを検索するためのビューがサポートされています。

Oracle HCM Cloud Connector for CData Sync ビュー

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.

接続文字列オプション

接続文字列プロパティは、接続を確立するために使用できるさまざまなオプションです。このセクションでは、本プロバイダーの接続文字列で設定できるオプションの一覧を示します。詳細については各リンクをクリックしてください。

接続を確立する方法について詳しくは、接続の確立を参照してください。

Authentication

プロパティ	説明
URL	The Oracle HCM Cloud URL.
User	認証で使用されるOracle HCM Cloud ユーザーアカウント。
Password	ユーザーの認証で使用されるパスワード。

SSL

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

Firewall

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

Proxy

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

Logging

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

Schema

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

Miscellaneous

プロパティ	説明
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	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

Authentication

このセクションでは、本プロバイダーの接続文字列で設定可能なAuthentication プロパティの全リストを提供します。

プロパティ	説明
URL	The Oracle HCM Cloud URL.
User	認証で使用されるOracle HCM Cloud ユーザーアカウント。
Password	ユーザーの認証で使用されるパスワード。

URL

The Oracle HCM Cloud URL.

解説

The Oracle HCM Cloud URL.

User

認証で使用されるOracle HCM Cloud ユーザーアカウント。

解説

このフィールドは、Password とともに、Oracle HCM Cloud サーバーに対して認証をするために使われます。

Password

ユーザーの認証で使用されるパスワード。

解説

User およびPassword を一緒に使用してサーバーで認証を行います。

SSL

このセクションでは、本プロバイダーの接続文字列で設定可能なSSL プロパティの全リストを提供します。

プロパティ	説明
SSLServerCert	TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

SSLServerCert

TLS/SSL を使用して接続するときに、サーバーが受け入れ可能な証明書。

解説

TLS/SSL 接続を使用する場合は、このプロパティを使用して、サーバーが受け入れるTLS/SSL 証明書を指定できます。コンピュータによって信頼されていない他の証明書はすべて拒否されます。

このプロパティは、次のフォームを取ります：


説明	例
フルPEM 証明書（例では省略されています）	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
証明書を保有するローカルファイルへのパス。	C:\cert.cer
公開鍵（例では省略されています）	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
MD5 Thumbprint （hex 値はスペースおよびコロン区切り）	ecadbdda5a1529c58a1e9e09828d70e4
SHA1 Thumbprint （hex 値はスペースおよびコロン区切り）	34a929226ae0819f2ec14b4a3d904f801cbb150d

これを指定しない場合は、マシンが信用するすべての証明書が受け入れられます。

すべての証明書の受け入れを示すには、'*'を使用します。セキュリティ上の理由から、これはお勧めできません。

Firewall

このセクションでは、本プロバイダーの接続文字列で設定可能なFirewall プロパティの全リストを提供します。

プロパティ	説明
FirewallType	プロキシベースのファイアウォールで使われるプロトコル。
FirewallServer	プロキシベースのファイアウォールの名前もしくはIP アドレス。
FirewallPort	プロキシベースのファイアウォールのTCP ポート。
FirewallUser	プロキシベースのファイアウォールに認証するために使うユーザー名。
FirewallPassword	プロキシベースのファイアウォールへの認証に使われるパスワード。

FirewallType

プロキシベースのファイアウォールで使われるプロトコル。

解説

このプロパティは、Sync App がFirewallServer プロキシ経由でトンネルトラフィックを使うためのプロトコルを指定します。デフォルトでは、Sync App はシステムプロキシに接続します。この動作を無効化し次のプロキシタイプのどれかで接続するには、ProxyAutoDetect をfalse に設定します。


タイプ	デフォルトポート	説明
TUNNEL	80	これが設定されている場合、Sync App はOracle HCM Cloud への接続を開き、プロキシを経由して通信が行われます。
SOCKS4	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 4 プロキシ経由で送信し、接続リクエストが許容されるかどうかを決定します。
SOCKS5	1080	これが設定されている場合、Sync App はデータをFirewallServer およびFirewallPort で指定されたSOCS 5 プロキシ経由で送信します。プロキシに認証が必要な場合には、FirewallUser およびFirewallPassword をプロキシが認識する認証情報に設定します。

HTTP プロキシへの接続には、ProxyServer およびProxyPort ポートを使ってください。HTTP プロキシへの認証には、ProxyAuthScheme、ProxyUser、およびProxyPassword を使ってください。

FirewallServer

プロキシベースのファイアウォールの名前もしくはIP アドレス。

解説

ファイアウォールトラバーサルを許容するために設定するIP アドレス、DNS 名、もしくはプロキシホスト名を指定するプロパティです。プロトコルはFirewallType で指定されます。このプロパティとFirewallServer を使って、SOCKS 経由での接続、もしくはトンネリングが可能です。HTTP プロキシへの接続には、ProxyServer を使用します。

Sync App はデフォルトでシステムプロキシを使うので注意してください。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定してください。

FirewallPort

プロキシベースのファイアウォールのTCP ポート。

解説

ファイアウォールトラバーサルを許容するために設定するプロキシベースのファイアウォールのTCP ポート。名前もしくはIP アドレスを指定するには、FirewallServer を使います。FirewallType でプロトコルを指定します。

FirewallUser

プロキシベースのファイアウォールに認証するために使うユーザー名。

解説

FirewallUser およびFirewallPassword プロパティは、FirewallType により指定された認証方式に則り、FirewallServer、およびFirewallPort で指定されたプロキシに対しての認証に使われます。

FirewallPassword

プロキシベースのファイアウォールへの認証に使われるパスワード。

解説

このプロパティは、FirewallType により指定された認証メソッドに則り、FirewallServer およびFirewallPort で指定されたプロキシに渡されます。

Proxy

このセクションでは、本プロバイダーの接続文字列で設定可能なProxy プロパティの全リストを提供します。

プロパティ	説明
ProxyAutoDetect	これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。
ProxyServer	HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。
ProxyPort	ProxyServer プロキシが起動しているTCP ポート。
ProxyAuthScheme	ProxyServer プロキシへの認証で使われる認証タイプ。
ProxyUser	ProxyServer プロキシへの認証に使われるユーザー名。
ProxyPassword	ProxyServer プロキシへの認証に使われるパスワード。
ProxySSLType	ProxyServer プロキシへの接続時に使用するSSL タイプ。
ProxyExceptions	ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

ProxyAutoDetect

これは、システムプロキシ設定を使用するかどうかを示します。これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

解説

これは他のプロキシ設定よりも優先されるため、カスタムプロキシ設定を使用するにはProxyAutoDetect をFALSE に設定する必要があります。

HTTP プロキシへの接続には、ProxyServer を参照してください。SOCKS やトンネリングなどの他のプロキシには、FirewallType を参照してください。

ProxyServer

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。

解説

HTTP トラフィックをルートするためのプロキシのホストネームもしくはIP アドレス。HTTP プロキシへの認証には、Sync App はHTTP、Windows(NTLM)、もしくはKerberos 認証タイプを使用することができます。

SOCKS プロキシを経由して接続する、もしくは接続をトンネルするには、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシを使う場合には、ProxyAutoDetect をfalse に設定します。

ProxyPort

ProxyServer プロキシが起動しているTCP ポート。

解説

HTTP トラフィックをリダイレクトするHTTP プロキシが実行されているポート。ProxyServer でHTTP プロキシを指定します。その他のプロキシタイプについては、FirewallType を参照してください。

ProxyAuthScheme

ProxyServer プロキシへの認証で使われる認証タイプ。

解説

この値は、ProxyServer およびProxyPort で指定されるHTTP プロキシに認証するために使われる認証タイプを指定します。

Sync App は、デフォルトでsystem proxy settings を使い、追加での設定が不要です。他のプロキシへの接続をする場合には、ProxyServer およびProxyPort に加え、ProxyAutoDetect をfalse に設定します。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

認証タイプは、次のどれかになります。

BASIC： Sync App はHTTP BASIC 認証を行います。
DIGEST： Sync App はHTTP DIGEST 認証を行います。
NEGOTIATE： Sync App は認証において有効なプロトコルに応じて、NTLM もしくはKereros トークンを取得します。
PROPRIETARY： Sync App はNTLM もしくはKerberos トークンを発行しません。このトークンを、HTTP リクエストのAuthorization ヘッダーに含める必要があります。

SOCKS 5 認証のような他の認証タイプを使用するには、FirewallType を参照してください。

ProxyUser

ProxyServer プロキシへの認証に使われるユーザー名。

解説

ProxyUser および ProxyPassword オプションは、ProxyServer で指定されたHTTP プロキシに対して接続および認証するために使用されます。

ProxyAuthScheme で使用可能な認証タイプを選択することができます。HTTP 認証を使う場合、これをHTTP プロキシで識別可能なユーザーのユーザー名に設定します。Windows もしくはKerberos 認証を使用する場合、このプロパティを次の形式のどれかでユーザー名に設定します。

user@domain
domain\user

ProxyPassword

ProxyServer プロキシへの認証に使われるパスワード。

解説

このプロパティは、NTLM(Windows)、Kerberos、もしくはHTTP 認証をサポートするHTTP プロキシサーバーに認証するために使われます。HTTP プロキシを指定するためには、ProxyServer およびProxyPort を設定します。認証タイプを指定するためにはProxyAuthScheme を設定します。

HTTP 認証を使う場合、さらにHTTP プロキシにProxyUser およびProxyPassword を設定します。

NTLM 認証を使う場合、Windows パスワードにProxyUser およびProxyPassword を設定します。Kerberos 認証には、これらを入力する必要があります。

SOCKS 5 認証もしくは、トンネリングは、FirewallType を参照してください。

デフォルトで、Sync App はsystem プロキシを使います。他のプロキシに接続する場合には、これをfalse に設定します。

ProxySSLType

ProxyServer プロキシへの接続時に使用するSSL タイプ。

解説

このプロパティは、ProxyServer で指定されたHTTP プロキシへの接続にSSL を使用するかどうかを決定します。この値は、AUTO、ALWAYS、NEVER、TUNNEL のいずれかです。有効な値は次のとおりです。


AUTO	デフォルト設定。URL がHTTPS URL の場合、Sync App は、TUNNEL オプションを使います。URL がHTTP URL の場合、コンポーネントはNEVER オプションを使います。
ALWAYS	接続は、常にSSL 有効となります。
NEVER	接続は、SSL 有効になりません。
TUNNEL	接続は、トンネリングプロキシを経由します。プロキシサーバーがリモートホストへの接続を開き、プロキシを経由して通信が行われます。

ProxyExceptions

ProxyServer 経由での接続が免除される宛先ホスト名またはIP のセミコロン区切りのリスト。

解説

ProxyServer は、このプロパティで定義されたアドレスを除くすべてのアドレスに使用されます。セミコロンを使用してエントリを区切ります。

Sync App は、追加設定なしにデフォルトでシステムのプロキシ設定を使います。この接続のプロキシ例外を明示的に構成するには、ProxyAutoDetect をfalse に設定して、ProxyServer およびProxyPort を設定する必要があります。認証するには、ProxyAuthScheme を設定し、必要な場合にはProxyUser およびProxyPassword を設定します。

Logging

このセクションでは、本プロバイダーの接続文字列で設定可能なLogging プロパティの全リストを提供します。

プロパティ	説明
LogModules	ログファイルに含めるコアモジュール。

LogModules

ログファイルに含めるコアモジュール。

解説

指定された（';' で区切られた）モジュールのみがログファイルに含まれます。デフォルトではすべてのモジュールが含まれます。

概要はログページを参照してください。

Schema

このセクションでは、本プロバイダーの接続文字列で設定可能なSchema プロパティの全リストを提供します。

プロパティ	説明
Location	テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。
BrowsableSchemas	このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。
Tables	このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。
Views	使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

Location

テーブル、ビュー、およびストアドプロシージャを定義するスキーマファイルを格納するディレクトリへのパス。

解説

Sync App のスキーマファイル（テーブルとビューの場合は.rsd ファイル、ストアドプロシージャの場合は.rsb ファイル）を含むディレクトリへのパス。このフォルダの場所は、実行ファイルの場所からの相対パスにすることができます。Location プロパティは、定義をカスタマイズしたり（例えば、カラム名を変更する、カラムを無視するなど）、新しいテーブル、ビュー、またはストアドプロシージャでデータモデルを拡張する場合にのみ必要です。

指定しない場合、デフォルトの場所は"%APPDATA%\\CData\\OracleHCM Data Provider\\Schema" となり、%APPDATA% はユーザーのコンフィギュレーションディレクトリに設定されます：

BrowsableSchemas

このプロパティは、使用可能なスキーマのサブセットにレポートされるスキーマを制限します。例えば、BrowsableSchemas=SchemaA,SchemaB,SchemaC です。

解説

スキーマをデータベースからリストすると、負荷がかかる可能性があります。接続文字列でスキーマのリストを提供すると、パフォーマンスが向上します。

Tables

このプロパティは、使用可能なテーブルのサブセットにレポートされるテーブルを制限します。例えば、Tables=TableA,TableB,TableC です。

解説

テーブルを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でテーブルのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいテーブルを指定します。各テーブルは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

Views

使用可能なテーブルのサブセットにレポートされるビューを制限します。例えば、Views=ViewA,ViewB,ViewC です。

解説

ビューを複数のデータベースからリストすると、負荷がかかる可能性があります。接続文字列でビューのリストを提供すると、Sync App のパフォーマンスが向上します。

このプロパティは、作業したいビューがすでにわかっていて、ビューが多すぎる場合に、ビューを自動的にリストする代わりに使用することもできます。

カンマ区切りのリストで使用したいビューを指定します。各ビューは、角かっこ、二重引用符、またはバッククオートを使用してエスケープされた特殊文字列を含む有効なSQL 識別子である必要があります。例えば、Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space` です。

複数のスキーマまたはカタログを持つデータソースに接続する場合は、複数のカタログやスキーマに存在するテーブル間の曖昧さを避けるため、最後の例のように、このプロパティにテーブルの完全修飾名を指定する必要があることに注意してください。

Miscellaneous

このセクションでは、本プロバイダーの接続文字列で設定可能なMiscellaneous プロパティの全リストを提供します。

プロパティ	説明
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	クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。
Other	これらの隠しプロパティは特定のユースケースでのみ使用されます。
PseudoColumns	このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。
Timeout	タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。
UserDefinedViews	カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

APIVersion

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

解説

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

IncludeCustomChildObjects

Whether or not to include the Custom Child Objects.

解説

Whether or not to include the Custom Child Objects.

IncludeCustomObjects

Property to include the Custom Objects.

解説

Property to include the Custom Objects.

MaxRows

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

解説

クエリで集計またはグループ化を使用しない場合に返される行数を制限します。これにより、設計時にパフォーマンスの問題を回避できます。

Other

これらの隠しプロパティは特定のユースケースでのみ使用されます。

解説

以下にリストされているプロパティは、特定のユースケースで使用可能です。通常のドライバーのユースケースおよび機能では、これらのプロパティは必要ありません。

複数のプロパティをセミコロン区切りリストで指定します。

統合およびフォーマット


DefaultColumnSize	データソースがメタデータにカラムの長さを提供しない場合に、文字列フィールドのデフォルトの長さを設定します。デフォルト値は2000です。
ConvertDateTimeToGMT	日時の値を、マシンのローカルタイムではなくGMT グリニッジ標準時に変換するかどうかを決定します。
RecordToFile=filename	基底のソケットデータ転送を指定のファイルに記録します。

PseudoColumns

このプロパティは、テーブルのカラムとして疑似カラムが含まれているかどうかを示します。

解説

Entity Framework ではテーブルカラムでない疑似カラムに値を設定できないため、この設定はEntity Framework で特に便利です。この接続設定の値は、"Table1=Column1, Table1=Column2, Table2=Column3" の形式です。"*=*" のように"*" 文字を使用して、すべてのテーブルとすべてのカラムを含めることができます。

Timeout

タイムアウトエラーがスローされ、処理をキャンセルするまでの秒数。

解説

Timeout が0に設定されている場合は、操作がタイムアウトしません。処理が正常に完了するか、エラー状態になるまで実行されます。

Timeout の有効期限が切れても処理が完了していない場合は、Sync App は例外をスローします。

UserDefinedViews

カスタムビューを含むJSON コンフィギュレーションファイルを指すファイルパス。

解説

ユーザー定義ビューは、UserDefinedViews.json というJSON 形式のコンフィギュレーションファイルで定義されています。Sync App は、このファイルで指定されたビューを自動的に検出します。

また、複数のビュー定義を持ち、UserDefinedViews 接続プロパティを使用して制御することも可能です。このプロパティを使用すると、指定されたビューのみがSync App によって検知されます。

このユーザー定義ビューのコンフィギュレーションファイルは、次のようにフォーマットされています。

各ルートエレメントはビューの名前を定義します。
各ルートエレメントには、query と呼ばれる子エレメントが含まれており、この子エレメントにはビューのカスタムSQL クエリが含まれています。

次に例を示します。

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

UserDefinedViews 接続プロパティを使用して、JSON コンフィギュレーションファイルの場所を指定します。次に例を示します。

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