On March 4, 2014, ASU_A_ADM (also known as PS_ASU_A_ADM) will be renamed to ASU_A_ADM_ARCH to help ensure that users of this data understand its archived state. Queries that require the frozen data in ASU_A_ADM / PS_ASU_A_ADM must be updated to reference the archive table instead. No column names will be changed.
If you want to continue to use these inactive tables,
here is what you need to do to modify your query:
• for
queries using ASU_A_ADM, please change the table’s Physical name from ASUDW.ASU_A_ADM to ASUDW.ASU_A_ADM_ARCH
• for
queries using PS_ASU_A_ADM, please change the table’s Physical name from
SYSADM.PS_ASU_A_ADM to ASUDW.ASU_A_ADM_ARCH
To see a specific list of reports using either table,
please click https://docs.google.com/a/asu.edu/spreadsheet/ccc?key=0AhOZY7Jpd1s1dEtfc2R2QmRwb2YwZlc2TUc3VGpXRHc. This list contains the suggested contact(s),
location and name of report. We have
created a help article (http://help.asu.edu/sims/selfhelp/SelfhelpKbView.seam?parature_id=8373-8193-7884)
for instructions on how to change a table name.
Queries that need current/up-to-date admissions
information should be adjusted to use the new Admissions Fact tables
(ASU_ADM_APPLICATION, ASU_ADM_APPLICANT, ASU_ADM_INTL_STUDENT and
ASU_ADM_APP_FIRST_AD_SNP) or other tables/views as needed.
If you need assistance in modifying your existing query,
please contact the BI Reporting team at myreports@asu.edu.
No comments:
Post a Comment