pvStaffJobPositionNotifications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
StaffJobPositionsSeq int 4 null
StaffID int 4 null
JobPositionsSeq int 4 √ null
JobPositionCode varchar 15 null
JobPositionDescription varchar 80 null
AwardCode varchar 15 null
AwardLevelCode varchar 15 null
StaffMailNameprimary varchar 100 null
StaffNameInternal varchar 100 null
StaffSurname varchar 30 null
StaffPreferred varchar 20 null
StaffName varchar 123 null
SchoolStaffCode varchar 30 null
CurrentJobPositionFlag bit 1 √ 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
NextReviewDate datetime 16,3 √ null
NotificationCampus varchar 3 √ null
NotificationType varchar 15 √ null
NotificationDestination varchar 15 √ null
NotificationDestinationDescription varchar 50 √ null
NotificationDestinationSynergyMeaning varchar 30 √ null
NotificationCodeAlpha varchar 25 √ null
NotificationID int 4 √ null
NotificationSynergyMeaning varchar 30 √ null
NotificationAction varchar 20 √ null
NotificationDescription varchar 50 √ null
NotificationEmailSubject varchar 200 √ null
NotificationEmailBody varchar 2147483647 √ null
NotificationAutoNotifyDaysBefore int 4 √ null
NotifyNameInternal varchar 100 √ null
NotifyMailName varchar 100 √ null
NotifySurname varchar 30 √ null
NotifyPreferred varchar 20 √ null
NotifyOccupEmail varchar 100 √ null

Table contained 0 rows

View Definition

Possibly Referenced Tables/Views