Docstoc

epm-dataviews

Document Sample
epm-dataviews Powered By Docstoc
					                                                                                                        University of Wisconsin System
                                                                                                                  HRS Project
                                                                                                                Data Dictionary
                                                                                                            Data View Descriptions




**UPDATED 2/2/2011
                                                                                                                   IAM Security Role(s)
                                                           Date Added /    Functional    Sensitive/Non-      (If muliple are listed, only one is
Data View/Record     View Name                               Updated         Area           Sensitive        needed to access the Data View)                                                           Description
UW_AM_ABSEVT_VW      Absence Event Definition Data View       10/31/2010 Absence        Non-Sensitive     EPM AM Query All Non Sensitive           Contains details for the employee's absence. Fields include Absence Reason, Absence Duration, Absence Take and
                                                                         Management                                                                Description, and Manager Approved.
UW_AM_ABSOVR_VW      Absence Override Definition Data         10/31/2010 Absence        Non-Sensitive     EPM AM Query All Non Sensitive           Contains Absence Override information. Fields include Entitlement Type and Frequency Option, Entitlement
                     View                                                Management                                                                Element, PIN Number, and Element Name.
UW_AM_ACCUM_VW       Absence Accumulator Data View            11/30/2010 Absence        Non-Sensitive     EPM AM Query All Non Sensitive           Contains Accumulator information. Accumulators are elements that store the cumulative values of defined items
                                                                         Management                                                                as they’re processed. For example, they can store accrued entitlement balances and other cumulative values.
                                                                                                                                                   There are two types of accumulators, some that pertain to a single segment, and others that span several
                                                                                                                                                   calculation periods: Segment accumulators accumulate values during a single segment and Balance accumulators
                                                                                                                                                   accumulate values over a period of time, such as a month or a year. Fields include Accumulator Type, Calculation
                                                                                                                                                   Status and Value, PIN Number and Element Name.
UW_AM_BAL_VW         (Non-Sensitive) Absence                    8/8/2011 Absence        Non-Sensitive     EPM AM Query All Non Sensitive           This view contains Absence Management balance information. This view will allow users to query balances as of a
                     Management Balance View                             Management                                                                particular date. Fields include Employee ID, Period End Date, PIN Number, Element Name, Union Code, Calculation
                                                                                                                                                   Result Value, Employee Classification, Calendar ID and Period ID.
UW_AM_ERNDED_VW      Absence Management                       11/30/2010 Absence        Non-Sensitive     EPM AM Query All Non Sensitive           Contains Absence elements related to earnings and deductions. Fields include Base Adjustment, Calculated Base
                     Earnings/Deductions Results Data                    Management                                                                Value and Adjustment, PIN Number and Element Name
                     View
UW_AM_PD_HRS_VW      (Non-Sensitive) Accumulator PIN           2/28/2011 Absence        Non-Sensitive     EPM AM Query All Non Sensitive           This view contains results for accumulator elements. Fields include Employee ID, Calendar ID, AM Paid Hours,
                     Results Data View                                   Management                                                                Period Begin and End Dates, and Forecasted Hours.
UW_AM_RLT_CG_VW      Absence Results by Calendar Group        10/31/2010 Absence        Non-Sensitive     EPM AM Query All Non Sensitive           Absence Management Results by Calendar Group View will display positive input, absence, and retroactive
                     Data View                                           Management                                                                processing results. This provides information about particular absences used/paid during particular periods as
                                                                                                                                                   opposed to balances. Fields include Absence Reason, Absence Type, Entitlement Balance, and Pay Group

UW_BN_ABBR_VW        Annual Benefits Base Rate Data           11/30/2010 Benefits       Sensitive         EPM BN Query Sensitive                   Contains employee's annual benefit base rate information. Field include Employee ID, Employee Record Number,
                     View                                                                                                                          Annual Benefits Base Rate, and Annual Benefits Base Rate Type.
UW_BN_BENCNS_VW      Benefits Counseling Data View              2/2/2012 Benefits       Sensitive         EPM BN Query Sensitive                   Contains information that will be utilized for benefit counseling sessions (with employees) and benefit
                                                                                                                                                   transactional reporting purposes. Fields include Compensation, FTE, Union Code, and Benefit Plan.
UW_BN_BPERSN_VW      (Sensitive) Benefits Person Data          1/31/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains sensitive coverage information for employees. Fields include Employee ID, Spouse State
                     View                                                                                                                          Employee, Other Medical Insurance, and Insurance Company Name.
UW_BN_DBN_EF_VW      (Sensitive) Additional Benefits           3/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains additional sensitive data regarding employee's dependent and beneficiary information. Fields
                     Dependent and Beneficiary                                                                                                     include Employee ID, Dependent/Beneficiary ID, Effective Date, Other Medical Insurance, and Insurance Company
                     Information Data View                                                                                                         Name.
UW_BN_DEPENR_VW      Benefits Plan Dependent                  11/30/2010 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains employee's dependent enrollment information (all Health Plan Types) and will be utilized for
                     Enrollment Data View                                                                                                          benefit transactional and reporting purposes. Fields include Plan Type, Benefit Plan, Dependent/Beneficiary,
                                                                                                                                                   Coverage, and Health Provider ID
UW_BN_DP_PER_VW      Benefits Dependent Personal Data          2/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains current dependent personal information and will be used for benefits transactional and
                     View                                                                                                                          reporting purposes. Fields include Name, Birthdate, Social Security Number, Address, and Relationship to
                                                                                                                                                   Employee.
