Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Salary Certificate for Parttime Job

VIEWS: 41 PAGES: 31

Salary Certificate for Parttime Job document sample

More Info
									                                                                                                                                                         Human Capitol Management Toolkit




                          QUERY DESCRIPTION                            LONG DESCRIPTION                          TYPE     QUERY NAME                                   PROMPTS                       RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                                                FREQUENCY

Benefits
    Leave Accrual
                          Accrued Sick/Vac                             Accrued Sick/Vac                          Query    GO_BB_LEAVE_ACCRUALS                         Company                       On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                          Accrued by Sick Leave or Vacation            Accrual report by leave type and range    Query    GO_BB_LEAVE_ACCRUALS_BY_TYPE                 Company,Plan Type, Process    On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       of process dates                                                                                Date Range
                          Annual Leave Balance                         Annual Leave Balance w/ hourly rate       Query    GO_BB_ANNUAL_BAL_WITH_HRLYRATE               Agency                        On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       and years of service                                                                            Last Accrual Date
                          List of EE with benefit allow                List of Employee with Benefit Allowance   Query    GO_BB_BENEFIT_ALLOWANCE_TOTAL                Company                       On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       Total
                          Leave Summ Rep by Accrual Date               Leave Summ Rep by Accrual Date            Query    GO_BB_LEAVE_SUMMARY                          Agency                        On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                                       Last Accrual Date
                          Leave by Empl                                Leave by Empl                             Query    GO_BB_LEAVE_TKN_BY_EMPLID                    EmplID                        On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                                       Plan Type (50=Sick,51=Annl,
                                                                                                                                                                       SHARED)

                          Leave/Svc Dt & Loc                           Leave/Svc Dt & Loc                        Query    GO_BB_LEAVE_WITH_SERV_DATE_LOC               Company                       On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                                       Plan Type
                          Leave Accruals                               Leave Accruals                            Report   Emp Leave Accrual Rpt (0053)                                               Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES>OK REPORTS >
                                                                                                                                                                                                                               BENEFITS
                          Retirement by Payrun ID                      Retirement report with calculated base.   Query    GO_BB_RETIREMENT_BY_PAYRUNID                 Payrun ID                     On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       Prompt by payrun ID and Company.                                                                Agency

                          Retirement - Active Job with No Retirement   Retirement - Active Job with No           Query    GO__BB_RTRMNT_ACTIVE_JOB_NO_RET              Agency                        On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                          Plan                                         Retirement Plan
                          Retirement Plan By Co for OPERS                                                        Query    GO_BB_RTRMNT_PLAN_BY_CO_OPERS                Agency                        On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                          Retirmement Plan by CO all others            Retirmement Plan by CO other than         Query    GO_BB_RTRMNT_PLAN_BY_CO_OTHER                Agency                        On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       OPERS
                          Teachers Retirement                          Current deductions for plan types 70,     Query    GO_BB_TEACHERS_RET_QUERY                     Company                       Each Payroll Processing   MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       7Y, 7Z                                                                                          Pay End Date
                          SROPC Retirement                             EE Elig for SROPC Not Enrolled            Query    GO_BB_SROPC_RET_PLAN_BY_JOBCD                                              On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                          SROPC Retirement                             Elig for SROPC but in OPERS               Query    GO_BB_SROPC_RET_PLAN_BY_JOBCD2                                             On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER

    Retirement Plans
                          Retire Plan by Agency - SSN                  Retire Plan by Agency - SSN               Query    GO_BB_CONV_RETIREMENT_PLANS                  Company                       On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                          Retire Plan by Agency - SSN with Division    Retire Plan by Agency - SSN with          Query    GO_BB_CONV_RETIREMENT_PLNS_DIV               Company                       On Demand                 MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       Division




7/22/2011
Revised: April 12, 2010                                                                                                                                                 1                                                                                                    D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                 Human Capitol Management Toolkit




                          QUERY DESCRIPTION      LONG DESCRIPTION                           TYPE     QUERY NAME                                PROMPTS                        RECOMMENDED                  NAVIGATION
                          REPORT NAME                                                                                                                                         FREQUENCY

Human Resources
    Audits
                          Action History         Returns list of employees who have had     Report   Personnel Actions History                 Language (default is English;    Agency HR: As required     MAIN MENU > WORKFORCE ADMINISTRATION > JOB INFORMATION
                                                 the Action (or Actions) that was                                                              keep default)                                               > REPORTS
                                                 established by Effective Date and                                                             From Date
                                                 Action parameter on the Run Control                                                           End Date
                                                                                                                                               From Company
                                                 Output is Agency Number/Description,                                                          To Company
                                                 Effective Date, Action/Reason, Empl                                                           (and in the Scroll Area)
                                                 Name, Empl ID, Hire Date, Yrs of Svc,                                                         Action (at least one Action must
                                                 Empl Type, Reg/Temp, Full/Part, Job                                                           be selected; you can insert
                                                 Code/Title, and if selected will include                                                      multiple rows)
                                                 Compensation Components (Comp
                                                 Rate Code(s), and Frequency




                          Actions Prompt         Returns all Job Data rows for              Query    GO_HR_ACTIONS                             Company                        Agency HR: As needed         MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                 employees) who have the Action by the                                                         Action                         based on internal business
                                                 From/To Eff Date range selected during                                                        From Effective Date            requirements
                                                 the Prompt                                                                                    To Effective Date

                                                 If the employee has one or more rows
                                                 for that Action, all rows will return

                                                 Recommend downloading into CSV or
                                                 Excel

                          Actions by Initiator   Returns all Job Data rows for              Query    GO_HR_ACTIONS_BY_INITIATOR                Company                        Agency HR: As needed         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                 employees) who have the Action by the                                                         From Effective Date            based on internal business
                                                 From/To Eff Date range selected during                                                        To Effective Date              requirements
                                                 the Prompt sorted by Initiator ID.

                                                 Recommend downloading into CSV or
                                                 Excel

                          All Actions            Returns all Job Data rows for              Query    GO_HR_ALL_ACTIONS                         Company                        Agency HR: As needed         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                 employees) who have the Action by the                                                         From Effective Date            based on internal business
                                                 From/To Eff Date range selected during                                                        To Effective Date              requirements
                                                 the Prompt

                                                 ID, Name, Empl Rcd#, Eff Dt, Eff Seq#,
                                                 Action, Reason, Position, Status, Dept,
                                                 Location, Jobcode, Empl Class,
                                                 Division, Spec Use1, Spec Use2, Comp
                                                 Rate, Comp Freq, Chg Amt, Chg Pct




7/22/2011
Revised: April 12, 2010                                                                                                                         2                                                                                                        D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                   Human Capitol Management Toolkit




                          QUERY DESCRIPTION              LONG DESCRIPTION                          TYPE    QUERY NAME                            PROMPTS               RECOMMENDED                  NAVIGATION
                          REPORT NAME                                                                                                                                  FREQUENCY
                          Audit All Actions              Returns all Job Data rows for             Query   GO_HR_AUD_ALL_ACTIONS                 Company               Agency HR: As needed         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                         employees) who have the Action by the                                                   From Effective Date   based on internal business
                                                         From/To Eff Date range selected during                                                  To Effective Date     requirements
                                                         the Prompt

                                                         Co, ID, Name, Empl Rcd#, Eff Dt, Eff
                                                         Seq#, Action, Reason, Position, Status,
                                                         Dept, Location, Loc Name, Jobcode,
                                                         Jobtitle, Empl Class, Division, Spec
                                                         Use1, Spec Use2, Comp Rate, Comp
                                                         Freq, Chg Amt, Chg Pct

                          Audit Appointment Data Entry   Returns all Appointments ('A' Reasons)    Query   GO_HR_AUDIT_APPOINTMENT_ENTRY         Company               Agency HR: Weekly to         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                         entered within a certain time period                                                    From Action Date      validate employee data
                                                         (i.e., dates between 01/01/06 to                                                        To Action Date
                                                         03/01/06)                                                                                                     Agency HR should hand off
                                                                                                                                                                       to Agency Payroll
                                                         Includes information from Job Data,
                                                         MDC Job Data, Employment

                          Audit Appointments             Returns all Appointments ('A' Reasons)    Query   GO_HR_LIST_APPOINTMENTS               Company               Agency HR: Weekly to         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                         for a certain time period (i.e., dates                                                  From Effective Date   validate employee data
                                                         between 01/01/06 to 03/01/06)                                                           To Effective Date
                                                                                                                                                                       Agency HR should hand off
                                                         Includes information from Job Data,                                                                           to Agency Payroll
                                                         MDC Job Data, Employment, and
                                                         Earnings Distribution

                          Audit Certified Apointments    Returns all Appointments ('A' Reasons)    Query   GO_HR_LIST_CERT_APPOINTMENTS          Company               Agency HR: Weekly to         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                         for a certain time period (i.e., dates                                                  From Effective Date   validate employee data
                                                         between 01/01/06 to 03/01/06)                                                           To Effective Date
                                                                                                                                                                       Agency HR should hand off
                                                         Includes EmplID, Name, Effdt, Action,                                                                         to Agency Payroll
                                                         Reason, Postion, DeptID, Location,
                                                         Jobcode, Reg/Temp, Full/Part, Empl
                                                         Class, Std Hrs, FTE, FLSA Status,
                                                         Paygroup, Hol Sched, Comp Freq,
                                                         Comprate, Division, WCC, SUF1,
                                                         SUF2, Cert#




7/22/2011
Revised: April 12, 2010                                                                                                                           3                                                                                               D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                       Human Capitol Management Toolkit




                          QUERY DESCRIPTION               LONG DESCRIPTION                            TYPE    QUERY NAME                             PROMPTS               RECOMMENDED                     NAVIGATION
                          REPORT NAME                                                                                                                                      FREQUENCY
                          Audit Changes                   Returns all Change transactions ('C'        Query   GO_HR_LIST_JOB_CHANGES                 Company               As required                     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          Reasons) for a certain time period (i.e.,                                                  From Effective Date
                                                          dates between 01/01/06 to 03/01/06)                                                        To Effective Date


                                                          Includes Company, EmplID, Empl Rcd,
                                                          Name, Effdt, Effseq, Action, Reason,
                                                          Empl Status, Postion, DeptID, Location,
                                                          Establishment, Jobcode, Reg/Temp,
                                                          Full/Part, Empl Class, Std Hrs, FTE,
                                                          FLSA Status, Paygroup, Empl Type,
                                                          Hol Sched, Tipped, Sal Admin Plan,
                                                          Grade, Step, Comp Freq, Comprate,
                                                          Chg Amount, Earns Dist Type, DeptID,
                                                          Acct Code, Earn Code, Dist %, Hire
                                                          Date, Term Date, Rehire Date, Prob
                                                          Date, Last Date Worked, Expected
                                                          Return, Co Seniority, Service Date,
                                                          Longevity Date, Division, WCC, SUF1,
                                                          SUF2


                          Audit Leave Transactions        Returns all Leave transactions ('L'         Query   GO_HR_LIST_LEAVES                      Company               As required                     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          Reasons) for a certain time period (i.e.,                                                  From Effective Date
                                                          dates between 01/01/06 to 03/01/06)                                                        To Effective Date

                                                          Includes information from Job Data,
                                                          MDC Job Data, Employment, and
                                                          Earnings Distribution

                          Audit Separation Transactions   Returns all Separation transactions ('S'    Query   GO_HR_LIST_SEPARATIONS                 Company               As required                     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          Reasons) for a certain time period (i.e.,                                                  From Effective Date
                                                          dates between 01/01/06 to 03/01/06)                                                        To Effective Date

                                                          Includes information from Job Data,
                                                          MDC Job Data, Employment, and
                                                          Earnings Distribution


                          Blank Birthdate                 Returns employees with a null (or           Query   GO_HR_BIRTHDATE_NULL                   Company               Agency HR: Weekly to           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          vacant) Birth Date field on                                                                                      validate employee
                                                          Identity/Diversity page of Personal Data                                                                         information
                                                                                                                                                                           Agency PY: Prior to creating
                                                          Includes Company Department,                                                                                     Pay Sheets; Payroll
                                                          Location, Division and Special Use                                                                               calculation will stop if Birth
                                                          Fields 1 and 2                                                                                                   Date value is missing;
                                                                                                                                                                           coordinate with HR to have
                                                                                                                                                                           value corrected

                                                                                                                                                                           Corrections to Birth Date do
                                                                                                                                                                           not require a Correct History
                                                                                                                                                                           Help Desk Case




