Table Definitions - Employee Information

02=Cert/Degree Code

CERTIFICATION

CERTIFICATE_CODE

Size: 10

02=Cert/Degree Code

CERTIFICATION

CERTIFICATE_CODE_DESC

Detailed Explanation of code. Size: 30

03=Institution

CERTIFICATION

INSTITUTION

Size: 10

03=Institution

CERTIFICATION

INSTITUTION_DESC

Detailed Explanation of code. Size: 30

04=Certificate Number

CERTIFICATION

CERTIFICATE_NUMBER

Size: 30

05=Issue Date

CERTIFICATION

ISSUE_DATE

Size: 11 Format: DD-MMM-YYYY

06=Expiry Date

CERTIFICATION

EXPIRY_DATE

Size: 11 Format: DD-MMM-YYYY

07=Verified By

CERTIFICATION

VERIFIED_BY

Size: 10

07=Verified By

CERTIFICATION

VERIFIED_BY_EMP_NAME

Size: 30

08=Verification Date

CERTIFICATION

VERIFIED_DATE

Size: 11 Format: DD-MMM-YYYY

09=Comment

CERTIFICATION

COMMENT

Size: 60

10=Limitations

CERTIFICATION

LIMITATIONS

Size: 60

Certificate Class

CERTIFICATION

CERTIFICATE_CLASS

Size: 10

Certificate Class Description

CERTIFICATION

CERTIFICATE_CLASS_DESC

Size: 30

Certificate Type

CERTIFICATION

CERTIFICATE_TYPE

Size: 10

Certificatte Type Description

CERTIFICATION

CERTIFICATE_TYPE_DESC

Size: 30

Majors 11

CERTIFICATION

MAJOR_01

Size: 10

Majors 11

CERTIFICATION

MAJOR_01_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 11 to 20

CERTIFICATION

MAJOR_CODES_(ALL_TEN)

Size: 50

Majors 11 to 20

CERTIFICATION

MAJOR_DESCS_(ALL_TEN)

Detailed Explanation of code. Size: 50

Majors 12

CERTIFICATION

MAJOR_02

Size: 10

Majors 12

CERTIFICATION

MAJOR_02_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 13

CERTIFICATION

MAJOR_03

Size: 10

Majors 13

CERTIFICATION

MAJOR_03_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 14

CERTIFICATION

MAJOR_04

Size: 10

Majors 14

CERTIFICATION

MAJOR_04_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 15

CERTIFICATION

MAJOR_05

Size: 10

Majors 15

CERTIFICATION

MAJOR_05_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 16

CERTIFICATION

MAJOR_06

Size: 10

Majors 16

CERTIFICATION

MAJOR_06_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 17

CERTIFICATION

MAJOR_07

Size: 10

Majors 17

CERTIFICATION

MAJOR_07_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 18

CERTIFICATION

MAJOR_08

Size: 10

Majors 18

CERTIFICATION

MAJOR_08_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 19

CERTIFICATION

MAJOR_09

Size: 10

Majors 19

CERTIFICATION

MAJOR_09_DESCRIPTION

Detailed Explanation of code. Size: 30

Majors 20

CERTIFICATION

MAJOR_10

Size: 10

Majors 20

CERTIFICATION

MAJOR_10_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 21

CERTIFICATION

MINOR_01

Size: 10

Minors 21

CERTIFICATION

MINOR_01_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 21 to 30

CERTIFICATION

MINOR_CODES_(ALL_TEN)

Size: 50

Minors 21 to 30

CERTIFICATION

MINOR_CODES_(ALL_TEN)

Detailed Explanation of code. Size: 50

Minors 22

CERTIFICATION

MINOR_02

Size: 10

Minors 22

CERTIFICATION

MINOR_02_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 23

CERTIFICATION

MINOR_03

Size: 10

Minors 23

CERTIFICATION

MINOR_03_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 24

CERTIFICATION

MINOR_04

Size: 10

Minors 24

CERTIFICATION

MINOR_04_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 25

CERTIFICATION

MINOR_05

Size: 10

Minors 25

CERTIFICATION

MINOR_05_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 26

CERTIFICATION

MINOR_06

Size: 10

Minors 26

CERTIFICATION

MINOR_06_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 27

CERTIFICATION

MINOR_07

Size: 10

Minors 27

CERTIFICATION

MINOR_07_DESCRIPTION

Detailed Explanation of code. Size: 80

Minors 28

CERTIFICATION

MINOR_08

Size: 10

Minors 28

CERTIFICATION

MINOR_08_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 29

CERTIFICATION

MINOR_09

Size: 10

Minors 29

CERTIFICATION

MINOR_09_DESCRIPTION

Detailed Explanation of code. Size: 30

Minors 30

CERTIFICATION

MINOR_10

Size: 10

Minors 30

CERTIFICATION

MINOR_10_DESCRIPTION

Detailed Explanation of code. Size: 30

02=Seminar Type

SEMINAR_ATTENDANCE

SEMINAR_TYPE_CODE

Size: 10

02=Seminar Type

SEMINAR_ATTENDANCE

SEMINAR_TYPE_DESC

Detailed Explanation of code. Size: 30

03=Start Date

SEMINAR_ATTENDANCE

START_DATE

Size: 11 Format: DD-MMM-YYYY

04=End Date

SEMINAR_ATTENDANCE

END_DATE

Size: 11 Format: DD-MMM-YYYY

05=Approval Date

SEMINAR_ATTENDANCE

APPROVED_DATE

Size: 11 Format: DD-MMM-YYYY

06=Working Days Missed

SEMINAR_ATTENDANCE

DAYS_MISSED

Size: 10 Format: ########.##

07=Seminar Name

SEMINAR_ATTENDANCE

SEMINAR_NAME

Detailed Explanation of code. Size: 30

08=Location

SEMINAR_ATTENDANCE

LOCATION_CODE

Size: 4

08=Location

SEMINAR_ATTENDANCE

LOCATION_NAME

Detailed Explanation of code. Size: 30

09=Credited Date

SEMINAR_ATTENDANCE

CREDITED_DATE

Size: 11 Format: DD-MMM-YYYY

10=Reimbursed Date

SEMINAR_ATTENDANCE

REIMBURSED_DATE

Size: 11 Format: DD-MMM-YYYY

11=Subject

SEMINAR_ATTENDANCE

SUBJECT_CODE

Size: 10

11=Subject

SEMINAR_ATTENDANCE

SUBJECT_DESCRIPTION

Detailed Explanation of code. Size: 30

12=Source

SEMINAR_ATTENDANCE

SOURCE

Size: 10

13=Pupose / Comments

SEMINAR_ATTENDANCE

COMMENT

Size: 50

14=Seminar Cost

SEMINAR_ATTENDANCE

SEMINAR_COST

Size: 10 Format: ########.##

15=Seminar Cost Paid By

SEMINAR_ATTENDANCE

SEMINAR_PAID_BY_CODE

Size: 10

15=Seminar Cost Paid By

SEMINAR_ATTENDANCE

SEMINAR_PAID_BY_DESC

Detailed Explanation of code. Size: 30

16=Housing Cost

SEMINAR_ATTENDANCE

HOUSING COST

Size: 10 Format: ########.##

17=Housing Cost Paid By

SEMINAR_ATTENDANCE

HOUSING_PAID_BY_CODE

Size: 10

17=Housing Cost Paid By

SEMINAR_ATTENDANCE

HOUSING_PAID_BY_DESC

Detailed Explanation of code. Size: 30

18=Travel Cost

SEMINAR_ATTENDANCE

TRAVEL_COST

Size: 10 Format: ########.##

19=Travel Cost Paid By

SEMINAR_ATTENDANCE

TRAVEL_PAID_BY_CODE

Size: 10

19=Travel Cost Paid By

SEMINAR_ATTENDANCE

TRAVEL_PAID_BY_DESC

Detailed Explanation of code. Size: 30

20=Other Expenses

SEMINAR_ATTENDANCE

OTHER_COST

Size: 10 Format: ########.##

21=Other Expenses Paid By

SEMINAR_ATTENDANCE

OTHER_PAID_BY_CODE

Size: 10

21=Other Expenses Paid By

SEMINAR_ATTENDANCE

OTHER_PAID_BY_DESC

Detailed Explanation of code. Size: 30

02=Skill Code

SPECIAL_SKILLS

SKILL_CODE

Size: 10

02=Skill Code

SPECIAL_SKILLS

SKILL_DESCRIPTION

Detailed Explanation of code. Size: 30

03=Proficiency

SPECIAL_SKILLS

PROFICIENCY_DESCRIPTION

Detailed Explanation of code. Size: 30

03=Proficiency

SPECIAL_SKILLS

PROFICIENCY_LEVEL

Size: 10

04=Certificate Code

SPECIAL_SKILLS

CERTIFICATION_CODE

Size: 10

04=Certificate Code