UW_BN_EMDENR_VW      Benefits Employee Dependent               3/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view will contain employee and dependent enrollment information (all Plan Types) and will be used for benefit
                     Enrollment Data View                                                                                                          transactional and reporting purposes. Fields include Benefit Plan, Plan Type, Election, Coverage Dates, and
                                                                                                                                                   Employee Contribution Amount.
UW_BN_EMPENR_VW      Employee's Benefits Enrollment           11/30/2010 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains employee's enrollment information (all Plan Types) such as participation in a benefit plan type,
                     Data View                                                                                                                     health related benefit information, life, accidental death, and disability related benefit elections, flexible spending
                                                                                                                                                   accounts etc. Fields include Plan Type, Benefit Plan, Coverage Election, Coverage Code, and Employee Contribution
                                                                                                                                                   Amount.
UW_BN_EMPPER_VW      Employee's Personal Benefit Data          2/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   Contains employee's current personal and benefit information such as Name, Birthdate, Social Security Number,
                     View                                                                                                                          Highly Compensated Employee, Address, and Personal Phone.
UW_BN_ER_BSD_VW      (Sensitive) Disability Benefit            2/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains disability benefit enrollment codes for employees. Fields include Employee ID, Employee Record
                     Enrollment Codes Data View                                                                                                    Number, Plan Type, Effective Date, and Enrollment Code.
UW_BN_ER_BSH_VW      (Sensitive) Health Benefit                2/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains health benefit enrollment codes for employees. Fields include Employee ID, Employee Record
                     Enrollment Codes Data View                                                                                                    Number, Cobra Event ID, Plan Type, Effective Date, and Enrollment Code.
UW_BN_ER_BSL_VW      (Sensitive) Life Benefit Enrollment       2/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains life benefit enrollment codes for employees. Fields include Employee ID, Employee Record
                     Codes Data View                                                                                                               Number, Plan Type, Effective Date, and Enrollment Code.
UW_BN_IND_FM_VW      Individual Family Life Insurance         11/30/2010 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains individual and family life insurance information for Individual and Family Life Employees,
                     Data View                                                                                                                     Spouse/Dependent, and Children(Plan Types 2Q, 2R, and 2S). Fields include Plan Type, Benefit Plan, Coverage
                                                                                                                                                   Dates, and Flat Amount.




01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                                                                                 1 of 8                                                                                                                     2/23/2012 6:04 PM
                                                                                                       University of Wisconsin System
                                                                                                                 HRS Project
                                                                                                               Data Dictionary
                                                                                                           Data View Descriptions




**UPDATED 2/2/2011
                                                                                                                  IAM Security Role(s)
                                                          Date Added /    Functional    Sensitive/Non-      (If muliple are listed, only one is
Data View/Record     View Name                              Updated         Area           Sensitive        needed to access the Data View)                                                           Description
UW_BN_TSA_HS_VW      Historical TSA Data View                 2/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains historical TSA information (prior to go-live) from the legacy system. Fields include Social Security
                                                                                                                                                  Number, Plan Type, Benefit Plan, Sum of Excess Deferrals, Sum of Non-WRS Service, Sum of Section 403B Cont,
                                                                                                                                                  Sum of Section 457 Cont, and Sum WRS Employee Contributions.
UW_BN_TSA_VW         TSA Data View                            2/28/2011 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains TSA (403b and 457) information from the production environment (HCM). Fields include Social
                                                                                                                                                  Security Number, Plan Type, Benefit Plan, Balances for Period, Quarter, and Year.
UW_BN_WRS_VW         Wisconsin Retirement System             12/30/2010 Benefits       Sensitive         EPM BN Query Sensitive                   This view contains employee's job, earnings and absence data. Fields include Employee ID, Job code, WRS Begin
                     (WRS) Data View                                                                                                              and End Dates, Absence Take, and Ending Entitlement Balance.
UW_COMB_APMT_VW      Combined (IADS + HCM)                    8/16/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains job data from legacy and HCM (both historical and production). Fields include Position Number,
                     Appointment Data View                              Resources                        EPM HR Query Person Sensitive            Appointment Begin Action, Appointment End Code, Faculty Relation UDDS, and FLSA Status. (Note: This view will
                                                                                                                                                  also contain legacy appointments that were NOT active at HRS go-live.)
UW_COMB_NSPR_VW      (Non-Sensitive) Combined (IADS +         3/28/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains non sensitive person data from legacy and HCM (both historical and production). Fields include
                     HCM) Non-Sensitive Person Data                     Resources                        EPM HR Query Person Sensitive            Employee ID, Name, Ethnic Group, and Date of Death. (Note: This view will also contain records for people whose
                     View                                                                                                                         legacy (IADS) appointments ended prior to HRS go-live.) Refer to UW_COMB_PERS_VW for information on
                                                                                                                                                  sensitive view.
UW_COMB_PCHG_VW      Combined (IADS + HCM) Visa Data          3/28/2011 Human          Sensitive         EPM HR Query VSACZN Sensitive            This view contains details regarding employee's Visa from legacy and HCM (both historical and production). Fields
                     View                                               Resources                                                                 include Employee ID, Action, Visa/Permit Type, Visa/Permit, and Expiration Date.
UW_COMB_PERS_VW      (Sensitive) Combined (IADS + HCM)        3/28/2011 Human          Sensitive         EPM HR Query Person Sensitive            This view contains sensitive person data from legacy and HCM (both historical and production). Fields include
                     Person Data View                                   Resources                                                                 Employee ID, Name, Social Security Number, Date of Birth, Ethnic Group, and Date of Death. (Note: This view will
                                                                                                                                                  also contain records for people whose legacy (IADS) appointments ended prior to HRS go-live.) Refer to
                                                                                                                                                  UW_COMB_NSPR_VW for information on non sensitive view.
