| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | This field contains the most current date the record was added or changed. Source field: SSRFEES_ACTIVITY_DATE |
| Admit_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | Student admit term. Source field: SSRFEES_TERM_CODE_ADMIT. |
| Amount Indexed - no
Format - Number
May be Null? Y | The amount in US dollars of the fee. Source field: SSRFEES_AMOUNT. |
| Course_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | Concatenation of the subject area + course number of the course section for which fees are set. |
| Course_Num
Indexed - no
Format - Varchar2(5 char)
May be Null? Y | Course number of the course section for which fees are set. Source: SSBSECT_CRSE_NUMB. |
| Crse_Fees_Seq_Num Indexed - no
Format - Number
May be Null? Y | Internal sequence number for making a unique index. Source field: SSRFEES_SEQ_NO |
| Crse_Ref_Num Indexed - no
Format - Varchar2(5)
May be Null? Y | This field defines the course reference number to which the course section fee applies. Source field: SSRFEES_CRN. |
| Curric_Campus Indexed - no
Format - Varchar2(3)
May be Null? Y | Student curriculum campus code. Source field: SSRFEES_CAMP_CODE. |
| Curric_Degree Indexed - no
Format - Varchar2(6)
May be Null? Y | Student curriculum degree code. Source field: SSRFEES_DEGC_CODE. |
| Curric_Dept Indexed - no
Format - Varchar2(4)
May be Null? Y | The department code associated with the major field of study. Source field: SSRFEES_DEPT_CODE. |
| Curric_Division Indexed - no
Format - Varchar2(2)
May be Null? Y | Student curriculum division code. Source field: SSRFEES_COLL_CODE. |
| Curric_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | Student curriculum level code. Source field: SSRFEES_LEVL_CODE_STDN. |
| Curric_Maj_Min Indexed - no
Format - Varchar2(4)
May be Null? Y | The major code for the field of study. Source field: SSRFEES_MAJR_CODE. |
| Curric_Maj_Min_Type Indexed - no
Format - Varchar2(15)
May be Null? Y | The field of study type, i.e., Major, Minor, Concentration. Source field: SSRFEES_LFST_CODE. |
| Curric_Program Indexed - no
Format - Varchar2(12)
May be Null? Y | Student curriculum program code. Source field: SSRFEES_PROGRAM. |
| Curr_Rate Indexed - no
Format - Varchar2(5)
May be Null? Y | The fee assessment rate code on the curriculum record. Source field: SSRFEES_RATE_CODE_CURRIC. |
| Curr_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | The student type code on the curriculum record. Source field: SSRFEED_STYP_CODE_CURRIC. |
| Detail_Code Indexed - no
Format - Varchar2(4)
May be Null? Y | This field defines the billing detail code of the specific fee(s). Source field: SSRFEES_DETL_CODE. Source validation table: TBBDETC. Warehouse validation table: DETAIL_CODE. |
| Fee_Ind Indexed - no
Format - Varchar2(1)
May be Null? Y | This field is used to specify whether the course fee will be assessed on a per-credit hour basis (C) or on a flat basis (F). Source field: SSRFEES_FEE_IND. |
| Fee_Ind_Num Indexed - no
Format - Number
May be Null? Y | This field is used to convert the fee indicator of F - flat or C - per credit to a 1 or 0. "F" is converted to a "1" and "C" is converted to a "0". Source field: SSRFEES_FEE_IND_IND |
| Fee_Level Indexed - no
Format - Varchar2(2)
May be Null? Y | This field identifies the level code that the fee is defined for. Source field: SSRFEES_LEVL_CODE. |
| Fee_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | Identifies the type of fee, used in fee assessment. Source field: SSRFEES_FTYP_CODE. Source validation table: STVFTYP. |
| Pri_Sec Indexed - no
Format - Varchar2(1)
May be Null? Y | A code value P(primary),S(secondary) or A(any) incidating which curriculum the rules should apply to. Source field: SSRFEES_PRIM_SEC_CDE. |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | Date this record was last refreshed in the Data Warehouse |
| Section_ID Indexed - no
Format - Varchar2(12)
May be Null? Y | The section ID (subject area + course number + section number) of the section for which fees are set. |
tr>Section_Num Indexed - no
Format - Varchar2(3)
May be Null? Y | The section number of the section for which fees are set. Source: SSBSECT_SEQ_NUMB |
tr>Subject Indexed - no
Format - Varchar2(4)
May be Null? Y | The subject area of the section for which fees are set. Source: SSBSECT_SUBJ_CODE |
| St_Attribute Indexed - no
Format - Varchar2(4)
May be Null? Y | Attribute code on the general student record. Source field: SSRFEES_ATTS_CODE. Source validation table: STVATTS. Warehouse validation table: V_STDNT_ATTR. |
| St_Class Indexed - no
Format - Varchar2(2)
May be Null? Y | Class code associated with the general student record and primary curriculum level code. Source field: SSRFEES_CLAS_CODE. Source validation table: STVCLAS. Warehouse validation table: V_CLASS. |
| St_Cohort Indexed - no
Format - Varchar2(10)
May be Null? Y | Cohort code on the general student record. Source field: SSRFEES_CHRT_CODE. Source validation table: STVCHRT. Warehouse validation table: V_COHORT. |
| St_Crse_Fees_Pk Indexed - yes
Format - Varchar2(25)
May be Null? N | Primary key based on Term, CRN, Detail Code, Fee Type Code, and Level |
| St_Rate Indexed - no
Format - Varchar2(5)
May be Null? Y | The fee assessment rate code on the general learner record. Source field: SSRFEES_RATE_CODE. Source validation table: STVRATE. Warehouse validation table: V_RATE. |
| St_Residency Indexed - no
Format - Varchar2(1)
May be Null? Y | The Vet School residency status of the student for the effective term. Source field: SSRFEES_RESD_CODE. Source validation table: STVRESD. Warehouse validation table: V_RESIDENCY. |
| St_Type Indexed - no
Format - Varchar2(1)
May be Null? Y | The type of student on the general student record. Source field: SSRFEES_STYP_CODE. Source validation table: STVSTYP. Warehouse validation table: V_STDNT_TYPE. |
| St_Visa Indexed - no
Format - Varchar2(2)
May be Null? Y | Visa code for the person. Source field: SSRFEES_VTYP_CODE. Source validation table: STVVTYP. Warehouse validation table: V_VISA. |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | This field defines the term to which the course section fee applies. Source field: SSRFEES_TERM_CODE. |