7/22/2011
Revised: April 12, 2010                                                                                                                               4                                                                                                  D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                   Human Capitol Management Toolkit




                          QUERY DESCRIPTION        LONG DESCRIPTION                           TYPE     QUERY NAME                                PROMPTS               RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                                  FREQUENCY
                          Blank Service Date       Returns employees with a null (or          Query    GO_HR_SERVICE_DT_NULL                     Company               Agency HR: Weekly to           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   vacant) Service Date field on                                                                                       validate employee
                                                   Employment Data page of Job Data                                                                                    information

                                                   Includes Company, Department,
                                                   Location, Division, Special Use Fields 1
                                                   and 2
                          Certified Appointments   Returns all certificate appointmens        Query    GO_HR_LIST_CERT_APPOINTMENTS              Company               Agency HR: Weekly to           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   between prompt dates                                                                          From Effective Date   validate employee data
                                                                                                                                                 To Effective Date
                                                                                                                                                                       Agency HR should hand off
                                                                                                                                                                       to Agency Payroll

                                                                                                                                                                       Corrections to Job Data will
                                                                                                                                                                       require a Correct History
                                                                                                                                                                       Help Desk Case

                                                                                                                                                                       Remember: employees
                                                                                                                                                                       have one HIRE action; if the
                                                                                                                                                                       employee is returning to the
                                                                                                                                                                       agency, or coming from
                                                                                                                                                                       another agency, the entered
                                                                                                                                                                       Action will be a REHIRE

                          Dept Action              Returns employees that are included in     Report   Department Action Notices                 From Company          As required                    MAIN MENU > WORKFORCE ADMINISTRATION > WORKFORCE
                                                   action notices that are tied to a time                                                        To Company                                           REPORTS
                                                   period or expiration date

                                                   Use it as a reminder of selected
                                                   personnel action notices

                                                   Output is Agency Name, the Type of
                                                   Notice and date, and the Employee
                                                   Name
                          Employment Dates         Audits employment dates against Job        Query    GO_HR_EMPLOYMENT_DATES                    Company               As required.                   MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   data




7/22/2011
Revised: April 12, 2010                                                                                                                           5                                                                                                 D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                           TYPE     QUERY NAME                                  PROMPTS                       RECOMMENDED                      NAVIGATION
                          REPORT NAME                                                                                                                                       FREQUENCY
                          Ethnic Validation   Returns every employee in the Agency       Query    GO_HR_ETHNIC_VAL                            Company                       Agency HR: Weekly to             MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              to validate Ethnic value and Primary                                                                                          confirm employee records
                                              indicator on Personal Data-                                                                                                   are correct and prior to any
                                              Identity/Diversity page                                                                                                       EEO reports

                                              Includes Company, Department,                                                                                                 There is no Payroll impact to
                                              Location, Division, Special Use Fields 1                                                                                      this clean up; it will impact
                                              and 2                                                                                                                         EEO reporting

                                              Recommend downloading into CSV or                                                                                             Corrections to Ethnic Group
                                              Excel                                                                                                                         on the Identity/Diversity
                                                                                                                                                                            page do not require a
                                                                                                                                                                            Correct History Help Desk
                                                                                                                                                                            Case; overtype the value if it
                                                                                                                                                                            is a Correction

                                                                                                                                                                            DO NOT insert an additional
                                                                                                                                                                            row unless the employee is
                                                                                                                                                                            claiming more than one
                                                                                                                                                                            Ethnic Group

                                                                                                                                                                            Ensure one Ethnic Group is
                                                                                                                                                                            the Primary


                          E-verify Audit      Returns employees who were hired or        Query    GO_HR_AUDIT_EVERIFY                         Agency                        Agency HR: Weekly to             MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                              rehired after 11/1/07 and do not show                                                                                         confirm compliance with
                                              the completed e-verify.                                                                                                       statutes.
                          Future Actions      Returns list of employees who have a       Report   Pending Future Actions 0220                 Language (default is English) Agency HR or Agency PY:          MAIN MENU > WORKFORCE ADMINISTRATION > WORKFORCE
                                              future action dated greater than the 'As                                                        As of Date                    As required                      REPORTS
                                              Of Date' Prompt in the Run Control                                                              Company
                                                                                                                                              Show Components? CheckBox If the Show Components?
                                              Output is Employee Name / Supervisor,                                                                                         Checkbox is checked, the
                                              Employee ID, Effective Date, Action,                                                                                          report will display
                                              Action Reason, Empl Type, Reg/Temp,                                                                                           compensation component
                                              Full/Part, Department ID, Department                                                                                          information
                                              Description, Job Code, Job Title, Salary
                                              Grade, Comp Rate                                                                                                              Report is useful prior to
                                                                                                                                                                            each payroll

                          Gender Unknown      Returns employees who have Gender          Query    GO_HR_GENDER_UNK_NULL                       Company                       Agency HR: Monthly to            MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              field on Personal Data/Personal History                                                                                       review/validate information
                                              set to Unknown
                                                                                                                                                                            Corrections to Personal
                                              Includes Department, Location,                                                                                                History page will require a
                                              Division, Special Use Fields 1 and 2                                                                                          Correct History Help Desk
                                                                                                                                                                            Case
                          Job Data Review     Returns last effective dated information   Query    GO_HR_JOB_DATA_ETAL_REVIEW                  Company                       Agency HR: Weekly to             MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              for employees by agency                                                                                                       ensure dates are populated
                                                                                                                                                                            correctly
                                              Includes information from Job Data,
                                              MDC Job Data, Employment, and                                                                                                 Corrections to Job Data will
                                              Earnings Distribution; and Department,                                                                                        require a Correct History
                                              Location, Division, Special Use Fields 1                                                                                      Help Desk Case
                                              and 2

                                              Recommend downloading into CSV or
                                              Excel




7/22/2011
Revised: April 12, 2010                                                                                                                        6                                                                                                           D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                    Human Capitol Management Toolkit




                          QUERY DESCRIPTION        LONG DESCRIPTION                           TYPE     QUERY NAME                                 PROMPTS                         RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                                             FREQUENCY
                          Leaves                   Returns list of employees who are on a     Report   Employees on Leave of Absence 0217         Language (default is English)   Agency HR or Agency PY:        MAIN MENU > WORKFORCE ADMINISTRATION > WORKFORCE
                                                   Leave of Absence                                                                               From Company                    As required                    REPORTS
                                                                                                                                                  To Company
                                                   Output is From / To Company Number,                                                                                            Use report to validate
                                                   Employee Name, Employee ID,                                                                                                    employees on Leave of
                                                   Department Description, Leave Began                                                                                            Absence
                                                   (date), Expected Return (date), Reason
                                                   for Leave, Telephone (number),
                                                   Company (number)

                          LOA, PLA, RET, SUS,TER   Returns employees with Action of LOA,      Query    GO_HR_TERM_ETAL_ACTION                     Company                         Agency HR: Weekly to           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   PLA, RET, SUS, TER for a certain time                                                          From Effective Date             validate employee data
                                                   period (i.e., dates between 01/01/06 to                                                        Thru Effective Date
                                                   03/01/06 employee may be on LOA; but                                                                                           Agency HR should hand off
                                                   repeat query for different date                                                                                                to Agency Payroll
                                                   parameters and same employee may
                                                   be TER)                                                                                                                        Corrections to Job Data will
                                                                                                                                                                                  require a Correct History
                                                   Includes Department, Location, Division                                                                                        Help Desk Case
                                                   and Special Use Fields 1 and 2

                                                   Recommend downloading into CSV or
                                                   Excel


                          Merit Transactions       Returns all Merit transactiions between    Query    GO_HR_MERIT_ACTIONS                        Company                         Agency HR: Weekly to           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   two dates.                                                                                     From Effective Date             validate employee data
                                                                                                                                                  To Effective Date
                                                                                                                                                                                  Corrections to Job Data will
                                                                                                                                                                                  require a Correct History
                                                                                                                                                                                  Help Desk Case

                                                                                                                                                                                  Remember: employees
                                                                                                                                                                                  have one HIRE action; if the
                                                                                                                                                                                  employee is returning to the
                                                                                                                                                                                  agency, or coming from
                                                                                                                                                                                  another agency, the entered
                                                                                                                                                                                  Action will be a REHIRE


                          New Hires/Rehires                                                   Query    GO_HR_NEW_REH_HIRE                         Company                         Agency HR: Weekly to           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   Returns New Hires and Rehires for a                                                            From Effective Date             validate employee data
                                                   certain time period (i.e., dates between                                                       To Effective Date
                                                   01/01/06 to 03/01/06 employee may be                                                                                           Agency HR should hand off
                                                   HIR; but repeat the query for different                                                                                        to Agency Payroll
                                                   date parameters and the same
                                                   employee may be REH)                                                                                                           Corrections to Job Data will
                                                                                                                                                                                  require a Correct History
                                                   Includes information from Job Data,                                                                                            Help Desk Case
                                                   MDC Job Data, Employment, and
                                                   Earnings Distribution                                                                                                          Remember: employees
                                                                                                                                                                                  have one HIRE action; if the
                                                   Recommend downloading into CSV or                                                                                              employee is returning to the
                                                   Excel                                                                                                                          agency, or coming from
                                                                                                                                                                                  another agency, the entered
                                                                                                                                                                                  Action will be a REHIRE




