BI Publisher

Payroll

Crystal

Query

Click on View Crystal Documents to see the posted documents off the OTS Training Website:

• Pro-Clarity Reporting Basics (PDF)

• Pro-Clarity Common Terms (PDF)

• Pro-Clarity Advanced Report Writing (PDF)

Payroll Query Simulated Tutorial in HTML Format (UPK)    Index

• Payroll: Locate Uncalculated Paylines (Simulated HTML)
  

• Payroll: FICA Student Workers Less Than 6 Credits (Simulated HTML)
  

• Payroll: Job Records Missing TU INFO Tab Data (Simulated HTML)
  

• Payroll: Finding Towson Job History on Employee (SImulated HTML)
  

• Payroll: Pay Other Earnings Record (Simulated HTML)

• Payroll: Pay US Tax (Simulated HTML)

• Payroll: Payable Time Status (Simulated HTML)

• Payroll: Locate Contract Employees with Most Recent Job Info (Simulated HTML)

• Payroll: Contract Employee Addl Pay Most Recent Job (Simulated HTML)

• Payroll: Contract Employee Addl Pay with Active Job (Simulated HTML)

• Payroll: CRG Active No Longer Contract (Simulated HTML)

• Payroll: CRG Inactive No Longer Contract Employ (SImulated HTML)

Payroll                                                                                                  Index   

• Payroll Hierarchy Relationships (VISIO PDF)

• Payroll Query Tables (EXCEL)

Payroll: Visio Documents of Pages:

• Personal Data: Personal Profile Page (Visio PDF)
  Personal Data: Name Page (Visio PDF)
  Personal Data: Eligibility /Identity Page (Visio PDF)
  Personal Data: Address Page (Visio PDF)
  Job Data: Work Location Page (Visio PDF)
  Job Data: Salary Plan Page (Visio PDF)
  Job Data: Payroll Page (Visio PDF)
  Job Data: Job Labor Page (Visio PDF)
  Job Data: Job Information Page (Visio PDF)
  Job Data: Job Earnings Distribution Page (Visio PDF)
  Job Data: Compenstion Page (Visio PDF)
  Employment Data: Employment Information Page (Visio PDF)
  Employment Data: Employment Dates Page (Visio PDF)
  Benefits Program Participation Page (Visio PDF)

Query Simulated Tutorial in HTML Format (UPK)                             Index

• PeopleSoft Query Simulated Tutorial Outline
  

• Query Manager Basics Training Guide (PDF)

• Run An Existing Query Using Query Viewer (PDF)

• Run An Existing Query Using Query Manager (PDF)

• Downloading Queries to Excel and CSV Files (PDF)

• Scheduling a Query in Process Scheduler (PDF)

• Making a Query Distinct (PDF)

• Renaming Queries (PDF)

• Deleting Queries (PDF)

• Effective Date Criteria (PDF)

Query: Defining Criteria                                                                         Index

• Specifying Effective Date Criteria (PDF)

• Applying Aggregate Functions (PDF)

• Creating A Query Using Having Criteria (PDF)

Query: Advanced Options                                                                     Index

• Creating Record Hierarchy Joins (PDF)

• Creating Record Joins (PDF)

Student Records Query Simulated Tutorial in HTML Format (UPK) Index

• Student Records: Enrollment Transcript Audit TU_SR_DD_AUD (SImulated HTML)
  

• Student Records: FT Deans List Prompt by Term (Simulated HTML)

• Student Records: Counts of Enrollment Appointments (Simulated HTML)

• Student Records: Checks Student Term Activated (Simulated HTML)

• Student Records: SAOFF Student Transcript Request (Simulated HTML)

• Student Records: Repeat Grade Report Prompt by Term (Simulated HTML)