Brief Description | HIPAA Training Compliance - lists users that have completed or not completed HIPAA training by departmentThis app monitors draw amounts for Wisconsin Partnership Program grants. | |
Data Classification | PublicInternal | |
Developer | Melissa Chan | |
Primary Audience | General HR users or others who are responsible for esuring HIPAA training of employeesWisconsin Partnership Program Administrators | |
Data Sources | EPM, AADW, CanvasSFMRT: FINANCE_QVDs_WISDM/PROJECT_ACCOUNTING.QVD | |
Data Load Schedule | daily | Definitions |
Plans for Future Development | Need to accommodate for year to year changeover | |
Daily | ||
Definitions | FY Period - A combination of Calendar Year and Calendar Month Nbr. Refers to the last day of the period. Category - Abbreviated name of the Award Sponsor Id. PERC = MSN102604, OAC = MSN102605, and ADMN = MSN102606. End Near Close - Flags projects whose end date falls before the Near Close date. Near Close - The YYYYMM that is three months after the selected FY Period. Fund Balance - The sum of Revenue_Itd and Exp_and_Sales_Cr_Itd, rounded to 2 decimals. Draw Amount - If expenses do not exceed the budget, this equals the sum of Revenue_Itd, Sales_Credit_Itd, and Expense_Itd. If the grant is overspent, this equals the sum of Budget_Itd and Revenue_Itd as long as the sum is greater than 0. Otherwise, this is null. Amount Overspent - If Expense_Itd and Sales_Credit_Itd exceeds the Budget_Itd, this field is null. Otherwise, it equals Expense_Itd + Sales_Credit_Itd - Budget_Itd For all other terms see WISDM definitions | |
Plans for Future Development | None at this time | |
Additional Notes | Only grants in Award Sponsor Id's MSN102604, MSN102605, or MSN102606 are included. This app excludes archived grants (where Project Status Number = 6), excludes grants with no financial nor budget activity, and excludes data from the current period. |
Page History
Overview
Content Tools