7/22/2011
Revised: April 12, 2010                                                                                                                            7                                                                                                           D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                              Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                            TYPE     QUERY NAME                               PROMPTS               RECOMMENDED                     NAVIGATION
                          REPORT NAME                                                                                                                             FREQUENCY
                          Not Paid Since      Returns active employees who have not       Query    GO_HR_NOT_PAID_SINCE_PROMPT              Not paid since date   Agency on demand                MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              been paid since the prompt date.


                                              Includes Company, Name, EmplID,
                                              Empl Rcd, Empl Status, Reg/Temp,
                                              Full/Part, Jobcode, Last Paid date


                          Null Prob Date      Returns employees who have an               Query    GO_HR_EMPL_CLASS_NULL_PROB_DT            Company               Agency HR: Weekly to            MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              Employee Class value of Probationary                                                                                validate employee
                                              Classified or Probationary                                                                                          information
                                              Classified/Trial Period with a null
                                              (blank) Probation Date on Employment                                                                                Corrections to Employment
                                                                                                                                                                  Data do not require a
                                              Returns employees in Empl Status A, L,                                                                              Correct History Help Desk
                                              P, or S                                                                                                             Case

                          Part Time Empls     Returns all agency employees based on       Query    GO_HR_PARTTIME_EMPL_VAL                  Company               Agency HR: As needed            MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              prompt                                                                                        Full/Part Time

                                              Includes Empl ID, Name, Position
                                              Number, Department, Location, Job
                                              Code, Reg/Temp, Full/Part, Standard
                                              Hours, FTE, Pay Group, Comp
                                              Frequency, Division and Special Use
                                              Fields 1 and 2
                          Passport/Visa       Returns information in two ways: first      Report   Passport/Visa Expiration                 None                  As required                     MAIN MENU > WORKFORCE ADMINISTRATION > CITIZENSHIP >
                                              section of the report lists passport                                                                                                                PASSPORT/VISA EXPIRATION AUDIT
                                              information: employee ID and name,                                                                                  Note that the report will
                                              dependent ID and name, country,                                                                                     return a blank header page if
                                              passport number, issue date, and                                                                                    there is no set up on
                                              expiration date; the second section of                                                                              Identification Data
                                              the report lists visa and work permit
                                              information: employee ID and name,
                                              dependent ID and name, country, visa
                                              and work permit number, type of permit,
                                              issue date, and expiration date. There is
                                              a page break between the first and
                                              second sections of the report

                          Past Prob Date      Returns employees who have a                Query    GO_HR_PRIOR_PROBATION_DT                 Company               Agency HR: Weekly to            MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              Probation Date that has passed (i.e.,                                                         Probation Dates       validate employee
                                              Probation Date value is 12/20/06 for a                                                                              information
                                              report run as of 2/1/07); compare the
                                              date to the Empl Class field on Job                                                                                 Corrections to Employment
                                              Data to determine the course of action                                                                              Data do not require a
                                                                                                                                                                  Correct History Help Desk
                                              Returns employees in Empl Status A, L,                                                                              Case
                                              P, or S




7/22/2011
Revised: April 12, 2010                                                                                                                      8                                                                                                   D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                Human Capitol Management Toolkit




                          QUERY DESCRIPTION       LONG DESCRIPTION                            TYPE     QUERY NAME                             PROMPTS                   RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                                   FREQUENCY
                          Primary Job             Returns list of employees who have          Report   Primary Job Audit 0210                 Personnel Status (Employee or Agency HR: As required       MAIN MENU >WORKFORCE ADMINISTRATION > WORKFORCE
                                                  either (a) multiple jobs with Primary                                                       Non Employee; select                                       REPORTS
                                                  Flag on all jobs, and/or (b) jobs with no                                                   Employee)                     Use the Primary Job Audit
                                                  Primary Flag indicator                                                                      Agency                        report to check for
                                                                                                                                                                            discrepancies in the primary
                                                  Output is Agency Number/Description,                                                                                      job designation for
                                                  Employee ID, Name, As of Date (from                                                                                       employees with multiple
                                                  Job Data), Empl Rcd #, Job Effdt,                                                                                         jobs
                                                  Indicator, Status, Business Unit, Job
                                                  Code, Department Short Description

                          Rejected Transactions   Returns list of transactions that have      Query    GO_HR_REJECTEC_TRANSACTIONS            Agency                    Agency HR: As required         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                  been rejected by OPM
                          Special Use Date        Returns employees by agency who             Query    GO_HR_SPECIAL_USE_DATE                 Company                   Agency HR and/or Agency        MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                  have a value in the Special Use Date                                                        From Special Use Dt       PY: as defined within the
                                                  field on MDC Job Data                                                                       To Special Use Dt         agency based on business
                                                                                                                                                                        process for field use
                                                  This field is used by agencies as a
                                                  business process is defined
                          Special Use Flds        Returns employees by agency to              Query    GO_HR_SPEC_USE_RVW                     Company                   Agency HR: Weekly to           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                  support HR/PY with task of confirming                                                                                 ensure correct Longevity
                                                  Longevity Dates                                                                                                       Date on Employment Data

                                                  Includes Company, Empl ID, Name,                                                                                      Corrections to the Longevity
                                                  Department ID, Location, Reg/Temp,                                                                                    Date can be done without a
                                                  Full/Part, Division, Special Use Fields                                                                               Correct History Help Desk
                                                  1, 2, and 3, Special Use Date,                                                                                        Case; however, this field
                                                  Hire/Rehire Dates and Longevity Date                                                                                  directly impacts Payroll--
                                                  from Employment                                                                                                       coordinate with Payroll for
                                                                                                                                                                        any changes/corrections



                          Standard Hours to FTE   Returns employees in A, L, P, or S          Query    GO_HR_STDHRS_FTE_VAL                   Company                   Agency HR: Weekly to          MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                  Employee Status, for Standard Hours                                                                                   ensure values are in sync
                                                  and FTE review on Job Data                                                                                            (i.e., Reg/Temp = Temp,
                                                                                                                                                                        Full/Part = Part Time, but
                                                  Includes Company, Job Code,                                                                                           Standard Hours = 40 v. 20
                                                  Reg/Temp, Full/Part Time,                                                                                             or some other number);
                                                  Department, Location, Division, Special                                                                               especially prior to beginning
                                                  Use Fields 1 and 2                                                                                                    a Payroll

                                                  Recommend downloading into CSV or                                                                                     Use to review data for
                                                  Excel                                                                                                                 employees who have gone
                                                                                                                                                                        Full Time to Part Time and
                                                                                                                                                                        vice versa but Standard
                                                                                                                                                                        Hours/FTE may or may not
                                                                                                                                                                        have been updated

                                                                                                                                                                        Corrections to Job Data will
                                                                                                                                                                        require a Correct History
                                                                                                                                                                        Help Desk Case



                          Summary of Actions      Returns a count of all Job transactions     Query    GO_HR_SUMMARY_OF_ACTIONS               Agency                    Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                  entered between dates.                                                                      From Entered Dt
                                                                                                                                              To Entered Dt
                                                  Includes Reason, Action, Gain/Loss,
                                                  Transaction Count



7/22/2011
Revised: April 12, 2010                                                                                                                        9                                                                                                     D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                     Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                         TYPE    QUERY NAME                          PROMPTS                  RECOMMENDED                 NAVIGATION
                          REPORT NAME                                                                                                                       FREQUENCY
                          With a Prob Date    Returns employees who have an            Query   GO_HR_EMPL_CLASS_WITH_PROB_DT       Company                  Agency HR: Weekly to        MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              Employee Class value of Permanent or                                                                          validate employee
                                              Unclassified with a value in the                                                                              information
                                              Probation Date field on Employment
                                                                                                                                                            Corrections to Employment
                                              Returns employees in Empl Status A, L,                                                                        Data do not require a
                                              P, or S                                                                                                       Correct History Help Desk
                                                                                                                                                            Case
                          Workgroup Audit     Returns employees who are not in the     Query   GO_HR_REG_TEMP_TO_WORKGROUP         Company, Regular/Temp,   Agency HR: Weekly to        MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              appropriate workgroup based on their                                                 Workgroup                validate employee
                                              Reg/Temp status and workgroup                                                                                 information
                                              prompt.




7/22/2011
Revised: April 12, 2010                                                                                                            10                                                                                                 D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                     Human Capitol Management Toolkit




                          QUERY DESCRIPTION     LONG DESCRIPTION                           TYPE     QUERY NAME                                     PROMPTS                      RECOMMENDED            NAVIGATION
                          REPORT NAME                                                                                                                                           FREQUENCY

    Compensation
                          Agency J/C List       Returns information for agencies that      Report   Agy Listing by Job Code (0067)                 Job Code(s)                  Agency HR: As needed   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                have the specific Job Code or Job                                                                  Legal Entity (MER or NMER)   OPM: As required       > HR
                                                Codes and Legal Entity established on
                                                the Run Control page

                                                Sorts by Job Code in numerical order
                                                and then by Agency in numerical order

                                                No employee information is returned;
                                                just counts of the number of employees
                                                in the specific Job Code for the agency


                          Annual Sal Analysis   This report allows OPM to review the       Report   Annual Salary Analysis (0079)                  Beginning Company            Agency HR: As needed   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                annual salary information for each                                                                 Ending Company               OPM: As required       > HR
                                                agency by Job Code

                                                Output is sorted by Job Code
                                                Description in alpha order, and includes
                                                Job Code, Job Code Description, # of
                                                Empls in the Job Code split under two
                                                headings: Unclassified and Classified
                                                (based on the employee's Empl Class
                                                value from Job Data), Total Annual
                                                Salary (combines the amounts for one
                                                or more employees in the same Job
                                                Code), and for Classified Employees,
                                                the Grade (pay band)

                                                Provides Total Number of Employees
                                                for Unclassified and Classified, and the
                                                Grand Total (for agencies authorized to
                                                run the report for multiple agencies) at
                                                the end of the report


                          Empls by J/C          Returns list of employees in the           Report   Employee by Job Code (0070)                    Beginning Job Code           Agency HR: As needed   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                requested Job Code(s)                                                                              Ending Job Code              OPM: As required       > HR
                                                                                                                                                   Beginning Company
                                                Output is by Job Code and Description,                                                             Ending Company
                                                then by Employee Name, Empl ID,
                                                Empl Class, Position Number, Location
                                                Code, and Location Code Description

                                                If OPM executes for multiple agencies,
                                                will break by agency number




7/22/2011
Revised: April 12, 2010                                                                                                                            11                                                                                               D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                      Human Capitol Management Toolkit




                          QUERY DESCRIPTION        LONG DESCRIPTION                           TYPE     QUERY NAME                                   PROMPTS              RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                                    FREQUENCY
                          Empls by J/C & Class     Returns list of all employees by Agency    Report   Agy Empl by Job Code (0073)                  Beginning Company    Agency HR: As needed           MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                    Ending Company       OPM: As required               > HR
                                                   Output sorts by Employee ID and
                                                   provides Job Code and Description,
                                                   Employee ID, Employee Name,
                                                   Employee Class, and the Class
                                                   Indicator from the employee's Position
                                                   Data record

                                                   If OPM runs the report for all agencies,
                                                   report will break by agency

                                                   The difference between this report and
                                                   Report Employee by Job Code (0070)
                                                   is the Class/Unclass indicator from
                                                   Position Data


                          FLSA Review              Returns employees in A, L, P, S status     Query    GO_HR_FLSA_AGENCY_USE                        Company              Agency HR: As needed to        MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   values for FLSA review; includes Pay                                                                                  review FLSA values
                                                   Group to assist with review
                                                                                                                                                                         Corrections to Job Data will
                                                   Includes Department, Location,                                                                                        require a Correct History
                                                   Division, Special Use Fields 1 and 2                                                                                  Help Desk Case

                                                   Recommend downloading into CSV or
                                                   Excel

                          FLSA Review Short List   Compares Paygroup with FLSA status         Query    GO_HR_FLSA_VERFICATION                       Company              Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                   and returns a list of employees that
                                                   need to be verified.includes Pay Group
                                                   to assist with review

                                                   Includes Company, EmplID, Name,
                                                   Empl Status, Jobcode, Paygroup, FLSA
                                                   Status, Remarks

                          Job Code by Agency       Returns list of Job Codes used by an       Report   Job Code Usage by Agy (0074)                 Beginning Company    Agency HR: As needed           MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                   agency                                                                                           Ending Company       OPM: As required               > HR

                                                   No employee information is returned;
                                                   output sorts by Job Code with
                                                   Description, Position Number, Grade,
                                                   and Effective Date (from Position Data);
                                                   all numeric Job Codes are first (Grade
                                                   field is blank), then the alpha-numeric
                                                   Job Codes (Grade field is populated)

                                                   Report provides grand total number of
                                                   Positions in the agency




