Data Warehouses Changes
There will be improvements in the presentation of data in the Data Warehouse and BusinessObjects. Below are changes:
The DRDA_CNTCT_EMPLID, DRDA_CNTCT_NAME, SUB_CONTRACT_AWARDEE, SUB_CONTRACT_AWARDEE_DESCR100, LOC_FUNDED and PROGRAM_CODE fields will be removed from the following Data Warehouses and corresponding tables:
- Space - PROJECT_GRANT_TBL
- Asset - PROJECT_GRANT_TBL and CURR_PROJECT_GRANT_VW
- Financials - PROJECT_GRANT_TBL and CURR_PROJECT_GRANT_VW
- Human Subjects Research - PROJECT_GRANT_TBL
- Proposal Management - CURR_PROJECT_GRANT_VW
- Financial Aid/Student Financials - CURR_PROJECT_GRANT_VW
- Payroll - PROJECT_GRANT_TBL
- Accounts Receivable - PROJECT_GRANT_TBL
- Human Resource - PROJECT_GRANT_TBL
Project Grant Table
- Renamed column SPONSOR_CLASS to SPONSOR_CLASS_FIN
- Source: M_SPONSOR_TBL
- Renamed column SPONSOR_CLASS_DESCR to SPONSOR_CLASS_FIN_DESCR
- Source: M_SPONSOR_TBL and PSXLATITEM
Sponsor Table
- Added column SPONSOR_CLASS_FIN
- Source: M_SPONSOR_TBL
- Added column SPONSOR_CLASS_FIN_DESCR
- Source: M_SPONSOR_TBL and PSXLATITEM
- Renamed column SPONSOR_CLASS to SPONSOR_CTGRY
- Source: SP_SPONSOR_GROUP (tree)
- Renamed column SPONSOR_CLASS_DESCR to SPONSOR_CTGRY_DESCR
- Source: SP_SPONSOR_GROUP (tree)
- Renamed column SPONSOR_GROUP to SPONSOR_SUBCTGRY
- Source: SP_SPONSOR_GROUP (tree)
- Renamed column SPONSOR_GROUP_DESCR to SPONSOR_SUBCTGRY_DESCR
- Source: SP_SPONSOR_GROUP (tree)
Vendor Table
The VENDOR_TYPE table will be removed from the Financial Data Warehouse.
The VENDOR table will have two new fields: VENDOR_PAYMENT_ALT_NAME1 and VENDOR_WITHHOLDING_ALT_NAME1.
