| Table(s) Affected |
Universe(s) Affected |
Advisory Description |
| Data Collection: All |
| T_NETID |
EDW - HR - Employee Administration
EDW - HR - Position/Job Hierarchy
EDW - STU - Current Applicant
EDW - STU - Registration Complete
EDW - STU - Registration Limited
EDW - STU - Registration Directory
EDW - STU - Academic Records |
This table may contain terminated and duplicate NetIDs. More... |
| Data Collection: Finance and HR
|
| N/A |
N/A |
Banner users should be aware of a potential issue involving labor encumbrances and carefully monitor their funds during the fiscal year end closeout process. For more information, see the OBFS notice. |
| Data Collection: Finance |
| T_AR_TRAN |
|
At times, an accounts receivable transaction occurs before the customer's general student record is created. The Data Warehouse processing does not update the rows in AR_TRAN or perform additional history tracking. (The Data Warehouse processing writes the row with the information available at the time.) This causes an occassional mismatch between Banner and the Data Warehouse. |
| T_CMDTY_CD |
EDW - Finance - Fixed Assets |
This table may contain similar commodity codes (one with, and one without a leading space) that have different descriptions. More... |
| T_FA |
EDW - Finance - Fixed Assets |
There are several hundred records in this table that have a system status code of "C" but no related description. More... |
| T_FA_TFER |
EDW - Finance - Fixed Assets |
The Banner source system contains 152 duplicate rows for a given combination of keys. These duplicate records were created incorrectly by the surplus warehouse feeder process, and are contained in this Data Warehouse table. More... |
| T_INV_VCHR |
EDW - Finance - Purchase Order / Invoices |
This table may contain invalid Invoice Voucher dates such as "01/01/200". More... |
| T_OL_DETL |
EDW - Finance - Ledgers OL/GL |
Some records in this table that were created prior to 5/12/04 contain unusual budget periods. More... |
| T_OL_SUM |
EDW - Finance - Ledgers OL/GL |
Some records in this table that were created prior to 5/12/04 contain unusual budget periods. More... |
| T_PO |
EDW - Finance - Purchase Order / Invoices |
This table may contain invalid Purchase Order dates such as "01/01/200". More... |
| T_POST_TRAN |
EDW - Finance - Purchase Order / Invoices |
This table may contain anomalous and potentially invalid records for checks processed prior to October 2003. More... |
| T_REQ |
EDW - Finance - Purchase Order / Invoices |
This table may contain invalid Requisition Order dates such as "01/01/200". More... |
| Data Collection: HR/Pay |
| T_ACCR_LEAVE |
EDW - HR - Payroll EDW - HR - Leave |
This table may contain inaccurate or incomplete leave information for data prior to August 2004. More... |
| T_ACCR_LEAVE_BAL_HIST |
EDW - HR - Payroll EDW - HR - Leave |
This table may contain inaccurate or incomplete leave information for data prior to August 2004. More... |
T_HR_ORG (V_PAYR_ORG) |
DM - HR - Payroll Reconciliation |
Please exercise caution when using this table. Error incidents have resulted from a new Payroll ID of "998". DS is actively working on a solution to be implemented with Banner 8 modifications. |
T_HR_PAYR_EXPS_DETL (V_HR_PAYR_EXPS_DETL) |
DM - HR - Payroll Reconciliation |
Please exercise caution when using this table. Error incidents have resulted from a new Payroll ID of "998". DS is actively working on a solution to be implemented with Banner 8 modifications. |
| T_JOB_HIST |
EDW - HR - Employee Administration |
This table may contain inaccurate or incomplete primary job indicators. There are approximately 3800 jobs that have incorrect end dates. More... |
| T_JOB_LBR_DIST |
EDW - HR - Employee Administration EDW - HR - Position and Job Hierarchy EDW - HR - Salary Planner EDW - HR - UI2 Reports EDW - HR - University Admin Reports |
1. This table may contain inaccurate or incomplete primary job indicators.
2. A timing issue exists with this table. It is a history tracking table, therefore rows that have an effective date after midnight are not loaded. This is done to ensure the new rows are added on the correct day. A problem occurs because the new Labor Distribution Row expires the old row. The effect is that the individual will not have any active Labor Distributions until the next day when the new Labor Distribution is added. More... |
| Data Collection: Student |
T_ADM_QUESTION_ANSR
T_MAX_TEST_RESULT
T_RS_MAX_TEST_SCORE
T_STUDENT_AH_CRS
T_STUDENT_AH_CRS_GRADE_HIST
T_STUDENT_AH_CRS_LEVEL_HIST
T_TEST_RESULT_HIST
|
N/A |
A timing issue during the go-live process of the ITPC Banner Upgrade project (ITPC-0300) resulted in missing rows in seven Data Warehouse tables. The Admissions table errors will affect Current Applicant and Registration Census as well.
The project team is working to correct the data issues as soon as possible during the post-production project window. |
T_DM_FA_ANLS_FACT_TERM T_DM_ORG |
DM - STU - Financial Aid Award by Term |
1. Use of the Organization information may cause your reports to return data through the 0405 Academic Year only. To avoid this, do not use the T_DM_ORG table or Universe Objects (College Name, Campus Name, School Code, School Name, Department Name). 2. Use of Department Code information will cause your reports to return data through the 0405 Academic Year only. To avoid limiting your data, do not use the following data in your reports: College Name, Campus Name, School Code, School Name, Department Code, Department Name. More... |
T_DM_ORG T_DM_FA_ORG_YR |
DM - STU - Financial Aid Award by Year |
YEAR Data Mart: Use of the Organization information may cause your reports to return data through the 0405 Academic Year only. In order to avoid this, do not use the these tables or Universe Objects (College Name, Campus Name, School Code, School Name, Department Name ). More... |
T_PERS_HIST T_RS_PERS |
EDW - STU - Registration Complete EDW - STU - Registration Limited EDW - STU - Current Applicant EDW - STU - Registration Census EDW - STU -Current Recruit EDW - STU - Academic Records |
This table may contain inaccurate or incomplete non-international race/ethnic information for data between November, 2005-January, 2006. More... |
| T_STUDENT_AH_CRS |
EDW - STU - Academic Records |
This table contains blank CRS_IDS for terms prior to Fall 2004 on all campuses. More... |
| T_ADM_APPL_ORIG_ADDR |
EDW - STU - Current Applicant DM - STU - Grad Admissions Data Mart DM - STU - RA Contact Analysis Data Mart EDW - STU - Registration Census DM - STU - Undergrad Admissions Data Mart |
This table contains approximately 78,000 blank addresses. More... |
| T_STUDENT_OVERALL_CRS_DETL |
EDW - STU - Academic Records |
This table contains only 10 years of academic history information. If you are interested in data older than 10 years, you need to use Institutional and Transfer Course information (Tables: T_STUDENT_AH_CRS, T_TFER_INST, T_TFER_CRS, T_EQ_UI_CRS). |