7/22/2011
Revised: April 12, 2010                                                                                                                             12                                                                                                D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                               Human Capitol Management Toolkit




                          QUERY DESCRIPTION         LONG DESCRIPTION                             TYPE    QUERY NAME                          PROMPTS              RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                             FREQUENCY
                          Job Data Compensation                                                  Query   GO_HR_JOB_COMP_VAL                  Company              Agency HR: Weekly to         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                    Returns all compensation from Job                                                                             validate all employees’
                                                    Data for employees in all employee                                                                            Comp Rate Code values on
                                                    status values for agency employees                                                                            Job Data in order to correct
                                                                                                                                                                  value prior to beginning a
                                                    Includes the Monthly or Bi Weekly                                                                             Payroll
                                                    Compensation and Frequency, as well
                                                    as Job Code, Pay Group, Comp Rate                                                                             Corrections to Job Data will
                                                    Code(s); and Department, Location,                                                                            require a Correct History
                                                    Division, Special Use Fields 1 and 2                                                                          Help Desk Case

                                                    Recommend downloading into CSV or
                                                    Excel

                          Last Increase             Returns an Alpha list of employees           Query   GO_HR_LAST_INCREASE                 Agency               Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                    Includes Name, EmplID, Jobcode, Job
                                                    Title, DeptID, Comp Rate, Last Incr
                                                    Date, Action, Reason, Percent, Change
                                                    Amt
                          Job Data w/o Earns Dist   Returns last effective dated information     Query   GO_HR_JOB_DATA_GENL_RVW             Company              Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                    for employees by agency; includes
                                                    information from Employment and
                                                    Compensation

                                                    Recommend downloading into CSV or
                                                    Excel
                          Job Family/Job Code       Returns from Job Data all agency             Query   GO_HR_JOB_FAMILY_JOB_CODE           Company              Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                    employees using the last effective
                                                    dated row information                                                                                         Corrections to Job Data will
                                                                                                                                                                  require a Correct History
                                                    Includes Company, Position Number,                                                                            Help Desk Case
                                                    Department, Location, Job Family, Job
                                                    Code and Description, Division, Special
                                                    Use Fields 1 and 2

                                                    (This query is similar to report Salary by
                                                    Job Code (0075) but query includes
                                                    Department, Location, Division, Special
                                                    Use Fields 1 and 2; and output can be
                                                    downloaded into Excel--report output is
                                                    .PDF)

                                                    Recommend downloading into CSV or
                                                    Excel




7/22/2011
Revised: April 12, 2010                                                                                                                      13                                                                                                D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                 Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                            TYPE     QUERY NAME                                  PROMPTS                        RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                         FREQUENCY
                          OPM 14              The OPM-14 report is produced for           Report   Personnel Action Rpt (0121)                 From Agency                     Agency HR: As required   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                              personnel actions based on prompts                                                               Through Agency                  OPM: As required         > HR
                                              (selection criteria) when the report is                                                          Reason Code (if limiting to a
                                              run                                                                                              unique Reason)
                                                                                                                                               EmplID (if limiting to a unique
                                                                                                                                               employee)
                                                                                                                                               Department (if limiting to a
                                                                                                                                               unique Department ID)
                                                                                                                                               Date Option (Effective Date of
                                                                                                                                               the transaction; or
                                                                                                                                               Approved/Rejected Date by
                                                                                                                                               OPM)
                                                                                                                                               Date Begin/Date End (tied to
                                                                                                                                               Date Options selected--
                                                                                                                                               Effective Date means Effective
                                                                                                                                               Date of Actions that occurred
                                                                                                                                               between two dates;
                                                                                                                                               Approved/Reject Date means
                                                                                                                                               Actions that were approved or
                                                                                                                                               rejected by OPM that occurred
                                                                                                                                               between two dates)
                                                                                                                                               Sort Option (defaults to print
                                                                                                                                               alpha by Last Name)

                          Salary by J/C       Returns listing of employees in a           Report   Salary by Job Code (0075)                   Beginning Company              Agency: As needed         MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                              specific agency by Job Code                                                                      Ending Company                 OPM: As required          > HR

                                              Output sorts by Job Code, and has Job
                                              Code, Job Code Description, Employee
                                              Name, Employee ID, Position Number,
                                              Class Indicator (C or U), current Pay
                                              Rate (Comp Frequency of monthly for
                                              all employees), and Grade (if classified;
                                              if unclassified will be blank)

                          Salary Statistics   Returns current agency employee             Query    GO_HR_SALARY_STATISTICS                     Agency                         As required               MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              count, total of Annual Rate, Average
                                              Annual Rate, and total Longevity for an
                                              agency.




