StaffJobPositionsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StaffJobPositionsHistorySeq int identity 4 √ null
TransactionGUID uniqueidentifier 16 √ null
TransactionMode char 1 √ null
StaffJobPositionsSeq int 4 null
ID int 4 null
JobLevel tinyint 1 null
JobLevelNextIncrementDate datetime 16,3 √ null
StartDate datetime 16,3 √ null
EndDate datetime 16,3 √ null
AppointmentLetter varchar 2147483647 √ null
FTE decimal 8,4 null
JobLevelNextIncrementYears smallint 2 null
JobPositionsSeq int 4 √ null
AwardLevelCode varchar 15 null
NextReviewDate datetime 16,3 √ null
OverrideReportsToJobPositionsSeq int 4 √ null
StaffJobPositionsGUID varchar 32 null
SIF3RefID uniqueidentifier 16 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
AK_StaffJobPositionsHistory_ID Performance Asc ID
AK_StaffJobPositionsHistory_TransactionGUID Performance Asc TransactionGUID
PK_StaffJobPositionsHistory_StaffJobPositionsHistorySeq Performance Asc StaffJobPositionsHistorySeq