Content Comparison

...

• Data Feeds
  • Faculty Core Records
    • Create full and incremental exports of faculty core data, combining PAC table with data warehouse tables
      • Store on H: drive through Crystal
      • Script daily transport to SFTP on Slate
      • Configure source format to import when file is dropped daily
  • Faculty Teaching
    • Create full and incremental exports of faculty teaching data, combining SIS tables with data warehouse tables
      • Store on H: drive through Crystal
      • Script daily transport to SFTP on Slate
      • Configure source format to import when file is dropped daily
  • Faculty Positions
    • Create full and incremental exports of faculty teaching data, combining PAC table with data warehouse tables
      • Store on H: drive through Crystal
      • Script daily transport to SFTP on Slate
      • Configure source format to import when file is dropped daily
• Landing Page
  • Faculty by Program - Create a chart with the following features:
    
    • Base: Person
    • Filter to include only faculty members with employment status of "Active - Full Time" or "Active - Part Time."
    • Create two columns:
      • Teachers - Filter for people with a status that is not in "Associate."
      • Associates - Filter for people with a status that is in "Associate."
    • Group by primary department.
  • Faculty by Rank - Create a chart with the following features:
    
    • Base: Person
    • Filter to include only faculty members with employment status of "Active - Full Time" or "Active - Part Time."
    • Group by Status.
  • Full-Time vs. Part-Time - Create a chart with the following features:
    
    • Base: Person
    • Filter to include only faculty members with employment status of "Active - Full Time" or "Active - Part Time."
    • Group by Employment Status.
• Hiring Checklist
  
  • Create an application period (Hiring) and round (2023) within Slate:
    • Create the following forms with a scope of Application Pages 
      
      • Instructional Eligibility Form
        • Components:
          • Instructor's name (textbox - required)
          • SPS program name (textbox - internal)
          • Course # and name (textbox - internal)
          • For credit (option buttons: Yes, No - internal)
          • Number of points (textbox - real numbers format - internal)
          • Start date (date - internal)
          • End date (date - internal)
          • Days and time (textbox - internal)
          • Title (option buttons: Lecturer, Associate - internal)
          • Compensation (textbox - internal)
          • Did you teach, are you teaching, or will you teach another course in addition to
            the above mentioned course during this academic year (July 1, 2023 – June 30,
            2024)?(This includes courses at SPS and in other departments/schools at the
            University) (Option buttons: Yes, No - required)
          • The following components should only display If Yes is selected for the above field:
            • Section break
              • Instructions: In addition to the course mentioned on this page, I have also taught or plan to teach the following course(s) during the academic year across the University:
            •  Section break
              • Replicate Block
              • No minimum or maximum number of rows
              • Replicate Title: Additional Courses
              • Insert label: Add an additional course
              • Row label: Course
            • Term (select: Summer 2023 (July, August), Fall 2023 (September – December), Spring 2024 (January – May), June 2024 - required)
            • School name (textbox - required)
            • Program name (textbox - required)
            • Course number (textbox - required)
            • Course name (textbox - required)
            • For Credit (option buttons: Yes, No - required)
              • If Yes: # of points (textbox - real numbers required)
            • Start date (date - required)
            • End date (date - required)
            • Day/time (textbox - required)
          • Section break
          • Please indicate if you had or will have an appointment with the SPS Faculty Assessment & Development
            department, this includes instructional roles with the Pedagogical Lab, conducting Faculty
            Peer Observations and Consultations, delivering Faculty Development Workshops, or facilitating Faculty Forums) during this academic year (July 1, 2023 – June 30, 2024) (option buttons - Yes, No - required)
        • The following components should only displayed if Yes is selected for the above field:
          • Section break
            • Replicate Block
            • No minimum or maximum number of rows
            • Replicate Title: SPS Pedological Lab Appointments
            • Insert label: Add an additional appointment
            • Row label: Appointment
            • Include the following fields:
              • Role (textbox - required)
              • Term (textbox - required)
      • Personnel Information Form 
        • Components:
          • This form will allow SPS Faculty Affairs to determine the hiring documents needed for your appointment. Please complete these questions to the best of you ability. (instruction)
          • Basic Contact Information (Section heading)
          • Email address (textbox - email address format - required)
          • First name (please provide full legal name) (textbox - required)
          • Last name (textbox - required)
          • What program will you be teaching with? (option buttons - required)
          • If you already have a UNI, please list it below (textbox)
          • Phone number (textbox - phone format - required)
          • Home address (address - required)
          • Mailing address (address - required)
          • Other Personal Information (Section heading)
          • Sex (option buttons: Male, Female - required)
          • Date of Birth (date - required)
          • Ethnicity (option buttons: White, Black, Hispanic, Asian/Pacific Islander, East Indian/Indian Subcontinent, I choose not to disclose - required)
          • Military Report Status - No military service, Not a veteran, Veteran, Newly separated veteran, Vietnam era veteran, Special disabled veteran, Other protected veteran, I choose not to disclose - required)
          • Marital Status (Option buttons: Single, Married, Separated, Divorced, Widowed - required)
          • If Martial status

...

• • • • • • is married, separated, or divorced:
          • Effective date (date - required)
          • Work Eligibility: Non-US citizens will be required to provide copies of their work authorization documents in addition to payroll paperwork. Documents requested may include PR Card, EAD Card, I-20, I-94, DS-2109, Passport, and current Visa. (instruction)

...

• • • • • • Please select your current status (option buttons: US Citizen, Permanent resident, EAD Card, F-1 Visa, J-1 Visa, Other)
          • If status

...

• • • • • • is "other," include the following field:
          • Other status (textbox - required)

Emergency Contact Information (section heading)
First & Last Name (textbox - required)
Relationship (to you) - textbox

...