UW_FN_BUDACT_VW      Budget Actuals Data View                10/31/2010 Finance        Non-Sensitive     EPM FI Query All Non Sensitive           This view contains all commitment accounting data related to department budget actuals such as encumbrance
                                                                                                                                                  balances and associated funding information (account code, account), encumbrance process type, annual
                                                                                                                                                  encumbrance amount, posted actual amount, and encumbrance actual amount. Fields include Account,
                                                                                                                                                  Combination Code, Department, Job Code, and Annual Encumbered Amount.
UW_FN_DEPBUD_VW      Department Budget Dates Data            10/31/2010 Finance        Non-Sensitive     EPM FI Query All Non Sensitive           This view contains all commitment accounting data related to department budget dates such as funding end dates
                     View                                                                                                                         for deduction and taxes. Fields include Deduction Combination Code, Tax Combination Code, Budget Begin and End
                                                                                                                                                  Dates.
UW_FN_ENCUMB_VW      Encumbrance                             10/31/2010 Finance        Non-Sensitive     EPM FI Query All Non Sensitive           This view contains all commitment accounting data related to department budget encumbrance earnings,
                     Earnings/Deductions/Taxes for                                                                                                deductions, and taxes. Fields include Job Code, Combination Code, Account, Encumbrance Earnings Amount,
                     given fiscal year                                                                                                            Encumbrance Deduction Amount, and Encumbrance Tax Amount.
UW_FN_ERDDTX_VW      Department Budget                       10/31/2010 Finance        Non-Sensitive     EPM FI Query All Non Sensitive           Contains Commitment Accounting Funding for Earnings, Deductions, and Taxes. Fields include Combination Code,
                     Earnings/Deductions/Taxes Data                                                                                               Earnings Code, Tax Balance Class, and Budget Amount.
                     View
UW_HIST_ACHG_VW      Historical (IADS) Appointment Data       3/28/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains all appointment-related changes for active and historical appointments (does not include HCM)
                     View                                               Resources                        EPM HR Query Person Sensitive            that occurred prior to HRS go-live. Fields include Position Number, Compensation Rate, Continuity Status, Job
                                                                                                                                                  Code, Pay Basis, and Tenure Status (Please note that historical student appointments are not included in this view).

UW_HR_ADDRES_VW      Address Data View                        3/28/2011 Human          Sensitive         EPM HR Query Address Sensitive           This view contains sensitive address data from HCM. Fields include Employee ID, Name, Address Type, Home
                                                                        Resources                                                                 Address, Business Address, Release Home Info Flag, City, County, and State.
UW_HR_ADRBUS_VW      Business Address View                   11/14/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains current business address, email, and phone data from HCM (on one row). Fields include
                                                                        Resources                        EPM HR Query Person Sensitive            Employee ID, Name, Business Address, Business Email Address, Business Phone, Business Romm Number, and
                                                                                                                                                  Business Mail Drop ID.
UW_HR_ADRHB_VW       Home and Business Address Data          11/14/2011 Human          Sensitive         EPM HR Query Address Sensitive           This view contains current Home and Business address, email, and phone data from HCM (on one row). Fields
                     View                                               Resources                                                                 include Employee ID, Name, Home Address, Home Email, Home Phone, Business Address, Business Email, and
                                                                                                                                                  Business Phone.
UW_HR_ALLJOB_VW      All Job Data View                        8/16/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           Contains all job rows from HCM including past, present, and future. Fields include Department FTE, Employee
                                                                        Resources                        EPM HR Query Person Sensitive            Classification Job Code and Title, Employee Type, Salary grade and plan, and compensation.

UW_HR_CURJOB_VW      Current Job Data View                    8/16/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           Contains the row currently in effect for each job from HCM. Fields include Department, FTE, Employee
                                                                        Resources                        EPM HR Query Person Sensitive            Classification, Job Code and Title, Employee Type, Salary grade and plan, and compensation.

UW_HR_EEO_VW         (Sensitive) Equal Employment            10/18/2011 Human          Sensitive         EPM HR Query EEO Sensitive               This view contains sensitive EEO data. This view will be used to create EEO and Affirmative Action (AA) reports
                     Opportunity Data View                              Resources                                                                 which will enable UW to remain compliant with regulatory reporting. Fields include Employee ID, Effective Date,
                                                                                                                                                  Disabled, Military Status, Wartime Veteran and non Wartime Veteran.
UW_HR_EMERCT_VW      Emergency Contact Data View              3/28/2011 Human          Sensitive         EPM HR Query EmerCT Sensitive            Contains emergency contacts for employees. Fields include Employee ID, Contact Name, Relationship to Employee,
                                                                        Resources                                                                 Phone, and Address.




01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                                                                                 2 of 8                                                                                                                    2/23/2012 6:04 PM
                                                                                                         University of Wisconsin System
                                                                                                                   HRS Project
                                                                                                                 Data Dictionary
                                                                                                             Data View Descriptions




**UPDATED 2/2/2011
                                                                                                                    IAM Security Role(s)
                                                            Date Added /    Functional    Sensitive/Non-      (If muliple are listed, only one is
Data View/Record     View Name                                Updated         Area           Sensitive        needed to access the Data View)                                                            Description
UW_HR_FMLA_VW        Family Medical Leave Act (FMLA)            3/28/2011 Human          Sensitive         EPM HR Query FMLA Sensitive              This view contains all family medical leave data for UW employees such as leave dates, leave reasons, FMLA plan
                     Data View                                            Resources                                                                 info, and approval information. Fields include Employee ID, Approver ID, FMLA Leave Reason, Type of FMLA Leave,
                                                                                                                                                    Approval Status, Leave Status, and Return Date. This view will be available 3 months after go live.

