Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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

NVL(SPBPERS_PREF_FIRST_NAME, SPRIDEN_FIRST_NAME) AS 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 F_ACCOUNT_BALANCE and that returns the value from here tbraccd_balance.

Formats that numerical value as currency.

PERSONAL_EMAIL

SZRCCAP_EMAIL_ADDRESS

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
  • No labels