Jobs
- 03 Jun 2024
- 1 minute read
- Print
- DarkLight
- PDF
Jobs
- Updated 03 Jun 2024
- 1 minute read
- Print
- DarkLight
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
The Profile tab lists all current and previous jobs, along with the dates of employment. The most recent job will always be listed first.
.png?sv=2022-11-02&spr=https&st=2024-07-27T08%3A09%3A41Z&se=2024-07-27T08%3A19%3A41Z&sr=c&sp=r&sig=nlYEiIa4PgZAllvLWS7DeRW5CRcPLT786qmMLMnHKYE%3D "image(339).png")
Jobs and courses data are also saved as grouped fields.
Review the standard Slate fields available for storing person data under each section of the profile tab in order to avoid field duplication when adding custom fields and prompts.
.png?sv=2022-11-02&spr=https&st=2024-07-27T08%3A09%3A41Z&se=2024-07-27T08%3A19%3A41Z&sr=c&sp=r&sig=nlYEiIa4PgZAllvLWS7DeRW5CRcPLT786qmMLMnHKYE%3D "image(338).png")
Job
Jobs have one rank column:
rank
Rank
The ranking order is as follows:
Order of Importance (ascending) - only if all Jobs have a defined Order of Importance.
Employment Date: To (most recent to least recent). If no To Date is specified, the current date is used.
ID (ascending)
Ranking Exclusions
None - all jobs are ranked.
The SQL code used to perform the ranking is below:
select row_number() over (partition by [record] order by [order], coalesce([to], getdate()) desc, [id]) as [rank]
from [job]Was this article helpful?
