1 of x

Oracle Field/Calc

DW Field

Description (Sample)

Data Type

Field Length

sfbetrm.sfbetrm_term_code as term,

TERM

Fall terms: %10

Spring terms: %20

Summer terms: %30

int

6

stvterm.stvterm_desc as semester,

SEMESTER

Fall 2006

spriden.spriden_id as studentid,

STUDENTID

Banner ID (@12345678)

spbpers.spbpers_ssn as ssn,

SSN

123456789

spriden.spriden_pidm as pidm,

PIDM

Up to 10-digit unique Banner id for student

spriden_last_name as LastName,

LASTNAME

spriden_first_name as FirstName,

FIRSTNAME

spriden_mi as MidInit,

MIDINIT

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

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

nvl(spriden_mi, '') as studentname,

STUDENTNAME

Concatenation of Last, First Middle Initial (Smith, John A)

spraddr.spraddr_street_line1 as address,

ADDRESS

Address at the start of the record’s term

spraddr.spraddr_city as city,

CITY

City at the start of the record’s term

spraddr.spraddr_stat_code as state,

STATE

State at the start of the record’s term

spraddr.spraddr_zip as zip,

ZIP

Zip at the start of the record’s term

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

PHONE

Current phone number

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, such as “Continuing Student”, “Returning Student”.

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

sgbstdn.SGBSTDN_PROGRAM_1

PROGRAM

The Program of the Major

g.SGBSTDN_DEPT_CODE

PROG_DEPT

Department code for student’s program

g.SGBSTDN_MAJR_CODE_CONC_1

PROG_GE_PATTERN

Student’s GE pattern for programs

SGBSTDN.SGBSTDN_MAJR_CODE_1

MAJOR_CODE

Numeric code for the student’s major

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

MAJOR

Description of the Major_Code