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

PTF Benefit Eligibility Report

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

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 jobs, 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

  1. Click Search to default in a run control, or Add a New Value if this is the first run by the user for this report.
Add a New Value tab
  1. Select the Company Code using the lookup
  2. Use the radio buttons to select one of the following conditions (separate runs must be performed for each condition)
    • PTF employees listed as Eligible but should be ineligible
    • PTF employees listed as Ineligible but should be eligible
    • PTF employees listed as Ineligible but may be eligible
  3. Click Run
  4. Use the Process Monitor to wait for the process CTC_BNELG_AE to show Success/Posted
    • NOTE: This can take a while, as there is a lot of information for it to process, anywhere up to and including 30 minutes

 

Process Request Parameters section
  1. Click Go back to PTF Benefit Eligibility Report at the bottom of the Process Monitor
  2. Click Report Manager at the top of the page
  3. Click CTC_BEN_ELG  CTC_BEN_ELG.pdf
  4. Click CTC_BEN_ELG.pdf
  5. The report lists the following fields for every applicable employee:
    • Name, Emplid, Winter/Fall/Summer/Spring 20XX (past 2 years of quarters) %FT Elig

PTF YRQ History Detail List

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

  1. Click Search to default in a run control, or Add a New Value if this is the first run by the user for this report.
Add  a New Value tab
  1. Select the Company code using the lookup.
  2. 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
  3. If Quarter Range is chosen, a Begin Term and an End Term must be specified using the lookup.
  4. 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.
  5. Click Run.
  6. Use the Process Monitor to wait for the process CTC_YRQ_AE to show Success/Posted.
Process Request Parameters section
  1. Click Go Back to PTF History Detail List at the bottom of the Process Monitor.
  2. Click Report Manager at the top of the page.
  3. Click CTC_PTFYRQ  CTC_PTFYRQ.pdf
  4. Click CTC_PTFYRQ.pdf
  5. The report lists the following fields for every applicable employee:
    • Name, Emplid, YQR, Ben Pgm, Con Unit, % Full Time, Full Time Rate
    • It will list under YQR ever Quarter included in the Begin and End Quarter Range

 

PTF LTD Salary Base Calc Report

Nagivation:  Main Menu > Benefits > CTC Custom > PTF LTD Report

  1. Click Search to default in a run control, or Add a New Value if this is the first run by the user for this report.
Add a New Value tab
  1. Select Company code using the lookup.
  2. As Of Date will default to the system date, change it if there is a different as of date that is of interest.
  3. Choose one of the following radio buttons:
    • All Active PTF
    • Active PTF with Opt LTD
    • Emplid(s)  (EMPLIDs must be supplied by the user under this option)
  4. Click Run.
  5. Use the Process Monitor to wait for the process CTC_PTFLTDAE to show Success/Posted.
Process Request Parameters section
  1. Click Go Back to PTF LTD Salary Base Calc at the bottom of the Process Monitor.
  2. Click Report Manager at the top of the page.
  3. Click CTC_PTF_LTD  CTC_PTF_LTD.pdf
  4. Click CTC_PTF_LTD.pdf
  5. The report lists the following fields for the applicable employees:
    • Name, Emplid, Emp Type, Empl Rcd, Ben Pgm, LTD Plan
    • For QTR1/2/3  Wages, Salary Base
    • Every EMPLID has a line with the total Wages and Salary Base for all jobs combined for that college