Database - Corsair

The SAP SuccessFactors plugin syncs data locally. Use corsair.sapsuccessfactors.db.<entity>.search({ data, limit?, offset? }) with the filters listed per entity.

New to Corsair? See database operations, data synchronization, and multi-tenancy.

Calibration Session

Path: sapsuccessfactors.db.calibrationSession.search

const rows = await corsair.sapsuccessfactors.db.calibrationSession.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`sessionId`	`string`	equals, contains, startsWith, endsWith, in
`sessionName`	`string`	equals, contains, startsWith, endsWith, in
`sessionOwnerId`	`string`	equals, contains, startsWith, endsWith, in
`sessionType`	`string`	equals, contains, startsWith, endsWith, in
`status`	`string`	equals, contains, startsWith, endsWith, in
`startDate`	`string`	equals, contains, startsWith, endsWith, in
`endDate`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Candidate

Path: sapsuccessfactors.db.candidate.search

const rows = await corsair.sapsuccessfactors.db.candidate.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`firstName`	`string`	equals, contains, startsWith, endsWith, in
`lastName`	`string`	equals, contains, startsWith, endsWith, in
`primaryEmail`	`string`	equals, contains, startsWith, endsWith, in
`contactEmail`	`string`	equals, contains, startsWith, endsWith, in
`cellPhone`	`string`	equals, contains, startsWith, endsWith, in
`city`	`string`	equals, contains, startsWith, endsWith, in
`country`	`string`	equals, contains, startsWith, endsWith, in
`currentTitle`	`string`	equals, contains, startsWith, endsWith, in
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Company

Path: sapsuccessfactors.db.company.search

const rows = await corsair.sapsuccessfactors.db.company.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`externalCode`	`string`	equals, contains, startsWith, endsWith, in
`startDate`	`string`	equals, contains, startsWith, endsWith, in
`name_defaultValue`	`string`	equals, contains, startsWith, endsWith, in
`status`	`string`	equals, contains, startsWith, endsWith, in
`country`	`string`	equals, contains, startsWith, endsWith, in
`currency`	`string`	equals, contains, startsWith, endsWith, in
`entityOID`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Employment

Path: sapsuccessfactors.db.employment.search

const rows = await corsair.sapsuccessfactors.db.employment.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`userId`	`string`	equals, contains, startsWith, endsWith, in
`personIdExternal`	`string`	equals, contains, startsWith, endsWith, in
`startDate`	`string`	equals, contains, startsWith, endsWith, in
`endDate`	`string`	equals, contains, startsWith, endsWith, in
`originalStartDate`	`string`	equals, contains, startsWith, endsWith, in
`seniorityDate`	`string`	equals, contains, startsWith, endsWith, in
`assignmentClass`	`string`	equals, contains, startsWith, endsWith, in
`employmentType`	`string`	equals, contains, startsWith, endsWith, in
`isContingentWorker`	`boolean`	equals
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Goal

Path: sapsuccessfactors.db.goal.search

const rows = await corsair.sapsuccessfactors.db.goal.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`userId`	`string`	equals, contains, startsWith, endsWith, in
`name`	`string`	equals, contains, startsWith, endsWith, in
`flag`	`string`	equals, contains, startsWith, endsWith, in
`state`	`string`	equals, contains, startsWith, endsWith, in
`type`	`string`	equals, contains, startsWith, endsWith, in
`metric`	`string`	equals, contains, startsWith, endsWith, in
`done`	`number`	equals, gt, gte, lt, lte, in
`start`	`string`	equals, contains, startsWith, endsWith, in
`due`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Goal Plan

Path: sapsuccessfactors.db.goalPlan.search

const rows = await corsair.sapsuccessfactors.db.goalPlan.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`name`	`string`	equals, contains, startsWith, endsWith, in
`type`	`string`	equals, contains, startsWith, endsWith, in
`dueDate`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Job Application

Path: sapsuccessfactors.db.jobApplication.search

const rows = await corsair.sapsuccessfactors.db.jobApplication.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`status`	`string`	equals, contains, startsWith, endsWith, in
`appStatusSetId`	`string`	equals, contains, startsWith, endsWith, in
`applicationDate`	`string`	equals, contains, startsWith, endsWith, in
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Job Requisition

Path: sapsuccessfactors.db.jobRequisition.search

const rows = await corsair.sapsuccessfactors.db.jobRequisition.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`internalStatus`	`string`	equals, contains, startsWith, endsWith, in
`jobTitle`	`string`	equals, contains, startsWith, endsWith, in
`jobCode`	`string`	equals, contains, startsWith, endsWith, in
`department`	`string`	equals, contains, startsWith, endsWith, in
`division`	`string`	equals, contains, startsWith, endsWith, in
`location`	`string`	equals, contains, startsWith, endsWith, in
`country`	`string`	equals, contains, startsWith, endsWith, in
`statusSetId`	`string`	equals, contains, startsWith, endsWith, in
`appStatusSetId`	`string`	equals, contains, startsWith, endsWith, in
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Person

