JobPositions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
JobPositionCode varchar 15 ('')
Description varchar 80 ('')
CategoryCode varchar 15 ('')
Overview varchar 2147483647 √ null
ActiveFlag bit 1 ((1))
FTERequired decimal 8,4 ((0))
AutoLevelIncrementFlag bit 1 ((0))
JobPositionsSeq int identity 4 √ null
JobPositionNotifications.JobPositionsSeq FK_JobPositionNotifications_JobPositions R
JobPositions.ReportsToJobPositionsSeq FK_JobPositions_ReportsToJobPositionsSeq R
JobPositionsConfigGroup.JobPositionsSeq FK_JobPositionsConfigGroup_JobPositions R
StaffJobPositions.JobPositionsSeq FK_StaffJobPositions_JobPositions R
StaffJobPositions.OverrideReportsToJobPositionsSeq FK_StaffJobPositions_OverrideReportsToJobPositionsSeq R
AwardCode varchar 15 ('')
ReportsToJobPositionsSeq int 4 √ null
JobPositions.JobPositionsSeq FK_JobPositions_ReportsToJobPositionsSeq R

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_JobPositions Primary key Asc JobPositionsSeq
AK_JobPositionss_ReportsToJobPositionsSeq Performance Asc ReportsToJobPositionsSeq

Relationships

Close relationships within degrees of separation