| Brief Description | This app assigns AFQ line codes and descriptions to 3 sets of data: UW data (UW AFQ), External Accounting, and the combination of UW and External Accounting (AFQ VW). Data from the final query (AFQ VW) are used in the official AFQ survey. |
| Data Classification | Internal |
| Developer | Melissa Chan |
| Primary Audience | SMPH Fiscal Affairs Accountant. This app is open to employees in 530230. |
| Data Sources | Views come from the XLS schema in ADW: Query 2 Query 3 |
| Data Load Schedule | Annually at fiscal year close |
| Definitions | See WISER Glossary |
| Plans for Future Development | |
| Additional Notes | Fiscal Affairs adds new values to the views and loads into ADW. AFQ VW - Report Rev & Exp sheet is used in the 'afq uw rev exp step3 fyx for data entry.xlsx' The External Accounting sheet ensures data is mapped to an AFQ line number (Line_Cd and Line_Desc) and an AFQ Rev_Exp_Type. |
Overview
Content Tools