7/22/2011
Revised: April 12, 2010                                                                                                                        14                                                                                                     D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                  Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                            TYPE     QUERY NAME                                   PROMPTS                        RECOMMENDED              NAVIGATION
                          REPORT NAME                                                                                                                                          FREQUENCY
                          Salary Step         Returns all effective dated rows from       Report   Salary Grade/Step Table                      Language (default is English; As required               MAIN MENU > COMPENSATION > BASE COMPENSATION > SALARY
                                              the Salary Grade Table for those                                                                  use Default)                                            PLAN REPORTS
                                              Grades that have a Step structure, such                                                           Checkbox for Show
                                              as Salary Plan of DPSP, Grade PTL,                                                                Components? (if checked, the
                                              Step 1, etc., beginning with the first                                                            Components of Pay are
                                              effective dated row to the last effective                                                         displayed on the report)
                                              dated row

                                              There is no employee information in the
                                              output

                                              The output includes a row for each
                                              effective dated row with Setid, Salary
                                              Plan/Grade/Step, Description, Effective
                                              Date, Components, Currency,
                                              Frequency, and Hourly, Daily, Monthly,
                                              and Annual compensation rates, and
                                              Rate Code Group, Percent and Points
                                              (the last three currently not used by the
                                              state)




    EEO Support
                          EEO-4               Returns EEO-4 Reporting Information         Report   EEO-4 St Local Gov-Agy(0215)                 From Date                      As defined by State      MAIN MENU > WORKFORCE MONITORING > MEET REGULATORY
                                              for the agency based on run control                                                               Fiscal Year Thru Date          reporting requirements   RQMTS > EEO REPORTS
                                              parameters                                                                                        From Company
                                                                                                                                                Contact Name
                                                                                                                                                Contact Title
                                                                                                                                                Authorized Official
                          EEO-4 Actions       Includes Appt Chg. Same Agency, New         Query    GO_HR_EEO4_ACTIONS                           Beginning and Ending effective As required              MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              hires, Rehires, Promotions, Demotions,                                                            dates company
                                              Terminations, Retirements

                          EEO-4 Audit         Returns employees with unspecified          Query    GO_HR_EEO4_ETHNICITY_GENDER                  Company                        As required              MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              gender or ethnic identity.
                          Positions by EEO    Returns Position information with EEO-      Report   Pos by EEO Category (0083                    From Company                   Agency HR: As required to MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                              4 Category data from Job Code Table                                                               To Company                     prepare for EEO-4 reporting > HR
                                                                                                                                                                               OPM: As required
                                              Output is by Agency and Description,
                                              and then EEO Category Description,
                                              with Job Code, Job Code Description,
                                              EEO-4 Category, Position Number,
                                              Status (Class or Unclass from Position),
                                              Location (from Position) and Date (max
                                              effective dated row from Position)

                                              Provides the total number of Job Codes
                                              in the specific EEO-4 category at each
                                              EEO-4 break point; there is NO
                                              employee information on this report

                                              Final result is Total Number of Positions
                                              for the Agency; if run for multiple
                                              agencies provides a Grand Total




7/22/2011
Revised: April 12, 2010                                                                                                                         15                                                                                                    D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                     Human Capitol Management Toolkit




                          QUERY DESCRIPTION             LONG DESCRIPTION                          TYPE     QUERY NAME                              PROMPTS              RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                                   FREQUENCY

    Employee Listings
                          Address Info                  Returns address information for agency    Query    GO_HR_ADDRESS_REVIEW                    Company              Agency HR: Weekly, and/or MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        employees                                                                                                       in conjunction with
                                                                                                                                                                        GO_HR_NEW_REH_HIRE
                                                        Includes Department, Location, Division                                                                         query
                                                        and Special Use Fields 1 and 2
                                                                                                                                                                        Corrections to Address
                                                        Recommend downloading into CSV or                                                                               History page will require a
                                                        Excel                                                                                                           Correct History Help Desk
                                                                                                                                                                        case

                                                                                                                                                                        Remember: DO NOT enter
                                                                                                                                                                        employee information in ALL
                                                                                                                                                                        CAPS; used mixed case
                                                                                                                                                                        All employees MUST have
                                                                                                                                                                        at least one Address Type =
                                                                                                                                                                        HOME to support system
                                                                                                                                                                        processing and reporting


                          Age and Years of Employment   List of active employees for the agency   Query    GO_HR_AGE_AND_YEARS_EMPLOYED            Agency, As of Date   On Demand                      MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        with age and years of employment as of
                                                        a certain date.
                          Birthdays                     Returns list of Employee Birthdays for    Report   Employee Birthdays 0227                 Agency               Agency HR: As required         MAIN MENU > WORKFORCE ADMINISTRATION > WORKFORCE
                                                        the Agency                                                                                                                                     REPORTS

                                                        Output is Agency Number/Description,
                                                        Month, Employee Name, Birth Day,
                                                        Gender, Department, Job Title

                          Contact Information           Returns address, Home and Cell            Query    GO_HR_OPS_PLAN_LIST                     Agency               Agency HR: As required         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        numbers, along with Job and Location .

                          Empl Agency Info              Returns all Active agency employees       Query    GO_HR_EMPLOYEE_AGENCY_INFO              Company              Agency HR: As required         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                        Includes Name, Agency #, Position #,                                                                            Corrections to Job Data will
                                                        Position Description, Hire Date, (Work)                                                                         require a Correct History
                                                        Location, (Work) Location Address,                                                                              Help Desk Case
                                                        City, State, Zip for all employees in
                                                        Empl Status of A, L, P or S




7/22/2011
Revised: April 12, 2010                                                                                                                            16                                                                                                D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                        Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                           TYPE    QUERY NAME                           PROMPTS              RECOMMENDED                     NAVIGATION
                          REPORT NAME                                                                                                                      FREQUENCY
                          Employee Counts     Returns the count of employees in all      Query   GO_HR_EMPL_COUNT                     Company              Agency HR: As needed to         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                              status values for an agency and is                                                                           review current headcount
                                              current as of the date it is executed                                                                        numbers

                                              This is a headcount by numbers-only
                                              query (i.e., 300=A, 2= L, 25=T, 4=R); no
                                              employee specific information is
                                              returned

                          Employee Listing    Returns all agency employees               Query   GO_HR_EMPLIDLIST_BYAGENCY            Company              Agency HR: Weekly to         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                           validate employee
                                              Includes Company, EmplID, SSN,                                                                               information; review to
                                              Name, Empl Status, Department ID,                                                                            ensure SSN is not all 9’s
                                              Location, Jobcode, FICA Status,                                                                              Agency PY: Prior to creating
                                              Division, Special Use 1 and 2 fields                                                                         Pay Sheets; give enough
                                                                                                                                                           time for Help Desk cases for
                                              Recommend downloading into CSV or                                                                            values that cannot be
                                              Excel                                                                                                        corrected by the agency

                                                                                                                                                           Corrections to SSN value do
                                                                                                                                                           not require a Correct History
                                                                                                                                                           Help Desk Case; however,
                                                                                                                                                           DO NOT correct this value
                                                                                                                                                           without talking to the CORE
                                                                                                                                                           team



                          Employee Listing    Returns all agency employees               Query   GO_HR_EMPLIDLIST_BY_AGENCY_2         Company              Agency HR: Weekly to         MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                           validate employee
                                              Includes Company, Division, EmplID,                                                                          information; review to
                                              Name, Paygroup, SSN, Employee                                                                                ensure SSN is not all 9’s
                                              Status, Effective Date                                                                                       Agency PY: Prior to creating
                                                                                                                                                           Pay Sheets; give enough
                                              Recommend downloading into CSV or                                                                            time for Help Desk cases for
                                              Excel                                                                                                        values that cannot be
                                                                                                                                                           corrected by the agency

                                                                                                                                                           Corrections to SSN value do
                                                                                                                                                           not require a Correct History
                                                                                                                                                           Help Desk Case; however,
                                                                                                                                                           DO NOT correct this value
                                                                                                                                                           without talking to the CORE
                                                                                                                                                           team


                          Employee Listing    Returns all agency employees               Query   GO_HR_EMPLOYEE_LIST                  Company              Agency HR: Run as needed MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                              Includes Company, EmplID, Name,
                                              Paygroup,Employee Status, Effective
                                              Date, Gender, Birthdate, Service date,
                                              Hire Date, Last Date Work

                                              Recommend downloading into CSV or
                                              Excel




7/22/2011
Revised: April 12, 2010                                                                                                               17                                                                                                 D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                                Human Capitol Management Toolkit




                          QUERY DESCRIPTION               LONG DESCRIPTION                             TYPE     QUERY NAME                                    PROMPTS                         RECOMMENDED              NAVIGATION
                          REPORT NAME                                                                                                                                                         FREQUENCY
                          Empls by Agency                 Returns list of all employees by Agency      Report   Empl by Agcy/Job Code (0072)                  Beginning Company               Agency HR: As needed     MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                              Ending Company                  OPM: As required         > HR
                                                          Output sorts by Job Code and provides
                                                          Job Code and Description, Employee
                                                          Name, Employee ID, Employee Class,
                                                          then counts the number of employees in
                                                          the Job Code

                                                          If OPM runs the report for all agencies,
                                                          report will break by agency, sub-total for
                                                          the agency, and then a grand total
                                                          (grand total is total number of
                                                          employees for the agency, NOT the
                                                          total number of employees in the Job
                                                          Code)


                          Empls by Agency                 Returns list of all employees with           Query    GO_HR_JOB_GENL_RVW_JOBCODE                    Company                         Agency HR: As needed     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          selected jobcode                                                                                    jobcode                         OPM: As required

                                                          Company, Employee ID, Empl Rcd#,
                                                          Name, Empl Status, Position, DeptID,
                                                          Location, Jobcode, Job title, Reg/Temp,
                                                          Full/Part, StdHrs, FTE, Empl Type,
                                                          Annual Rate, Longevity Date, Division,
                                                          WCC, SUF1, SUF2
                          Employee List with Reports To   Returns all agency employees                 Query    GO_HR_EMPL_REPORTS_TO                         Company                         Agency HR: As needed     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                          Includes Name, EmplID, Empl Rcd#,
                                                          Position, Location, Reports To

                          Employee List with Supervisor   Returns all agency employees                 Query    GO_HR_EMPLIST_WITH_SUPERVISOR                 Agency                          Agency HR: As needed     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                          Includes Name, EmplID, Empl Rcd#,
                                                          Position, Location, Reports To,
                                                          Supervisor, Supervisor ID

                          Home Address                    Returns list of Employees' Home              Report   Employee Home Address Listing                 Agency                          Agency HR: As required   MAIN MENU > WORKFORCE ADMINISTRATION > PERSONAL
                                                          Address for the Agency                                                                                                              Agency PY: As required   INFORMATION > BIOGRAPHICAL >

                                                          Output is alphabetical by Employee
                                                          Name, then Address, City, State, Postal

                          Labels                          Creates mailing labels for employees in      Report   Mailing Labels 0226                           Language (default is English)   As required              MAIN MENU > WORKFORCE ADMINISTRATION > WORKFORCE
                                                          the agency in status A, L, P and S                                                                  Agency                                                   REPORTS

                                                          Output is Employee Name (alpha order,
                                                          Last Name), Home Address, City,
                                                          State, Zip+Four

                          Employees on Detail/Temp Duty   Returns all agency employees with an         Query    GO_HR_ON_DETAIL_LIST                          Company                         As required              MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          Expected Job End Date on the Work
                                                          Location tab of Job Data

                                                          Includes Co, Name, EmplID, Empl
                                                          Rcd#, Position, Posn Date, Jobcode,
                                                          DeptID, Location, Reports To, Expected
                                                          End Date




7/22/2011
Revised: April 12, 2010                                                                                                                                       18                                                                                                     D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                                Human Capitol Management Toolkit




                          QUERY DESCRIPTION                LONG DESCRIPTION                            TYPE     QUERY NAME                                    PROMPTS                         RECOMMENDED              NAVIGATION
                          REPORT NAME                                                                                                                                                         FREQUENCY
                          Rough Estimate for Retirements   Returns all agency employees with an        Query    GO_HR_RETIREMENT_ESTIMATE                     Company                         As required              MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           Expected Job End Date on the Work
                                                           Location tab of Job Data

                                                           Includes Division, Location, Name,
                                                           EmplID, Empl Rcd#, Position, Jobcode,
                                                           DeptID, Service Date, Age, Service Yrs,
                                                           Rule, Yrs to Rule, Yrs to 62


                          Supervisor Listing               Returns information by Employee             Report   Supervisor Listing (0175)                     Agency                          Agency HR: As needed     MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                           Name, Employee ID and Position                                                                                                     OPM: As required         > HR
                                                           Number for those employees who have
                                                           the ‘Supervisor Level’ field populated on
                                                           the Job Information page on Job Data

                          Temp Empls                       Returns an alphabetical list of all         Report   Temporary Employees                           Language (default is English;   Agency HR: As required   MAIN MENU > WORKFORCE ADMINISTRATION > JOB INFORMATION
                                                           employees marked as temporary, along                                                               keep default)                   Agency PY: As required   > REPORTS
                                                           with length of service and other details                                                           As of Date
                                                           of employment                                                                                      From Agency
                                                                                                                                                              To Agency
                                                           Output is Agency Number/Description,
                                                           Empl ID, Empl Rcd Nbr, Empl Name,
                                                           Hire Date, Hire Days (from Hire Date
                                                           to As of Date on the Run Control),
                                                           Comp Rate and Frequency, FLSA Flag,
                                                           Job Title, and Department Description


                          Turnover                         Returns Turnover Analysis by Company        Report   Employee Turnover Analysis 0218               From Date                       Agency HR: As required   MAIN MENU > WORKFORCE ADMINISTRATION > WORKFORCE
                                                           for a defined period                                                                               End Date                                                 REPORTS
                                                                                                                                                              From Company
                                                           Output is Business Unit, Department ID,                                                            To Company
                                                           Department Description, Begin Count +
                                                           Hires/Rehires - Terminations -
                                                           Retirements + Transfers In - Transfers
                                                           Out, End Count, and Turnover Rate
                                                           Percentage

                          Unclass Empls                    Returns listing of all Unclassified         Report   Unclassified Employees (0076)                 Beginning Company               Agency: As needed        MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                           employees in that agency                                                                           Ending Company                  OPM: As required         > HR

                                                           Output sorts by Empl ID, with Name,
                                                           Position Number, Eff Dt (of last Action
                                                           on Job Data), Compensation (by Comp
                                                           Frequency, Monthly or Bi-Weekly), Job
                                                           Code and Job Code Description

                          Years of Svc                     Returns employees with their years of       Query    GO_HR_YEARS_OF_SERVICE                        Company                         Agency HR: As needed     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           service.                                                                                           As of Date

                                                           Output is Company, ID, Name, Status,
                                                           Reg/Temp, Full/Part, Group, Division,
                                                           As of Date, Service Date, Yrs of Service




7/22/2011
Revised: April 12, 2010                                                                                                                                       19                                                                                                     D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                         Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                          TYPE     QUERY NAME                            PROMPTS                          RECOMMENDED                      NAVIGATION
                          REPORT NAME                                                                                                                                   FREQUENCY
                          Years of Svc        Returns employees with years of           Report   Years of Service 0209                 As of Date                       Agency HR or PY: As              MAIN MENU > WORKFORCE ADMINISTRATION > WORKFORCE
                                              service or greater as indicated in the                                                   From Company                     required                         REPORTS
                                              Run Control                                                                              To Company                       OPM: As required
                                                                                                                                       Years of Service (enter value)
                                              Output is Agency Number, Years of                                                                                         This report supplies a list of
                                              Service = (value), As of Date (from Run                                                                                   employees who have
                                              Control), Empl ID, Rcd #, Name (alpha,                                                                                    completed the number of
                                              last name), Hire Date, Years of Service                                                                                   years of service specified in
                                              = Yrs / Months, Department Description,                                                                                   the Run Control
                                              Title




7/22/2011
Revised: April 12, 2010                                                                                                                20                                                                                                            D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                        Human Capitol Management Toolkit




                          QUERY DESCRIPTION     LONG DESCRIPTION                            TYPE     QUERY NAME                                       PROMPTS                        RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                                                FREQUENCY

    Position Management
                          Active/Inactive Pos   Returns Active or Inactive Positions        Report   Active/Inactive Positions (0212)                 As of Date                     As required                    MAIN MENU > ORGANIZATIONAL DEVELOPMENT > POSITION
                                                based on check box selected on Run                                                                    From Company                                                  MANAGEMENT > POSITION REPORTS
                                                Control                                                                                               To Company
                                                                                                                                                      Check Box Active Positions
                                                Output is Business Unit, Department ID,                                                               Check Box Inactive Positions
                                                Position Number, Effective Date,
                                                Position Title, Reports To, Company,
                                                Location, Max Head Count, Full/Part,
                                                Reg/Temp, Std Hours, Job Share,
                                                Position Status, Effective Status, Status
                                                Date, Budgeted Position (Y/N)

                                                Sorts by Job Code; provides total
                                                number of Job Codes at each Job Code
                                                break; and total number of positions at
                                                the end of the report

                          Incumbents            Returns all agency employees                Query    GO_HR_POSITIONS_INCUMBENTS                       Company                        Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                Includes Work Location and Work
                                                Address, Empl ID, Name, FTE, Job
                                                Code and Description, Position
                                                Number, Compensation, and Adds to
                                                FTE Y/N
                          Incumbents            Returns all agency employees                Query    GO_HR_POS_INC_BY_LOC_JOBCD                       Company                        Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                Includes Work Location and Work
                                                Address, Empl ID, Name, FTE, Job
                                                Code and Description, SSN, Position
                                                Number, Compensation, and Adds to
                                                FTE, Reports To
                          Incumbents            Returns listing of employees in that        Report   Agency Incumbent by Pos (0077)                   From Agency                    Agency: As needed              MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                agency                                                                                                To Agency                      OPM: As required               > hr

                                                Output sorts by Agency/Description and
                                                then Position Number, with Position
                                                Department ID and Description,
                                                Position Allocated Job Code, the
                                                Incumbent Job Code and the Employee
                                                Name

                                                If there is no Incumbent in the Position,
                                                the value in the Employee Name
                                                column is "VACANT"
                          Position Prompt       Returns all Job Data rows for               Query    GO_HR_POSITION_PROMPT                            Company                        Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                employee(s) who has been in a Position                                                                Position Number
                                                on the Job Data record                                                                                From Eff Dt                    Corrections to Job Data will
                                                                                                                                                      To Eff Dt                      require a Correct History
                                                Note: Take into account the HIR/CNV                                                                                                  Help Desk Case
                                                row for converted employees; the
                                                Effective Date on the first row is the
                                                Hire Date--the Hire Row date may not
                                                be the date the employee actually went
                                                into the Position on that row




