Mainframe -- "3270" Crosswalk Table

A considerable amount of the historical data on the mainframe is available through UW Business Intelligence (UWBI) reports. The crosswalk table below identifies the new access locations for the "3270" transaction data. If you are unable to retrieve the data through UWBI, please contact your designated Affinity Group with any questions.

3270 Mainframe Cross Table - 11/12/18
 3270 Transaction  3270 Transaction Description  New Access Location(s)
 APCT  Appointment Percent History Inquiry: This screen displayed the total appointment percent levels for a requested period of time.  UWBI - Workforce: Job History or Jobs for a Given Date Range - reflects the max effective dated row for a job, including legacy InfoAccess appointments. Contains all appointment data as it existed in InfoAccess appointment tables.

IADS_BACKUP or microfiche - Contact your Affinity Group. IADS_BACKUP will contain more history than the UWBI reports.

 APDT  Appointment Dept Inquiry: This screen displayed how the appointment was shared, what department affiliation existed, Department FTE percents, and whether LOA was active.  UWBI - Workforce: Job History or Jobs for a Given Date Range - reflects the max effective dated row for a job, including legacy InfoAccess appointments.  Contains all appointment data as it existed in InfoAccess appointment tables.

IADS_BACKUP or microfiche - Contact your Affinity Group.  IADS_BACKUP will contain more history than the UWBI reports.
 APPI  Appointment Inquiry:  This screen displayed information for one selected appointment as of a requested date.  UWBI - Workforce: Job History or Jobs for a Given Date Range - reflects the max effective dated row for a job, including legacy InfoAccess appointments. Contains all appointment data as it existed in InfoAccess appointment tables.

IADS_BACKUP or microfiche - Contact your Affinity Group. IADS_BACKUP will contain more history than the UWBI reports.
 APPR  Appointment by Person Inquiry: This screen displayed Appointments for a specific person, Appointment Ids, Employment verification and Appointment update functions.  UWBI - Workforce: Job History or Jobs for a Given Date Range - reflects the max effective dated row for a job, including legacy InfoAccess appointments. Contains all appointment data as it existed in InfoAccess appointment tables.

IADS_BACKUP or microfiche - Contact your Affinity Group.  IADS_BACKUP will contain more history than the UWBI reports.
 APRH  Appointment Rate and Title History Inquiry: This screen displayed all changes in rate and title history from the “as of date” back to the earliest rate and title for the selected appointment.  UWBI - Workforce: Rate and Jobcode History - reflects rate and title history for jobs - including legacy InfoAccess appointments. Contains all rate and title history as reflected in InfoAccess tables.

IADS_BACKUP or microfiche - Contact your Affinity Group.
 APSABB  Appointment Sabbatical: This screen showed the percent a faculty appointment was on “paid” sabbatical for an appointment department.  UWBI - Workforce: Job History or Jobs for a Given Date Range - reflects the max effective dated row for a job, including legacy InfoAccess appointments. Contains all appointment data as it existed in InfoAccess appointment tables.

IADS_BACKUP or microfiche - Contact your Affinity Group. IADS_BACKUP will contain more history than the UWBI reports.
 APTNR  Appointment Inquiry: Department tenure inquiry. Displayed history of facaulty relation changes and history of tenure percent changes.  IADS_BACKUP or microfiche - Contact your Affinity Group.
 CNAM  Name Look Up: This screen allowed you to look up an employee phonetically when the SSN was unknown.  Phoentic search is not possible in Oracle P/S applications.  IADS_BACKUP or microfiche - Contact your Affinity Group.
 DNAM  Person Inquiry:  Name Look-up with SS#-no B/D.  IADS_BACKUP or microfiche - Contact your Affinity Group.
 PEIQ  Person Inquiry: This screen showed the same information as the INQY inquiry screen plus addresses, FTE, VISA, W4 date, and Employed County.  UWBI - Payroll: TXIQ or Payroll & Deductions  - combines HRS and legacy InfoAccess payroll, deduction and tax history.  InfoAccess data exists from December 1997 through April 2011. A separate report in UWBI - TXIQ - reflect payroll tax information from the InfoAccess database (from January 1998 through April 2011).

IADS_BACKUP or microfiche - Contact your Affinity Group.
 PHIQ  Payroll History Inquiry: Payroll History displayed payroll calculation history for an employee through various screens.  UWBI - Payroll: Payroll & Deductions or HRS Payroll History - combines HRS and legacy InfoAccess payroll, deduction and tax history.  InfoAccess data exists from December 1997 through April 2011.  A separate report in UWBI - TXIQ - reflect payroll tax information from the InfoAccess database (from January 1998 through April 2011).

IADS_BACKUP or microfiche - Contact your Affinity Group.
 PLAI  Classified Leave Inquiry: This screen showed year to date leave balances for a permanent or project classified employee.  UWBI - Absence: InfoAccess Classified Leave Balances, InfoAccess Classified Leave Changes and InfoAccess Classified Leave Usage - reflect classified leave balance, changes and usage from the October A 2006  through the April 2011 payroll calculation.

IADS_BACKUP or microfiche - Contact your Affinity Group.
 UCLI  Unclassified Leave Inquiry: this screen showed leave information for unclassified appointments. UWBI - Absence: InfoAccess Unclassified Leave-Active Pre-HRS, InfoAccess Unclassified Leave-Inactive Pre-HRS and InfoAccess Unclassified Leave Credit-Debit - reflect unclassified leave history from the June 1991 through the March 2011 payroll calculations.

IADS_BACKUP does not contain any unclassified leave history.  Data not available via UWBI - check microfiche - Contact your Affinity Group.
 UNAM  Person Inquiry: Name Look-up no SS#-no B/D. IADS_BACKUP or microfiche - Contact your Affinity Group.



Keywords:3270 transaction description new access location UW Business Intelligence UWBI   Doc ID:88844
Owner:Chris M.Group:DoIT Help Desk
Created:2019-01-04 12:32 CDTUpdated:2019-01-06 08:46 CDT
Sites:DoIT Help Desk
Feedback:  0   0