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

« Previous Version 3 Current »

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. That Term Selection is used for how far back to look at registered students. It includes the term selected.

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 a Current Account Balance greater than or equal to that.

๐Ÿ“„ Results

Field Name

Data Source/Logic

Description (sample)

NAME

BANINST1.GOKNAME.F_GET_NAME (SPRIDEN_PIDM, 'PFML')

Uses Preferred First Name if it exists. If it doesnโ€™t exist, it uses Legal First Name.

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

ACCOUNT BALANCE

     INNER JOIN
     (  SELECT TBRACCD_PIDM                         AS ACCOUNT_PIDM,
               SUM (
                   DECODE (TBBDETC_TYPE_IND,
                           'C', TBRACCD_AMOUNT,
                           TBRACCD_AMOUNT * -1))    AS ACCOUNT_BALANCE
          FROM TBRACCD
               INNER JOIN TBBDETC
                   ON TBBDETC_DETAIL_CODE = TBRACCD_DETAIL_CODE
      GROUP BY TBRACCD_PIDM)
         ON ACCOUNT_PIDM = REGISTERED_PIDM

Grabs the studentโ€™s current Account Balance as detailed by the Cashierโ€™s department.

Formats that numerical value as currency.

HIGHEST REGISTERED TERM

(SELECT SGBSTDN_PIDM                AS RECENT_PIDM,
    MAX (SGBSTDN_TERM_CODE_EFF)     AS RECENT_TERM_CODE
    FROM SGBSTDN

Lists the furthest out term code the student was/is registered for.

GIF of Dr. Emmett Brown (played by Christopher Lloyd) saying 'Great Scott'. From the 'Back to the Future' film.

Can be in the future.

RACE/ETHNICITY

REPORTSNET.f_get_race_ethn_desc

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

PERSONAL EMAIL

BANINST1.Cos_f_Get_Email_Personal (SPRIDEN_PIDM)

Error rendering macro 'excerpt-include' : No link could be created for 'DOC:Common Definitions'.

๐Ÿ—บ Report Domain

Returns the most recent student information where the report options are met.

๐Ÿ”€ Examples

Options:

Term Selection: โ€œ202120 - Spring 2021โ€

Minimum Balance Owed: โ€œ500โ€

๐Ÿ‘จโ€โš•๏ธ Student 1:

Last registered for classes in โ€œ202020 - Spring 2020โ€

Current Balance Owed: โ€œ$1000โ€

โ›” Would Not Show Up

๐Ÿ‘ทโ€โ™€๏ธ Student 2:

Last registered for classes in โ€œ202120 - Spring 2021โ€

Current Balance Owed: โ€œ$499โ€

โ›” Would Not Show Up

๐Ÿ‘ฎโ€โ™‚๏ธ Student 3:

Last registered for classes in โ€œ202220 - Spring 2022โ€

Owed โ€œ$1000โ€ in โ€œ202120 - Spring 2021โ€

Current Balance Owed: โ€œ$499โ€

โ›” Would Not Show Up

๐Ÿ‘จโ€๐Ÿญ Student 4:

Last registered for classes in โ€œ202120 - Spring 2021โ€

Owed โ€œ$60โ€ in โ€œ202120 - Spring 2021โ€

Current Balance Owed: โ€œ$750โ€

(plus) Would Show Up

๐Ÿ•ต๏ธโ€โ™€๏ธ Student 5:

Last registered for classes in โ€œ202220 - Spring 2022โ€

Current Balance Owed: โ€œ$500โ€

(plus) Would Show Up


Version Date Comment
Current Version (v. 3) Jul 20, 2022 16:44 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

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.