Integrated financial, research, and academic data designed for easy queries and analysis, with certified definitions and documented business rules.ĭaily accumulation of FAS transaction data, budget index, etc.Īrchive (from the ODS) of one year payroll check register detail, and gross pay control totals used for verification. Note: If a port number is required to connect, use edwpub.s.uw.edu,1433 What servers and databases are available in the EDW? Server If you need to request new or different access to EDW, visit the Request Access pageįor more information on EDW security, visit the Data Security page.Note: you may have been granted access to more than one role. In the example above, the user has been assigned to the EDW Administrator role. The data you can access is governed by the role to which you have been assigned. Look under the Application column – you have access to EDW data, reports, cubes, and visualizations if you see EDW listed.ASTRA will display a list of authorizations:.Not sure if you have access to EDW data and tools? Or want to find out what kind of access you have? Any UW employee can use ASTRA to view their EDW access. For more information, check your browser’s documentation, or see: Bypass your cache Do I have access to the EDW? In Firefox, Chrome, and Edge, you can override the caching by pressing Control-F5 with this page open. Note: If the data in the above table does not appear to be updating when you click the Refresh button, you may need to override your browser’s caching feature. Paycalc load from Workday into HumanResources Payment (Actual Distributions), Benefits, Faculty Bioĭaily load from Workday into HumanResources Person, Employment, Financial (Projected Distributions) Geopolitical Entities, Names, and Codes (GENC) For example, a “Load Freq” of “Daily: Mon-Fri” means that the data will be processed after business hours Monday through Friday and made available the next morning (Tuesday through Saturday). Note: The “Load Freq” indicates the days of the week whose data is made available in the EDW the next morning.
The table is organized by Subject Area and Data Component.
The data availability table shows when and how frequently data is loaded into the EDW.
0 kommentar(er)
