DW Field | Oracle Field/Calc DW Field | Description (Sample) |
TERM | sfbetrm.sfbetrm_term_code as term,TERM
| | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | TERM |
|---|
| nopanel | true |
|---|
|
|
SEMESTER | stvterm.stvterm_desc as semester,
| SEMESTER | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | SEMESTER |
|---|
| nopanel | true |
|---|
|
|
STUDENTID | spriden.spriden_id as studentid,
| STUDENTID | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | BANNERID |
|---|
| nopanel | true |
|---|
|
|
SSN | spbpers.spbpers_ssn as ssn,
| SSN | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | SSN |
|---|
| nopanel | true |
|---|
|
|
PIDM | spriden.spriden_pidm as pidm,PIDM
| | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | PIDM |
|---|
| nopanel | true |
|---|
|
|
LASTNAME | spriden_last_name as LastName,
| LASTNAME | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | LASTNAME |
|---|
| nopanel | true |
|---|
|
|
FIRSTNAME | spriden_first_name as FirstName,
| FIRSTNAME | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | FIRSTNAME |
|---|
| nopanel | true |
|---|
|
|
MIDINIT | spriden_mi as MidInit,MIDINIT
| | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | MIDINIT |
|---|
| nopanel | true |
|---|
|
|
STUDENTNAME | nvl(spriden_last_name, '') || ', ' ||
nvl(spriden_first_name, '') || ' ' ||
nvl(spriden_mi, '') as studentname,
| STUDENTNAME | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | STUDENTNAME |
|---|
| nopanel | true |
|---|
|
|
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 | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | PHONE |
|---|
| nopanel | true |
|---|
|
|
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_1
| PROGRAM | 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 |
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. |
GENDER | SPBPERS.SPBPERS_SEX as gender,
| GENDER | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | LEGALSEX |
|---|
| nopanel | true |
|---|
|
|
BIRTHDATE | spbpers.spbpers_birth_date as birthdate,
| BIRTHDATE | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | BIRTHDATE |
|---|
| nopanel | true |
|---|
|
|
AGE | f_calculate_age(null,spbpers_birth_date, spbpers_dead_date) as age,AGE
| | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | AGE |
|---|
| nopanel | true |
|---|
|
|
AGEATTERM | f_calculate_age(stvterm_end_date,spbpers_birth_date, spbpers_dead_date)
| AGEATTERM | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | AGEATTERM |
|---|
| nopanel | true |
|---|
|
|
CENSUSAGEGROUP | substr(baninst1.cos_fw_census_age_categ(sfbetrm_term_code,spbpers_birth_date,spbpers_dead_date),1,18)
| CENSUSAGEGROUP | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | CENSUSAGEGROUP |
|---|
| nopanel | true |
|---|
|
|
MARITAL_CODE | SPBPERS.SPBPERS_MRTL_CODE
| MARITAL_CODE | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | MARITALSTATUS |
|---|
| nopanel | true |
|---|
|
|
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 | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | DEPRECATED |
|---|
| nopanel | true |
|---|
|
|
NEW_ETHNICITY | decode(spbpers_ethn_cde, null, null, 1, 'Not Hispanic', 2, 'Hispanic')NEW_ETHNICITY
| | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | HISPANICLATINO |
|---|
| nopanel | true |
|---|
|
|
RACES | SUBSTR (f_get_races (spriden_pidm), 1, 60)
| RACES | | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | RACEETHNICITY |
|---|
| nopanel | true |
|---|
|
|
RACES_DESC | SUBSTR (f_get_races_desc (spriden_pidm), 1, 1200)RACES_DESC
| Description of RACES code(s). Pipe '|' delimited. |
RACE_ETHN_CDE | Anchor |
|---|
| race_ethn_cde |
|---|
| race_ethn_cde |
|---|
|
| SUBSTR(REPORTSNET.f_get_race_ethn(spriden_pidm), 1, 1)
| | Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | RACEETHNICITYDATAMART |
|---|
| nopanel | true |
|---|
|
|
RACE_ETHN_CDE_DESC | Anchor |
|---|
| race_ethn_cde_desc |
|---|
| race_ethn_cde |
|---|
| | Insert excerpt |
|---|
| Common Definitions | Common Definitions | | name | RACEETHNICITYDATAMART |
|---|
| nopanel | true |
|---|
| _desc |
|
| SUBSTR(REPORTSNET.f_get_race_ethn_desc(REPORTSNET.f_get_race_ethn(spriden_pidm)), 1, 30)
RACE_ETHN_CDE_DESC | Anchor |
|---|
| race_ethn_cde_desc | race_ethn_cde_desc| Insert excerpt |
|---|
| Common Definitions |
|---|
| Common Definitions |
|---|
| name | RACEETHNICITYDATAMARTDESCRIPTION |
|---|
| nopanel | true |
|---|
|
|