Docstoc

epm-dataviews

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




**UPDATED 10/18/2011
                                                                                     Functional
Data View/Record       View Name                            Date Added/Updated         Area       Sensitive/Non-Sensitive                                                       Description
UW_AM_ABSEVT_VW        Absence Event Definition Data View               10/31/2010 Absence        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             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             Contains Accumulator information. Accumulators are elements that store the cumulative values of defined items as
                                                                                   Management                               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_ERNDED_VW        Absence Management                               11/30/2010 Absence        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_RLT_CG_VW        Absence Results by Calendar Group                10/31/2010 Absence        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_AM_PD_HRS_VW        (Non-Sensitive) Accumulator PIN                   2/28/2011 Absence        Non-Sensitive             This view will contain 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_BAL_VW           (Non-Sensitive) Absence                            8/8/2011 Absence        Non-Sensitive             This view will contain Absence Management balance information. This view will allow users to query balances as of
                       Management Balance View                                     Management                               a 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_BN_ABBR_VW          Annual Benefits Base Rate Data                   11/30/2010 Benefits       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                     3/28/2011 Benefits       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_DEPENR_VW        Benefits Plan Dependent                          11/30/2010 Benefits       Sensitive                 This view will contain 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                 This view will contain 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                 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                 This view will contain employee's enrollment information (all Plan Types) such as participation in a benefit plan
                       Data View                                                                                            type, 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                 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_IND_FM_VW        Individual Family Life Insurance                 11/30/2010 Benefits       Sensitive                 This view will contain 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.
UW_BN_TSA_HS_VW        Historical TSA Data View                          2/28/2011 Benefits       Sensitive                 This view will contain 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                 This view will contain 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                 This view will contain 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_BN_BPERSN_VW        (Sensitive) Benefits Person Data                  1/31/2011 Benefits       Sensitive                 This view will contain sensitive coverage information for employees. Fields include Employee ID, Spouse State
                       View                                                                                                 Employee, Other Medical Insurance, and Insurance Company Name.


3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                                                                     1 of 8                                                                                                      10/25/2011 11:53 AM
                                                                                         University of Wisconsin System
                                                                                                   HRS Project
                                                                                                 Data Dictionary
                                                                                             Data View Descriptions




                                                                                      Functional
Data View/Record       View Name                             Date Added/Updated         Area       Sensitive/Non-Sensitive                                                         Description
UW_BN_DBN_EF_VW        (Sensitive) Additional Benefits                    3/28/2011 Benefits       Sensitive                 This view will contain 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_ER_BSD_VW        (Sensitive) Disability Benefit                     2/28/2011 Benefits       Sensitive                 This view will contain disability benefit enrollment codes for employees. Fields include Employee ID, Employee
                       Enrollment Codes Data View                                                                            Record Number, Plan Type, Effective Date, and Enrollment Code.
UW_BN_ER_BSH_VW        (Sensitive) Health Benefit                         2/28/2011 Benefits       Sensitive                 This view will contain 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                 This view will contain life benefit enrollment codes for employees. Fields include Employee ID, Employee Record
                       Codes Data View                                                                                       Number, Plan Type, Effective Date, and Enrollment Code.