Path: sapsuccessfactors.db.person.search

const rows = await corsair.sapsuccessfactors.db.person.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`personIdExternal`	`string`	equals, contains, startsWith, endsWith, in
`personId`	`string`	equals, contains, startsWith, endsWith, in
`dateOfBirth`	`string`	equals, contains, startsWith, endsWith, in
`countryOfBirth`	`string`	equals, contains, startsWith, endsWith, in
`regionOfBirth`	`string`	equals, contains, startsWith, endsWith, in
`placeOfBirth`	`string`	equals, contains, startsWith, endsWith, in
`perPersonUuid`	`string`	equals, contains, startsWith, endsWith, in
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Personal

Path: sapsuccessfactors.db.personal.search

const rows = await corsair.sapsuccessfactors.db.personal.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`personIdExternal`	`string`	equals, contains, startsWith, endsWith, in
`startDate`	`string`	equals, contains, startsWith, endsWith, in
`endDate`	`string`	equals, contains, startsWith, endsWith, in
`firstName`	`string`	equals, contains, startsWith, endsWith, in
`lastName`	`string`	equals, contains, startsWith, endsWith, in
`middleName`	`string`	equals, contains, startsWith, endsWith, in
`formalName`	`string`	equals, contains, startsWith, endsWith, in
`birthName`	`string`	equals, contains, startsWith, endsWith, in
`gender`	`string`	equals, contains, startsWith, endsWith, in
`maritalStatus`	`string`	equals, contains, startsWith, endsWith, in
`nationality`	`string`	equals, contains, startsWith, endsWith, in
`preferredName`	`string`	equals, contains, startsWith, endsWith, in
`salutation`	`string`	equals, contains, startsWith, endsWith, in
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

Position

Path: sapsuccessfactors.db.position.search

const rows = await corsair.sapsuccessfactors.db.position.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`code`	`string`	equals, contains, startsWith, endsWith, in
`effectiveStartDate`	`string`	equals, contains, startsWith, endsWith, in
`effectiveEndDate`	`string`	equals, contains, startsWith, endsWith, in
`effectiveStatus`	`string`	equals, contains, startsWith, endsWith, in
`externalName_defaultValue`	`string`	equals, contains, startsWith, endsWith, in
`jobCode`	`string`	equals, contains, startsWith, endsWith, in
`department`	`string`	equals, contains, startsWith, endsWith, in
`division`	`string`	equals, contains, startsWith, endsWith, in
`company`	`string`	equals, contains, startsWith, endsWith, in
`location`	`string`	equals, contains, startsWith, endsWith, in
`payGrade`	`string`	equals, contains, startsWith, endsWith, in
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.

User

Path: sapsuccessfactors.db.user.search

const rows = await corsair.sapsuccessfactors.db.user.search({
    data: { /* filters below */ },
    limit: 100,
    offset: 0,
});

Searchable filters

Field	Type	Operators
`entity_id`	`string`	equals, contains, startsWith, endsWith, in
`userId`	`string`	equals, contains, startsWith, endsWith, in
`username`	`string`	equals, contains, startsWith, endsWith, in
`defaultFullName`	`string`	equals, contains, startsWith, endsWith, in
`firstName`	`string`	equals, contains, startsWith, endsWith, in
`mi`	`string`	equals, contains, startsWith, endsWith, in
`lastName`	`string`	equals, contains, startsWith, endsWith, in
`email`	`string`	equals, contains, startsWith, endsWith, in
`status`	`string`	equals, contains, startsWith, endsWith, in
`department`	`string`	equals, contains, startsWith, endsWith, in
`division`	`string`	equals, contains, startsWith, endsWith, in
`location`	`string`	equals, contains, startsWith, endsWith, in
`title`	`string`	equals, contains, startsWith, endsWith, in
`managerId`	`string`	equals, contains, startsWith, endsWith, in
`hrId`	`string`	equals, contains, startsWith, endsWith, in
`hireDate`	`string`	equals, contains, startsWith, endsWith, in
`lastModifiedDateTime`	`string`	equals, contains, startsWith, endsWith, in
`lastModified`	`string`	equals, contains, startsWith, endsWith, in
`timeZone`	`string`	equals, contains, startsWith, endsWith, in
`country`	`string`	equals, contains, startsWith, endsWith, in
`state`	`string`	equals, contains, startsWith, endsWith, in
`city`	`string`	equals, contains, startsWith, endsWith, in
`zipCode`	`string`	equals, contains, startsWith, endsWith, in
`addressLine1`	`string`	equals, contains, startsWith, endsWith, in
`businessPhone`	`string`	equals, contains, startsWith, endsWith, in
`cellPhone`	`string`	equals, contains, startsWith, endsWith, in
`empId`	`string`	equals, contains, startsWith, endsWith, in
`totalTeamSize`	`number`	equals, gt, gte, lt, lte, in

Every .search() also accepts limit and offset for pagination. .list() is available on the same path without the .search suffix in code — see database operations.