A. Staff Import

Description:

This file holds the staff data for the school, both teaching and non-teaching.

 

Field Name

Data Type

Length

Required / Optional

Field Explanation (If Required)

UID

Text

10

Required

Staff User ID - Unique ID that should Match College Admin System Number.

Title

 Text

10

Required

Mr, Mrs, Dr ........

Surname

Text

30

Required

 

Given1

Text

30

Required

 

Given2

Text

30

Optional

 

Display Surname First

 Boolean

1

Optional

0=No, 1=Yes

Preferred

Text

30

Optional

 

Preferred Surname

Text

30

Optional

 

Display Preferred Surname First

 Boolean

 1

Optional

0=No, 1=Yes

Suffix

Text

10

Optional

This is used for end of name details such as John Smith The Third, where "The Third" is the suffix.

Gender

Text

1 (M or F)

Required

M=Male F=Female

BirthDate

Date/Time

-

Required

Should be in the format (dd/mm/YYyy)

Email

Text

100

Required

This value should be the user’s login name for the computer system @ school’s domain.

SchoolStaffCode

Text

10

Optional

This value should correspond to whatever is used for designating staff within the timetabling program.  If a staff member is in the timetable then this field is required to match their identity during timetable import.

Staff Category

Text

10

Required

TCH = Teaching Staff etc

ADM = Office Staff and school Officers etc

ANC = Cleaners/Gardeners etc

INS =Instructional or Sessional Staff who are external to the college.

Teacher Registration Number

Text

 50

Optional

 

Extension Number

Text

 10

Optional

 Used for Internal Phone System

Status

Text

10

Required

NOR =Currently on staff

LEFT = No longer on Staff

LEA = On Leave

* Or other school defined options

 

LoginName

Text

50

Required

This is the computer Login Name of the User.

 

Example