7/22/2011
Revised: April 12, 2010                                                                                                                               21                                                                                                          D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                                Human Capitol Management Toolkit




                          QUERY DESCRIPTION               LONG DESCRIPTION                           TYPE     QUERY NAME                                      PROMPTS                          RECOMMENDED                    NAVIGATION
                          REPORT NAME                                                                                                                                                          FREQUENCY
                          Position List                   Returns all positions                      Query    GO_HR_POSITION_LIST                             Agency                           As required                    MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                          Includes Position, Name, Jobcode,
                                                          Position Title, Location, Location Name,
                                                          Dept Name, Full/Part, Reg/Temp, Std
                                                          Hrs, Status Date


                          Position Status                 Returns information related to the         Report   Position Status                                 Language (defaults to English;   As required                    MAIN MENU > ORGANIZATIONAL DEVELOPMENT > POSITION
                                                          Position, which includes incumbents;                                                                use default)                                                    MANAGEMENT > POSITION REPORTS
                                                          sorts by Department Code                                                                            As of Date
                                                                                                                                                              From Agency
                                                          Output includes Agency                                                                              To Agency
                                                          Number/Description, Department ID,
                                                          Job Code, Position Number, Effective
                                                          Date, Position Title, Reg/Temp,
                                                          Contract, Position Status, Status Date,
                                                          Requisition Information for Recruit
                                                          Workforce which is not used, and
                                                          Incumbent Name


                          Position Val                    Returns agency Positions, retrieving the   Query    GO_HR_POSITION_VAL                              Business Unit                    Agency HR: As needed           MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          most current effective-dated row from
                                                          the Position Data table                                                                                                              Use in conjunction with (or
                                                                                                                                                                                               separate from) OCP_083HR
                                                          This is a Position Data table validation                                                                                             Pos by EEO Category
                                                          query; no employee information is                                                                                                    Report (retrieves filled and
                                                          returned                                                                                                                             vacant positions)

                                                          Recommend downloading into CSV or
                                                          Excel
                          Position Variance               Compares position jobcode, location,       Query    GO_HR_POSITION_VARIANCE                         Agency                           As required                    MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          dept, f/p, r/t, Std.Hrs values to
                                                          employee record
                          Unclass Positions               Returns listing of all Unclassified        Report   Unclass Positions by Agy (0117)                 From Company                     Agency HR: As needed           MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                          employees in that agency, and any                                                                   To Company                       OPM: As required               > hr
                                                          positions that are VACANT                                                                           From Department
                                                                                                                                                              To Department
                                                          Output is Position Number, Department
                                                          ID from Position, Location from
                                                          Position, FTE from Position, Job Code
                                                          from Position, Employee ID, Employee
                                                          Name, Unclassified Cite Code

                          Vacant Positions with History   Returns vacant Positions (no current       Query    GO_HR_VACANT_POSITIONS_HISTORY                  Company                          As required                    MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                          incumbents)

                                                          Output is Position Number, Location,
                                                          Location Description, Department ID,
                                                          Dept Description, Job
                                                          Code/Description, Reg/Temp, Full/Part,
                                                          FTE, Status Date, Empl ID, Name,
                                                          Posn End Date




7/22/2011
Revised: April 12, 2010                                                                                                                                       22                                                                                                            D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                                            Human Capitol Management Toolkit




                          QUERY DESCRIPTION                            LONG DESCRIPTION                           TYPE     QUERY NAME                                     PROMPTS              RECOMMENDED                     NAVIGATION
                          REPORT NAME                                                                                                                                                          FREQUENCY
                          Vacant Unclassified Positions by Cite Code   Returns vacant Positions (no current       Query    GO_HR_VACANT_POS_BY_CITE_CD                    Company              As required                     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       incumbents)

                                                                       Output is Cite Code, Position Number,
                                                                       Effdt, Description, Jobcode, DeptID,
                                                                       Location, Reg/Temp, Full/Part,
                                                                       Class/Uncl
                          Vacant Positions                             Returns vacant Positions (no current       Report   Vacant Positions by Agy (0221)                 Agency               As required                     MAIN MENU > ORGANIZATIONAL DEVELOPMENT > POSITION
                                                                       incumbents)                                                                                                                                             MANAGEMENT > POSITION REPORTS

                                                                       Output is Agency Number/Description,
                                                                       Position Number, Department ID, Job
                                                                       Code/Description, Reg/Temp, Full/Part
                                                                       Time, Confidential Position (Y/N),
                                                                       Status, Status Date

                                                                       Sorts by Department ID with total
                                                                       number of Positions in that Department
                                                                       at each change of Department

                                                                       Grand Total of Vacant Positions for
                                                                       Agency is at end of report




    System Tables
                          Action Reason Tbl                            Returns listing of all Action-Reasons on   Report   Action Reason Table                            None                 As required                     MAIN MENU > SETUP HRMS > WORKFORCE ADMINISTRATION >
                                                                       the Table, both Active and Inactive;
                                                                       Inactive are notated on the report with
                                                                       an 'I'

                                                                       No employee information is included on
                                                                       this report
                          Location Table                               Returns Agency active and inactive         Query    GO_HR_LOCATION_VAL                             SetID                Agency HR: As needed            MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                       Location Codes, retrieving the most                                                                                     Agency PY: As needed
                                                                       current effective-dated row
                                                                                                                                                                                               Ensure that if Agency has
                                                                       This is a Location Table validation                                                                                     created a new Location
                                                                       query; no employee information is                                                                                       Code, effective date is
                                                                       returned                                                                                                                considered (as this is a
                                                                                                                                                                                               default on Position Data)
                                                                       Recommend downloading into CSV or                                                                                       and that the Establishment
                                                                       Excel                                                                                                                   ID has been included for that
                                                                                                                                                                                               Location Code

                                                                                                                                                                                               Agencies are responsible for
                                                                                                                                                                                               maintaining their respective
                                                                                                                                                                                               Location Codes




7/22/2011
Revised: April 12, 2010                                                                                                                                                   23                                                                                                 D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                      Human Capitol Management Toolkit




                          QUERY DESCRIPTION   LONG DESCRIPTION                          TYPE     QUERY NAME                         PROMPTS              RECOMMENDED   NAVIGATION
                          REPORT NAME                                                                                                                    FREQUENCY
                          Salary Grade        Returns all effective dated rows from     Report   Salary Grade Table                 None                               MAIN MENU > COMPENSATION > SALARY PLAN REPORTS
                                              the Salary Grade Table for those Salary
                                              Plans that have a Grade structure, such
                                              as Salary Plan of Classified with the
                                              associated Grades, beginning with the
                                              most recent Effective Date and working
                                              backwards

                                              There is no employee information in the
                                              output

                                              The output includes a row for each
                                              effective dated row with Setid, Salary
                                              Plan/Grade, Description of the Grade,
                                              Effective Date, and the Hourly, Daily,
                                              Monthly and Annual Min-Mid-Max Dollar
                                              Amounts




7/22/2011
Revised: April 12, 2010                                                                                                             24                                                                                  D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                                  Human Capitol Management Toolkit




                          QUERY DESCRIPTION                        LONG DESCRIPTION                          TYPE     QUERY NAME                                PROMPTS                        RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                                          FREQUENCY

Payroll
    Audit
                          Account Codes by FY and SetID            Account Codes by FY and SetID             Query    GO_PY_ACCOUNT_CODES_AGNCY                 SetID                          On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                                Budget Reference
                          All Comp                                 All compensation rates by Company         Query    GO_PY_COMPENSATION_SETUP                  Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                   and Location                                                                                 Location%
                          Audit HR Actions in Paygroup             Looks for transactions between certain    Query    GO_PY_AUDIT_ENTRY_BY_PAYGROUP             Company, action dates, &       Each Payroll Processing   MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                   Action dates in a specific Paygroup on                                                       Paygroup.
                                                                   Job Data.
                          Check Confirms                           Check for Confirms                        Query    GO_PY_CALENDAR_STATUS                     Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Check Pay Calendar                       Check Pay Calendar Setup                  Query    GO_PY_PAY_CALENDAR_SETUP                  Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Calendars Not Confirmed                  Calendars Not Confirmed                   Query    GO_PY_CAL_NOT_CONFIRMED                   Pay Run ID                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Checks by Pay Period                     Checks paid for selected pay periods      Query    GO_PY_CHECKS_PAID                         Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                                Pay Period End Date
                                                                                                                                                                Check Issue Date
                          Count Paysheets                          Count paysheets                           Query    GO_PY_COUNT_PAYSHEETS                     Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                                Pay Period End
                          Direct Deposit                           Lists employees who have a Direct         Query    GO_PY_DIRECT_DEPOSIT_INFO_LOC             Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                   Deposit record within that agency
                          Earnings Statements                      Earnings Statements for Checks and        Report   Earnings Statement (0040)                 On Cycle Run:                  Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                   Advices                                                                                      Pay Run ID                                               > PAYROLL
                                                                                                                                                                Off Cycle Pay Calendar:
                                                                                                                                                                Company
                                                                                                                                                                Pay Group
                                                                                                                                                                Pay Period End Date
                                                                                                                                                                Process Page / Thru
                                                                                                                                                                Payroll Cycle:
                                                                                                                                                                On Cycle
                                                                                                                                                                Off Cycle
                                                                                                                                                                Both
                                                                                                                                                                Starting Check/Advice Nbr
                                                                                                                                                                Thru
                                                                                                                                                                Message
                          Fed/State Tax                            Federal and State Tax Withholding Info    Query    GO_PY_FED_STATE_TAX_WH                    Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                          Fed or State Tax Exemption               Audits for Fed or State Tax Exemption     Query    GO_PY_TAX_EXEMPT_AUDIT                    Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                          Longevity                                Longevity by Division                     Query    GO_PY_LONGEVITY_DIVISION                  Pay Period Start Date          On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                                Pay Period End date
                                                                                                                                                                Company
                                                                                                                                                                Earnings Code
                          Longevity Comp                           Calculates the Longevity payment          Report   MDC Lgvty Cmp (0024)                      Years of Service               Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                   amount according to specific                                                                                                                          > PAYROLL
                                                                   requirements and enters the information
                                                                   into Payable Time.
                          Longevity Payments                       Lists employees and amounts being         Report   Longevity Amounts (0024)                                                 Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                   paid longevity this pay cycle                                                                                                                         > PAYROLL
                          Paygroup Change                          List employees with Paygroup changes      Query    GO_PY_PAYGROUP_MIDPERIOD_CHG              Pay Run ID (for period begin   Each Payroll Processing   MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                   within a pay period.                                                                         and end)
                                                                                                                                                                Company
                          Paygroup Audit                           Lists employees whose JOB paygroup        Query    GO_PY_PAYGRP_REVIEW                       Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                   does not match their Payroll Date
                                                                   Primary Paygroup
                          Paygroup Difference between PY and Job   Lists employees that have a different     Query    GO_PY_PAYGRPDIFF_JOB_PYRL_CMP             Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                   paygroup on job versus the paygroup
                                                                   shown on the Payroll Data 2 tab, by
                                                                   company.
                          Payline Data                             Payline Data for Company by Pay           Query    GO_PY_PAY_PAYLINE                         Pay Period End                 On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                   Period                                                                                       Company



