Versions Compared

Version Old Version 95 New Version 96
Changes made by

Adam Lenter

Adam Lenter

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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
              • Phone Number (textbox - phone number format - required)
              • Email Address (textbox - email address format - required)
            • Education History (section heading)
              • Section break
                • Replicate Block
                • No minimum or maximum number of rows
                • Replicate Title: Additional Degrees
                • Insert label: Add an additional degree
                • Row label: Degree
                • Include the following fields:
              • Type of Degree (BA, BS, MS, PhD, etc.) (textbox - required)
              • Date Received (date - required)
              • Institution Name (textbox - required)
              • Location (City, State) (textbox - required)
              • Section break
            • Student Status (Section heading)
              • Are you a current student at Columbia Teacher's College, or Barnard? (option buttons: yes, no - required)
              • If yes, include the following fields:
                • In which school are you enrolled?  (option buttons: Columbia University, Teacher's College, Barnard - required)
                • What type of degree program are you currently enrolled in? (option buttons: Undergraduate, Graduate, Doctorate/terminal - required)
                • Are you enrolled full-time (12+ credits) for the semester you will be working? **Half-time enrollment is NOT considered full-time (option buttons - yes, no - required)
              • If you are a current student, when is your expected graduation date? (Columbia confers degrees in February, May, and October) (date - month/year - required)
            • Columbia Employment (Section heading)
              • Will you be employed in any other department or program at Columbia Universityduring the semester you will be working for SPS? (Option buttons: yes/no - required)
              • If yes, include the following fields:
                • In what capacity will you be employed? (option buttons - see current form for list - required)
                • What is your title (textbox - required)
                • What School and Department will your other position be in? (textbox - required)
                • Who is the HR Contact for this position? (Full Name and Email) (textbox - required)
            • Past Columbia Employment (section heading)
              • Have you ever been employed by Columbia? (Option buttons: yes/no - required)
              • If yes, include the following fields:
                • What was your title? (textbox - required)
                • Approximately when did you receive your last paycheck? (date - month/year - required)
                • What School and Department did you work for? (textbox - required)
                • Who was the HR contact for this position? (Name and Email) (textbox - required)
            • Document Upload
              • Upload Resume/CV.
            • Policy Agreement (section heading)
              • Lecturers and Associates are eligible to teach up to three courses per year, but no more than two courses per semester. This includes all courses across Columbia University, including those in other departments/schools. By selecting yes below, you agree that you will not violate this policy. (option buttons: yes/no - required)
              • Students cannot hold more than 1 Officer Position (e.g. TA, Teaching Fellow, etc.) at a time, and may not work more than a total of 20 hours per week across all jobs in which you are employed by Columbia University. By selecting yes below, you agree that this position with SPS will not violate this policy. (option buttons: yes/no - required)

        • New Instructor Record Request Form

          • Require SSO to complete

          • Components:
            • Email address (textbox - read-only)
            • Role (Option buttons: Instructor, Advisor - required)
            • First name (textbox - read-only)
            • Middle name (textbox - read only)
            • Last name (textbox - read only)
            • UNI (textbox - read only)
            • Department (select: see original form for list - required)

            • Instructor/Advisor YEAR of birth - 4 digit year of birth. If not provided, this may be requested. Not required for active graduate and undergraduate TAs. (textbox - integer format - required)

    • Create checklists that faculty leadership can mark as received for the following items: