RecruitingCESitesfilters

Columns


Name	Type	Description
RecruitingCESitesSiteId [KEY]	Long	Finds Recruiting CE Site by a unique Site ID and the primary key
RecruitingCESitesThemeId [KEY]	Long	Finds Recruiting CE Site by a unique Theme ID and the primary key
ObjectCtxId	Long	ID assigned to the filters pertaining to the candidate experience.
DimensionTypeCode	String	Code assigned to the type of dimensions in the filters.
GeographyNodeId	Long	ID assigned to the geographical node selected in the filters.
GeographyId	Long	ID assigned to the geography selected in filters.
JobFamilyId	Long	ID assigned to the job family in the filters.
JobFunctionCode	String	Job function code assigned to the filters.
OrganizationId	Long	Organization ID assigned to the filters.
RecruitingTypeCode	String	Recruiting type code assigned to the filters.
DimensionKey [KEY]	String	Key assigned to the dimension in filters.
SegmentCode	String	Segment code of the site context filters.
ColumnName	String	Column name of the site context filters.
ContextCode	String	Context code of the site context filters.
DFFId	String	Flexfield ID of the site context filters.
SegmentName	String	Segment name of the site context filters.
SegmentAttributeName	String	Segment attribute name of the site context filters.

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