Oracle Field/Calc
| DW Field | Description (Sample) | Data Type | Field Length |
| HIGHSCHOOL |
|
|
|
| ENG251_ELIG | Score on most recent English 251 placement test. 0 to 6.0. |
|
|
SELECT MAX (sortest_test_date) FROM sortest WHERE sortest_pidm = spriden.spriden_pidm AND sortest_tesc_code = 'LE') | ENG_TEST_DATE | Test date of most recent English 251 placement test
|
|
|
f_test_score_fnc (spriden_pidm,'LM','HIGH',null) | MATHPLACE | Score on most recent Math placement test. 0 to 6.0. |
|
|
SELECT MAX (sortest_test_date) FROM sortest WHERE sortest_pidm = spriden.spriden_pidm AND sortest_tesc_code = 'LM') | MATH_TEST_DATE | Test date of most recent Math placement test |
|
|
f_test_score_fnc (spriden_pidm,'LR','HIGH',null) | READ_LEVEL | Score on most recent Reading placement test. 0 to 6.0. |
|
|
SELECT MAX (sortest_test_date) FROM sortest WHERE sortest_pidm = spriden.spriden_pidm AND sortest_tesc_code = 'LR') | READ_TEST_DATE | Test date of most recent Reading placement test |
|
|
f_test_score_fnc (spriden_pidm,'ESL1','HIGH',null) | CELSA_ESL | Score on CELSA ESL test |
|
|
SELECT MAX (sortest_test_date) FROM sortest WHERE sortest_pidm = spriden.spriden_pidm AND sortest_tesc_code = 'ESL1') | ESL_TEST_DATE | Test date of most recent ESL test |
|
|
f_test_score_fnc (spriden.spriden_pidm, 'LESL', 'HIGH', NULL) | ESL_PLACEMENT | ESL Placement Level |
|
|
baninst1.cos_f_get_lgpa(spriden_pidm, 'UG','O') | OVERALL_GPA | Float – from all terms attended. Updated during semester Includes transfer courses. |
|
|
baninst1.cos_f_get_lhrs_ern(spriden_pidm, 'UG','O') | OVERALL_HRS_EARNED | Float – Units earned with grades A to D, P, or CR. This includes transferred units into COS and units earned at COS. |
|
|
baninst1.cos_f_get_lhrs_gpa(spriden_pidm, 'UG','O') | OVERALL_HRS_PASSED | Float – Units earned with grades A to F. This includes transferred units into COS and units earned at COS. Used for GPA calculation. |
|
|
baninst1.cos_f_get_lhrs_ern(spriden_pidm, 'UG','T') | TRANSFER_IN_UNITS | Units transferred from outside institution |
|
|
baninst1.cos_f_get_lgpa(spriden_pidm, 'UG','T') | TRANSFER_IN_GPA | GPA of units transferred from outside institution |
|
|
baninst1.cos_f_get_tgpa(spriden_pidm, sfbetrm_term_code, 'UG','O') as term_gpa, | TERM_GPA | Float – GPA for this term. Includes transfer units. |
|
|
baninst1.cos_f_get_tenrl(spriden_pidm, sfbetrm_term_code) | TERM_HOURS | Float – Hours enrolled for this term (R% registration). Same as units. [Note: used in StudentFundType view] |
|
|
baninst1.cos_f_get_tpass(spriden_pidm, sfbetrm_term_code) | TERM_PASSED | Float – Units passed for this term. Changed to look at current grade in Academic History instead of initial grade in registration. Includes but not limited to (has numbers too but excluded them here): A, A+, A-, B, B+, B-, C, C+, CR, D, D+, D-, P NOTE: There is no C-, we do not give out this grade at this time.
See following internal sql (oracle) – maybe mod term_passed_abc to use this instead:
SELECT DISTINCT shrgrde_code FROM shrgrde WHERE shrgrde_passed_ind = 'Y' and regexp_like(shrgrde_code, '\D') ORDER BY 1; |
|
|
baninst1.cos_f_get_tpass_abc(spriden_pidm, sfbetrm_term_code) | TERM_PASSED_ABC | Float – Units passed for courses taken this term with grade of A, B, or C (including + and – grades) |
|
|
F_GET_ACCUM_TUNITS_ATT (spriden_pidm,'000000', sfbetrm_term_code, 'UG')
| TERM_ACCUM_UNITS_ATT | Accumulative units attempted from the earliest term available in Banner to the term of this record. Same as Units Attempted on SWIASTD screen (except this is an accumulation for each term). This includes both Institutional and Transfer. |
|
|
F_GET_ACCUM_TUNITS_PASSED (spriden_pidm,'000000', sfbetrm_term_code, 'UG') | TERM_ACCUM_UNITS_PASSED | Accumulative units passed from the earliest term available in Banner to the term of this record. Same as Units Attempted on SWIASTD screen (except this is an accumulation for each term). This includes both Institutional and Transfer. |
|
|
reportsnet.F_GET_ACCUM_TGPA (spriden_pidm, '000000', sfbetrm_term_code, 'UG', 'I') | TERM_ACCUM_GPA | Accumulative GPA from the earliest term available in Banner to the term of this record. |
|
|
reportsnet.f_get_univ_units (spriden_pidm, 'DA', sfbetrm_term_code) | COS_DEGREE_UNITS_ATT | Units attempted for degree for the term on this record at COS. This does NOT include Credit/No Credit courses. |
|
|
reportsnet.f_get_univ_qual_pts (spriden_pidm, 'DA', sfbetrm_term_code) | COS_DEGREE_PTS | Grade points for degree for the term on this record at COS |
|
|
reportsnet.f_get_univ_units_passed (spriden_pidm, 'DA', sfbetrm_term_code) | COS_DEGREE_UNITS_PASSED | Units passed for degree for the term on this record at COS. This does include Credit/No Credit courses. |
|
|
reportsnet.f_get_univ_qual_pts (spriden_pidm, 'DA', sfbetrm_term_code) / reportsnet.f_get_univ_units (spriden_pidm, 'DA',sfbetrm_term_code) | COS_DEGREE_GPA | Grade Point Average for degree for the term on this record at COS |
|
|
reportsnet.f_get_accum_univ_qual_pts (spriden_pidm, 'DA', '000000', sfbetrm_term_code) / reportsnet.f_get_accum_univ_units (spriden_pidm, 'DA', '000000', sfbetrm_term_code) | TERM_ACCUM_COS_DEGREE_GPA | Accumulative GPA for degree at COS from the earliest term available in Banner to the term of this record |
|
|
reportsnet.f_get_univ_units (spriden_pidm, 'TCSU', sfbetrm_term_code) | CSU_DEGREE_UNITS_ATT | Units attempted for degree for the term on this record transferable to a California State University |
|
|
reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TCSU', sfbetrm_term_code) | CSU_DEGREE_PTS | Grade points for degree for the term on this record transferable to a California State University |
|
|
reportsnet.f_get_univ_units_passed (spriden_pidm,'TCSU',sfbetrm_term_code) | CSU_DEGREE_UNITS_PASSED | Units passed for degree for the term on this record transferable to a California State University |
|
|
reportsnet.f_get_accum_univ_units (spriden_pidm, 'TCSU', '000000', sfbetrm_term_code) | TERM_ACCUM_CSU_DEGREE_ UNITS_PASSED | Accumulative units passed for degree from the earliest term available in Banner to the term of this record transferable to a California State University |
|
|
reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TCSU', sfbetrm_term_code) / reportsnet.f_get_univ_units (spriden_pidm, 'TCSU', sfbetrm_term_code) | CSU_DEGREE_GPA | Grade Point Average for degree for the term on this record transferable to a California State University |
|
|
reportsnet.f_get_accum_univ_qual_pts (spriden_pidm,'TCSU', '000000', sfbetrm_term_code) / reportsnet.f_get_accum_univ_units (spriden_pidm, 'TCSU', '000000', sfbetrm_term_code) | TERM_ACCUM_CSU_DEGREE_GPA | Accumulative GPA for a CSU degree from the earliest term available in Banner to the term of this record |
|
|
reportsnet.f_get_univ_units (spriden_pidm, 'TUC', sfbetrm_term_code) | UC_DEGREE_UNITS_ATT | Units attempted for degree for the term on this record transferable to a University of California |
|
|
reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TUC', sfbetrm_term_code) | UC_DEGREE_PTS | Grade points for degree for the term on this record transferable to a University of California |
|
|
reportsnet.f_get_univ_units_passed (spriden_pidm, 'TUC', sfbetrm_term_code) | UC_DEGREE_UNITS_PASSED | Units passed for degree for the term on this record transferable to a University of California |
|
|
reportsnet.f_get_accum_univ_units (spriden_pidm, 'TUC', '000000', sfbetrm_term_code) | TERM_ACCUM_UC_DEGREE_ UNITS_PASSED | Accumulative units passed for degree from the earliest term available in Banner to the term of this record transferable to a University of California |
|
|
reportsnet.f_get_univ_qual_pts (spriden_pidm, 'TUC', sfbetrm_term_code) / reportsnet.f_get_univ_units_passed (spriden_pidm, 'TUC', sfbetrm_term_code) | UC_DEGREE_GPA | Grade Point Average for degree for the term on this record transferable to a University of California |
|
|
reportsnet.f_get_accum_univ_qual_pts (spriden_pidm, 'TUC', '000000', sfbetrm_term_code) / reportsnet.f_get_accum_univ_units (spriden_pidm, 'TUC', '000000', sfbetrm_term_code) | TERM_ACCUM_UC_DEGREE_GPA | Accumulative GPA for a UC degree from the earliest term available in Banner to the term of this record |
|
|
baninst1.cos_f_univ_units(spriden.spriden_pidm, 'DA') | OVERALL_COS_DEGREE_ UNITS_ATT | Total units attempted for degree (for all terms including terms older than those in the warehouse) at COS. This does NOT include Credit/No Credit courses. |
|
|
baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'DA') | OVERALL_COS_DEGREE_PTS | Total grade points for degree (for all terms including terms older than those in the warehouse) at COS |
|
|
baninst1.cos_f_univ_passed(spriden.spriden_pidm, 'DA') | OVERALL_COS_DEGREE_ UNITS_PASSED | Total units passed for degree (for all terms including terms older than those in the warehouse) at COS. This does include Credit/No Credit courses. |
|
|
to_char(baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'DA') / nullif(baninst1.cos_f_univ_units(spriden.spriden_pidm, 'DA'),0),'99.99') | OVERALL_COS_DEGREE_ GPA | Grade Point Average for degree (for all terms including terms older than those in the warehouse)at COS |
|
|
baninst1.cos_f_univ_units(spriden.spriden_pidm, 'TCSU') | OVERALL_CSU_DEGREE_ UNITS_ATT | Total units attempted for degree (for all terms including terms older than those in the warehouse) transferable to a California State University |
|
|
baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'TCSU') | OVERALL_CSU_DEGREE_PTS | Total grade points for degree (for all terms including terms older than those in the warehouse)transferable to a California State University |
|
|
baninst1.cos_f_univ_passed(spriden.spriden_pidm, 'TCSU') | OVERALL_CSU_DEGREE_ UNITS_PASSED | Total units passed for degree (for all terms including terms older than those in the warehouse) transferable to a California State University |
|
|
to_char(baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'TCSU') / nullif(baninst1.cos_f_univ_units(spriden.spriden_pidm, 'TCSU'),0),'99.99') | OVERALL_CSU_DEGREE_GPA | Grade Point Average for degree (for all terms including terms older than those in the warehouse) transferable to a California State University |
|
|
baninst1.cos_f_univ_units(spriden.spriden_pidm, 'TUC') | OVERALL_UC_DEGREE_ UNITS_ATT | Total units attempted for degree (for all terms including terms older than those in the warehouse) transferable to a University of California |
|
|
baninst1.cos_f_univ_qual_pts(spriden.spriden_pidm, 'TUC') | OVERALL_UC_DEGREE_PTS | Total grade points for degree (for all terms including terms older than those in the warehouse) transferable to a University of California |
|
|
baninst1.cos_f_univ_passed(spriden.spriden_pidm, 'TUC') | OVERALL_UC_DEGREE_ UNITS_PASSED | Total units passed for degree (for all terms including terms older than those in the warehouse) transferable to a University of California |
|
|
baninst1.cos_f_univ_qual_pts (spriden_pidm, 'TUC') / baninst1.cos_f_univ_units (spriden_pidm, 'TUC') | OVERALL_UC_DEGREE_GPA | Grade Point Average for degree (for all terms including terms older than those in the warehouse) transferable to a University of California |
|
|
sgbeops.SGBEOPS_EOPS_CODE | EOPS | Code From STVEOPS (EOPS program). The ‘E’ value means the Student is part of the EOPS program during the term on this record. At the end of the term, the code may change to something other than C. So, they are in EOPS if this code is not null and not ‘C%’. E: EOPS-Elig next term G: EOPS-Successfully Comp. Goal P: EOPS-failed Cont/CARE-New CARE C: EOPS-Chosen EOPS/CARE-w/oWaiv CE: Chose not to be in EOPS S: EOPS-Completed 6 Sem. U: EOPS-Comp 70 Units, end elig. X: EOPS-Unknown/Unreported B: CARE-waiver CalWORKS/TANF/AFDC N: CARE-not served by CARE pgm L: CARE-Obsolete Code/Do Not Use |
|
|
substr(f_get_student_is_disa(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,1) | DRC | Student is disabled (Y). This value can only be determined once Sandy Gaither has entered this student as a DRC student in Banner. |
|
|
substr(f_get_disa_codes(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,10) | DRC_CODES | List of disability codes (1 character each, no delimiter, up to 10 codes) |
|
|
SGBUSER.SGBUSER_SUDA_CODE | VATEA | Vocational And Technological Education Act (A/N) A: student in vocational program N: in vocational course, but not vocational major |
|
|
SUBSTR(COS_GENERAL_RESTR.F_IS_PUENTE_BY_PIDM(spriden.SPRIDEN_PIDM), 1, 1) | PUENTE | Student is part of Puente program (Y or null). BANNER does not store this information per term. The nightly job updates this column for all rows in Student to the current Puente status. |
|
|
substr(f_get_cohort_codes(spriden.SPRIDEN_PIDM, sfbetrm.SFBETRM_TERM_CODE),1,10) | COHORT_CODES | Currently limited to codes A through E |
|
|
select count(sfrstcr.SFRSTCR_CRN) from sfrstcr where sfrstcr.sfrstcr_term_code = sfbetrm.SFBETRM_TERM_CODE AND sfrstcr.sfrstcr_pidm = SFBETRM.SFBETRM_PIDM AND sfrstcr.SFRSTCR_RSTS_CODE like 'R%' GROUP BY sfrstcr.SFRSTCR_PIDM | REGISTERED_CLASSES | Number of classes for which the student has registered |
|
|
f_get_campuses (spriden.spriden_pidm, sfbetrm.sfbetrm_term_code), 1, 100) | CAMPUSES | Pipe delimited string of 3-char campus codes for all campuses at which the student is enrolled in courses. |
|
|
nvl(greatest(sfbetrm.sfbetrm_activity_date, spraddr.spraddr_activity_date, spriden.spriden_activity_date, sprtele.sprtele_activity_date, spbpers.spbpers_activity_date), sfbetrm.sfbetrm_activity_date) as activity_date | ACTIVITY_DATE | Datetime – most recent activity date from all tables involved (sfbterm, spraddr, spriden, sprtele, spbpers, sfbetrm). Essentially this is the last time that any information about the student was changed. |
|
|
substr(f_get_cast_code(spriden.spriden_pidm),1,2) as CAST_CODE,_cast_code | CAST_CODE | Combined Academic Standing Code for the tern of this record. Note that this code will not be correct until grades have been entered at the end of the term: 00: Good Standing 03: Progress Probation 04: Academic Probation 05: Both Prog & Acad Probation 06: Progress Dismissal 07: Academic Dismissal 08: Both Acad & Prog Dismiss |
|
|
substr(BANINST1.cos_f_get_email(spriden.SPRIDEN_PIDM),1,90) as EMAIL | The Student’s email address |
|
| |
substr(f_get_visa_type(spriden.SPRIDEN_PIDM, stvterm.STVTERM_START_DATE, stvterm.STVTERM_END_DATE),1,2) | VISA_TYPE | see VISA type code in Appendix |
|
|
substr(f_get_calworks_code(spriden.SPRIDEN_ID, sfbetrm.sfbetrm_term_code),1,1) | CALWORKS | 2: CALWORKS self referral participation 3: CALWORKS county referral participation Null if not participating in CALWORKS |
|
|
substr(f_get_veteran_status(spriden.SPRIDEN_PIDM, sfbetrm.sfbetrm_term_code),1,1) | VETERAN | ‘Y’ if the student was a veteran for the term of this record. Null otherwise. |
|
|
cast(cosbwckrgtm.cos_f_calc_reg_appt( SPRIDEN.SPRIDEN_PIDM, cos_f_get_next_term()) as date) | REGIS_APPT | The date of the student’s next registration appointment |
|
|
select s.SGRSPRT_SPST_CODE from sgrsprt s where s.sgrsprt_term_code = term and s.SGRSPRT_PIDM = pidm and s.SGRSPRT_SPST_CODE = 'A'; | ATHLETE | ‘Y’ if the student is an athlete for the term of this record (at least one record in SGRSPRT where SGRSPRT_SPST_CODE = ‘A’) |
|
|
select 'Y' from sfrsrpo s where s.sfrsrpo_term_code = term and s.SFRSRPO_PIDM = pidm and s.SFRSRPO_ROVR_CODE = 'FYE' | FIRST_YR_EXPERIENCE | ‘Y’ if the student is in First Year Experience for the term of this record. |
|
|
select 'Y' from sfrsrpo s where s.sfrsrpo_term_code = term and s.SFRSRPO_PIDM = pidm and s.SFRSRPO_ROVR_CODE = 'SYE' | SECOND_YR_EXPERIENCE | ‘Y’ if the student is in Second Year Experience for the term of this record. |
|
|
select decode (s.sgrsact_actc_code, 'wia', 'y', 'n') from saturn.sgrsact s where s.sgrsact_term_code = sfbetrm_term_code and s.sgrsact_actc_code = 'wia' and s.sgrsact_pidm = spriden.spriden_pidm | WIA | ‘Y’ if the student is WIA (Workforce Investment Act) for the term of this record. |
|
|
decode(FINANCIAL_AID1_NON_BOGG.AWARD_PAID_TERM, null, 'N', 0, 'N', 'Y') | PELL | ‘Y” if the Student was awarded PELL for the term of this record. ‘N’ otherwise. |
|
|
RCRAPP2_MODEL_CDE when RCRAPP2_INFC_CODE = 'EDE'
| DEPENDENT | Dependency status from the FAFSA, if the student submitted a FAFSA. This is the status for the aid year in which this record’s term falls (example: 200810 is in the 0708 aid year, so this value will be the same for 200810, 200820, 200830): I: Independent D: Dependent Null: student did not submit a FAFSA OR they did not supply a dependency status |
|
|
(BANINST1.COS_GENERAL.F_MAX_SIGNED_EDPLAN_DATE (s.SPRIDEN_PIDM, f.sfbetrm_term_code)) AS Ed_Plan_Date | ED_PLAN_DATE | Date that the student met with a counselor to create an educational plan. If null, no meeting took place and no plan was created. NOTE: This does NOT show the most recent date just that a meeting took place at one time. This is also looking at an older table so the data is inaccurate. |
|
|
SGBSTDN.SGBSTDN_EDLV_CODE | ED_LEVEL_CODE | A three position alphanumeric field which indicate the highest level of the education that the student completed |
|
|
SUBSTR (REPORTSNET.F_GET_STUDENT_IS_FIRST_GEN (SPRIDEN.SPRIDEN_PIDM, sfbetrm.sfbetrm_term_code), 1, 1 ) | FIRST_GEN | ‘Y’ / ‘N’ if Student is a first-generation college student (based on 2 Parent Education Level questions on CCCApply). |
|
|
REPORTSNET.F_GET_STUDENT_ORIENTATION_DATE (SPRIDEN.SPRIDEN_PIDM) | ORIENTATION | The date the student attended orientation. If null, we have no record of the student attending orientation. |
|
|
General
Content
Integrations
0 Comments