Page Comparison

DW Field

TERM

sfbetrm.sfbetrm_term_code as term,

TERM

SEMESTER

stvterm.stvterm_desc as semester,

SEMESTER

STUDENTID

spriden.spriden_id as studentid,STUDENTID

SSN

spbpers.spbpers_ssn as ssn,

SSN

PIDM

spriden.spriden_pidm as pidm,PIDM

LASTNAME

spriden_last_name as LastName,LASTNAME

FIRSTNAME

spriden_first_name as FirstName,FIRSTNAME

MIDINIT

spriden_mi as MidInit,

MIDINIT

STUDENTNAME

nvl(spriden_last_name, '') || ', ' ||

nvl(spriden_first_name, '') || ' ' ||

nvl(spriden_mi, '') as studentname,STUDENTNAME

ADDRESS

spraddr.spraddr_street_line1 as address,

ADDRESS

Address at the start of the record’s term

CITY

spraddr.spraddr_city as city,

CITY

City at the start of the record’s term

STATE

spraddr.spraddr_stat_code as state,STATE

State at the start of the record’s term

ZIP

spraddr.spraddr_zip as zip,ZIP

Zip at the start of the record’s term

PHONE

decode(sprtele_phone_number, null, '', '(' || sprtele_phone_area || ') ' || sprtele_phone_number) as phone,

PHONE

STATUS

decode(f_sgbstdn_fields (spriden.spriden_pidm, sfbetrm.sfbetrm_term_code, 'STU_TYPE'), null, null, substr(f_get_desc_fnc('STVSTYP',f_sgbstdn_fields (spriden.spriden_pidm, sfbetrm.sfbetrm_term_code,'STU_TYPE'),30),1,30) ) as status,STATUS

Description of Student Status. See the STVSTYP lookup table in the Appendix. This is the full description of the status. (Continuing Student, Returning Student)

There is also the CAST code (shrttrm_cast_code) which is included at the end of the record.

PROGRAM

sgbstdn.SGBSTDN_PROGRAM_1PROGRAM

The program of the major

PROG_DEPT

g.SGBSTDN_DEPT_CODE

PROG_DEPT

Department code for student’s program

PROG_GE_PATTERN

g.SGBSTDN_MAJR_CODE_CONC_1PROG_GE_PATTERN

Student’s GE pattern for programs

IN_STATE_IND

MAJOR_CODE

SGBSTDN.SGBSTDN_MAJR_CODE_1

MAJOR_CODE

Numeric code for the student’s major

MAJOR

substr(f_get_desc_fnc('STVMAJR',SGBSTDN.SGBSTDN_MAJR_CODE_1,30),1,30) as Major,MAJOR

Description of the MAJOR_CODE

GOAL

substr(f_get_desc_fnc('STVEGOL',SGBSTDN_EGOL_CODE,30),1,30) as Goal,

GOAL

Uninformed Educational Goal description

GOAL_INFORMED_EFF_TERM

substr(f_get_serdtgl_eff_term(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,6)

GOAL_INFORMED_EFF_TERM

The term at which the Informed Goal codes became effective.

FIN_AID_IND_BY_MJR

substr( baninst1.cos_general_restr.f_aid_ind_from_stvmajor_code( sgbstdn.sgbstdn_majr_code_1, f_get_serdtgl_eff_term(spriden.spriden_pidm, sfbetrm.sfbetrm_term_code)), 1, 1)

FIN_AID_IND_BY_MJR

This is a Financial Aid indicator based on the major code. ('Y', 'N')

CTE_IND_BY_MJR

SUBSTR( baninst1.cos_general_restr.f_cte_ind_from_stvmajor_code( sgbstdn.sgbstdn_majr_code_1 ,f_get_serdtgl_eff_term(spriden.spriden_pidm, sfbetrm.sfbetrm_term_code)) ,1 ,1)

CTE_IND_BY_MJR

This is a CTE indicator based on the major code. ('Y', 'N')

GOAL_INFORMED_CODES

substr(f_get_serdtgl_codes(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,10)

GOAL_INFORMED_CODES

Most recent Informed Goal codes. Up to 10 codes, no delimiter. See Goal Codes in Appendix.

SELECT *
FROM COS_DATALAKEHOUSE.DATALAKE.COSBANNERPROD_SATURN_STVGOAL
WHERE INVOKE_DATA_DATE = CURRENT_DATE;

GENDER

SPBPERS.SPBPERS_SEX as gender,GENDER

BIRTHDATE

spbpers.spbpers_birth_date as birthdate,

BIRTHDATE

AGE

f_calculate_age(null,spbpers_birth_date, spbpers_dead_date) as age,

AGE

AGEATTERM

f_calculate_age(stvterm_end_date,spbpers_birth_date, spbpers_dead_date)

AGEATTERM

CENSUSAGEGROUP

substr(baninst1.cos_fw_census_age_categ(sfbetrm_term_code,spbpers_birth_date,spbpers_dead_date),1,18)

CENSUSAGEGROUP

MARITAL_CODE

SPBPERS.SPBPERS_MRTL_CODE

MARITAL_CODE

ETHNICITY

decode(spbpers_ethn_code,null,null, substr(f_get_desc_fnc('STVETCT',(substr(f_get_ethn_category(spbpers_ethn_code,'ETCT'),1,1)),30),1,30))ETHNICITY

NEW_ETHNICITY

decode(spbpers_ethn_cde, null, null, 1, 'Not Hispanic', 2, 'Hispanic')

NEW_ETHNICITY

RACES

SUBSTR (f_get_races (spriden_pidm), 1, 60)

RACES

RACES_DESC

SUBSTR (f_get_races_desc (spriden_pidm), 1, 1200)

RACES_DESC

Description of RACES code(s). Pipe '|' delimited.

RACE_ETHN_CDE

SUBSTR(REPORTSNET.f_get_race_ethn(spriden_pidm), 1, 1)

RACE_ETHN_CDE_DESC

SUBSTR(REPORTSNET.f_get_race_ethn_desc(REPORTSNET.f_get_race_ethn(spriden_pidm)), 1, 30)

RACE_ETHN_CDE_DESC