Knowledge Navigator is a web-based application that allows UW data users to explore key concepts from subject areas including Academic, Finance, Human Resources, and Research. The tool also visually demonstrates how key concepts are linked to data objects like reports and tables.
Content for Knowledge Navigator is developed by business and/or technical subject matter experts and then vetted by data custodians before becoming available in the tool. While users could always provide feedback on this content by submitting a ticket to the Help Desk, there are now two new features that make it easier for users to engage with specific content: Feedback and Expert Advice!
Using the New Features
You can now provide general feedback or expert advice on any detail page in Knowledge Navigator.
Feedback
This feature allows any user to provide feedback on any detail page in Knowledge Navigator. This feedback can include anything from requesting additional detail or clarity on a particular term to identifying gaps or errors.
To submit feedback:
Scroll to the form at the bottom of any detail page in Knowledge Navigator. Example of the Feedback Form
Select Feedback.
Enter your comments.
Click Submit. Your feedback will be submitted to Knowledge Navigator’s Metadata Manager for review and follow up.
Expert Advice
This feature allows users with expertise in Enterprise Data Warehouse (EDW) business concepts, databases, and/or reporting and visualization development, to share their knowledge on a specific page in Knowledge Navigator.
To submit expert advice:
Scroll to the form at the bottom of any detail page in Knowledge Navigator. Example of the Expert Advice Form
Select Expert Advice.
Indicate whether you want your name and UW NetID posted with this advice in Knowledge Navigator.
Enter your comments.
Click Submit. Your feedback will be submitted to Knowledge Navigator’s Metadata Manager for processing. Once processing is complete, your advice will display with the details on the page.
Questions?
Email help@uw.edu with “Knowledge Navigator” in the subject line.
DocuSign recently announced changes and enhancements that will gradually be rolled out to Production in May 2024. All changes and enhancements are available in the Sandbox environment.
Changes to Global Header Tabs
Renaming of Manage to Agreements
Removal of the Transactions and Forms tabs
New Transactions can be started from the home page or found under the Agreements tab.
Forms has been renamed to Web Forms and can be found under the Templates tab.
View of home page with updated global header tabs. Transactions can now be started from the home page.
Transactions can also be started under the Agreements tab
Forms (now Web Forms) can be found under the Templates tab
General user interface refresh
Most of the DocuSign interface has a slightly updated look and feel. Included in this refresh is a change of the envelopes lists, templates lists, and web forms lists to be paginated instead of an infinite scroll pattern.
New Functionality — Web Forms
DocuSign now provides Web Forms. This functionality enables users to transform a template into a responsive form for your recipients to complete and sign. As the web form builder, the user is not the sender but can reassign the sender role to another person or authorize yourself.
Additionally, users who have the ability to create web forms will be able to copy an existing web form configuration. Once created, the new web form can be modified independently of the original form.
More information on how to use web forms can be found in DocuSign Support.
New Support Pop-ups
The DocuSign user experience now includes pop-ups for new DocuSign services, e.g.Intelligent Agreement Management, that are not available in our environment.
Additionally, some new instructional pop-ups will lead a user through a process that doesn’t correspond to the access configurations in the UW account. We recommend dismissing irrelevant pop-ups for the time being. Our team will address this with the vendor.
Thank you for using eSignatures. Please don’t hesitate to contact us with any questions.
Update: Options for disabling DocuSign envelope removal notifications
What’s happening?
As was announced last fall, the eSignatures service is rolling out a retention period for aging envelopes in all of our departmental DocuSign accounts. As part of this process, DocuSign sends a notification email to provide an opportunity for anyone who was party to the envelope to retrieve it before it is removed from the system. They will most often look like this:
Figure 1: Notification for Document Removal from DocuSign System
What are my options?
If you want to be reminded before an envelope you sent or signed is removed, you do not need to take any action. You will receive these notifications if any envelopes you signed or otherwise were party to are going to be removed from the system.
If you do not want to receive these notifications, follow the steps below to update your account notification preferences. If you have sent or signed a large amount of envelopes and do not need to be notified when they will be removed, we recommend that you update your preferences to not receive these notifications.
How do I update my DocuSign notification preferences?
Log in to DocuSign using your UW NetID at https://account.docusign.com and click on your profile icon at the top right of the page. Select “My Preferences.” Figure 2: My Preferences in DocuSign
Click “Notifications” on the bottom left. This opens your notification preferences. There are sections for notifications you receive as a sender and recipient. Figure 3: Notifications in DocuSign
Under “Sending Notifications”, uncheck “Documents will be purged from the system.” Figure 4: Sending Notifications in DocuSign
Scroll further down the page to “Recipient Notifications” and uncheck this box there as well. Figure 5: Recipient Notifications in DocuSign
Click “Save” either at the top or bottom of the page to update your preferences. Figure 6: Sending Notifications Menu with Option to Save
Support
If you have any questions or concerns regarding this announcement, please reach out to the eSignatures team directly at eSignatures Help.
If you have any questions regarding records management, please reach out to the UW Records Management Services team at recmgt@uw.edu. For questions regarding UW Medicine Records and Information Governance, you can reach their team athrc@uw.edu.
Exciting news! The Reporting & Analytics team (R&A) and Finance DATAGroup have released the new UW Finance Cube! This represents a major advancement in connecting users to Workday data, providing greater flexibility over traditional Workday reports.
As of 4/23/24, this resource is now available to authorized users through the BI Portal.
Note: You must be logged into Husky OnNet (VPN) in order to access the links in this article. For more information, refer to Husky OnNet.
What is UW Finance Cube FY 2024?
The UW Finance Cube offers a comprehensive view of UW Finances for Fiscal Year 2024, including revenue, expenses, and beginning balances. It also allows users to analyze transactions at various levels using dimensions such as Ledger Account, Cost Center, Fund, Function, and many more!
More generally, a data cube is a powerful analysis tool, which allows users to quickly and easily slice and dice data across multiple dimensions, in a single view. For an introduction to cubes, including their benefits over traditional analysis tools such as reports, refer to the What is a Cube introductory video.
How will UW Finance Cube FY 2024 help me?
Comprehensive Financial Insights: View financial data across multiple dimensions. Whether it’s analyzing research award expenditures and gift revenues or tracking procurement expenses, you can gain a holistic view of your financial landscape.
Drill-Down Capabilities: Drill down from summaries to finer levels of information. This feature allows for more granular analysis and better decision-making.
User-Friendly Pivot Tables: Connect to the cube and effortlessly create pivot tables by dropping prepopulated measures and dimensions into place.
Preferred Analysis Tool: Connect to the cube via your preferred analysis tool (for example, Excel, Power BI, or Tableau) for seamless integration.
How reliable is the data?
Reliable! The data source for the cube is Workday Finance, so as long as the data in Workday is accurate, the data in the cube is accurate.
Additionally, while this is the first public-facing release, this is technically Release 3 (R3) for the cube. Prior releases allowed our development team to learn about Workday production data, design a scalable solution, capture applicable dimensions and measures, and conduct User Acceptance Testing (UAT) with approximately 15 users across campus. UAT ensured the cube would meet user needs and helped us identify some additional dimensions to include in this release.
Document Management System (DMS) released DocFinity v12.4 upgrade on April 7, 2024.
This upgrade includes the following:
New Feature – Bulk Reindexing
Bulk Reindex allows you to reindex multiple documents at once with the same values. Bulk reindex is only available when selecting multiple documents with the same document type. The Re-Index button is available on the Results panel.
To learn more, please review the details in Release Notes.
For many Grant Managers and Principal Investigators, the implementation of Workday Finance marked the beginning of a journey—for answers, efficiencies, and reports, but most importantly, data. Along the way, these folks have come across Office Hours and Webinars, UW Connect articles and wiki pages, seeking answers and sharing gaps and pain points, all of which have supported us as we develop solutions.
While there is still more work to do, the Finance DATAGroup, with support from UW-IT Reporting & Analytics, is thrilled to announce three new Grant Reporting resources to provide clarity and support for grant management.
The Grant Planning and Forecasting Tool is a worksheet, which calculates totals based on actual Workday data and manually entered projected values. A Grant Manager can use this tool to review actuals and track projections for a grant with the Principal Investigator (PI). This is helpful in understanding how grant funding is being spent, making projections, and then making adjustments, as needed, based on the calculations.
Note: You must be logged into Husky OnNet (VPN) in order to access the above link. For more information, refer to Husky OnNet.
Post Award Dashboard
The Post Award Dashboard displays grant expense and balance data in table and visual format using data available in Workday. This tool provides an alternative way to access this data for users who are not as familiar with Workday.
This dashboard was originally developed by the Office of Research to fill an urgent need for Principal Investigators (PI) and Grant Managers following Workday Go Live. This second iteration builds on the first, moving the dashboard into Tableau (our supported visualization tool), streamlining filters, tables, and visuals, pulling data directly from Workday to ensure data integrity, and incorporating feedback from a group of early adopters. This dashboard is a work-in-progress and iterative updates are expected.
Note: You must be logged into Husky OnNet (VPN) in order to access the above link. For more information, refer to Husky OnNet.
Principal Investigator Dashboard
The Principal Investigator (PI) Dashboard displays grant data, which is tailored to the PI, who is logged into Workday. This gives PIs a central place to find grant-related content that is specific to them.
This dashboard splits data across six tabs—My Sponsored Grants, My Awards, My Stand Alone Grants, My Gifts, Grant Staffing, and Additional Resources—which are explained in more detail in the following sections.
Tips:
For help finding this dashboard in Workday, refer to Finding Reports.
For help saving this dashboard to your Apps list in Workday, refer to Customizing Workday.
Note: You must be logged into Husky OnNet (VPN) in order to access the above links. For more information, refer to Husky OnNet.
My Sponsored Grants Tab
This tab displays a snapshot of the Sponsored Grants associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab refreshes nightly, so it reflects data from the previous day. Because this tab is not updated in real-time, you may find some discrepancies between this tab and real-time reports (for example, R1234).
Example of the “My Sponsored Grants” Tab
My Awards Tab
This tab displays a snapshot of the awards associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab refreshes nightly, so it reflects data from the previous day. Because this tab is not updated in real-time, you may find some discrepancies between this tab and real-time reports (for example, R1234).
Example of the “My Awards” Tab
My Stand Alone Grants Tab
This tab displays a snapshot of the stand-alone grants associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab reflects data in real-time.
Example of the “My Stand Alone Grants” Tab
My Gifts Tab
This tab displays gifts, but unlike the other tabs, the gits that display are not specific to the PI. This tab also allows the user to drill into additional detail, if needed.
Note: This tab reflects data in real-time.
Example of the “My Gifts” Tab
Grant Staffing Tab
This tab displays the staff working on grants associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab refreshes nightly, so it reflects data from the previous day. Because this tab is not updated in real-time, you may find some discrepancies between this tab and real-time reports (for example, R1234).
Example of the “Grant Staffing” Tab
Additional Resources
This tab links out to helpful resources for the PI, including reports (Workday, research, and legacy), tasks, and other external resources.
Example of the “Additional Resources” Tab
Questions?
Please contact datagrp@uw.edu to initiate a ticket with the Finance DATAGroup.
The student database (SDB) will go through a reorganization on July 20, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on July 22, 2024.
However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data.
Last Updated – 7.18.24
Columns to be Added
Table
Column
DataType
ADDRESSES
SF_COUNTRY
char(2)
BUDGET_RESOURCES
BR_FOOD
int
BR_HOUSING
int
BR_EXTRA_FOOD
int
BR_EXTRA_HOUSING
int
ISIR_TRANSACTIONS
ISIR_CPS_SAI_BLK
bit
ISIR_CPS_P_SAI_BLK
bit
ISIR_INAS_SAI
int
ISIR_INAS_SAI_BLK
bit
NSLDS_DATA_PELL_DATA
N_PELL_SAI
int
SF_EVALUATION
S_MIDDLE_NAME
char(15)
S_SUFFIX
char(10)
STD_EITC_RCVD
char(1)
P1_EITC_RCVD
char(1)
USER_PROV_DATA
char(5)
P_INCOME_ADDITIONS
decimal(11,0)
S_INCOME_ADDITIONS
decimal(11,0)
INSTITUTIONAL_SAI
int
INST_SAI_BLK
bit
IP_S_ADJ_BUS_FARM
decimal(15,0)
IP_P_ADJ_BUS_FARM
decimal(15,0)
SF_EVALUATION1
PJ_STD_FAM_SIZE
char(2)
PJ_P1_FAM_SIZE
char(2)
SR_MAJOR_CODE
MAJOR_TYPES_20
bit
STUDENT_1
DISAB_ARCHIVE_FLG
bit
S1_BOOLEAN_09
bit
S1_BOOLEAN_10
bit
S1_BOOLEAN_11
bit
S1_BOOLEAN_12
bit
S1_BOOLEAN_13
bit
S1_BOOLEAN_14
bit
S1_BOOLEAN_15
bit
S1_BOOLEAN_16
bit
DISAB_ARC_UPDT_DT
datetime
DISAB_ARC_UPDT_ID
char(12)
S1_SPARE_F
char(64)
S1_SPARE_M
char(64)
S1_SPARE_L
char(64)
S1_SPARE_S
char(10)
New Table
Table
Column
Key
DataType
SR_ADM_RESULTS
MY_AA
Y
char(12)
SR_AAR_APPL_NAME
char(45)
SR_AAR_APPL_DOB
datetime
SR_AAR_SYSKEY
int
SR_AAR_EXACTID
char(10)
SR_AAR_CAMPUS
tinyint
SR_AAR_FORM_TYPE
char(8)
SR_AAR_APPL_TYPE
char(1)
SR_AAR_ENTRY_TERM
char(6)
SR_AAR_STATUS
char(1)
SR_AAR_MESSAGE
char(50)
SR_AAR_POSTED_DT
datetime
Columns to be Removed
Table
Column
Notes
SR_ADM_APPL
UW_PROMISE
No data
SR_MAJOR_CODE
MAJOR_EXCHANGE
Not in use, all records ‘0’
STUDENT_1
S1_BOOLEAN_07
Not in use, being replaced by Disab_Archive_Flg
Datatype Changes
Table
Column
DataType(new)
Data Type (old)
SA_WD_SUM_TRAN
WD_SUM_DB_AMOUNT
decimal(11,2)
decimal(9,2)
WD_SUM_CR_AMOUNT
decimal(11,2)
decimal(9,2)
SF_EVALUATION
IP_PC
decimal(15,0)
int
IP_TI
decimal(15,0)
int
IP_SATI
decimal(15,0)
int
IP_ATI
decimal(15,0)
int
SF_EVALUATION1
PJ_STD_EXMPTS
tinyint
decimal(15,0)
PJ_SP_EXMPTS
tinyint
decimal(15,0)
PJ_P1_EXMPTS
tinyint
decimal(15,0)
PJ_P2_EXMPTS
tinyint
decimal(15,0)
Field Moves – from SF_Evaluation to SF_Evaluation1
Two resources in the BI Portal leverage the same data: UW Admissions Cube and All Applications Report. In an effort to streamline security for this data, we recently deployed security updates to both of these resources.
Why was this change necessary?
Historically, access to the UW Admissions Cube and All Applications Report was managed separately, meaning that a user could have access to one resource, but not the other. This change allows us to grant user access at the data level, which ensures consistency in data management.
I no longer have access. What should I do?
The data accessed through these resources must be handled with care—it includes sensitive student data, data that could be misinterpreted and data that should only be communicated to students via the Office of Admissions. Therefore, action is required to gain or maintain access:
Note: You will need to be connected to the VPN to access this video.
Email studentdata@uw.edu and include “Access to Data in the UW Admissions Cube or All Applications Report” in the subject line. Make sure to indicate that you watched the video.
Content Spotlight: Information & Technology Governance
The UW has a new Information & Technology governance model to help guide how we use IT, aimed at enabling transformation and innovation at the UW through strategic investment in information and technology. The governance model is detailed in IT Connect’s IT at the UW section, and gives an overview of the governance groups that oversee various IT domains, their membership, and their purpose.
The content is an excellent example of teams from UW-IT collaborating to create an informative topical experience on IT Connect. If you or your team want support with creating web experiences on IT Connect, fill out this intake form and check the “Consulting on web content” option.
Web Content Best Practices: Optimize content for search engines
Good SEO practices on IT Connect content help end users find the information they seek. The IT Connect platform includes many features behind the scenes to help improve the search prominence of the site, but a significant key to the success of content in search results relies on the content itself.
Use plain language and use the words that end users use.
Repeat keywords throughout the content. If a word is central to a topic, if it appears on the page more than a few times, that page is more likely to be featured in search results for that term.
Use headings logically. Headings can be important for search engines evaluation of a page for search results. For the IT Connect internal search, headings are given additional weight. Headings should be clear and aimed at reader comprehension first, but use keywords in headings where it makes sense to do so.
Do you need some help creating IT Connect content, another head to brainstorm content organization and layout, or want to learn how to use the features available in IT Connect? There are several ways to get help:
Content Manager Documentation: Extensive documentation, ranging from the basics of WordPress to advanced features for pages, is available on the IT Connect Content Manager Documentation.
Guide to writing documentation: Use the Getting started with documentation guide to help you start writing documentation. The guide breaks down the documentation process that will benefit your end users.
Training: One-on-one training for managing content on IT Connect is available from the IT Connect service manager, Nick Rohde, over Zoom or in person. Get tips on correctly formatting content using the tools in IT Connect or learn how to organize your content. To arrange training, fill out this intake form.
Consultation: Consultation sessions for individuals or teams are available from the IT Connect product manager, Nick Rohde. To schedule a consultation, fill out this intake form.
The student database (SDB) will go through a reorganization on January 27, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 29, 2024.
However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data.
Last Updated – 1.23.24
**below additions to SF_Evaluation will result in additional records being shifted to SF_Evaluation1, will add details as soon as available.
Columns to be Added
Table
Column
DataType
ISIR_TRANSACTIONS
ISIR_CPS_SAI
int
ISIR_CPS_PROV_SAI
int
I_SP_SIGNATURE_CD
char(1)
I_P1_SIGNATURE_CD
char(1)
I_P2_SIGNATURE_CD
char(1)
I_SP_SSN_MATCH_FL
char(1)
I_P1_SSN_MATCH_FL
char(1)
I_P2_SSN_MATCH_FL
char(1)
PELL_DISBURSEMENT
PD_PAY_END_DT
datetime
PD_QTR_FLG
char(1)
SA_WD_DET_TRANS
WD_DET_BANK_CD
char(1)
SA_WD_SUM_TRAN
WD_SUM_BANK_CD
char(1)
STUDENT_1
DISAB_MORE_IND
bit
SYS_TBL_63_NONTUIT_CHARGES
AID_REPAY_CHARGE
bit
SPARE_BOOLEAN_2
bit
SDBDB01
G_SA_FLAG4
bit
SF_EVALUATION1
PJ_STD_DEPS
tinyint
PJ_SP_DEPS
tinyint
PJ_P1_DEPS
tinyint
PJ_P2_DEPS
tinyint
SP_TAX_RETURN_DT
datetime
P2_TAX_RETURN_DT
datetime
SF_EVALUATION
IP_S_IPA
decimal(15,0)
IP_S_APA
decimal(15,0)
S_SP_SSN_MATCH_IND
char(1)
P1_SSN_MATCH_IND
char(1)
P2_SSN_MATCH_IND
char(1)
S_DRUG_HOLD_IND
char(1)
SSA_CITIZENSHIP_SP
char(1)
SSA_CITIZENSHIP_P1
char(1)
SSA_CITIZENSHIP_P2
char(1)
STD_TU_MATCH_FLG
char(1)
SP_TU_MATCH_FLG
char(1)
P1_TU_MATCH_FLG
char(1)
P2_TU_MATCH_FLG
char(1)
MET_POVERTY_GUIDE
char(1)
SPO_PENSIONS_MAN
decimal(11,0)
P1_PENSIONS_MAN
decimal(11,0)
SAI_BLK
bit
PROV_SAI_BLK
bit
S_NO_FAM_MEMB_BLK
bit
S_NO_IN_COLLE_BLK
bit
STD_WK_INCOME_BLK
bit
STD_INTEREST_BLK
bit
STD_IRA_DIST_BLK
bit
STD_IRA_ROLL_BLK
bit
STD_PENSIONS_BLK
bit
STD_PENS_ROLL_BLK
bit
STD_AGI_BLK
bit
STD_TAX_PAID_BLK
bit
STD_DEDCT_PMT_BLK
bit
S_EDUC_CREDIT_BLK
bit
STD_SCHED_C_BLK
bit
STD_GRNT_SCHL_BLK
bit
STD_FRGN_EXCL_BLK
bit
STD_CHLD_SUPP_BLK
bit
STD_CASH_BLK
bit
STD_BUS_FARM_BLK
bit
STD_INVEST_BLK
bit
SPO_WK_INCOME_BLK
bit
SPO_INTEREST_BLK
bit
SPO_IRA_DIST_BLK
bit
SPO_IRA_ROLL_BLK
bit
SPO_PENSIONS_BLK
bit
SPO_PENS_ROLL_BLK
bit
SPO_AGI_BLK
bit
SPO_TAX_PAID_BLK
bit
SPO_DEDCT_PMT_BLK
bit
SPO_EDUC_CRED_BLK
bit
SPO_SCHED_C_BLK
bit
SPO_FRGN_EXCL_BLK
bit
P1_WK_INCOME_BLK
bit
P1_INTEREST_BLK
bit
P1_IRA_DIST_BLK
bit
P1_IRA_ROLL_BLK
bit
P1_PENSIONS_BLK
bit
P1_PENS_ROLL_BLK
bit
P1_AGI_BLK
bit
P1_TAX_PAID_BLK
bit
P1_DEDCT_PMT_BLK
bit
P1_EDUC_CRED_BLK
bit
P1_SCHED_C_BLK
bit
P1_GRNT_SCHL_BLK
bit
P1_FRGN_EXCL_BLK
bit
P1_CHLD_SUPP_BLK
bit
P1_BUS_FARM_BLK
bit
P1_INVEST_BLK
bit
P1_CASH_BLK
bit
P2_WK_INCOME_BLK
bit
P2_INTEREST_BLK
bit
P2_IRA_DIST_BLK
bit
P2_IRA_ROLL_BLK
bit
P2_PENSIONS_BLK
bit
P2_PENS_ROLL_BLK
bit
P2_AGI_BLK
bit
P2_TAX_PAID_BLK
bit
P2_DEDCT_PMT_BLK
bit
P2_EDUC_CRED_BLK
bit
P2_SCHED_C_BLK
bit
P2_FRGN_EXCL_BLK
bit
IP_STD_FWS_BLK
bit
IP_SP_FWS_BLK
bit
IP_P1_FWS_BLK
bit
IP_P2_FWS_BLK
bit
IP_ATI_BLK
bit
IP_P_PTA_BLK
bit
IP_IPA_BLK
bit
IP_P_PEEA_BLK
bit
IP_AI_BLK
bit
IP_AAI_BLK
bit
IP_PC_BLK
bit
IP_STD_PTA_BLK
bit
IP_S_IPA_BLK
bit
IP_STD_PNAAI_BLK
bit
IP_STD_SEEA_BLK
bit
IP_SATI_BLK
bit
IP_STAI_BLK
bit
IP_SCI_BLK
bit
IP_SAAI_BLK
bit
IP_SC_SAAI_BLK
bit
IP_DNW_BLK
bit
IP_NW_BLK
bit
IP_APA_BLK
bit
IP_PCA_BLK
bit
IP_SDNW_BLK
bit
IP_S_APA_BLK
bit
IP_SCA_BLK
bit
CUI_STD_AGI_BLK
bit
CUI_STD_EXEMP_BLK
bit
CUI_STD_DEPS_BLK
bit
CUI_STD_INC_BLK
bit
CUI_STD_TAX_BLK
bit
CUI_STD_EDUC_BLK
bit
CUI_STD_IRA_D_BLK
bit
CUI_STD_IRA_P_BLK
bit
CUI_STD_INTER_BLK
bit
CUI_STD_PENSN_BLK
bit
CUI_STD_SCHDC_BLK
bit
CUI_SPO_AGI_BLK
bit
CUI_SPO_EXEMP_BLK
bit
CUI_SPO_DEPS_BLK
bit
CUI_SPO_INC_BLK
bit
CUI_SPO_TAX_P_BLK
bit
CUI_SPO_EDUC_BLK
bit
CUI_SPO_IRA_D_BLK
bit
CUI_SPO_IRA_P_BLK
bit
CUI_SPO_INTER_BLK
bit
CUI_SPO_PENSN_BLK
bit
CUI_SPO_SCHDC_BLK
bit
CUI_P1_AGI_BLK
bit
CUI_P1_EXEMPT_BLK
bit
CUI_P1_DEPS_BLK
bit
CUI_P1_INC_BLK
bit
CUI_P1_TAX_BLK
bit
CUI_P1_EDUC_BLK
bit
CUI_P1_IRA_D_BLK
bit
CUI_P1_IRA_P_BLK
bit
CUI_P1_INTER_BLK
bit
CUI_P1_PENSN_BLK
bit
CUI_P1_SCHDC_BLK
bit
CUI_P2_AGI_BLK
bit
CUI_P2_EXEMPT_BLK
bit
CUI_P2_DEPS_BLK
bit
CUI_P2_INC_BLK
bit
CUI_P2_TAX_BLK
bit
CUI_P2_EDUC_BLK
bit
CUI_P2_IRA_D_BLK
bit
CUI_P2_IRA_P_BLK
bit
CUI_P2_INTER_BLK
bit
CUI_P2_PENSN_BLK
bit
CUI_P2_SCHDC_BLK
bit
IP_STI_BLK
bit
IP_TI_BLK
bit
IP_FTI_BLK
bit
PJ_STD_WORK_BLK
bit
PJ_STD_TAXES_BLK
bit
PJ_STD_AGI_BLK
bit
PJ_STD_UNTAXI_BLK
bit
PJ_STD_IRA_P_BLK
bit
PJ_STD_EDUC_BLK
bit
PJ_STD_INTER_BLK
bit
PJ_STD_EXMPT_BLK
bit
PJ_STD_DEPS_BLK
bit
PJ_STD_SCHDC_BLK
bit
PJ_STD_UNTAXP_BLK
bit
PJ_SP_WORK_BLK
bit
PJ_SP_TAXES_BLK
bit
PJ_SP_AGI_BLK
bit
PJ_SP_UNTAXI_BLK
bit
PJ_SP_IRA_P_BLK
bit
PJ_SP_EDUC_BLK
bit
PJ_SP_INTER_BLK
bit
PJ_SP_EXMPT_BLK
bit
PJ_SP_DEPS_BLK
bit
PJ_SP_SCHDC_BLK
bit
PJ_SP_UNTAXP_BLK
bit
PJ_P1_WORK_BLK
bit
PJ_P1_TAXES_BLK
bit
PJ_P1_AGI_BLK
bit
PJ_P1_UNTAXI_BLK
bit
PJ_P1_IRA_PMT_BLK
bit
PJ_P1_EDUC_BLK
bit
PJ_P1_INTER_BLK
bit
PJ_P1_EXMPT_BLK
bit
PJ_P1_DEPS_BLK
bit
PJ_P1_SCHDC_BLK
bit
PJ_P1_UNTAXP_BLK
bit
PJ_P2_WORK_BLK
bit
PJ_P2_TAXES_BLK
bit
PJ_P2_AGI_BLK
bit
PJ_P2_UNTAXI_BLK
bit
PJ_P2_IRA_PMT_BLK
bit
PJ_P2_EDUC_BLK
bit
PJ_P2_INTER_BLK
bit
PJ_P2_EXMPT_BLK
bit
PJ_P2_DEPS_BLK
bit
PJ_P2_SCHDC_BLK
bit
PJ_P2_UNTAXP_BLK
bit
SPARE_BOOLEAN1
bit
SPARE_BOOLEAN2
bit
SPARE_BOOLEAN3
bit
SPARE_BOOLEAN4
bit
Columns with datatype changes
Table
Column
DataType (existing)
DataType
(New)
SF_EVALUATION1
(currently in SF_EVALUATION)
SNG_SUM_ENROLL_ST
char(1)
char(2)
SNG_AUT_ENROLL_ST
char(1)
char(2)
SNG_WIN_ENROLL_ST
char(1)
char(2)
SNG_SPR_ENROLL_ST
char(1)
char(2)
Columns to be Removed
Table
Column
Notes
SDBDB01
G_WORKDAY_FIN
Replaced with G_SA_FLAG4
SF_EVALUATION
STD_TU_MATCH_DT
Not currently in use
Replaced with STD_TU_MATCH_FLG
SP_TU_MATCH_DT
Not currently in use
Replaced with SP_TU_MATCH_FLG
P1_TU_MATCH_DT
Not currently in use
Replaced with P1_TU_MATCH_FLG
P2_TU_MATCH_DT
Not currently in use
Replaced with P2_TU_MATCH_FLG
SR_DEPT_CODE
DEPT_FAS_ORG_CODE
STUDENT_1
S1_BOOLEAN_06
Not currently in use
Replaced with DISAB_MORE_IND
SA_WD_DET_TRANS
WD_DET_AID_TYPE
SA_AID_DISB_TRANS
Entire table
Columns moving from SF_Evaluation to SF_Evaluation1 due to column additions:
