Data Source | PROD_DB |
|---|---|
Job/Process Source (Refresh Interval) | Application job, Baseline Banner Tables (Live Data) |
Functional User(s) | Elise Garcia (Director Student Success) |
Report Owner | Elise Garcia (Director Student Success) |
Contains PII | Yes |
🛠 What It’s Used For
Undocumented students often do not offer up residency information on their application because of misuse and mistreatment. To connect qualifying students to AB 540 services we first need to identify them. Student Success spends time each semester trying to identify qualifying students who have a high dollar balance on their account and providing services.
🔘 Options
Options | Description |
|---|---|
Term Selection | SELECT TERM AS "TERM_CODE", SEMESTER AS "DESC", TERM + ' - ' + SEMESTER AS DISPLAY FROM cos_argos_term_dw_vw Allows one term selection from a list of the last 10 years. Term defined as: Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. |
Minimum Balance Owed | Allows for user entry where only numerical values will allow the report to work. This value is used to return only student records that have an Account Balance greater than that. |
📄 Results
Field Name | Data Source/Logic | Description (sample) |
|---|---|---|
FIRST_NAME |
| Uses Preferred First Name if it exists. If it doesn’t it uses Legal First Name. Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. |
ACCOUNT_BALANCE | Uses function | Formats that numerical value as currency. |
PERSONAL_EMAIL |
| Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'. |
🗺 Report Domain
Returns records that are greater than the amount entered on Minimum Balance Owed and in the selected term.
| Version | Date | Comment |
|---|---|---|
| Current Version (v. 1) | Jun 01, 2022 20:37 | Jordan Lamb |
| v. 3 | Jul 20, 2022 16:44 | Jordan Lamb |
| v. 2 | Jun 01, 2022 20:37 | Jordan Lamb |
| v. 1 | Jun 01, 2022 20:37 | Jordan Lamb |
0 Comments