SPECIAL_SKILLS

CERTIFICATION_CODE_DESC

Detailed Explanation of code. Size: 30

05=Certificate No

SPECIAL_SKILLS

CERTIFICATION_NO

Size: 10

06=Certificate Expiry

SPECIAL_SKILLS

EXPIRY_DATE

Size: 11 Format: DD-MMM-YYYY

07=Experience Unit Type

SPECIAL_SKILLS

EXP_UNIT_TYPE

Size: 10

08=Experience Units

SPECIAL_SKILLS

EXPERIENCE_UNITS

Size: 10 Format: ######.####

09=Last Used

SPECIAL_SKILLS

LAST_USED_DATE

Size: 11 Format: DD-MMM-YYYY

10=Skill Expiry

SPECIAL_SKILLS

SKILL_EXPIRY_DATE

Size: 11 Format: DD-MMM-YYYY

11=Comment

SPECIAL_SKILLS

COMMENT

Size: 40

02=Position

CONTRACTS

POSITION

Size: 10

02=Position

CONTRACTS

POSITION_DESCRIPTION

Detailed Explanation of code. Size: 30

03=Start Date

CONTRACTS

START_DATE

Size: 11 Format: DD-MMM-YYYY

04=End Date

CONTRACTS

END_DATE

Size: 11 Format: DD-MMM-YYYY

05=Contract Desc

CONTRACTS

CONTRACT_DESCRIPTION

Size: 50

06=FTE

CONTRACTS

FTE

Size: 10 Format: ########.##

07=Comment 1

CONTRACTS

COMMENT_01

Size: 50

08=Comment 2

CONTRACTS

COMMENT_02

Size: 50

02=C.R.C. Date

CRIMINAL_RECORD_CHECK

STATUS_DATE

Size: 11 Format: DD-MMM-YYYY

03=C.R.C. Status

CRIMINAL_RECORD_CHECK

STATUS_CODE

Size: 10

04=Comment

CRIMINAL_RECORD_CHECK

COMMENT

Size: 70

02=Reason Code

CRITICAL_DATES

REASON_CODE

Size: 10

02=Reason Code

CRITICAL_DATES

REASON_DESC

Detailed Explanation of code. Size: 30

03=Date

CRITICAL_DATES

EVENT_DATE

Size: 11 Format: DD-MMM-YYYY

04=Interval Code

CRITICAL_DATES

INTERVAL_CODE

Size: 10

04=Interval Code

CRITICAL_DATES

INTERVAL_DESC

Detailed Explanation of code. Size: 30

05=Next Date

CRITICAL_DATES

NEXT_DATE

For items that re-occur Size: 11 Format: DD-MMM-YYYY

06=Comments

CRITICAL_DATES

COMMENT

Size: 50

02=Dated Comment Code

DATED_COMMENT

COMMENT_CODE

Size: 10

02=Dated Comment Code

DATED_COMMENT

COMMENT_CODE_DESC

Detailed Explanation of code. Size: 30

03=Dated Comment

DATED_COMMENT

COMMENT

Size: 100

Automatic Time Stamp

DATED_COMMENT

TIMESTAMP

Size: 20 Format: DD-MMM-YYYY H

02=Dependent #

DEPENDENTS

DEPENDENT_NO

Size: 4

03=Social Insurance Number

DEPENDENTS

SIN

Size: 10

04=Name

DEPENDENTS

FIRST_NAME

Size: 15

04=Name

DEPENDENTS

LAST_NAME

Size: 30

04=Name

DEPENDENTS

MIDDLE_NAME

Size: 10

06=Address 1

DEPENDENTS

ADDRESS_01

Size: 30

06=Address 2

DEPENDENTS

ADDRESS_02

Size: 30

08=City

DEPENDENTS

CITY

Size: 20

09=Province

DEPENDENTS

PROVINCE

Size: 10

10=Postal Code

DEPENDENTS

POSTAL_CODE

Size: 10

11=Country

DEPENDENTS

COUNTRY

Size: 10

12=Telephone

DEPENDENTS

PHONE