UW_FN_BUDACT_VW        Budget Actuals Data View                          10/31/2010 Finance        Non-Sensitive             This view will contain 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             This view will contain all commitment accounting data related to department budget dates such as funding end
                       View                                                                                                  dates 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             This view will contain 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             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_COMB_APMT_VW        Combined (IADS + HCM)                              8/16/2011 Human          Non-Sensitive             This view will contain job data from legacy and HCM (both historical and production). Fields include Position
                       Appointment Data View                                        Resources                                Number, 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             This view will contain non sensitive person data from legacy and HCM (both historical and production). Fields
                       HCM) Non-Sensitive Person Data                               Resources                                include Employee ID, Name, Ethnic Group, and Date of Death. (Note: This view will also contain records for people
                       View                                                                                                  whose 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                 This view will contain details regarding employee's Visa from legacy and HCM (both historical and production).
                       View                                                         Resources                                Fields 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                 This view will contain 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_HIST_ACHG_VW        Historical (IADS) Appointment Data                 3/28/2011 Human          Non-Sensitive             This view will contain all appointment-related changes for active and historical appointments (does not include
                       View                                                         Resources                                HCM) 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                 This view will contain 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_ALLJOB_VW        All Job Data View                                  8/16/2011 Human          Non-Sensitive             Contains all job rows from HCM including past, present, and future. Fields include Department FTE, Employee
                                                                                    Resources                                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             Contains the row currently in effect for each job from HCM. Fields include Department, FTE, Employee
                                                                                    Resources                                Classification, Job Code and Title, Employee Type, Salary grade and plan, and compensation.
UW_HR_EMERCT_VW        Emergency Contact Data View                        3/28/2011 Human          Sensitive                 Contains emergency contacts for employees. Fields include Employee ID, Contact Name, Relationship to Employee,
                                                                                    Resources                                Phone, and Address.
UW_HR_FMLA_VW          Family Medical Leave Act (FMLA)                    3/28/2011 Human          Sensitive                 This view will contain 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_MNGPRF_VW        Manage Profile Data View                           3/28/2011 Human          Non-Sensitive             This view will contain education information for all profiles for a person. Fields include Profile ID, Profile Description,
                                                                                    Resources                                Major, Minor, and School Codes.




3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                                                                      2 of 8                                                                                                          10/25/2011 11:53 AM
                                                                                          University of Wisconsin System
                                                                                                    HRS Project
                                                                                                  Data Dictionary
                                                                                              Data View Descriptions




                                                                                       Functional
Data View/Record       View Name                              Date Added/Updated         Area       Sensitive/Non-Sensitive                                                         Description
UW_HR_NS_PER_VW        (Non-Sensitive) Person Data View                    9/27/2011 Human          Non-Sensitive             Contains current non sensitive person data from HCM (including non-sensitive address data). Fields include Name,
                                                                                     Resources                                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_PERSON_VW        (Sensitive) Person Data View                        3/28/2011 Human          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_TENURE_VW        Tenure Data View                                    3/28/2011 Human          Non-Sensitive             This view will contain faculty employee tenure data. Fields include Tenure Department, Academic Rank, Tenure
                                                                                     Resources                                Granted date, Tenure Home Organization, and Tenure Track Start Date.
UW_HR_VSACZN_VW        Visa/Citizen Data View                              3/28/2011 Human          Sensitive                 This view will contain details regarding employee's Passport, Visa, and Supporting Document information. It will
                                                                                     Resources                                also 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_HR_JCD_DT_VW        Historical Title File - Job Code                    2/28/2011 Human          Non-sensitive             This view will contain Job Code history from historical title file. Fields include SetID, Job Code, Effective Date,
                       History Data View                                             Resources                                Employee Classification, Sort Order, and Short Description.
UW_HR_SG_ANF_VW        Historical Title File - Salary Grade                2/28/2011 Human          Non-sensitive             This view will contain Salary Grade history from historical title file. Fields include Salary Administration Plan, Salary
                       History Data View                                             Resources                                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             This view will contain salary grade job code history from historical title file. Fields include SetID, Salary
                       Job Code History Data View                                    Resources                                Administration Plan, Grade, Effective Date, and Job code.

UW_HR_PERPOI_VW        Person of Interest Data View                        8/23/2011 Human          Non-Sensitive             This view will contain all POI records, current and historic. Fields include Employee ID, POI Type, Security Access
                                                                                     Resources                                Type, and Expected End Date.
UW_HR_EEO_VW           (Sensitive) Equal Employment                       10/18/2011 Human          Sensitive                 This view will contain 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_POS_DA_VW        (Non-Sensitive) Position Data View                 10/31/2011 Human          Non-Sensitive             This view will contain current and historical position information. This view will be helpful in some reporting that
                                                                                     Resources                                specifically looks at how (legacy) appointments changed over time. This view will be available 6 months after go
                                                                                                                              live.
UW_PY_ADD_PY_VW        Additional Pay Data View                           12/30/2010 Payroll        Non-Sensitive             This view will contain 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             This table will contain 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             Contains year to date deduction information for employees with deductions. Fields include Deduction Code,
                                                                                                                              Deduction Classification, Deduction Balance - YTD, QTD, & MTD.
UW_PY_BAL_ERNGS        Earnings Balance Data View                         12/30/2010 Payroll        Non-Sensitive             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                 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             This view will contain 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             This table will contain 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 Data                  11/30/2010 Payroll        Non-Sensitive             This table will contain regular and adjusted deductions balances for employees who had deduction balance
                       View                                                                                                   adjusted. 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             This table will contain 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                 This table will contain 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.


3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                                                                       3 of 8                                                                                                          10/25/2011 11:53 AM
                                                                                          University of Wisconsin System
                                                                                                    HRS Project
                                                                                                  Data Dictionary
                                                                                              Data View Descriptions




                                                                                       Functional
Data View/Record       View Name                              Date Added/Updated         Area       Sensitive/Non-Sensitive                                                       Description
UW_PY_BALAD_TAX        Tax Balance Adjustment Data View                   11/30/2010 Payroll        Non-Sensitive             This table will contain 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             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                 This view will contain 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                 This view will contain 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             This view will contain general deduction information for employees with general deductions. Fields include
                       View                                                                                                   Deduction Code, Deduction Amount, Deduction Percent, Goal Amount, and Current Goal Balance.
UW_PY_ERNDST_VW        (Sensitive) Earnings Distribution                  12/30/2010 Payroll        Sensitive                 This view will contain 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             This view will contain 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             This view will contain 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                            1/31/2011 Payroll        Non-Sensitive             This view will contain non sensitive earnings distribution information (funding information) for all employees
                       Distribution Data View                                                                                 created 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
UW_PY_NS_PYI_VW        (Non-Sensitive) Pay Check and                       6/27/2011 Payroll        Non-Sensitive             view.
                                                                                                                              This view will contain 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             This view will contain 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.

UW_PY_PYINFO_VW        (Sensitive) Pay Check and Other Pay                 6/27/2011 Payroll        Sensitive                 This view will contain 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             This view will contain 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                 This view will contain 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_TL_EMPDTA_VW        Basic Time & Labor Employee Data                   12/30/2010 Time and Labor Non-Sensitive             Contains basic information about time reporters. Fields include Time Reporting Status, Workgroup, Task group, Rule
                       View                                                                                                   elements, TCD Group, Approver and Approver Backup, UW Non Approver and Non Approver backup.

UW_TL_EXCPTN_VW        Time & Labor Exception Data View                    2/28/2011 Time and Labor Non-Sensitive             This view will contain exceptions tied to an employee's job. Fields include Exception ID, Date Under Report,
                                                                                                                              Exception Messages, Exception Status, and Source of Exception,
UW_TL_PAYRPT_VW        Reported & Payable Time Data View                   2/28/2011 Time and Labor Non-Sensitive             This view will contain payable and reported time rows for time reporters. Fields include Time Reporting Code,
                                                                                                                              Punch 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             This view will contain 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.


3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                                                                       4 of 8                                                                                                      10/25/2011 11:53 AM
                                                                                       University of Wisconsin System
                                                                                                 HRS Project
                                                                                               Data Dictionary
                                                                                           Data View Descriptions




                                                                                    Functional
Data View/Record       View Name                           Date Added/Updated         Area       Sensitive/Non-Sensitive                                                      Description
UW_TL_SCH_AS_VW        Time & Labor Schedule Assignment                12/30/2010 Time and Labor Non-Sensitive             This view will contain schedule for time reporters. Fields include Schedule Group, Rotation ID, Schedule ID and
                       Data View                                                                                           Description.
UW_PYRCD_TBL_VW        Time & Labor Payroll Coordinator                 1/31/2011 Time and Labor Non-sensitive             This view will list all payroll coordinators for an employee. Fields include Employee ID, Employee Record Number,
                       Data View                                                                                           Effective Date, Effective Sequence, and Payroll Coordinator.
UW_TL_EX_DIF_VW        Time & Labor Exam Differential                   1/31/2011 Time and Labor Non-sensitive             This view will list 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_GR_DTL_VW        Time & Labor Group Detail Data                   1/31/2011 Time and Labor Non-sensitive             This view will contain 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_ST_DIF_VW        Time & Labor Student Differential                1/31/2011 Time and Labor Non-sensitive             This view will contain 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             This view will list time reporter roles associated with an employee. Fields include Employee ID, Employee Record
                       Data View                                                                                           Number, Role Name, and Operator ID.




3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                                                                  5 of 8                                                                                                       10/25/2011 11:53 AM
                                                 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 OWS 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

3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                       6 of 8                         10/25/2011 11:53 AM
                                                 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

3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                       7 of 8                         10/25/2011 11:53 AM
                                                 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




3e23cec1-59c6-4baf-af97-bf8f2ecf2724.xlsx                       8 of 8                         10/25/2011 11:53 AM

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:2
posted:10/25/2011
language:English
pages:8