StaffJobPositions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StaffJobPositionsSeq int identity 4 √ null
ID int 4 ((0))
Staff.ID FK_StaffJobPositions_Staff R
JobLevel tinyint 1 ((0))
JobLevelNextIncrementDate datetime 16,3 √ null
StartDate datetime 16,3 √ null
EndDate datetime 16,3 √ null
AppointmentLetter varchar 2147483647 √ null
FTE decimal 8,4 ((1))
JobLevelNextIncrementYears smallint 2 ((0))
JobPositionsSeq int 4 √ null
JobPositions.JobPositionsSeq FK_StaffJobPositions_JobPositions R
AwardLevelCode varchar 15 ('')
NextReviewDate datetime 16,3 √ null
OverrideReportsToJobPositionsSeq int 4 √ null
JobPositions.JobPositionsSeq FK_StaffJobPositions_OverrideReportsToJobPositionsSeq R
StaffJobPositionsGUID varchar 32 (replace(newid(),'-',''))
SIF3RefID uniqueidentifier 16 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_StaffJobPositions Primary key Asc StaffJobPositionsSeq
AK_StaffJobPositions_ID Performance Asc ID
AK_StaffJobPositions_JobPositionsSeq Performance Asc JobPositionsSeq
AK_StaffJobPositions_OverrideReportsToJobPositionsSeq Performance Asc OverrideReportsToJobPositionsSeq

Relationships

Close relationships within degrees of separation