7/22/2011
Revised: April 12, 2010                                                                                                                                         25                                                                                                     D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                   Human Capitol Management Toolkit




                          QUERY DESCRIPTION             LONG DESCRIPTION                           TYPE     QUERY NAME                           PROMPTS                    RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                       FREQUENCY
                          Payroll - GL                  Payroll data sorted and totaled by GL      Report   Budget Check (0025)                  Pay Run:                   Each Payroll Processing   MAIN MENU > PAYROLL FOR NORTH AMERICA > PAYROLL
                                                        accounting data                                                                          Pay Run ID                                           DISTRIBUTION > PREPARE GL INFORMATION >
                                                                                                                                                 or
                                                                                                                                                 Pay Calendar:
                                                                                                                                                 Company
                                                                                                                                                 Pay Group
                                                                                                                                                 Pay End Date
                                                                                                                                                 Business Unit
                                                                                                                                                 Display Details checkbox
                                                                                                                                                 Approving Officer
                                                                                                                                                 Approving Board Member
                                                                                                                                                 Authorized Agent of OPM
                          Reconcile Longevity           Data used to reconcile the Longevity       Query    GO_PY_LONGRECON                      Pay Run ID                 On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        Report
                          Review Paygroups by Company   Review Paygroups by Company                Query    GO_PY_PAYGRP_PROMPT                  Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                 Paygroup
                          Validate Pay Calendar         Validate Pay Calendar by Company           Query    GO_PY_PAY_CALENDAR                   Pay Run ID                 On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Zero Net Check                Check for a net pay of zero                Query    GO_PY_CHECK_NETPAY_FOR_ZERO          Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                 Pay Period End Date

    Deductions
                          AP Status for Garns           Reports AP status of garnishment           Query    GO_PY_GARNISH_NOT_SENT_TO_AP         Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        payments                                                                                 Greater than Date
                          Bonds                         Bond Spec Data by Company                  Query    GO_PY_BOND_SPEC_DATA                 Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Garn Deduction                Garnishment Deduction Information by       Query    GO_PY_GARNISHMENT_DED_INFO           Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        Company and Pay Period                                                                   From Pay Period End Date
                                                                                                                                                 Thru Pay Period End Date
                          Garn Spec Data                Validate Garn Spec Data Setup              Query    GO_PY_GARN_SPEC_DATA                 Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Garnishment Fees              The query returns the garnishment          Query    GO_PY_GARN_FEES                      Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        amount and the fees paid. It can be                                                      Pay Period End Date
                                                        used as supporting detail on the
                                                        voucher to pay the processing fee to the
                                                        agency
                          Garns Balances                Garnishment Balances by Company            Query    GO_PY_GARNISHMENT_BALANCES           Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                 Year
                          Gen Ded by Company            General Deductions by Company              Query    GO_PY_GENERAL_DEDUCTIONS             Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          General Deductions            Lists general deductions by company        Query    GO_PY_COMPANY_GENL_DED               Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                          List of Garnishments          Query returns the Vendor ID, Invoice #,    Query    GO_PY_GARN_BY_PAY_END_DT             Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        EmplID, Amount, Pay Period End date                                                      Pay Period End Date
                                                        and 'Sent to AP' Status of garnishments

                          OLERS Enrollment              Employees who have elected OLERS           Query    GO_PY_OLERS_ENROLL                   Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        Plan Type 70
                          OPERS Enrollment              Employees who have elected OPERS           Query    GO_PY_OPERS_ENROLL                   Company                    On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        Plan Type 4Y
                          Detail AP Extract Line        Detailed AP extract line with employee     Query    GO_PY_AP_EXTRACT_BY_PAYRUN           Payrun ID                  On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        ID and voucher ID. Run by payrun ID.

                          AP Extract Summary            List of AP Vouchers extracted by payrun    Query    GO_PY_AP_EXTRACT_SUMMARY             Payrun ID                  On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        ID. The amounts are summed up by
                                                        voucher number. Run by payrun ID.

                          Detailed AP Line w/Wrong BU   AP extract line with AP Business Unit      Query    GO_PY_AP_EXTRACT_WRONG_BU            Payrun ID                  On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                        not equal to the agency business unit.                                                   AP Business Unit
                                                        This query helps users identify AP lines
                                                        for employees who transferred to a
                                                        different agency mid-pay period.




7/22/2011
Revised: April 12, 2010                                                                                                                          26                                                                                                 D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                                 Human Capitol Management Toolkit




                          QUERY DESCRIPTION                LONG DESCRIPTION                           TYPE     QUERY NAME                                      PROMPTS                     RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                                      FREQUENCY
                          Teachers Retirement Deductions   Run by Companies that have Teachers'       Report   Teachers Retirement Rpt (0102)                  Company                     Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                           Retirement and sent in with the                                                                     Beginning Pay End Date                                > PAYROLL
                                                           payments                                                                                            Ending Pay End Date

    Earnings
                          BEA, RBA                         Total BEA, RBA by Agency                   Query    GO_PY_ADDITIONAL_PAY_PAID                       Company                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                               Earnings Code
                          Check earnings detail            Earnings Detail                            Query    GO_PY_CHECK_EARNINGS_DETAIL                     Payrun ID                   On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Gross to Net                     Gross to Net by Company                    Query    GO_PY_GROSS_TO_NET_W_SALARY                     Company                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                               Pay Period End Date
                                                                                                                                                               Off-Cycle?
                          Neg RET Spcl Accum by Pay End    Use after Pay Calc is run to find          Query    GO_PY_NEGATIVE_RET_ACCUMULATOR                  Company                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           negative RET Special Accumulator                                                                    Pay End Date
                                                           earnings by Pay End Date. If any
                                                           found, enter a one time deduction
                                                           OVERRIDE with the correct percent and
                                                           calc routine of Rate X Special Earnings.




                          Overtime Earnings                Overtime Earnings                          Query    GO_PY_OT_EARNS_BY_PERIOD                        Company                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          Other Earns                      All Other Earns Paid                       Query    GO_PY_PAY_OTHER_EARNS                           Company                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                               Pay Period End Date
                                                                                                                                                               Earn Code
                                                                                                                                                               Off Cycle
                          Shift, Training, On Call         Shift Differential, Training Pay and On    Query    GO_PY_COMPENSATION                              Company                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           Call                                                                                                Company CRC%
                                                                                                                                                               From Pay Period
                                                                                                                                                               To Pay Period Date

    Funding
                          Blank Earnings Dist.             Blank Earnings Distribution by             Query    GO_PY_BLANK_JOB_EARN_ACCT_CD                    Company                     On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           Company and Location                                                                                Location
                                                                                                               MAIN MENU> REPORTING TOOLS > QUERY >
                                                                                                               QUERY VIEWER
                          Earns Dist Acct Codes            Check Job Earn Dist Acct Codes             Query    GO_PY_JOB_EARNS_DIST                 Company                                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                                                                                                               MAIN MENU> REPORTING TOOLS > QUERY >
                                                                                                               QUERY VIEWER
                          Funding Account Codes            Funding Account Codes by Company           Query    GO_PY_FUNDING_ACCOUNT_CODES          Company                                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

                          Funding Accts and Sub-Activity   Breaks down the total cost of a payroll    Report   Funding Distribution Rep (0108)                 Pay Run: Pay Run ID         Each Payroll Processing   MAIN MENU > PAYROLL FOR NORTH AMERICA > PAYROLL
                                                           in detail by Fund Acct and Sub-Activity                                                             or                                                    DISTRIBUTION > PREPARE GL INFORMATION >
                                                                                                                                                               Pay Calendar:
                                                                                                                                                               Company
                                                                                                                                                               Pay Group
                                                                                                                                                               Pay End Date

    Leave
                          Leave Accrual Audit              Leave Accrual Audit                        Report   Leave Accrual Audit Rpt (0056)                  As of Date                  On Demand                 MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                               Sort (1=Emplid, 2=Name,                               > PAYROLL
                                                                                                                                                               3=Location, 4=Deptid)
                                                                                                                                                               Minimum Hours
                                                                                                                                                               Hours Checked (A=Annual,
                                                                                                                                                               C=Combined Sick & Annual)
                                                                                                                                                               Agency
                                                                                                                                                               Beginning Deptid
                                                                                                                                                               Ending Deptid




7/22/2011
Revised: April 12, 2010                                                                                                                                        27                                                                                                  D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                          Human Capitol Management Toolkit




                          QUERY DESCRIPTION         LONG DESCRIPTION                          TYPE     QUERY NAME                                       PROMPTS                        RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                                  FREQUENCY
                          Leave Accrual Errors      Leave Accrual Errors                      Report   Leave Error Rpt (0057)                           As of Date                     Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                        Sort By (1. Empl ID 2. Empl                              > PAYROLL
                                                                                                                                                        Name)
                                                                                                                                                        Agency
                          Leave Accruals            Leave Accruals                            Report   Emp Leave Accrual Rpt (0053)                                                    Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                                                                                 > BENEFITS
                          Leave Obligation          Leave Obligation                          Report   Leave Obligation Report (0308)                   Agency                         Fiscal Year End           MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                        Plan Type (50=Sick,                                      > PAYROLL
                                                                                                                                                        51=Annual)
                                                                                                                                                        Accrual Process Date

    Registers
                          Creation of Claim         Creation of Claim Document                Report   Payroll Claim Document (0018)                                                   Each Payroll Processing   MAIN MENU > PAYROLL FOR NORTH AMERICA > PAYROLL
                                                                                                                                                                                                                 DISTRIBUTION > PREPARE GL INFORMATION >
                          Credit Union Deductions   Employee Deduction detail for OPEA or     Report   Credit Union Report (0104)                       Company                        Each Payroll Processing   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                    the Credit Union                                                                                    Pay Run ID                                               > PAYROLL
                                                                                                                                                        Plan Type
                                                                                                                                                        Deduction Code
                                                                                                                                                        Sort Order (1=SSN, 2=Name)
                                                                                                                                                        Agency

                          Deduction Register        Based on the user’s row level security,   Report   Deduction Register (0205)                        On Cycle Run:                  Each Payroll Processing   PAYROLL FOR NORTH AMERICA > PAYROLL PROCESSING USA >
                                                    only allows them to see the companies                                                               Pay Run ID                                               PAY PERIOD REPORTS
                                                    they have access to                                                                                 Off Cycle Pay Calendar:
                                                                                                                                                        Company
                                                                                                                                                        Pay Group
                                                                                                                                                        Pay End Date
                                                                                                                                                        Process Page / Thru
                                                                                                                                                        Payroll Cycle:
                                                                                                                                                        On Cycle
                                                                                                                                                        Off Cycle
                                                                                                                                                        Both
                          Employee Payroll Count    Lists the number of employees on the      Report   Employees on Agt Payroll (0113)                                                 Monthly                   MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                    payroll as of the end of each month                                                                                                                          > PAYROLL

                          List Paychecks            List of paychecks by pay period           Query    GO_PY_PAY_CHECK_LIST                             Company                        On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        Pay Period End Date
                                                                                                                                                        Paycheck Issue Date
                          Longevity Eligibility     Payroll Longevity Eligibility             Report   Longevity Pay Eligibility (0060)                 Year                           On Demand                 MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                        Sort By: EmplID, or Name, or                             > PAYROLL
                                                                                                                                                        Department ID
                                                                                                                                                        From Month
                                                                                                                                                        Thru Month
                                                                                                                                                        From Agency
                                                                                                                                                        To Agency
                          Multiple Worksite Rpt     Breakdown by county on employment         Report   OESC Multiple Worksite Report                    Company                        On Demand                 MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                    and wage information                                                                                Year                                                     > PAYROLL
                                                                                                                                                        Quarter




