1 data warehouse time and labor subject area october 8, 2010
DESCRIPTION
33 Potential uses for Time and Labor Subject Area –Leave Usage over time period –Project Related Hours –Hours by ChartField The Day Date column reflects the “Date Under Report”. Year Number from this data dimension is set to drill to Quarter, then Month, then Date when used on a request Statewide Time and Labor Dashboard has been developed as a starting point Data Warehouse AP Super Subject AreaTRANSCRIPT
![Page 1: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/1.jpg)
1
Data Warehouse Time and Labor Subject AreaOctober 8, 2010
![Page 2: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/2.jpg)
22
Data WarehouseProject Transactions Subject Area
• HCM - Workforce – Time and Labor– Data extracted nightly– Contains information from the payable time
table in SHARP– Data available is based on Departmental
security
![Page 3: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/3.jpg)
33
• Potential uses for Time and Labor Subject Area– Leave Usage over time period– Project Related Hours– Hours by ChartField
• The Day Date column reflects the “Date Under Report”. Year Number from this data dimension is set to drill to Quarter, then Month, then Date when used on a request
• Statewide Time and Labor Dashboard has been developed as a starting point
Data WarehouseAP Super Subject Area
![Page 4: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/4.jpg)
44
Data WarehouseTime and Labor Dashboard – Leave Usage
![Page 5: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/5.jpg)
55
• FMLA Leave Usage– This request includes the following Time Reporting Codes:
FMCMT, FMDDY, FMHCT, FMLWP, FMNWT, FMSCK, FMSHL, FMVAC
• Sick Leave Usage – Hour Based TRCs– This request includes the following Time Reporting Codes:
OSL, SCK, WSL, FMSCK
• Sick Leave Usage – Amount Based TRCs– This request includes the SLP and SLK Time Reporting
Codes– Reminder: Amount Based TRCs have amounts reported as
“Number of Hours”. Use the Column Properties button to display as a monetary value.
Data WarehouseTime and Labor Dashboard – Leave Usage
![Page 6: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/6.jpg)
66
Data WarehouseTime and Labor Dashboard – TRC Funding
![Page 7: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/7.jpg)
77
• Hour Based TRCs by Selection– This request includes hour based Time Reporting Codes– Use the column selector to choose the ChartField you wish
to use to run the request
• Amount Based TRCs by Selection– This request includes amount based Time Reporting Codes– Use the column selector to choose the ChartField you wish
to use to run the request
Data WarehouseTime and Labor Dashboard – TRC Funding
![Page 8: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/8.jpg)
88
Data WarehouseTime and Labor Dashboard – Project Related
![Page 9: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/9.jpg)
99
Data WarehouseTime and Labor Dashboard – Project Related
• Project Related - Hour Based TRCs– This request includes hour based Time Reporting Codes– Includes PC Business Unit, Project ID, Project Description,
Activity ID, Activity Description, and Number of Hours
• Project Related – Amount Based TRCs– This request includes amount based Time Reporting Codes– Includes PC Business Unit, Project ID and Description,
Activity ID and Description, and Amount
![Page 10: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/10.jpg)
1010
Data WarehouseTime and Labor Dashboard – TRC Summary
![Page 11: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/11.jpg)
1111
Data WarehouseTime and Labor Dashboard – TRC Summary
• Time Reporting Code Summary– Provides Time Reporting Codes by groupings (view the
spreadsheet outlining the codes assigned to each group at http://www.da.ks.gov/sharp/datawarehouse/TRCGroups.xls)
– Provides Pie Chart format as well as table format
![Page 12: 1 Data Warehouse Time and Labor Subject Area October 8, 2010](https://reader036.vdocuments.us/reader036/viewer/2022062600/5a4d1b277f8b9ab0599979e6/html5/thumbnails/12.jpg)
1212
Data Warehouse Resources
• SHARP website: http://www.da.ks.gov/sharp/
• SHARP Infolist– Subscribe at http://www.da.ks.gov/gov/listserv.htm
• SMART Help Desk (for data warehouse issues)• Search the SMART Solutions Knowledgebase at https://dahelpdesk.ks.gov/sd/SolutionsHome.sd
• Log in to Service Desk at https://dahelpdesk.ks.gov/• Call 785-368-8000, Select Option 2