JobDistributionDetails

Columns


Name	Type	Description
PostingStartDate	Datetime	Start date of the job posting.
PostingEndDate	Datetime	End date of the job posting.
PostingStatus	String	Status of the job posting.
JobType	String	Type of job.
StudyLevel	String	Educational qualification of the candidate.
ExternalContactName	String	External contact name of the candidate.
ExternalContactEmail	String	External contact email of the candidate.
PartnerId	String	ID assigned to the partner.
JobSchedule [KEY]	String	Schedule of the job.
ContractType [KEY]	String	Type of contract signed with the candidate.
JobShift [KEY]	String	Shift of the job.
RequisitionNumber	String	Requisition number of the job posting.
OrganizationDisplayName	String	Display name of the organization.
JobFamilyCode	String	Code assigned to the job family.
InternationalTravelRequired	String	Indicates if international travel is required for the candidate.
DomesticTravelRequired	String	Indicates if domestic travel is required for the candidate.
PrimaryLocationCountryCode	String	Country code of the primary location of the job posting.
PrimaryLocationLevelTwoCode	String	Second level code of the primary location of the job posting.
PrimaryWorkLocationPostalCode	String	Postal code of the primary work location of the job posting.
WorkplaceTypeCode	String	Type of workplace of the job requisition.

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