Reports Flashcards
What do you use EKDT for?
First employment date
What do you use ENSS for?
Look up employee numbers by SSN or name, review if member had multiple employee number
What do you use JTIP for?
Employment dates, sub-item and salaries up to 1990
JHIST
Employment dates, sub-item and salaries from 1990 to 3/31/2010
JINQ
start to end dates for sub items if they changed position (temp to permanent, change from general to safety…) (FOR CWPTAPPS)
PHRQ
Employee pay History info.
EPM
Check termination date and employment status: A = active or T = terminated; date of birth
QJIN
Summary of member’s employment history, items, and date ranges (FOR E-HR)
TEHW
Employee’s Timecard per pay period available from 4/1/2012 to current.
QRTE
History of salary through the years.
QSAL
pay period specifically that you’re looking for. Break down by hourly, and any other item that the employee is being paid on.
CENTRAL PERSONNEL RECORDS - EMPLOYEE HISTORY
Listed Alphabetically, showed hire date, salary, term date, employee number from 1920 - 1979
CENTRAL PERSONNEL RECORDS - ATTENDANCE RECORD
Listed by employee number, showed time worked and time absent from 1920 - 1979
Employee Sequence Payroll Register
Listed by employee number, show payroll date, job item, hire & term date, scheduled and actual earnings (from 12/31/77 - 3/31/10)
TIPPS
Listed by last name, show employment history from early 1970s to 1990