Versions Compared

Version Old Version 108 New Version 109
Changes made by

Bryon Vaughn

Bryon Vaughn

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:
        • Instructors - 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 Period "Fall - Summer" (Key=AY24, Year=2024) and Rounds "Faculty New Hire" and "Faculty Re-Hire"
      • Use existing application forms and fields where collected values align
        • Personal Background (Slate form)
          • Name: First, Last, Preferred
          • Email
          • Home and Mailing Address
          • Phone
          • Sex
          • Date of Birth
          • Ethnicity + Race
        • Academic History
          • Institution, Degree Type, Date, Location
        • Employment History
          • Q: Should we use Use the employment forms form to capture this info in more details than just the resume?
        • Activities and Distinctions
          • Q: Should we use Use the activity forms form to capture this info in more details than just the resume?
      • Use custom forms to collect additional information
        • FORM: Other Personal Information
          • 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)
          • Emergency Contact (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)FORM: 
        • FORM: Employment Eligibility
          • What program will you be teaching with? (option buttons - required)
          • If you already have a UNI, please list it below (textbox)
          • 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 enter 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)
          • 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 University during 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)
          • 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)
      • Update custom instructions on all forms in coordination with FA team
      • Update the login page to show SSO login link for re-hires, or any user with a valid CU login
        • Continue with local account for new hires without UNI
      • Person-scoped form(s)

        • New Instructor Record Request Form

          • Require SSO to complete

          • Fields:
            • 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 (drop-down: 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 checklist groups and checklist items by application type
      • Group: All (for all applications)
        • Resume/CV (upload)
        • Permission Form
        • Signed offer letter
        • NYS 195.1
        • Tax forms,
        • Visa documents (if necessary)
        • Ethnicity forms
        • I-9
        • Faculty ID card received
        • UNI activation confirmed
        • Faculty active in PAC
      • Group: New Hire
      • Group: Re-Hire
    • Create an automated email triggered by confirmation that faculty is active in PAC to send:
      • Direct deposit setup information
      • Payroll calendar
      • Faculty self-service

...