UW_HR_GT_TBL_VW      Faculty Governance Data View               1/25/2012 Human          Non-sensitive     EPM HR Query All Non Sensitive           This view contains faculty governance data such as Division Affiliation, Faculty Senate Seat Number within a
                                                                          Resources                        EPM HR Query Person Sensitive            district, Faculty Senate Seat Type, etc.

UW_HR_JCD_DT_VW      Historical Title File - Job Code           2/28/2011 Human          Non-sensitive     EPM HR Query All Non Sensitive           This view contains Job Code history from historical title file. Fields include SetID, Job Code, Effective Date,
                     History Data View                                    Resources                        EPM HR Query Person Sensitive            Employee Classification, Sort Order, and Short Description.

UW_HR_MNGPRF_VW      Manage Profile Data View                   3/28/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains education information for all profiles for a person. Fields include Profile ID, Profile Description,
                                                                          Resources                        EPM HR Query Person Sensitive            Major, Minor, and School Codes.

UW_HR_NS_PER_VW      (Non-Sensitive) Person Data View           9/27/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           Contains current non sensitive person data from HCM (including non-sensitive address data). Fields include Name,
                                                                          Resources                        EPM HR Query Person Sensitive            Marital Status, Highest Education Level, and Address- not home address unless person agrees to disclose it. Refer
                                                                                                                                                    to UW_HR_PERSON_VW for information on sensitive view.