7/22/2011
Revised: April 12, 2010                                                                                                                                 28                                                                                                     D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                            Human Capitol Management Toolkit




                          QUERY DESCRIPTION            LONG DESCRIPTION                           TYPE     QUERY NAME                                     PROMPTS                       RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                                   FREQUENCY
                          PY register - by Div/Name    Adds the ER portion to the payroll         Report   Payroll Reg - Div/Name (0312c)                 Process Request Parameters:   Each Payroll Processing   PAYROLL FOR NORTH AMERICA > PAYROLL PROCESSING USA >
                                                       register and sorts by division then last                                                           On Cycle Run:                                           PAY PERIOD REPORTS
                                                       name                                                                                               Pay Run ID
                                                                                                                                                          Off-Cycle Pay Calendar:
                                                                                                                                                          Company
                                                                                                                                                          Pay Group
                                                                                                                                                          Pay End Date
                                                                                                                                                          Page Number / Thru
                                                                                                                                                          Payroll Cycle:
                                                                                                                                                          On-Cycle
                                                                                                                                                          Off-Cycle
                                                                                                                                                          Both

                          PY register - by Mail Drop   Adds the ER portion to the payroll         Report   Payroll Reg - Mail Drop (0312)                 Process Request Parameters:   Each Payroll Processing   PAYROLL FOR NORTH AMERICA > PAYROLL PROCESSING USA >
                                                       register and sorts by mail drop                                                                    On Cycle Run:                                           PAY PERIOD REPORTS
                                                                                                                                                          Pay Run ID
                                                                                                                                                          Off-Cycle Pay Calendar:
                                                                                                                                                          Company
                                                                                                                                                          Pay Group
                                                                                                                                                          Pay End Date
                                                                                                                                                          Page Number / Thru
                                                                                                                                                          Payroll Cycle:
                                                                                                                                                          On-Cycle
                                                                                                                                                          Off-Cycle
                                                                                                                                                          Both

                          PY register - by Name        Adds the ER portion to the payroll         Report   Payroll Register - Name (0233)                 Process Request Parameters:   Each Payroll Processing   PAYROLL FOR NORTH AMERICA > PAYROLL PROCESSING USA >
                                                       register and sorts by name                                                                         On Cycle Run:                                           PAY PERIOD REPORTS
                                                                                                                                                          Pay Run ID
                                                                                                                                                          Off-Cycle Pay Calendar:
                                                                                                                                                          Company
                                                                                                                                                          Pay Group
                                                                                                                                                          Pay End Date
                                                                                                                                                          Page Number / Thru
                                                                                                                                                          Payroll Cycle:
                                                                                                                                                          On-Cycle
                                                                                                                                                          Off-Cycle
                                                                                                                                                          Both

                          Workers Comp Payments        Calculates total due for a specified       Report   Workers Comp Reports (0110)                    Division                      On Demand                 MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                       period for Workers Comp                                                                            Issue Date                                              > PAYROLL
                                                                                                                                                          Start Date
                                                                                                                                                          End Date
                                                                                                                                                          From Agency
                                                                                                                                                          To Agency
                                                                                                                                                          Experience Modifier




7/22/2011
Revised: April 12, 2010                                                                                                                                   29                                                                                                    D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                          Human Capitol Management Toolkit




                          QUERY DESCRIPTION                LONG DESCRIPTION                       TYPE     QUERY NAME                                   PROMPTS                RECOMMENDED               NAVIGATION
                          REPORT NAME                                                                                                                                          FREQUENCY

Time & Labor
    Audit
                          Audit Posted Time                Weekly Elapsed Time by OperID          Query    GO_TL_AUD_TIME_POSTED_BY_OPRID               From Date              On Demand                 MAIN MENU > OK CUSTOM REPORTS/PROCESSES > OK REPORTS
                                                                                                                                                        To Date                                          > PAYROLL
                                                                                                                                                        Operator ID
                          Audit Posted Time                Weekly Elapsed Time by UserID          Query    GO_TL_AUDIT_ELAPSED_TME_EMP                  From Date              On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        To Date
                                                                                                                                                        Operator ID
                          Elapsed Time Above               Weekly Elapsed Time Above Stated       Query    GO_TL_WKLY_TIME_MORE_THAN_100                Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           Quantity                                                                                     From Date
                                                                                                                                                        To Date
                                                                                                                                                        Quantities Above____
                          Empls by Workgroups              Employees by Workgroups                Query    GO_TL_CHECK_WORKGROUPS                       Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        Workgroup+%
                          FMLA TRC's                       FMLA Time Reporter Codes               Query    GO_TL_FMLA_TRC                               Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date
                          LWOP TRC's                       Payable Time by LWOP TRC's             Query    GO_TL_TIME_LWOP_TRC                          Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date
                          Keyed Time                       Keyed Weekly Elapsed Time              Query    GO_TL_WEEKLY_ELAPSED_TIME                    Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date
                          Keyed Time by Location           Keyed Weekly Elapsed Time              Query    GO_TL_ELAPSED_TIME_BY_LOC                    Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date
                          Keyed Time                       Keyed Weekly Elapsed Time - TRC        Query    GO_TL_WEEKLY_ELAPSED_TIME_TRC                Company                Each Payroll Processing   MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date
                                                                                                                                                        TRC
                          Negative Leave                   List of negative leave that needs      Query    GO_TL_TIME_NEEDS_APPROVED                    Workgroup ID           On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           approval
                          Payable Status                   Payable Status Report with Row Level   Report   Payable Status Report (0203)                 Description            Each Payroll Processing   MAIN MENU > TIME AND LABOR > REPORTS
                                                           security incorporated                                                                        From Date
                                                                                                                                                        End Date
                                                                                                                                                        Agency
                                                                                                                                                        Checkboxes:
                                                                                                                                                        Approved
                                                                                                                                                        Closed
                                                                                                                                                        Diluted
                                                                                                                                                        Estimated
                                                                                                                                                        Needs Approval
                                                                                                                                                        Paid
                                                                                                                                                        Rejected
                                                                                                                                                        Sent to Payroll
                                                                                                                                                        Taken by Payroll
                          Payable Time and Status          Payable Time and Status plus Name,     Query    GO_TL_PAY_TIME_TRCS_SUM_DHS                  Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                           Div and Loc
                          Payable Time-Employee            Payable Time by EmplID                 Query    GO_TL_PAY_TIME_BY_EMPLID                     Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date
                                                                                                                                                        EmplID
                          Payable Time by TRC & Location   Payable Time by TRC & Location         Query    GO_TL_TIME_TRC_PAY_PER_LOC                   Company                On Demand                 MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date
                                                                                                                                                        trc
                          Payable Time-Pay Period          Payable Time by Pay Period             Query    GO_TL_PAY_TIME_BY_PAY_PERIOD                 Company                Each Payroll Processing   MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                        From Date
                                                                                                                                                        To Date



7/22/2011
Revised: April 12, 2010                                                                                                                                 30                                                                                             D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls
                                                                                                                                         Human Capitol Management Toolkit




                          QUERY DESCRIPTION                    LONG DESCRIPTION                           TYPE    QUERY NAME                           PROMPTS                       RECOMMENDED   NAVIGATION
                          REPORT NAME                                                                                                                                                FREQUENCY
                          Time by Mail Drop                    Returns TL information sorting against     Query   GO_TL_PAYABLE_TIME_BY_MAILDROP       Company                       On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                               Mail Drop using the LIKE feature                                                        Mail Drop (use % wild card;
                                                                                                                                                       e.g. 090%)
                                                               Enter the % sign as the wildcard to pull
                                                               multiple LIKE Mail Drop ID's.

                          TL Exceptions                        Query returns exceptions listed by         Query   GO_TL_EXCEPTIONS_BY_AGENCY_DIV       Company                       On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                               agency and division
                          TL Exceptions                        List of Exceptions from T&L                Query   GO_TL_EXCEPTIONS_BY_AGENCY           Company                       On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          TR v. Job                            Check TR versus Job                        Query   GO_TL_TIME_REPORTER_LIST             Company                       On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                          TRCs                                 TRCs by Program                            Query   GO_TL_TRC_LIST_BY_PROGRAM            TRC Program                   On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER

    Comp Time
                          Comp Balance                         Comp Balance by EmplID                     Query   GO_TL_COMP_DAY_BAL                   EmplID                        On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Comp Plan (COMPREG,
                                                                                                                                                       SHARED, etc)
                          Comp Plans                           List of Comp Plans by employee             Query   GO_TL_COMP_PLAN_ENROLLMENT           Company                       On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Comp Plan (COMPREG,
                                                                                                                                                       SHARED, etc.)
                          Leave/Comp Balance                   Leave and Comp Balances                    Query   GO_TL_LEAVE_BAL                      Agency+%                      On Demand     MAIN MENU> REPORTING TOOLS > QUERY > QUERY VIEWER
                                                               Includes Department, Location, Division                                                 Leave Accrual Proc Dt >=
                                                               and Special Use fields 1 and 2


Training
                          Agency Workshop Participant Status   Agency Workshop Participant Status         Query   GO_AT_AGENCY_PARTICIPNT_STATUS       Session Start Date            On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Session End Date
                          Course List with Ed Units            Course List with Ed Units                  Query   GO_AT_COURSE_LISTING                                               On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                          Participant Status For Course        Participant Status For Course              Query   GO_AT_COURSE_PARTICIPANT_STAT        Course Code                   On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Session Start Date
                                                                                                                                                       Session End Date
                          Training History by Individual       Training History by Individual             Query   GO_AT_INDIVIDUAL_TRANSCRIPTS         Employee ID                   On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                          Couse Attendance by Session          Couse Attendance by Session                Query   GO_AT_PARTICIPANTS_BY_DATE           Session Start Date            On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Session End Date
                          Workshop Participant Status          Workshop Participant Status                Query   GO_AT_PARTICIPANT_WORKSHOP_ST        Session Start Date            On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Session End Date
                          Student Counts for Course/Sess       Student Counts for Course/Sess             Query   GO_AT_SESSION_PARTICIPANT_CNTS       Session Start Date            On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Session End Date
                          Session Roster                       Session Roster                             Query   GO_AT_WORKSHOP_ROSTER                Session Start Date            On Demand     MAIN MENU > REPORTING TOOLS > QUERY > QUERY VIEWER
                                                                                                                                                       Session End Date




7/22/2011
Revised: April 12, 2010                                                                                                                                31                                                                                        D:\Docstoc\Working\pdf\83a5808d-d23c-46e9-9365-8615dc6585f9.xls

								
To top