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 40 Next »

DW Field

Oracle Field/Calc

 

Description (Sample)

Snowflake Import Status

TERM

sfbetrm.sfbetrm_term_code as term,

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

NEEDED

SEMESTER

stvterm.stvterm_desc as semester,

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

NEEDED

STUDENTID

spriden.spriden_id as studentid,

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

NEEDED

SSN

spbpers.spbpers_ssn as ssn,

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

NEEDED

PIDM

spriden.spriden_pidm as pidm,

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

NEEDED

LASTNAME

spriden_last_name as LastName,

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

NEEDED

FIRSTNAME

spriden_first_name as FirstName,

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

NEEDED

MIDINIT

spriden_mi as MidInit,

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

NEEDED

STUDENTNAME

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

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

nvl(spriden_mi, '') as studentname,

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

NEEDED

ADDRESS

spraddr.spraddr_street_line1 as address,

Address at the start of the record’s term

NEEDED

CITY

spraddr.spraddr_city as city,

City at the start of the record’s term

NEEDED

STATE

spraddr.spraddr_stat_code as state,

State at the start of the record’s term

NEEDED

ZIP

spraddr.spraddr_zip as zip,

Zip at the start of the record’s term

NEEDED

PHONE

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

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

NEEDED

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,

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.

NEEDED

PROGRAM

sgbstdn.SGBSTDN_PROGRAM_1

The program of the major

NEEDED

PROG_DEPT

g.SGBSTDN_DEPT_CODE

Department code for student’s program

Has snapshot data on SGASTDN instead of the maintained data on SOACURR.

NEEDED

PROG_GE_PATTERN

g.SGBSTDN_MAJR_CODE_CONC_1

Student’s GE pattern for programs

NEEDED

IN_STATE_IND

NOT NEEDED

Data Steward Disagreement

MAJOR_CODE

SGBSTDN.SGBSTDN_MAJR_CODE_1

Numeric code for the student’s major

NEEDED

MAJOR

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

Description of the MAJOR_CODE

NEEDED

GOAL

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

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

NOT NEEDED

GOAL_INFORMED_EFF_TERM

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

 

The term at which the Informed Goal codes became effective.

NOT NEEDED

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)

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

NEEDED

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)

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

NEEDED

GOAL_INFORMED_CODES

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

 

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

NOT NEEDED

GENDER

SPBPERS.SPBPERS_SEX as gender,

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

NEEDED

BIRTHDATE

spbpers.spbpers_birth_date as birthdate,

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

NEEDED

AGE

f_calculate_age(null,spbpers_birth_date, spbpers_dead_date) as age,

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

NEEDED

AGEATTERM

f_calculate_age(stvterm_end_date,spbpers_birth_date, spbpers_dead_date)

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

NEEDED

CENSUSAGEGROUP

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

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

NOT NEEDED

MARITAL_CODE

SPBPERS.SPBPERS_MRTL_CODE

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

NEEDED

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))

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

NOT NEEDED

NEW_ETHNICITY

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

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

NEEDED - JL OVERRIDE

RACES

SUBSTR (f_get_races (spriden_pidm), 1, 60)

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

NEEDED - JL OVERRIDE

Needs rework to allow 3 character codes.

RACES_DESC

SUBSTR (f_get_races_desc (spriden_pidm), 1, 1200)

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

NEEDED - JL OVERRIDE

RACE_ETHN_CDE

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

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

NEEDED - JL OVERRIDE

RACE_ETHN_CDE_DESC

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

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

NEEDED - JL OVERRIDE

  • 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.