UW_HR_OCTJOB_VW      (Sensitive) October Frozen Job View        1/17/2012 Human          Sensitive         EPM HR Query EEO Sensitive               This view contains a snapshot of current job data related to people with active/term/leave jobs during October.
                                                                          Resources                        EPM HR Query Person Sensitive            This view includes the same individuals as the October Payroll view (which is still maintained in InfoAccess, not
                                                                                                                                                    EPM - see InfoAcess OCTOBER_PAYROLL data view
                                                                                                                                                    http://www.doit.wisc.edu/infoaccess/dataviews/Finance/Budget/Budget%20Payroll/OCTOBER_PAYROLL.htm),
                                                                                                                                                    but also includes individuals not paid in October who have active jobs, such as $0 appointments or individuals on
                                                                                                                                                    leave. This data view contains data from Oct 2011 only. This view will be refreshed once a year after October
                                                                                                                                                    payroll has been run.

                                                                                                                                                    To access data from Oct 1987 through Oct 2010, you need to access the InfoAccess OCTOBER_FROZEN_APPT data
                                                                                                                                                    view (see
                                                                                                                                                    http://www.doit.wisc.edu/infoaccess/dataviews/HumanResources/LegacyHR/Appointment/Appointment%20Appt
                                                                                                                                                    _/october_frozen_appt.htm)
UW_HR_PERPOI_VW      Person of Interest Data View               8/23/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains all POI records, current and historic. Fields include Employee ID, POI Type, Security Access Type,
                                                                          Resources                        EPM HR Query Person Sensitive            and Expected End Date.

UW_HR_PERSON_VW      (Sensitive) Person Data View               3/28/2011 Human          Sensitive         EPM HR Query Person Sensitive            Contains current sensitive person data from HCM. Fields include Social Security Number, Birthdate, Name, Marital
                                                                          Resources                                                                 Status, and Highest Education Level. Refer to UW_HR_NS_PER_VW for information on non-sensitive view.

UW_HR_POS_DA_VW      (Non-Sensitive) Position Data View        10/31/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains current and historical position information. This view will be helpful in some reporting that
                                                                          Resources                        EPM HR Query Person Sensitive            specifically looks at how (legacy) appointments changed over time. This view will be available 6 months after go
                                                                                                                                                    live.
UW_HR_SG_ANF_VW      Historical Title File - Salary Grade       2/28/2011 Human          Non-sensitive     EPM HR Query All Non Sensitive           This view contains Salary Grade history from historical title file. Fields include Salary Administration Plan, Salary
                     History Data View                                    Resources                        EPM HR Query Person Sensitive            Grade, Grade Pay Basis, Title Group, and Hire Maximum.

UW_HR_SGD_JC_VW      Historical Title File - Salary Grade       2/28/2011 Human          Non-sensitive     EPM HR Query All Non Sensitive           This view contains salary grade job code history from historical title file. Fields include SetID, Salary Administration
                     Job Code History Data View                           Resources                        EPM HR Query Person Sensitive            Plan, Grade, Effective Date, and Job code.

UW_HR_TENURE_VW      Tenure Data View                           3/28/2011 Human          Non-Sensitive     EPM HR Query All Non Sensitive           This view contains faculty employee tenure data. Fields include Tenure Department, Academic Rank, Tenure
                                                                          Resources                        EPM HR Query Person Sensitive            Granted date, Tenure Home Organization, and Tenure Track Start Date.

UW_HR_VSACZN_VW      Visa/Citizen Data View                     3/28/2011 Human          Sensitive         EPM HR Query VSACZN Sensitive            This view contains details regarding employee's Passport, Visa, and Supporting Document information. It will also
                                                                          Resources                                                                 contain data related to their Substantial Presence Test. Fields include Passport Number, Country Issuing Passport,
                                                                                                                                                    Issuing Authority, Visa/Permit Type, Visa/Permit Number, Supporting Document ID, Alien Registration, and Passed
                                                                                                                                                    Test.
UW_PY_ADD_PY_VW      Additional Pay Data View                  12/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This view contains additional pay information such as other hours, other pay, additional pay reason, and pay
                                                                                                                                                    frequency for all employees with additional pay set up. Fields include Earnings Code, Hourly Rate, Reason for
                                                                                                                                                    Additional Pay, Goal Amount and Balance.
UW_PY_BAL_ARR        Arrears Balance Data View                 11/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This table contains Deduction Arrears balance for any employee with an arrears amount. Fields include Employee
                                                                                                                                                    ID, Plan Type, Benefit Plan, Deduction Code, Deduction Classification, and Arrears Balance.
UW_PY_BAL_DED        Deduction Balance Data View               12/30/2010 Payroll        Non-Sensitive     EPM PY Qry DEDBAL NonSensitive           Contains year to date deduction information for employees with deductions. Fields include Deduction Code,
                                                                                                                                                    Deduction Classification, Deduction Balance - YTD, QTD, & MTD.


01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                                                                                  3 of 8                                                                                                                       2/23/2012 6:04 PM
                                                                                                         University of Wisconsin System
                                                                                                                   HRS Project
                                                                                                                 Data Dictionary
                                                                                                             Data View Descriptions




**UPDATED 2/2/2011
                                                                                                                    IAM Security Role(s)
                                                            Date Added /    Functional    Sensitive/Non-      (If muliple are listed, only one is
Data View/Record     View Name                                Updated         Area           Sensitive        needed to access the Data View)                                                          Description
UW_PY_BAL_ERNGS      Earnings Balance Data View                12/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           Contains year to date earnings information for all employees. Fields include Earnings Code, Hours - YTD, QTD, &
                                                                                                                                                    MTD, Gross Earnings - YTD, QTD, & MTD.
UW_PY_BAL_GARN       Garnishment Balance Data View             12/30/2010 Payroll        Sensitive         EPM PY Qry GARNSHMNT Sensitive           Contains year to date garnishment information for employees with garnishments. Fields include Garnishment ID,
                                                                                                                                                    Garnishment Deduction Balance - YTD, QTD, & MTD, Payee Deduction Fee Balance - YTD, QTD, & MTD.

UW_PY_BAL_TAX        Tax Balance Data View                      1/31/2011 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This view contains tax balance information for all employees (YTD, QTD, MTD tax balances). Fields include No Limit
                                                                                                                                                    Gross YTD, No Limit Gross QTD, No Limit Gross MTD, Taxable Gross YTD, Taxable Gross QTD, Taxable Gross MTD,
                                                                                                                                                    and associated tax amounts.
UW_PY_BALAD_ARR      Arrears Balance Adjustment Data           11/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This table contains regular and adjusted deduction arrears balances for employees who had arrears balance
                     View                                                                                                                           adjusted. Fields include Plan Type, Benefit Plan, Arrears Balance and Adjusted Arrears Balance, and Adjustment
                                                                                                                                                    Reason.
UW_PY_BALAD_DED      Deduction Balance Adjustment              11/30/2010 Payroll        Non-Sensitive     EPM PY Qry DEDBAL NonSensitive           This table contains regular and adjusted deductions balances for employees who had deduction balance adjusted.
                     Data View                                                                                                                      Fields include Balance ID, Deduction Balance and Adjusted Deduction Balance - YTD, QTD, & MTD, and Adjustment
                                                                                                                                                    Reason.
UW_PY_BALAD_ERN      Earnings Balance Adjustment Data          11/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This table contains regular and adjusted hours and earnings for employees who had earnings balance adjusted.
                     View                                                                                                                           Fields include Earnings Code, Hours and Adjusted Hours - YTD, QTD, & MTD, Earnings and Adjusted Earnings YTD,
                                                                                                                                                    QTD, & MTD, and Adjustment Reason.
UW_PY_BALAD_GRN      Garnishment Balance Adjustment            11/30/2010 Payroll        Sensitive         EPM PY Qry GARNSHMNT Sensitive           This table contains regular and adjusted garnishment balances for employees who had garnishments balance
                     Data View                                                                                                                      adjusted. Fields include Garnish ID, Garnishment Deduction Balance and Adjusted Garnishment Deduction Balance -
                                                                                                                                                    YTD, QTD, & MTD, and Adjustment Reason.
UW_PY_BALAD_TAX      Tax Balance Adjustment Data View          11/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This table contains regular and adjusted taxes for employees who had tax balance adjusted. Fields include Tax and
                                                                                                                                                    Adjusted Tax - YTD, QTD & MTD, Taxable Gross and Adjusted Taxable Gross - YTD, QTD, & MTD, No Limit Gross and
                                                                                                                                                    Adjusted No Limit Gross - YTD, QTD, & MTD, and Adjustment Reason.
UW_PY_CHECK_YTD      YTD Check Data View                       12/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           Contains year to date paycheck information for employees. Fields include Balance ID, Balances - Year, Quarter, &
                                                                                                                                                    Period, Total Gross YTD, Total Taxes YTD, Total Deductions YTD, and Net Pay YTD.
UW_PY_DEDDST_VW      (Sensitive) Deduction Distribution        12/30/2010 Payroll        Sensitive         EPM PY Qry Empl Lvl Sensitive            This view contains sensitive deduction distribution information for all employees created during payroll
                     Data View                                                                                                                      calculation/distribution process. Fields include Pay Group, Pay Period End Date, Benefit Plan, Deduction Code,
                                                                                                                                                    Deduction Class, and Current Deduction. Refer to UW_PY_NS_DDD_VW for information on non sensitive view.

UW_PY_DIRDEP_VW      (Sensitive) Direct Deposit Data View      12/30/2010 Payroll        Sensitive         EPM PY Qry DIRDEP Sensitive              This view contains sensitive direct deposit information such as bank, deposit, and prenote details for employees
                                                                                                                                                    with direct deposit set up. Fields include Account Number, Account Type, Deposit Amount, Bank Information, and
                                                                                                                                                    Prenote Status. Refer to UW_PY_NS_DDP_VW for information on non sensitive view.

UW_PY_EMPDED_VW      General Employee Deduction Data           11/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This view contains general deduction information for employees with general deductions. Fields include Deduction
                     View                                                                                                                           Code, Deduction Amount, Deduction Percent, Goal Amount, and Current Goal Balance.
UW_PY_ERNDST_VW      (Sensitive) Earnings Distribution           2/2/2012 Payroll        Sensitive         EPM PY Qry Empl Lvl Sensitive            This view contains sensitive earnings distribution information (funding information) for all employees created
                     Data View                                                                                                                      during payroll calculation/distribution process. Fields include Address, Pay Group, Pay Period End Date,
                                                                                                                                                    Combination Code, Total Deductions, Gross, and Taxes. Refer to UW_PY_NS_ERD_VW for information on non
                                                                                                                                                    sensitive view.
UW_PY_NS_DDD_VW      (Non-Sensitive) Deduction                 12/30/2010 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This view contains non sensitive deduction distribution information for all employees created during payroll
                     Distribution Data View                                                                                                         calculation/distribution process. Fields include Pay Group, Pay Period End date, Deduction Code, Deduction Class,
                                                                                                                                                    and Accounting Code. Refer to UW_PY_DEDDST_VW for information on sensitive view.

UW_PY_NS_DDP_VW      (Non-Sensitive) Direct Deposit Data        1/31/2011 Payroll        Non-Sensitive     EPM PY Qry DIRDEP NonSensitive           This view contains non sensitive direct deposit information (such as bank, deposit, and prenote details) for
                     View                                                                                                                           employees with direct deposit set up. Fields include Account Type, Deposit Type, Deposit Amount, and Prenote
                                                                                                                                                    Status. Refer to UW_PY_DIRDEP_VW for information on sensitive view.
UW_PY_NS_ERD_VW      (Non-Sensitive) Earnings                    2/2/2012 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This view contains non sensitive earnings distribution information (funding information) for all employees created
                     Distribution Data View                                                                                                         during payroll calculation/distribution process. Fields include Employee ID, Department, Pay Group, Paycheck
                                                                                                                                                    Status, Combination Code, and Earnings Code. Refer to UW_PY_ERNDST_VW for information on sensitive view.

UW_PY_NS_PYI_VW      (Non-Sensitive) Pay Check and              6/27/2011 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This view contains non sensitive transactional earnings data for all employees. Fields include Earnings Code and
                     Other Pay Earnings Data View                                                                                                   Description, Regular Hours, Hourly Rate, Regular Earnings, and Overtime Hours. Refer to UW_PY_PYINFO_VW for
                                                                                                                                                    information on sensitive view.
UW_PY_NS_TXD_VW      (Non-Sensitive) Tax Distribution           1/31/2011 Payroll        Non-Sensitive     EPM PY Qry Empl Lvl NonSensitv           This view contains non sensitive tax distribution information for all employees created during payroll
                     Data View                                                                                                                      calculation/distribution process. Fields include Pay Group, Tax Class, Current Tax, Accounting Period, Budget Data,
                                                                                                                                                    and Current Taxable Gross. Refer to UW_PY_TAXDST_VW for information on sensitive information.



01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                                                                                  4 of 8                                                                                                                   2/23/2012 6:04 PM
                                                                                                        University of Wisconsin System
                                                                                                                  HRS Project
                                                                                                                Data Dictionary
                                                                                                            Data View Descriptions




**UPDATED 2/2/2011
                                                                                                                   IAM Security Role(s)
                                                           Date Added /    Functional    Sensitive/Non-      (If muliple are listed, only one is
Data View/Record     View Name                               Updated         Area           Sensitive        needed to access the Data View)                                                          Description
UW_PY_PYINFO_VW      (Sensitive) Pay Check and Other Pay       6/27/2011 Payroll        Sensitive         EPM PY Qry Empl Lvl Sensitive            This view contains sensitive transactional pay data by paycheck for all employees. Fields include Social Security
                     Earnings Data View                                                                                                            Number, Address, Earnings Code and Description, Regular Hours, Regular Earnings, Total Gross, Taxes, and
                                                                                                                                                   Deductions. Refer to UW_PY_NS_PYI_VW for information on non sensitive view.
UW_PY_RETDED_VW      Retro Deduction Calculation Data          1/31/2011 Payroll        Non-Sensitive     EPM PY Qry RETRO NonSensitive            This view contains retro deduction calculation results information for all employees (extracted and calculated for
                     View                                                                                                                          the retro deduction process). Fields include Plan Type, Benefit Plan, Deduction Code, Deduction Class, Retro
                                                                                                                                                   Deduction Effective Date, Retro Deduction Request Type, and Retro Pay Group.
UW_PY_TAXDST_VW      (Sensitive) Tax Distribution Data         1/31/2011 Payroll        Sensitive         EPM PY Qry Empl Lvl Sensitive            This view contains sensitive tax distribution information for all employees created during payroll
                     View                                                                                                                          calculation/distribution process. Fields include Address, Social Security Number, Pay Group, Tax Class, Current Tax,
                                                                                                                                                   Budget Data, Total Deductions, Gross, and Taxes. Refer to UW_PY_NS_TXD_VW for information on non sensitive
                                                                                                                                                   view.
UW_PYRCD_TBL_VW      Time & Labor Payroll Coordinator          1/31/2011 Time and Labor Non-sensitive     EPM PY Qry Empl Lvl NonSensitv           This view lists all payroll coordinators for an employee. Fields include Employee ID, Employee Record Number,
                     Data View                                                                                                                     Effective Date, Effective Sequence, and Payroll Coordinator.
UW_TL_EMPDTA_VW      Basic Time & Labor Employee Data         12/30/2010 Time and Labor Non-Sensitive     EPM TL Query All Non Sensitive           Contains basic information about time reporters. Fields include Time Reporting Status, Workgroup, Task group,
                     View                                                                                                                          Rule elements, TCD Group, Approver and Approver Backup, UW Non Approver and Non Approver backup.

UW_TL_EX_DIF_VW      Time & Labor Exam Differential            1/31/2011 Time and Labor Non-sensitive     EPM TL Query All Non Sensitive           This view lists all exam differentials (extra amount given to students who work during the final exam week) for
                     Data View                                                                                                                     employees. Fields include Employee ID, Employee Record Number, Effective Date, Effective Sequence, and Exam
                                                                                                                                                   Differential ID.
UW_TL_EXCPTN_VW      Time & Labor Exception Data View          2/28/2011 Time and Labor Non-Sensitive     EPM TL Query All Non Sensitive           This view contains exceptions tied to an employee's job. Fields include Exception ID, Date Under Report, Exception
                                                                                                                                                   Messages, Exception Status, and Source of Exception,
UW_TL_GR_DTL_VW      Time & Labor Group Detail Data            1/31/2011 Time and Labor Non-sensitive     EPM TL Query All Non Sensitive           This view contains information about employees assigned to a group within Time & Labor. Static group members
                     View                                                                                                                          will be in this record automatically. Dynamic group members will be in this record only once the group is refreshed.
                                                                                                                                                   Fields include Group ID, Employee ID, Employee Record Number, and Group Type.
UW_TL_PAYRPT_VW      Reported & Payable Time Data              2/28/2011 Time and Labor Non-Sensitive     EPM TL Query All Non Sensitive           This view contains payable and reported time rows for time reporters. Fields include Time Reporting Code, Punch
                     View                                                                                                                          in and out, Task group, Reported and Payable hours.
UW_TL_RPT_TM_VW      Reported Time Data View                   2/28/2011 Time and Labor Non-Sensitive     EPM TL Query All Non Sensitive           This view contains reported time data for time reporters. Fields include Punch In and Out, Rule Elements, Time
                                                                                                                                                   Collection Device Supervisor ID, and Last Updated Date and Time.
UW_TL_SCH_AS_VW      Time & Labor Schedule Assignment         12/30/2010 Time and Labor Non-Sensitive     EPM TL Query All Non Sensitive           This view contains schedule for time reporters. Fields include Schedule Group, Rotation ID, Schedule ID and
                     Data View                                                                                                                     Description.
UW_TL_ST_DIF_VW      Time & Labor Student Differential         1/31/2011 Time and Labor Non-sensitive     EPM TL Query All Non Sensitive           This view contains Student Differential ID's associated with time reporters. Fields include Employee ID, Employee
                     Data View                                                                                                                     Record, Effective Date, Effective Sequence, and Student Differential ID.
UW_TL_TMEREP_VW      Time & Labor Time Reporter Roles          1/31/2011 Time and Labor Non-sensitive     EPM TL Query All Non Sensitive           This view lists time reporter roles associated with an employee. Fields include Employee ID, Employee Record
                     Data View                                                                                                                     Number, Role Name, and Operator ID.




01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                                                                                  5 of 8                                                                                                                  2/23/2012 6:04 PM
                                             University of Wisconsin System
                                                       HRS Project
                                                     Data Dictionary
                                                 EPM Lookup Records

                                        Record/Table      Record/Table Name
                                        UW_P_ABBR_TYP     Multiple ABBRs Code Table View
                                        UW_P_ACCT_CD      Account Codes View
                                        UW_P_ACTION       ACTION Setup Table View
                                        UW_P_ACTN_RSN     Action/Reason Combinations VW
                                        UW_P_ADDR_TYP     Address Type Table View
                                        UW_P_BAS_GRP      BAS Group Table View
                                        UW_P_BNFPLN       Benefit Plans View
                                        UW_P_BN_DFN_OPT   Benefit Option Definition View
                                        UW_P_BN_DFN_PGM   Benefit Def Program View
                                        UW_P_BUS_UNT_HR   HR Business Unit Table View
                                        UW_P_CAL_DETP     Detail Calendar Periods View
                                        UW_P_CNTRT_TYP    Contract Type Table View
                                        UW_P_COMPANY      Company Codes View
                                        UW_P_COMP_RTCD    Comp Rate Code View
                                        UW_P_COUNTRY      Countries View
                                        UW_P_COVRG_CD     Coverage Code Definition View
                                        UW_P_CO_STTAX     Company State/Fed Tax View
                                        UW_P_CTZN_STS     Citizen Status Table View
                                        UW_P_CURR_CD      Currency Codes View
                                        UW_P_DEDUCTION    Deduction Definition View
                                        UW_P_DEPT         Departments View
                                        UW_P_EARNINGS     Earnings Codes View
                                        UW_P_EG_RANK      Academic Rank Table View
                                        UW_P_EMPL_CLS     UW Employee Class View
                                        UW_P_ERNPRG_DEF   Earnings Codes for Earn Pgm VW
                                        UW_P_ERNPRG_TBL   Earnings Prog Tbl Descr View
                                        UW_P_ESTAB        Establishment Codes View
                                        UW_P_ETHNIC_GRP   Ethnic Group Table View
                                        UW_P_FREQUENCY    Frequency Table View
                                        UW_P_GLACCT       Accounts View
                                        UW_P_GLJRNL_TMP   GL Journal Template View
                                        UW_P_GP_ABS_RSN   Absence Reasons View
                                        UW_P_GP_ABS_TKE   Absence Take Rules Dfn VW
                                        UW_P_GP_ABS_TYP   Absence Type View
                                        UW_P_GP_ENT_TYP   Element Entry Type View
                                        UW_P_GP_PIN       Staging -Pay Item Name Def VW

01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                   6 of 8                         2/23/2012 6:04 PM
                                             University of Wisconsin System
                                                       HRS Project
                                                     Data Dictionary
                                                 EPM Lookup Records

                                        Record/Table      Record/Table Name
                                        UW_P_GP_PIN_CAT   Element Category View
                                        UW_P_GP_PIN_TYP   Element Type View
                                        UW_P_HP_FRG_GRP   Fringe Group Table View
                                        UW_P_HR_BRG_UNT   Bargaining Units View
                                        UW_P_JOBCD        Job Codes View
                                        UW_P_JPM_PROFIL   JPM Profile Header View
                                        UW_P_LOCAL_TX     Local Tax Table View
                                        UW_P_LOCATN       Company Site Locations View
                                        UW_P_MAJOR        College Major Subject Codes VW
                                        UW_P_NAME_FMT     Name Format Types View
                                        UW_P_NAME_PFX     Name Prefixes View
                                        UW_P_NAME_SFX     Name SuffixTable View
                                        UW_P_NAME_TYP     Name Type Table View
                                        UW_P_NID_TYP      National ID Type Table View
                                        UW_P_PAYGROUP     Paygroups View
                                        UW_P_PAY_CAL      Pay Calendar View
                                        UW_P_PAY_FRM      Payroll Form Codes View
                                        UW_P_PAY_RUN      Payroll Run ID View
                                        UW_P_PERSON       PERSON record View
                                        UW_P_PERS_NID     PERS_NID Record View
                                        UW_P_POSTN_DATA   Position Data View
                                        UW_P_PROJECT      Projects View
                                        UW_P_PROJ_ACTVY   Project Activities View
                                        UW_P_PSXLATITEM   Translate Value Items View
                                        UW_P_REG_REGION   Regulatory Region View
                                        UW_P_RTRDDMAS     Retro Deduction Mass Rqst VW
                                        UW_P_RTRDDPGM     Retro Deduction Program View
                                        UW_P_SAL_GRD      Salary Grade View
                                        UW_P_SAL_PLAN     Salary Administration Plan VW
                                        UW_P_SAL_RATECD   Salary Grade View
                                        UW_P_SAL_STEP     Salary Step Table View
                                        UW_P_SCHOOL       Schools/Universities View
                                        UW_P_SCH_DEFN     Schedule Definition Table View
                                        UW_P_SCH_GRP      Schedule Group Table View
                                        UW_P_SPRT_DOC     Visa Supporting Documents View
                                        UW_P_STATE        State CDs/Names by Country VW

01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                   7 of 8                         2/23/2012 6:04 PM
                                             University of Wisconsin System
                                                       HRS Project
                                                     Data Dictionary
                                                 EPM Lookup Records

                                        Record/Table      Record/Table Name
                                        UW_P_TAX_LOCTN1   Tax Location Codes View
                                        UW_P_TAX_LOCTN2   Tax Location states/locales VW
                                        UW_P_TL_OVRSN     Override Reason Codes View
                                        UW_P_TL_RPTDTMP   Time Reporting Template View
                                        UW_P_TL_RSPRF     Restriction Profiles View
                                        UW_P_TL_RULELM1   Rule Element 1 View
                                        UW_P_TL_RULELM2   Rule Element 2 View
                                        UW_P_TL_RULELM3   Rule Element 3 View
                                        UW_P_TL_RULELM4   Rule Element 4 View
                                        UW_P_TL_RULELM5   Rule Element 5 View
                                        UW_P_TL_TASK      T & L Task Table View
                                        UW_P_TL_TCDGR     TCD Groups Definition View
                                        UW_P_TL_TM_PRDS   Time Periods Table View
                                        UW_P_TL_TRC       TRC Table View
                                        UW_P_TL_TSKGR     Time & Labor Taskgroup View
                                        UW_P_TL_TSKPRF    Time Task Profile View
                                        UW_P_TL_USRFLD1   User Field Table 1 View
                                        UW_P_TL_USRFLD2   User Field Table 2 View
                                        UW_P_TL_USRFLD3   User Field Table 3 View
                                        UW_P_TL_USRFLD4   User Field Table 4 View
                                        UW_P_TL_USRFLD5   User Field Table 5 View
                                        UW_P_TL_WKGRP     Workgroup Table View
                                        UW_P_UNION        Unions Views
                                        UW_P_VENDOR       Vendor Header View
                                        UW_P_VISA_PMT     Visa Req by Country View




01ee6eda-e896-4153-8a36-5a8ee6da9493.xlsx                   8 of 8                         2/23/2012 6:04 PM

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:2/23/2012
language:
pages:8