Red Rover Export

Modified on Tue, Oct 1 at 6:49 AM

About

This task creates two files that are exported to Red Rover.

staffDemographics.csv

1 Row is created in this file for each Location that an employee has on the demographics page.

If an employee has 3 locations, there will be 3 rows for that employee in this file.

ColumnSample DataDescription
Role

Employee

Substitute if substitute flag set on demographics page.
If not, Employee.
Identifier1234Staff Id
LastNameMouseStaff Last Name
FirstNameMickeyStaff First Name
MiddleNameTheodoreStaff Middle Name
ActiveYesStaff.employmentStatus.. Active=Yes.  Any other value of employeStatus will be blank in the file.
Emailmmouse@disney.comStaff primary email address (First email on the Staff Contact by seq)
Phone908-555-1212Staff primary phone (First phone number on the Staff Contact by seq)

Unscheduled Location

005If Unscheduled Location is checked on demographics, it is the location code.
HoursPerDay4.2Hours per day from the salary guide on the position tracking.  This value is then scaled to the FTE of the position tracking record.
ContractId10CALIf the employee has no red over days setup (am/pm/full) for the location on the demographics tab, then the red rover contract id or calendar code is used for the Staff Attendance Calendar.

If the employee has at least one red over days setup (am/pm/full) for the location on the demographics tab, then the calendar code is used for the Staff Attendance Calendar.
Position Schedule Mode IDUnscheduledIf Unscheduled Locations on the Staff Demographics page is checked, the word Unscheduled will be used.

If it is not checked, the location code is used.
PositionTypeIdBUILDSUBPrimary Department Code on the Staff Demographics page
TitleScience TeacherText in the Job Title drop down on the Staff Demographics page.
LocationId099If Unscheduled Locations is checked on the Staff Demographics page, this value will be blank.
Other wise it Location Code
BellScheduleId070If no red rover days are configured (am/pm/full), then the Bell Schedule code is used from the dropdown in the Edit Location popup.  If that value is blank, this field will be blank.

If at least one day is configured, then the red rover bell schedule code is used; if that value is blank, it will use the location code instead.
DaysofWeek

Mon,Tue,Wed,Thu,Fri

If Unscheduled Location is checked, this field will be blank.
Otherwise it will contain the days of the week the person is scheduled.
StartPeriodIdMorningMorning if the person is assigned am days
Afternoon if the person is assigned pm days
EndPeriodIdAfternoonMorning if the person is assigned am days
Afternoon if the person is assigned pm days
SupervisorIdentifier8491The staff ID of the staff member with the organizational relationship of ABSENCE.
SupervisorNameMouse, MinnieThe Full Name of the staff member with the organizational relationship of ABSENCE.
FallbackSupervisorIdentifiers7144The staff ID of the staff member with the organizational relationship of ABSENCE2.
QualifiedForPaidHolidaysYESAlways YES
QualifiedForPTOYESAlways YES

Badge Number

2897Swipe Pin Number on the Staff Demographics page

absenceReasonBalances.csv

This file contains one row per Attendance Balance Record (StaffAttendanceBalance) per Staff member.

ColumnSample DataDescription
Identifier
1234Staff Id
AbsenceReasonId
FL
Balance Code (As defined on the Setup.Calendars.Balance Codes screen)
AbsenceReasonCategoryId

Always Blank
AsOfDate
9/1/2030Date of hire (Staff Demographics Tab) OR 7/1 of the current school year if Date of HIre is after 7/1.

The intention is to have the balance as of the first day of school in the school year.
Balance
24.5Value in the Original column
BalanceType
DailyAlways Daily

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article