Part-Time Faculty Benefits Reports

Purpose:  Use this document as a reference for using the custom reports for part-time faculty benefits information in ctcLink.

Audience:  Benefits Administrator.

You must have at least one of these local college managed security roles:

  • ZD Benefits Reporting

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

NOTE: This report will total all FWL FTE’s from both Job and FWL to generate one totaled FTE.  Any jobs in Job Data that have an EMPL CLASS of Part Time Faculty will not be considered for Job purposes (as they are being taken from FWL), but any other Job Data that contains an EMPL CLASS outside of that will be added in.

For instance, if a PTF employee has three (3) jobs, two (2) of them with an EMPL CLASS of Part Time Faculty and one with an EMPL CLASS of Hourly, then it will add the FTE from FWL which contains the Contract Types that have the Benefit Eligibility box checked in FWL but will also add the Hourly Job’s Job Data FTE.

This means for PTF to correctly be represented on this report, all non-PTF EMPL CLASS Jobs must have a correct FTE maintained in Job Data.

PTF Benefit Eligibility Report

Navigation:  Benefits > CTC Custom > CTC Reports > PTF Benefit Eligibility Report

  1. The PTF Benefit Eligibility Report run control search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Institution, Admissions Letter, Summer, FYR Admit Type).
  3. The PTF Benefit Eligibility Report page displays. On the page, select the Company Code using the lookup icon.
  4. Use the radio buttons to select one of the following conditions (separate runs must be performed for each condition):
  5. PTF employees listed as Eligible but should be ineligible.
  6. PTF employees listed as Ineligible but should be eligible.
  7. PTF employees listed as Ineligible but may be eligible.
  8. Select the Run button.
PTF Benefit Eligibility Report
  1. The Process Scheduler Request page displays.
  2. Please refer to the Process Schedule Request steps for further instructions.
  3. Select Go back to PTF Benefit Eligibility Report at the bottom of the Process Monitor.
  4. Select Report Manager at the top of the page.
  5. Please refer to the Report Manager steps for further instructions.
  6. Select CTC_BEN_ELG  CTC_BEN_ELG.pdf. And then select CTC_BEN_ELG.pdf.
  7. The report lists the following fields for every applicable employee:  Name, Empl ID, Winter/Fall/Summer/Spring 20XX (past 2 years of quarters) %FT Elig.
PTF YRQ History Detail List

Navigation:  Benefits > CTC Custom > CTC Reports > PTF YRQ History Detail List

  1. The PTF YRQ History Detail List run control search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Institution, Admissions Letter, Summer, FYR Admit Type).
  3. The PTF YRQ History Detail List page displays. Select the Company code using the lookup.
  4. Select one of the radio buttons: All Years/Quarters  (this should rarely be used as it will take a long time to process), Quarter Range.
  5. If Quarter Range is chosen, a Begin Term and an End Term must be specified using the lookup.
  6. NOTE:  There is a check box at the bottom of the page which defaults to unchecked that, when checked, will include all jobs.  The default (unchecked) only looks at PTF jobs.
  7. Select the Run button.
PTF YRQ History Detail list run control page
  1. The Process Scheduler Request page displays.
  2. Please refer to the Process Schedule Request steps for further instructions.
  3. Select Go Back to PTF History Detail List at the bottom of the Process Monitor.
  4. The PTF History Detail List page displays.
  5. Select the Report Manager link.
  6. Please refer to the Report Manager steps for further instructions.
  7. Select CTC_PTFYRQ  CTC_PTFYRQ.xlsx.
  8. The report lists the following fields for every applicable employee:  
    1. Name, Empl ID, YQR, Ben Pgm, Con Unit, % Full Time, Full Time Rate.
    2. It will list under YQR every Quarter included in the Begin and End Quarter Range.

Process complete.

PTF LTD Salary Base Calc Report

Navigation:  Menu > Benefits > CTC Custom > PTF LTD Report

  1. The PTF LTD Salary Base Calc Report run control search page displays.
  2. If you have run this process or report in the past, select the Find an Existing Value tab to enter an existing Run Control ID and select the Search button. If this is the first time running this process or report, select the Add a New Value tab to create a new Run Control ID and select the Add button. 
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Institution, Admissions Letter, Summer, FYR Admit Type).
    • The PTF LTD Salary Base Calculation Report page displays.
  3. Select Company code using the lookup.
  4. As Of Date will default to the system date, change it if there is a different as of date that is of interest.
  5. Choose one of the following radio buttons: All Active PTF, Active PTF with Opt LTD.
  6. Empl ID(s) - (Empl IDs must be supplied by the user under this option).
  7. Select the Run button.
PTF LTD Salary Base Calc Report run control page
  1. The Process Scheduler Request page displays.
  2. Please refer to the Process Schedule Request steps for further instructions.
  3. Select Go Back to PTF LTD Salary Base Calc at the bottom of the Process Monitor.
  4. The PTF LTD Salary Base Calculation Report page displays.
  5. Select Report Manager at the top of the page.
  6. Please refer to the Report Manager steps for further instructions.
  7. Select CTC_PTF_LTD  CTC_PTF_LTD.pdf.
  8. The report lists the following fields for the applicable employees:
    1. Name, Empl ID, Emp Type, Empl Rcd, Ben Pgm, LTD Plan.
    2. For QTR1/2/3  Wages, Salary Base.
    3. Every Empl ID has a line with the total Wages and Salary Base for all jobs combined for that college.

Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.