Size: 13 Format: (###)###-####

13=Birth Date

DEPENDENTS

AGE_ASOF_DATE

Size: 11 Format: DD-MMM-YYYY

13=Birth Date

DEPENDENTS

BIRTH_DATE

Birthdate of employee dependent Size: 11 Format: DD-MMM-YYYY

14=Age

DEPENDENTS

AGE

Size: 10 Format: ###########

15=Gender

DEPENDENTS

GENDER

Size: 10

16=Smoker

DEPENDENTS

SMOKER_YN

Size: 6

17=Disability

DEPENDENTS

DISABILITY_CODE

Size: 10

17=Disability

DEPENDENTS

DISABILITY_DESC

Detailed Explanation of code. Size: 30

01=Employee

EMERGENCY_CONTACT

*EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

02=Doctor's Name --> 01=Last Name

EMERGENCY_CONTACT

DOCTOR_LAST_NAME

Size: 30

02=Doctor's Name --> 02=First Name

EMERGENCY_CONTACT

DOCTOR_FIRST_NAME

Size: 15

02=Doctor's Name --> 03=Middle Name

EMERGENCY_CONTACT

DOCTOR_MIDDLE_NAME

Size: 10

03=Doctor's Phone #1

EMERGENCY_CONTACT

DOCTOR_PHONE_1

Size: 13 Format: (###)###-####

04=Doctor's Phone #2

EMERGENCY_CONTACT

DOCTOR_PHONE_2

Size: 13 Format: (###)###-####

01=Dependent #

EMERGENCY_CONTACT

NOK_DEPENDENT_NO

Size: 10

02=Salutation

EMERGENCY_CONTACT

NOK_SALUTATION

Detailed Explanation of code. Size: 10

03=Name --> 01=Last Name

EMERGENCY_CONTACT

NOK_LAST_NAME

Size: 30

03=Name --> 02=First Name

EMERGENCY_CONTACT

NOK_FIRST_NAME

Size: 15

03=Name --> 03=Middle Initial

EMERGENCY_CONTACT

NOK_MIDDLE_NAME

Size: 10

04=Home Phone

EMERGENCY_CONTACT

NOK_PHONE_01

Size: 13 Format: (###)###-####

05=Work Phone

EMERGENCY_CONTACT

NOK_PHONE_02

Size: 13 Format: (###)###-####

06=Primary Language

EMERGENCY_CONTACT

NOK_PRIM_LANGUAGE_CODE

Size: 10

06=Primary Language

EMERGENCY_CONTACT

NOK_PRIM_LANGUAGE_DESC

Detailed Explanation of code. Size: 30

07=Secondary Language

EMERGENCY_CONTACT

NOK_SEC_LANGUAGE_CODE

Size: 10

07=Secondary Language

EMERGENCY_CONTACT

NOK_SEC_LANGUAGE_DESC

Detailed Explanation of code. Size: 30

08=Religion

EMERGENCY_CONTACT

NOK_RELIGION

Size: 10

09=Addr1

EMERGENCY_CONTACT

NOK_ADDRESS_01

Size: 30

10=Addr2

EMERGENCY_CONTACT

NOK_ADDRESS_02

Size: 30

11=City

EMERGENCY_CONTACT

NOK_CITY

Size: 30

12=Province

EMERGENCY_CONTACT

NOK_PROVINCE

Size: 10

13=Postal Code

EMERGENCY_CONTACT

NOK_POSTAL_CODE

Size: 10

14=Country

EMERGENCY_CONTACT

NOK_COUNTRY

Size: 10

15=Employer

EMERGENCY_CONTACT

NOK_EMPLOYER

Size: 20

16=Supervisor Name

EMERGENCY_CONTACT

NOK_SUPERVISOR

Size: 20

Contact Comment

EMERGENCY_CONTACT

NOK_COMMENT

Size: 30

Contact Gender

EMERGENCY_CONTACT

NOK_GENDER

Size: 6

Admin E-Mail

EMPLOYEE_DEMOGRAPHICS

ADMIN_EMAIL_ADDRESS

This field is to be used as a secondary e-mail address that can receive staffing notifications generated by SNS. Size: 30

Assignment As Of Date

EMPLOYEE_DEMOGRAPHICS

HAS_ASSIGNMENT_ASOF_DATE

Based on the information in the employee's assignment screen during the specified time range Size: 11 Format: DD-MMM-YYYY

Assignment Date Range

EMPLOYEE_DEMOGRAPHICS

HAS_ASSIGNMENT_ASOF_DATE_RANGE

Based on the information in the employee's assignment screen during the specified time range Size: 11 Format: DD-MMM-YYYY

Contract access date

EMPLOYEE_DEMOGRAPHICS

CONTRACT_ACC_DATE

Fields typically track hire dates/continuing hire dates/Sub/Cas hire dates Size: 11 Format: DD-MMM-YYYY

Does fulltime include leaves?

EMPLOYEE_DEMOGRAPHICS

FULL_TIME_INCLUDE_LEAVES_YN

Internal Lookup: Y=Yes, N=No. Based on the assignment type is it considered a leave type of assignment Size: 10

Full Time?

EMPLOYEE_DEMOGRAPHICS

FULL_TIME_YN

Internal Lookup: Y=Yes, N=No. Based on the assigned position within the assignment and the Full-Time Equivalent specified in the position code database. Size: 10

Fulltime as of date

EMPLOYEE_DEMOGRAPHICS

FULL_TIME_AS_OF_DATE

Based on the assigned position within the assignment and the Full-Time Equivalent specified in the position code database as of a certain date Size: 10 Format: DD-MMM-YYYY

Fulltime as of date range

EMPLOYEE_DEMOGRAPHICS

FULL_TIME_AS_OF_DATE_RANGE

Based on the assigned position within the assignment and the Full-Time Equivalent specified in the position code database during the specified time range Size: 11 Format: DD-MMM-YYYY

Has Assignment?

EMPLOYEE_DEMOGRAPHICS

HAS_ASSIGNMENT_YN

Internal Lookup: Y=Yes, N=No. Based on the information in the employee's assignment screen Size: 10

Recorded in ADS?

EMPLOYEE_DEMOGRAPHICS

RECORDED_IN_ADS

Internal Lookup: Y=YES, N=NO. Tracks names that have been recorded for use in the Automated Dispatch System Size: 5

Seniority Date

EMPLOYEE_DEMOGRAPHICS

SENIORITY_DATE

Fields typically track hire dates/continuing hire dates/Sub/Cas hire dates Size: 11 Format: DD-MMM-YYYY

Sub/Casual Hire Date

EMPLOYEE_DEMOGRAPHICS

SUB_CAS_HIRE_DATE

Fields typically track hire dates/continuing hire dates/Sub/Cas hire dates Size: 11 Format: DD-MMM-YYYY

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_1

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_2

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_3

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_4

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_5

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_6

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_7

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_8

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

Specified assignment data

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_9

Assign_Info_# can be used as the display, sort or selection field. The corresponding Assign_Info_Fields_# are put in the selection fields column to designate which field should apply to the Assign_Info_# field Size: 100

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_1

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_2

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_3

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_4

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_5

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_6

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_7

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_8

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

What assignment field(s) to display

EMPLOYEE_DEMOGRAPHICS

ASSIGN_INFO_FIELDS_9

Internal Lookup: PC=Pos, PD=Pos Desc, PDC=Pos Desc & Code, SD=Start Date, ED=End Date, TC=Type Code, TD=Type Desc, TDC=Type Desc & Code, UN=Units, UPD=UPD, RE=Reason , BE=Benefits, PR=Pro D, ST=School Term, PI=Pay ID, COM=Comment, LC=Loc, LN=Loc Nam Size: 10

01=Employee No

NAME_AND_SIN

EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10 Format: TRIM

02=S.I.N.

NAME_AND_SIN

SIN_SSN_NO

Size: 10 Format: TRIM

03=Name

MIXED_CASE_NAME

LAST_NAME, FIRST NAME

Proper Case Size: 20

03=Name

NAME_AND_SIN

LAST_NAME, FIRST_NAME

Do not use the employee name field to select on. If you want to select by employee, then use the EMPLOYEE NO field. Otherwise your report will run extremely slow. Size: 20

03=Name --> 01=Last Name

MIXED_CASE_NAME

LAST_NAME

Proper Case Size: 25

03=Name --> 01=Last Name

NAME_AND_SIN

LAST_NAME

Do not use the employee name field to select on. If you want to select by employee, then use the EMPLOYEE NO field. Otherwise your report will run extremely slow. Size: 25

03=Name --> 02=First Name

MIXED_CASE_NAME

FIRST_NAME

Proper Case Size: 15

03=Name --> 02=First Name

NAME_AND_SIN

FIRST_NAME

Do not use the employee name field to select on. If you want to select by employee, then use the EMPLOYEE NO field. Otherwise your report will run extremely slow. Size: 15

03=Name --> 03=Middle Initial

MIXED_CASE_NAME

MIDDLE_NAME

Proper Case Size: 10

03=Name --> 03=Middle Initial

NAME_AND_SIN

MIDDLE_NAME

Do not use the employee name field to select on. If you want to select by employee, then use the EMPLOYEE NO field. Otherwise your report will run extremely slow. Size: 10

03=Name, 01=Employee No

MIXED_CASE_NAME

EMP_NAME_AND_NUMBER

Proper Case Size: 30

03=Name,01=Employee No

NAME_AND_SIN

EMP_NAME_AND_NUMBER

Do not use the employee name field to select on. If you want to select by employee, then use the EMPLOYEE NO field. Otherwise your report will run extremely slow. Size: 30

04=Position

EMPLOYEE_DEMOGRAPHICS

LIST_OF_SUPERVISORS

Size: 30

04=Pref Name

NAME_AND_SIN

PREFERRED_NAME

Do not use the employee name field to select on. If you want to select by employee, then use the EMPLOYEE NO field. Otherwise your report will run extremely slow. Size: 30

05=Salutation

NAME_AND_SIN

SALUTATION

Detailed Explanation of code. Size: 3

06 = Status

EMPLOYEE_DEMOGRAPHICS

STATUS_DESCRIPTION

Detailed Explanation of code. Size: 30

06=Status

EMPLOYEE_DEMOGRAPHICS

STATUS_CODE

Size: 4

07=Category

EMPLOYEE_DEMOGRAPHICS

CATEGORY_CODE

Code only Size: 4

07=Category

EMPLOYEE_DEMOGRAPHICS

CATEGORY_DESCRIPTION

Description from Database Size: 20

08=Address 1

ADDRESS_AND_PHONE

ADDRESS_1

Size: 30

09=Address 2

ADDRESS_AND_PHONE

ADDRESS_2

Size: 30

10=CITY, 11=PROVINCE, 12=POSTAL CODE

ADDRESS_AND_PHONE

CITY_PROV_POST

Size: 30

10=City

ADDRESS_AND_PHONE

CITY

Size: 20

11=Province

ADDRESS_AND_PHONE

PROVINCE

Size: 10

12=Postal Code

ADDRESS_AND_PHONE

POSTAL_ZIP_CODE

Size: 10

13=Country

ADDRESS_AND_PHONE

COUNTRY

Size: 10

14=Emp E-mail

EMPLOYEE_DEMOGRAPHICS

EMPLOYEE_EMAIL_ADDRESS

Size: 30

14=Emp E-mail

EMPLOYEE_DEMOGRAPHICS

EMPLOYEE_EMAIL_WITH_DOMAIN

Employee E-Mail and Domain (Personal e-mail address *the client email domain information can be found on the HR Master Profile) Size: 30

18=Telephone 1

ADDRESS_AND_PHONE

LISTED_PHONE_NO_1

Size: 13 Format: (###)###-####

18=Telephone 1

ADDRESS_AND_PHONE

PHONE_NO_1

Size: 13 Format: (###)###-####

18=Telephone 1

ADDRESS_AND_PHONE

UNLISTED_PHONE_NO_1

Internal Lookup: =LISTED, Y=UNLISTED, Size: 3

19=Telephone 2

ADDRESS_AND_PHONE

LISTED_PHONE_NO_2

Size: 13 Format: (###)###-####

19=Telephone 2

ADDRESS_AND_PHONE

PHONE_NO_2

Size: 13 Format: (###)###-####

19=Telephone 2

ADDRESS_AND_PHONE

UNLISTED_PHONE_NO_2

Internal Lookup: =LISTED, Y=UNLISTED, Size: 3

20=Birth Date

EMPLOYEE_DEMOGRAPHICS

BIRTH_DATE

Size: 11 Format: DD-MMM-YYYY

20=Birth Date

EMPLOYEE_DEMOGRAPHICS

BIRTH_MONTH

Current Month=Cur, Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec Size: 10

20=Birth Date

EMPLOYEE_DEMOGRAPHICS

BIRTH_MONTH_AND_DAY

Combines the Month and Day Size: 15

20=Birth Date

EMPLOYEE_DEMOGRAPHICS

BIRTH_MONTH_NO

01=January, 02=February, 03=March, 04=April, 05=May, 06=June, 07=July, 08=August, 09=September, 10=October, 11=November, 12=December, Current Month=Cur, Next Month=Next, Last Month=Last Size: 10

20=Birth Date

EMPLOYEE_DEMOGRAPHICS

EMPLOYEE_AGE

Calculated based on Birth Date Size: 3 Format: ##########

20=Birth Date (as to the closest 10 years)

EMPLOYEE_DEMOGRAPHICS

EMPLOYEE_AGE_(10_YR_INTS)

Size: 10

20=Birth Date (Age calculated as of a date)

EMPLOYEE_DEMOGRAPHICS

EMPLOYEE_AGE_ASOF_DATE

Size: 11 Format: DD-MMM-YYYY

20=Birth Date (as to the closest 20 years)

EMPLOYEE_DEMOGRAPHICS

EMPLOYEE_AGE_(20_YR_INTS)

Size: 10

20=Birth Date (as to the closest 5 years - i.e. 23-> 25)

EMPLOYEE_DEMOGRAPHICS

EMPLOYEE_AGE_(5_YR_INTS)

Size: 10

21=Gender

EMPLOYEE_DEMOGRAPHICS

GENDER

Size: 3

21=Gender

EMPLOYEE_DEMOGRAPHICS

GENDER_DESC

Description pulled from Database Size: 6

22=Marital Status

EMPLOYEE_DEMOGRAPHICS

MARITAL_STATUS_CODE

Size: 3

22=Marital Status

EMPLOYEE_DEMOGRAPHICS

MARITAL_STATUS_DESC

Description pulled from Database Size: 20

23=Contractual Fte

EMPLOYEE_DEMOGRAPHICS

CONTRACTUAL_FTE

Size: 9 Format: ######.####

Description of Sort

NAME_AND_SIN

SORT_HEADER_NAME

Size: 30

Security Employee

NAME_AND_SIN

SECURITY_EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

02=Bargaining Unit

EMPLOYEE_DEMOGRAPHICS

BARGAINING_UNIT

Size: 8

02=Bargaining Unit

EMPLOYEE_DEMOGRAPHICS

BARG_UNIT_DESCRIPTION

Detailed Explanation of code. Size: 30

03=Department

EMPLOYEE_DEMOGRAPHICS

DEPARTMENT_CODE

Size: 4

03=Department

EMPLOYEE_DEMOGRAPHICS

DEPARTMENT_DESCRIPTION

Detailed Explanation of code. Size: 30

04=Position

EMPLOYEE_DEMOGRAPHICS

POSITION_CODE

Size: 8

04=Position

EMPLOYEE_DEMOGRAPHICS

POSITION_DESCRIPTION

Detailed Explanation of code. Size: 30

05=Location

EMPLOYEE_DEMOGRAPHICS

LOCATION_CODE

Size: 4

05=Location

EMPLOYEE_DEMOGRAPHICS

LOCATION_NAME

Detailed Explanation of code. Size: 50

09=Last Transfer Date

EMPLOYEE_DEMOGRAPHICS

LAST_TRANSFER_DATE

Size: 11 Format: DD-MMM-YYYY

11=T.Q.S Date (Teacher Qualification Service Date)

EMPLOYEE_DEMOGRAPHICS

TQS_DATE

Size: 11 Format: DD-MMM-YYYY

12=T.Q.S Category (Teacher Qualification Category)

EMPLOYEE_DEMOGRAPHICS

TQS_CATEGORY

Size: 3

13=Salary Grid

EMPLOYEE_DEMOGRAPHICS

SALARY_GRID

Size: 6

15=Dept. Head [Y/N]

EMPLOYEE_DEMOGRAPHICS

DEPARTMENT_HEAD

Size: 3

16=Primary Language

EMPLOYEE_DEMOGRAPHICS

LANGUAGE_CODE

Size: 2

16=Primary Language

EMPLOYEE_DEMOGRAPHICS

LANGUAGE_DESCRIPTION

Detailed Explanation of code. Size: 30

17=Disability Code

EMPLOYEE_DEMOGRAPHICS

DISABILITY_CODE

Size: 2

17=Disability Code

EMPLOYEE_DEMOGRAPHICS

DISABILITY_DESCRIPTION

Detailed Explanation of code. Size: 30

18=Ethnic Code

EMPLOYEE_DEMOGRAPHICS

ETHNIC_CODE

Size: 2

18=Ethnic Code

EMPLOYEE_DEMOGRAPHICS

ETHNIC_DESCRIPTION

Detailed Explanation of code. Size: 30

19=Citizenship

EMPLOYEE_DEMOGRAPHICS

CITIZENSHIP

Size: 10

20=Elig As Sub (eligible as a substitute)

EMPLOYEE_DEMOGRAPHICS

ELIGIBLE_AS_SUB

Internal Lookup: Y=YES, N=NO, Size: 3

21=Elig As Cas (eligible as a casual)

EMPLOYEE_DEMOGRAPHICS

ELIGIBLE_AS_CAS

Internal Lookup: Y=YES, N=NO, Size: 3

22=School Term

EMPLOYEE_DEMOGRAPHICS

SCHOOL_TERM

Internal Lookup: Y=YES, N=NO, Size: 3

23=Travel Allow

EMPLOYEE_DEMOGRAPHICS

TRAVEL_ALLOWANCE

Internal Lookup: Y=YES, N=NO. (This field is used to flag or to indicate employee(s) that receive a travel allowance as part of their normal salary) Size: 4

11=Total Seniority Days

EMPLOYEE_DEMOGRAPHICS

SENIORITY_TOTAL_DAYS

Size: 10 Format: ######.####

15=Seniority Y=Yrs, M=Mon

EMPLOYEE_DEMOGRAPHICS

SENIORITY_YRS_MNS

Size: 6

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD01

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD02

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD03

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD04

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD05

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD06

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD07

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD08

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD09

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD10

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD11

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD12

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD13

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD14

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD15

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD16

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD17

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD18

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD19

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD20

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD21

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD22

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD23

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD24

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD25

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD26

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD27

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD28

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD29

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD30

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD31

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD32

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD33

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD34

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD35

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD36

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD37

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD38

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD39

Size: 80

User Defined Field

USER_DEFINED_DEMOGRAPHICS

FIELD40

Size: 80

02=Reason for Action

DISCIPLINARY_ACTION

REASON

Size: 10

02=Reason for Action

DISCIPLINARY_ACTION

REASON_DESCRIPTION

Detailed Explanation of code. Size: 30

03=Date Problem Occurred

DISCIPLINARY_ACTION

DATE_ISSUE_OCCURRED

Size: 11 Format: DD-MMM-YYYY

04=Reason Comments

DISCIPLINARY_ACTION

REASON_COMMENTS

Size: 30

05=Action Taken

DISCIPLINARY_ACTION

ACTION_CODE

Size: 10

05=Action Taken

DISCIPLINARY_ACTION

ACTION_DESCRIPTION

Detailed Explanation of code. Size: 30

06=Date of Action

DISCIPLINARY_ACTION

ACTION_DATE

Size: 11 Format: DD-MMM-YYYY

07=Action Comments

DISCIPLINARY_ACTION

ACTION_COMMENTS

Size: 30

08=Action Taken By

DISCIPLINARY_ACTION

ACTION_TAKER_EMP_NAME

Size: 30

08=Action Taken By

DISCIPLINARY_ACTION

ACTION_TAKER_EMP_NO

Size: 10

09=Bargaining Unit Informed

DISCIPLINARY_ACTION

BARG_UNIT_INFORMED_YN

Size: 10

10=Contact Name

DISCIPLINARY_ACTION

CONTACT_NAME

Size: 30

11=Date of Contact

DISCIPLINARY_ACTION

CONTACT_DATE

Size: 11 Format: DD-MMM-YYYY

02=Position

EVALUATION

EVAL_POSITION_CODE

Size: 8

02=Position

EVALUATION

EVAL_POSITION_DESC

Detailed Explanation of code. Size: 30

03=Assign Start

EVALUATION

START_DATE

Size: 11 Format: DD-MMM-YYYY

04=Evaluation Code

EVALUATION

EVALUATION_CODE

Size: 6

04=Evaluation Code

EVALUATION

EVALUATION_DESC

Detailed Explanation of code. Size: 30

05=Location

EVALUATION

EVAL_LOCATION_NAME

Detailed Explanation of code. Size: 30

05=Location

EVALUATION

EVAL_LOCATION_NO

Size: 4

06=Required Date

EVALUATION

REQUIRED_DATE

Size: 11 Format: DD-MMM-YYYY

07=Completed Date

EVALUATION

COMPLETED_DATE

Size: 11 Format: DD-MMM-YYYY

08=Completion Code

EVALUATION

COMPLETION_CODE

Size: 4

08=Completion Code

EVALUATION

COMPLETION_DESC

Detailed Explanation of code. Size: 30

09=Completed By

EVALUATION

COMPLETED_BY_EMP_NO

Size: 10

09=Completed By

EVALUATION

COMPLETED_BY_NAME

Size: 30

10=Supervisor

EVALUATION

SUPERVISOR_EMP_NO

Size: 10

10=Supervisor

EVALUATION

SUPERVISOR_NAME

Size: 30

11=1st Interval

EVALUATION

NOTE_01_INTERVAL_CODE

Size: 6

11=1st Interval

EVALUATION

NOTE_01_INTERVAL_DESC

Detailed Explanation of code. Size: 30

12=Date To Be Sent

EVALUATION

NOTE_01_DATE

Size: 11 Format: DD-MMM-YYYY

13=Date Sent

EVALUATION

NOTE_01_SENT

Size: 11 Format: DD-MMM-YYYY

14=2nd Interval

EVALUATION

NOTE_02_INTERVAL_CODE

Size: 6

14=2nd Interval

EVALUATION

NOTE_02_INTERVAL_DESC

Detailed Explanation of code. Size: 30

15=Date To Be Sent

EVALUATION

NOTE_02_DATE

Size: 11 Format: DD-MMM-YYYY

16=Date Sent

EVALUATION

NOTE_02_SENT

Size: 11 Format: DD-MMM-YYYY

17=Final Date Sent

EVALUATION

FINAL_SENT_DATE

Size: 8 Format: DD-MMM-YYYY

18=Comment

EVALUATION

COMMENT

Size: 80

Secured by Supervisor

EVALUATION

SECURED_SUPERVISOR_YN

Internal Lookup: Y=YES, N=NO. only the supervisor listed on the evaluation would see evaluation information(i.e. evaluations due/ overdue) on a report Size: 10

02=Years Experience in Dist

EXPERIENCE

DISTRICT_EXPERIENCE

Size: 10 Format: ######.####

03=Years Experience in Prov

EXPERIENCE

PROVINCE_EXPERIENCE

Size: 10 Format: ######.####

04=Years Experience Elsewhere

EXPERIENCE

OUT_OF_PROVINCE_EXPERIENCE

Size: 10 Format: ######.####

05=Last Secondary School

EXPERIENCE

LAST_SECONDARY_SCHOOL

Detailed Explanation of code. Size: 30

06=Last Post Secondary School

EXPERIENCE

LAST_POST_SECONDARY_SCHOOL

Detailed Explanation of code. Size: 30

07=Temp/Sub Experience

EXPERIENCE

TEMP_OR_SUB_EXPERIENCE

Size: 10

08=Comment

EXPERIENCE

COMMENT

Size: 30

01=Employee

GRIEVANCE

*EMPLOYEE_NO

This field should be used whenever you want to select records by employee. None of the fields with employee name should ever be used to select individual employees. Size: 10

02=Reason

GRIEVANCE

REASON

Size: 10

02=Reason

GRIEVANCE

REASON_DESCRIPTION

Detailed Explanation of code. Size: 30

03=Grieve Date

GRIEVANCE

GRIEVANCE_DATE

Size: 11 Format: DD-MMM-YYYY

04=Grievance Number

GRIEVANCE

GRIEVANCE_NUMBER

Size: 15

05=Location

GRIEVANCE

LOCATION

Size: 10

05=Location

GRIEVANCE

LOCATION_NAME

Detailed Explanation of code. Size: 30

06=Position

GRIEVANCE

POSITION

Size: 10

06=Position

GRIEVANCE

POSITION_DESCRIPTION

Detailed Explanation of code. Size: 30

07=Comment

GRIEVANCE

COMMENT

Size: 30

08=Review Date

GRIEVANCE

REVIEW_DATE

Size: 11 Format: DD-MMM-YYYY

09=Reviewed By

GRIEVANCE

REVIEWED_BY_EMP_NAME

Size: 30

09=Reviewed By

GRIEVANCE

REVIEWED_BY_EMP_NO

Size: 10

30=Comment

GRIEVANCE

LONG_COMMENT

Size: 80

Description of resolution

GRIEVANCE

RESOLUTION_DESCRIPTION

Detailed Explanation of code. Size: 30

Stage (10,14,18,22,26)

GRIEVANCE

STAGE_CODE

Size: 10

Stage Comment (13,17,21,25,29)

GRIEVANCE

STAGE_COMMENT

Size: 50

Stage Date (11,15,19,23,27)

GRIEVANCE

STAGE_DATE

Size: 11 Format: DD-MMM-YYYY

Stage Reason Code (12,16,20,24,28)

GRIEVANCE

STAGE_DESCRIPTION

Detailed Explanation of code. Size: 30

Stage Reason Code (12,16,20,24,28)

GRIEVANCE

STAGE_RESOLUTION

Size: 10

02=HIRE DATE

HIRE_INFORMATION

HIRE_DATE

Size: 11 Format: DD-MMM-YYYY

03=HIRE TYPE

HIRE_INFORMATION

HIRE_TYPE_CODE

Size: 10

04=Term Date

HIRE_INFORMATION

TERMINATION_DATE

Size: 11 Format: DD-MMM-YYYY

05=Term Reason

HIRE_INFORMATION

TERMINATION_CODE

Size: 10

05=Term Reason

HIRE_INFORMATION

TERMINATION_DESCRIPTION

Detailed Explanation of code. Size: 30

06=Prev Name

HIRE_INFORMATION

PREVIOUS_FULL_NAME

Size: 50

06=Prev Name --> 01=Last Name

HIRE_INFORMATION

PREVIOUS_LAST_NAME

Size: 25

06=Prev Name --> 02=First Name

HIRE_INFORMATION

PREVIOUS_FIRST_NAME

Size: 15

06=Prev Name --> 03=Middle Initial

HIRE_INFORMATION

PREVIOUS_MIDDLE_NAME

Size: 10

07=Init Bargain Unit

HIRE_INFORMATION

BARGAINING_UNIT

Size: 8

14=Hire Type

HIRE_INFORMATION

HIRE_TYPE_DESCRIPTION

Detailed Explanation of code. Size: 30

Indicates the type of hire record

HIRE_INFORMATION

HIRE_TYPE_INDICATOR

Internal Lookup: C=CURRENT HIRE RECORD, O=ORIGINAL HIRE RECORD, Size: 3

Teac Date 01 --> 08 (Date)

HIRE_INFORMATION

DATE_01

Size: 11 Format: DD-MMM-YYYY

Teac Date 01 --> 09 (Y/N)

HIRE_INFORMATION

FLAG_YN_01

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 01 --> 10 (File #)

HIRE_INFORMATION

FILE_NO_01

Size: 15

Teac Date 02 --> 11 (Date)

HIRE_INFORMATION

DATE_02

Size: 11 Format: DD-MMM-YYYY

Teac Date 02 --> 12 (Y/N)

HIRE_INFORMATION

FLAG_YN_02

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 02 --> 13 (File #)

HIRE_INFORMATION

FILE_NO_02

Size: 15

Teac Date 03 --> 14 (Date)

HIRE_INFORMATION

DATE_03

Size: 11 Format: DD-MMM-YYYY

Teac Date 03 --> 15 (Y/N)

HIRE_INFORMATION

FLAG_YN_03

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 03 --> 16 (File #)

HIRE_INFORMATION

FILE_NO_03

Size: 15

Teac Date 04 --> 17 (Date)

HIRE_INFORMATION

DATE_04

Size: 11 Format: DD-MMM-YYYY

Teac Date 04 --> 18 (Y/N)

HIRE_INFORMATION

FLAG_YN_04

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 04 --> 19 (File #)

HIRE_INFORMATION

FILE_NO_04

Size: 15

Teac Date 05 --> 20 (Date)

HIRE_INFORMATION

DATE_05

Size: 11 Format: DD-MMM-YYYY

Teac Date 05 --> 21 (Y/N)

HIRE_INFORMATION

FLAG_YN_05

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 05 --> 22 (File #)

HIRE_INFORMATION

FILE_NO_05

Size: 15

Teac Date 06 --> 23 (Date)

HIRE_INFORMATION

DATE_06

Size: 11 Format: DD-MMM-YYYY

Teac Date 06 --> 24 (Y/N)

HIRE_INFORMATION

FLAG_YN_06

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 06 --> 25 (File #)

HIRE_INFORMATION

FILE_NO_06

Size: 15

Teac Date 07 --> 26 (Date)

HIRE_INFORMATION

DATE_07

Size: 11 Format: DD-MMM-YYYY

Teac Date 07 --> 27 (Y/N)

HIRE_INFORMATION

FLAG_YN_07

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 07 --> 28 (File #)

HIRE_INFORMATION

FILE_NO_07

Size: 15

Teac Date 08 --> 29 (Date)

HIRE_INFORMATION

DATE_08

Size: 11 Format: DD-MMM-YYYY

Teac Date 08 --> 30 (Y/N)

HIRE_INFORMATION

FLAG_YN_08

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 08 --> 31

HIRE_INFORMATION

FILE_NO_08

Size: 15

Teac Date 09 --> 32 (Date)

HIRE_INFORMATION

DATE_09

Size: 11 Format: DD-MMM-YYYY

Teac Date 09 --> 33 (Y/N)

HIRE_INFORMATION

FLAG_YN_09

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 09 --> 34 (File #)

HIRE_INFORMATION

FILE_NO_09

Size: 15

Teac Date 10 --> 10 (Date)

HIRE_INFORMATION

DATE_10

Size: 11 Format: DD-MMM-YYYY

Teac Date 10 --> 36 (Y/N)

HIRE_INFORMATION

FLAG_YN_10

Internal Lookup: Y=YES, N=NO, Size: 3

Teac Date 10 --> 37 (File #)

HIRE_INFORMATION

FILE_NO_10

Size: 15

Teac Date 11 --> 38 (Date)

HIRE_INFORMATION

MISC_DATE

Size: 11 Format: DD-MMM-YYYY

Teac Date 11 --> 39 (Y/N)

HIRE_INFORMATION

MISC_FLAG_YN

Size: 15

Teac Date 11 --> 40 (File #)

HIRE_INFORMATION

MISC_FILE_NO

Size: 15

01=1

HIRE_INFORMATION

CURRENT_SEN_BANK_01

Size: 10

02=2

HIRE_INFORMATION

CURRENT_SEN_BANK_02

Size: 10

03=3

HIRE_INFORMATION

CURRENT_SEN_BANK_03

Size: 10

04=4

HIRE_INFORMATION

CURRENT_SEN_BANK_04

Size: 10

05=5

HIRE_INFORMATION

CURRENT_SEN_BANK_05

Size: 10

10=1

HIRE_INFORMATION

CURRENT_SEN_CODE_01

Size: 10

10=2

HIRE_INFORMATION

CURRENT_SEN_CODE_02

Size: 10

10=3

HIRE_INFORMATION

CURRENT_SEN_CODE_03

Size: 10

10=4

HIRE_INFORMATION

CURRENT_SEN_CODE_04

Size: 10

10=5

HIRE_INFORMATION

CURRENT_SEN_CODE_05

Size: 10

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_DEMO

Size: 6

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_DEMO

Size: 6

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_DEMO

Size: 6

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_01_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_01_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_01_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_02_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_02_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_02_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_03_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_03_DEMO

Size: 2

01=Salary Grid

DEMO_PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_03_DEMO

Size: 2

01=Salary Grid

PAYROLL_FUNCTION_LINE

SALARY_GRID

Size: 6

01=Salary Grid

PAYROLL_FUNCTION_LINE

SALARY_GRID

Size: 6

01=Salary Grid

PAYROLL_FUNCTION_LINE

SALARY_GRID

Size: 6

01=Salary Grid (1st 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_01

Size: 2

01=Salary Grid (1st 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_01

Size: 2

01=Salary Grid (1st 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_01

Size: 2

01=Salary Grid (Last 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_03

Size: 2

01=Salary Grid (Last 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_03

Size: 2

01=Salary Grid (Last 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_03

Size: 2

01=Salary Grid (Middle 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_02

Size: 2

01=Salary Grid (Middle 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_02

Size: 2

01=Salary Grid (Middle 2 characters of salary grid)

PAYROLL_FUNCTION_LINE

SALARY_GRID_SEG_02

Size: 2

02=Cycle Code

DEMO_PAYROLL_FUNCTION_LINE

CYCLE_CODE_DEMO

Size: 2

02=Cycle Code

DEMO_PAYROLL_FUNCTION_LINE

CYCLE_CODE_DEMO

Size: 2

02=Cycle Code

DEMO_PAYROLL_FUNCTION_LINE

CYCLE_CODE_DEMO

Size: 2

02=Cycle Code

PAYROLL_FUNCTION_LINE

FL_CYCLE_CODE

Size: 2

02=Cycle Code

PAYROLL_FUNCTION_LINE

FL_CYCLE_CODE

Size: 2

02=Cycle Code

PAYROLL_FUNCTION_LINE

FL_CYCLE_CODE

Size: 2

03=Pay Type

DEMO_PAYROLL_FUNCTION_LINE

PAY_TYPE_DEMO

Size: 2

03=Pay Type

DEMO_PAYROLL_FUNCTION_LINE

PAY_TYPE_DEMO

Size: 2

03=Pay Type

DEMO_PAYROLL_FUNCTION_LINE

PAY_TYPE_DEMO

Size: 2

03=Pay Type

PAYROLL_FUNCTION_LINE

PAY_TYPE

Size: 2

03=Pay Type

PAYROLL_FUNCTION_LINE

PAY_TYPE

Size: 2

03=Pay Type

PAYROLL_FUNCTION_LINE

PAY_TYPE

Size: 2

04=Pay Code

DEMO_PAYROLL_FUNCTION_LINE

PAY_CODE_DEMO

Size: 2

04=Pay Code

DEMO_PAYROLL_FUNCTION_LINE

PAY_CODE_DEMO

Size: 2

04=Pay Code

DEMO_PAYROLL_FUNCTION_LINE

PAY_CODE_DEMO

Size: 2

04=Pay Code

PAYROLL_FUNCTION_LINE

PAY_CODE

Size: 2

04=Pay Code

PAYROLL_FUNCTION_LINE

PAY_CODE

Size: 2

04=Pay Code

PAYROLL_FUNCTION_LINE

PAY_CODE

Size: 2

05=Percent Employed

DEMO_PAYROLL_FUNCTION_LINE

PERCENTAGE_EMPLOYED_DEMO

Size: 10 Format: ######.####

05=Percent Employed

DEMO_PAYROLL_FUNCTION_LINE

PERCENTAGE_EMPLOYED_DEMO

Size: 10 Format: ######.####

05=Percent Employed

DEMO_PAYROLL_FUNCTION_LINE

PERCENTAGE_EMPLOYED_DEMO

Size: 10 Format: ######.####

05=Percent Employed

PAYROLL_FUNCTION_LINE

PERCENTAGE_EMPLOYED

Size: 10 Format: ######.####

05=Percent Employed

PAYROLL_FUNCTION_LINE

PERCENTAGE_EMPLOYED

Size: 10 Format: ######.####

05=Percent Employed

PAYROLL_FUNCTION_LINE

PERCENTAGE_EMPLOYED

Size: 10 Format: ######.####

06=Pay Rate

DEMO_PAYROLL_FUNCTION_LINE

PAY_RATE_DEMO

Size: 10 Format: ######.####

06=Pay Rate

DEMO_PAYROLL_FUNCTION_LINE

PAY_RATE_DEMO

Size: 10 Format: ######.####

06=Pay Rate

DEMO_PAYROLL_FUNCTION_LINE

PAY_RATE_DEMO

Size: 10 Format: ######.####

06=Pay Rate

PAYROLL_FUNCTION_LINE

PAY_RATE

Size: 10 Format: ######.####

06=Pay Rate

PAYROLL_FUNCTION_LINE

PAY_RATE

Size: 10 Format: ######.####

06=Pay Rate

PAYROLL_FUNCTION_LINE

PAY_RATE

Size: 10 Format: ######.####

07=Base Hours

DEMO_PAYROLL_FUNCTION_LINE

BASE_HOURS_DEMO

Size: 10 Format: ######.####

07=Base Hours

DEMO_PAYROLL_FUNCTION_LINE

BASE_HOURS_DEMO

Size: 10 Format: ######.####

07=Base Hours

DEMO_PAYROLL_FUNCTION_LINE

BASE_HOURS_DEMO

Size: 10 Format: ######.####

07=Base Hours

PAYROLL_FUNCTION_LINE

BASE_HOURS

Size: 10 Format: ######.####

07=Base Hours

PAYROLL_FUNCTION_LINE

BASE_HOURS

Size: 10 Format: ######.####

07=Base Hours

PAYROLL_FUNCTION_LINE

BASE_HOURS

Size: 10 Format: ######.####

08=Occupation Code

DEMO_PAYROLL_FUNCTION_LINE

OCCUPATION_CODE_DEMO

Size: 4

08=Occupation Code

DEMO_PAYROLL_FUNCTION_LINE

OCCUPATION_CODE_DEMO

Size: 4

08=Occupation Code

DEMO_PAYROLL_FUNCTION_LINE

OCCUPATION_CODE_DEMO

Size: 4

08=Occupation Code

PAYROLL_FUNCTION_LINE

OCCUPATION_CODE

Size: 4

08=Occupation Code

PAYROLL_FUNCTION_LINE

OCCUPATION_CODE

Size: 4

08=Occupation Code

PAYROLL_FUNCTION_LINE

OCCUPATION_CODE

Size: 4

09=Employee Type

DEMO_PAYROLL_FUNCTION_LINE

EMPLOYEE_TYPE_DEMO

Size: 2

09=Employee Type

DEMO_PAYROLL_FUNCTION_LINE

EMPLOYEE_TYPE_DEMO

Size: 2

09=Employee Type

DEMO_PAYROLL_FUNCTION_LINE

EMPLOYEE_TYPE_DEMO

Size: 2

09=Employee Type

PAYROLL_FUNCTION_LINE

EMPLOYEE_TYPE

Size: 2

09=Employee Type

PAYROLL_FUNCTION_LINE

EMPLOYEE_TYPE

Size: 2

09=Employee Type

PAYROLL_FUNCTION_LINE

EMPLOYEE_TYPE

Size: 2

10=Shift Code

DEMO_PAYROLL_FUNCTION_LINE

SHIFT_CODE_DEMO

Size: 2

10=Shift Code

DEMO_PAYROLL_FUNCTION_LINE

SHIFT_CODE_DEMO

Size: 2

10=Shift Code

DEMO_PAYROLL_FUNCTION_LINE

SHIFT_CODE_DEMO

Size: 2

10=Shift Code

PAYROLL_FUNCTION_LINE

SHIFT_CODE

Size: 2

10=Shift Code

PAYROLL_FUNCTION_LINE

SHIFT_CODE

Size: 2

10=Shift Code

PAYROLL_FUNCTION_LINE

SHIFT_CODE

Size: 2

11=Start Date

DEMO_PAYROLL_FUNCTION_LINE

START_DATE_DEMO

Size: 11

11=Start Date

DEMO_PAYROLL_FUNCTION_LINE

START_DATE_DEMO

Size: 11

11=Start Date

DEMO_PAYROLL_FUNCTION_LINE

START_DATE_DEMO

Size: 11

11=Start Date

PAYROLL_FUNCTION_LINE

START_DATE

Size: 11

11=Start Date

PAYROLL_FUNCTION_LINE

START_DATE

Size: 11

11=Start Date

PAYROLL_FUNCTION_LINE

START_DATE

Size: 11

12=End Date

DEMO_PAYROLL_FUNCTION_LINE

END_DATE_DEMO

Size: 11

12=End Date

DEMO_PAYROLL_FUNCTION_LINE

END_DATE_DEMO

Size: 11

12=End Date

DEMO_PAYROLL_FUNCTION_LINE

END_DATE_DEMO

Size: 11

12=End Date

PAYROLL_FUNCTION_LINE

END_DATE

Size: 11

12=End Date

PAYROLL_FUNCTION_LINE

END_DATE

Size: 11

12=End Date

PAYROLL_FUNCTION_LINE

END_DATE

Size: 11

13=GL Costing

DEMO_PAYROLL_FUNCTION_LINE

DEFAULT_GL_DEMO

Size: 12

13=GL Costing

DEMO_PAYROLL_FUNCTION_LINE

DEFAULT_GL_DEMO

Size: 12

13=GL Costing

DEMO_PAYROLL_FUNCTION_LINE

DEFAULT_GL_DEMO

Size: 12

13=GL Costing

PAYROLL_FUNCTION_LINE

DEFAULT_GL

Size: 12

13=GL Costing

PAYROLL_FUNCTION_LINE

DEFAULT_GL

Size: 12

13=GL Costing

PAYROLL_FUNCTION_LINE

DEFAULT_GL

Size: 12

Cost Center

DEMO_PAYROLL_FUNCTION_LINE

DEFAULT_COST_CENTER_DEMO

Size: 10

Cost Center

DEMO_PAYROLL_FUNCTION_LINE

DEFAULT_COST_CENTER_DEMO

Size: 10

Cost Center

DEMO_PAYROLL_FUNCTION_LINE

DEFAULT_COST_CENTER_DEMO

Size: 10

Cost Center

PAYROLL_FUNCTION_LINE

DEFAULT_COST_CENTER

Size: 10

Cost Center

PAYROLL_FUNCTION_LINE

DEFAULT_COST_CENTER

Size: 10

Cost Center

PAYROLL_FUNCTION_LINE

DEFAULT_COST_CENTER

Size: 10

Employee Number

DEMO_PAYROLL_FUNCTION_LINE

ID_DEMO

Size: 14

Employee Number

DEMO_PAYROLL_FUNCTION_LINE

ID_DEMO

Size: 14

Employee Number

DEMO_PAYROLL_FUNCTION_LINE

ID_DEMO

Size: 14

Employee Number

PAYROLL_FUNCTION_LINE

ID

Size: 14

Employee Number

PAYROLL_FUNCTION_LINE

ID

Size: 14

Employee Number

PAYROLL_FUNCTION_LINE

ID

Size: 14

Function Line Order #

DEMO_PAYROLL_FUNCTION_LINE

ORDER_NO_DEMO

Size: 5

Function Line Order #

DEMO_PAYROLL_FUNCTION_LINE

ORDER_NO_DEMO

Size: 5

Function Line Order #

DEMO_PAYROLL_FUNCTION_LINE

ORDER_NO_DEMO

Size: 5

Function Line Order #

PAYROLL_FUNCTION_LINE

ORDER_NO

Size: 5

Function Line Order #

PAYROLL_FUNCTION_LINE

ORDER_NO

Size: 5

Function Line Order #

PAYROLL_FUNCTION_LINE

ORDER_NO

Size: 5

13=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_01_DESC

Detailed Explanation of code. Size: 30

15=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_02_CODE

Size: 10

15=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_02_DESC

Detailed Explanation of code. Size: 30

17=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_03_CODE

Size: 10

17=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_03_DESC

Detailed Explanation of code. Size: 30

19=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_04_CODE

Size: 10

19=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_04_DESC

Detailed Explanation of code. Size: 30

21=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_05_CODE

Size: 10

21=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_05_DESC

Detailed Explanation of code. Size: 30

23=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_06_CODE

Size: 10

23=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_06_DESC

Detailed Explanation of code. Size: 30

25=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_07_CODE

Size: 10

25=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_07_DESC

Detailed Explanation of code. Size: 30

27=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_08_CODE

Size: 10

27=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_08_DESC

Detailed Explanation of code. Size: 30

29=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_09_CODE

Size: 10

29=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_09_DESC

Detailed Explanation of code. Size: 30

31=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_10_CODE

Size: 10

31=First Subject

EMPLOYEE_PREFERENCES

SUBJECT_10_DESC

Detailed Explanation of code. Size: 30

33=Second Subject

EMPLOYEE_PREFERENCES

SUBJECT2_01_CODE

Size: 10

33=Second Subject

EMPLOYEE_PREFERENCES

SUBJECT2_01_DESC

Detailed Explanation of code. Size: 30

34=Level

EMPLOYEE_PREFERENCES

LEVEL2_01_CODE

Size: 4

34=Level

EMPLOYEE_PREFERENCES

LEVEL2_01_DESC

Detailed Explanation of code. Size: 30

34=Level

EMPLOYEE_PREFERENCES

LEVEL2_02_CODE

Size: 4

34=Level

EMPLOYEE_PREFERENCES

LEVEL2_02_DESC

Detailed Explanation of code. Size: 30

35=Second Subject

EMPLOYEE_PREFERENCES

SUBJECT2_02_CODE

Size: 10

35=Second Subject

EMPLOYEE_PREFERENCES

SUBJECT2_02_DESC

Detailed Explanation of code. Size: 30

37=Second Subject

EMPLOYEE_PREFERENCES

SUBJECT2_03_CODE

Size: 10

37=Second Subject

EMPLOYEE_PREFERENCES

SUBJECT2_03_DESC

Detailed Explanation of code. Size: 30

38=Level

EMPLOYEE_PREFERENCES

LEVEL2_03_CODE

Size: 4

38=Level

EMPLOYEE_PREFERENCES

LEVEL2_03_DESC

Detailed Explanation of code. Size: 30

39=Com1

EMPLOYEE_PREFERENCES

COMMENT_01

Size: 80

40=Com2

EMPLOYEE_PREFERENCES

COMMENT_02

Size: 80

Area=03

EMPLOYEE_PREFERENCES

AREA_01_CODE

Size: 4

Area=03

EMPLOYEE_PREFERENCES

AREA_01_DESC

Detailed Explanation of code. Size: 30

Area=04

EMPLOYEE_PREFERENCES

AREA_02_CODE

Size: 4

Area=04

EMPLOYEE_PREFERENCES

AREA_02_DESC

Detailed Explanation of code. Size: 30

Area=05

EMPLOYEE_PREFERENCES

AREA_03_CODE

Size: 4

Area=05

EMPLOYEE_PREFERENCES

AREA_03_DESC

Detailed Explanation of code. Size: 30

Area=06

EMPLOYEE_PREFERENCES

AREA_04_CODE

Size: 4

Area=06

EMPLOYEE_PREFERENCES

AREA_04_DESC

Detailed Explanation of code. Size: 30

Area=07

EMPLOYEE_PREFERENCES

AREA_05_CODE

Size: 4

Area=07

EMPLOYEE_PREFERENCES

AREA_05_DESC

Detailed Explanation of code. Size: 30

Areas: 03,04,05,06,07

EMPLOYEE_PREFERENCES

ALL_AREA_CODES

Size: 50

Areas: 03,04,05,06,07

EMPLOYEE_PREFERENCES

ALL_AREA_DESCS

Detailed Explanation of code. Size: 50

First Subject Levels (14,16,18,20,22,24,26,28,30,3

EMPLOYEE_PREFERENCES

ALL_LEVEL_CODES

Size: 50

First Subject Levels (14,16,18,20,22,24,26,28,30,3

EMPLOYEE_PREFERENCES

ALL_LEVEL_DESCS

Detailed Explanation of code. Size: 50

First Subject=13

EMPLOYEE_PREFERENCES

SUBJECT_01_CODE

Size: 10

Level: 14,16,18,20,22,24,26,28,30,32,34,36,38

EMPLOYEE_PREFERENCES

ALL_SUB_LEV_CODES

Size: 50

Level: 14,16,18,20,22,24,26,28,30,32,34,36,38

EMPLOYEE_PREFERENCES

ALL_SUB_LEV_DESCS

Detailed Explanation of code. Size: 50

Level=14

EMPLOYEE_PREFERENCES

LEVEL_01_CODE

Size: 4

Level=14

EMPLOYEE_PREFERENCES

LEVEL_01_DESC

Detailed Explanation of code. Size: 30

Level=16

EMPLOYEE_PREFERENCES

LEVEL_02_CODE

Size: 4

Level=16

EMPLOYEE_PREFERENCES

LEVEL_02_DESC

Detailed Explanation of code. Size: 30

Level=18

EMPLOYEE_PREFERENCES

LEVEL_03_CODE

Size: 4

Level=18

EMPLOYEE_PREFERENCES

LEVEL_03_DESC

Detailed Explanation of code. Size: 30

Level=20

EMPLOYEE_PREFERENCES

LEVEL_04_CODE

Size: 4

Level=20

EMPLOYEE_PREFERENCES

LEVEL_04_DESC

Detailed Explanation of code. Size: 30

Level=22

EMPLOYEE_PREFERENCES

LEVEL_05_CODE

Size: 4

Level=22

EMPLOYEE_PREFERENCES

LEVEL_05_DESC

Detailed Explanation of code. Size: 30

Level=24

EMPLOYEE_PREFERENCES

LEVEL_06_CODE

Size: 4

Level=24

EMPLOYEE_PREFERENCES

LEVEL_06_DESC

Detailed Explanation of code. Size: 30

Level=26

EMPLOYEE_PREFERENCES

LEVEL_07_CODE

Size: 4

Level=26

EMPLOYEE_PREFERENCES

LEVEL_07_DESC

Detailed Explanation of code. Size: 30

Level=28

EMPLOYEE_PREFERENCES

LEVEL_08_CODE

Size: 4

Level=28

EMPLOYEE_PREFERENCES

LEVEL_08_DESC

Detailed Explanation of code. Size: 30

Level=30

EMPLOYEE_PREFERENCES

LEVEL_09_CODE

Size: 4

Level=30

EMPLOYEE_PREFERENCES

LEVEL_09_DESC

Detailed Explanation of code. Size: 30

Level=32

EMPLOYEE_PREFERENCES

LEVEL_10_CODE

Size: 4

Level=32

EMPLOYEE_PREFERENCES

LEVEL_10_DESC

Detailed Explanation of code. Size: 30

Loc Types: 08

EMPLOYEE_PREFERENCES

LOCATION_TYPE_01_CODE

Size: 1

Loc Types: 08

EMPLOYEE_PREFERENCES

LOCATION_TYPE_01_DESC

Detailed Explanation of code. Size: 30

Loc Types: 09

EMPLOYEE_PREFERENCES

LOCATION_TYPE_02_CODE

Size: 1

Loc Types: 09

EMPLOYEE_PREFERENCES

LOCATION_TYPE_02_DESC

Detailed Explanation of code. Size: 30

Loc Types: 10

EMPLOYEE_PREFERENCES

LOCATION_TYPE_03_CODE

Size: 1

Loc Types: 10

EMPLOYEE_PREFERENCES

LOCATION_TYPE_03_DESC

Detailed Explanation of code. Size: 30

Loc Types: 11

EMPLOYEE_PREFERENCES

LOCATION_TYPE_04_CODE

Size: 1

Loc Types: 11

EMPLOYEE_PREFERENCES

LOCATION_TYPE_04_DESC

Detailed Explanation of code. Size: 30

Loc Types: 12

EMPLOYEE_PREFERENCES

LOCATION_TYPE_05_CODE

Size: 1

Loc Types: 12

EMPLOYEE_PREFERENCES

LOCATION_TYPE_05_DESC

Detailed Explanation of code. Size: 30

Location Types (08, 09,10,11,12)

EMPLOYEE_PREFERENCES

ALL_LOCATION_TYPE_CODES

Size: 50

Location Types (08, 09,10,11,12)

EMPLOYEE_PREFERENCES

ALL_LOCATION_TYPE_DESCS

Detailed Explanation of code. Size: 50

Second Subject Level (34,36,38)

EMPLOYEE_PREFERENCES

ALL_2_LEVEL_CODES

Size: 50

Second Subject Level (34,36,38)

EMPLOYEE_PREFERENCES

ALL_2_LEVEL_DESCS

Detailed Explanation of code. Size: 50

Second Subjects (33,35,37)

EMPLOYEE_PREFERENCES

ALL_2_SUBJECT_CODES

Size: 50

Second Subjects (33,35,37)

EMPLOYEE_PREFERENCES

ALL_2_SUBJECT_DESCS

Detailed Explanation of code. Size: 50

Subjects: 13,15,17,19,21,23,25,27,29,31,33,35,37

EMPLOYEE_PREFERENCES

ALL_SUBJECT_CODES

Size: 50

Subjects: 13,15,17,19,21,23,25,27,29,31,33,35,37

EMPLOYEE_PREFERENCES

ALL_SUBJECT_DESCS

Detailed Explanation of code. Size: 50

02=1st Location

TRANSFER_REQUEST

LOCATION_01_CODE

Size: 4

02=1st Location

TRANSFER_REQUEST

LOCATION_01_NAME

Detailed Explanation of code. Size: 30

03=2nd Location

TRANSFER_REQUEST

LOCATION_02_CODE

Size: 4

03=2nd Location

TRANSFER_REQUEST

LOCATION_02_NAME

Detailed Explanation of code. Size: 30

04=3rd Location

TRANSFER_REQUEST

LOCATION_03_CODE

Size: 4

04=3rd Location

TRANSFER_REQUEST

LOCATION_03_NAME

Detailed Explanation of code. Size: 30

05=Low Level

TRANSFER_REQUEST

LOW_LEVEL_CODE

Size: 10

05=Low Level

TRANSFER_REQUEST

LOW_LEVEL_DESC

Detailed Explanation of code. Size: 30

06=High Level

TRANSFER_REQUEST

HIGH_LEVEL_CODE

Size: 10

06=High Level

TRANSFER_REQUEST

HIGH_LEVEL_DESC

Detailed Explanation of code. Size: 30

07=1st Subject

TRANSFER_REQUEST

SUBJECT_01_CODE

Size: 10

07=1st Subject

TRANSFER_REQUEST

SUBJECT_01_DESC

Detailed Explanation of code. Size: 30

08=2nd Subject

TRANSFER_REQUEST

SUBJECT_02_CODE

Size: 10

08=2nd Subject

TRANSFER_REQUEST

SUBJECT_02_DESC

Detailed Explanation of code. Size: 30

09=1st Position

TRANSFER_REQUEST

POSITION_01_CODE

Size: 10

09=1st Position

TRANSFER_REQUEST

POSITION_01_DESC

Detailed Explanation of code. Size: 30

10=2nd Position

TRANSFER_REQUEST

POSITION_02_CODE

Size: 10

10=2nd Position

TRANSFER_REQUEST

POSITION_02_DESC

Detailed Explanation of code. Size: 30

11=3rd Position

TRANSFER_REQUEST

POSITION_03_CODE

Size: 10

11=3rd Position

TRANSFER_REQUEST

POSITION_03_DESC

Detailed Explanation of code. Size: 30

12=1st Area

TRANSFER_REQUEST

AREA_01_CODE

Size: 4

12=1st Area

TRANSFER_REQUEST

AREA_01_DESC

Detailed Explanation of code. Size: 30

13=2nd Area

TRANSFER_REQUEST

AREA_02_CODE

Size: 4

13=2nd Area

TRANSFER_REQUEST

AREA_02_DESC

Detailed Explanation of code. Size: 30

14=Requested FTE

TRANSFER_REQUEST

REQUESTED_FTE

Size: 10 Format: ########.##

15=Years in Assign

TRANSFER_REQUEST

YEARS_IN_ASSIGN

Size: 10 Format: ########.##

16=Intent

TRANSFER_REQUEST

INTENT

Size: 10

17=Comment

TRANSFER_REQUEST

COMMENT

Size: 40

Sequence

TRANSFER_REQUEST

SEQUENCE

Size: 4

Year when transfer occurs

TRANSFER_REQUEST

TRANSFER_YEAR

Size: 4