The Profile tab lists all current and previous jobs by default. Custom views let you customize this list to display more information.

Like interests, schools, and other objects on the Profile tab, jobs are saved as grouped fields.

Review the standard fields to avoid field duplication when adding custom job fields and prompts.

Job ranks

Slate ranks many types of records, including jobs. Jobs have one rank column: rank. There are no ranking exclusions—all jobs are ranked.

The ranking order for job records is:

1. Order of Importance (ascending): Only if all jobs have a value in the Order of Importance field

2. Dates of Employment - To (Most to least recent): If no To date is specified, defaults to the current date.

3. ID (ascending): If neither of the above are present, or are all equal, Slate sorts jobs by their unique IDs.

The SQL used to perform the ranking is:

select row_number()
over (partition by [record] order by [order], coalesce([to], getdate()) desc, [id])
as [rank]
from [job]