Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Neu Financial Aid Reporting Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: Z_NEU_SFRRGFE_VW

Description Displays all accounts receivable detail codes for each class by Academic Term. Sourced from Banner AR.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY_DATE   This field specifies the most current date record was created or updated. DATE      
ASSESS_BY_COURSE_IND   Flag to indicate whether or not to assess charges by course. Valid values are Y or N. VARCHAR2(1 CHAR)      
ATTR_CODE_CRSE   Course attribute as defined on the course schedule. VARCHAR2(4 CHAR) STVATTR    
ATTS_CODE   Student's general student attribute code. VARCHAR2(4 CHAR) STVATTS    
COLL_CODE   Student's college code (STVCOLL). VARCHAR2(2 CHAR)      
COPY_IND   Flag to denote that this rule is able to be copied forward to another term for maintenance/data entry sake. Valid values are Y or N. VARCHAR2(1 CHAR)      
CRED_IND   This field is this flag that indicates the hours to use in rule hour determination. When the course waive indicator (SFRRGFE_CRSE_WAIV_IND) is set to 'Y', this flag indicates the hours to use in rule hour determination: 'N' indicates to use waive hours; 'Y' indicates to use bill hours. VARCHAR2(1 CHAR)      
CRSE_OVERLOAD_START_HR   Starting hours for plus per credit charging used in 'flat and plus per credit' charging. NUMBER(11,3)      
CRSE_WAIV_IND   Flag to indicate that this rule can be skipped if the course is marked as being exempt from rule assessment processing (SFRSTCR_WAIV_HR = 0). Valid values are Y and N. VARCHAR2(1 CHAR)      
DETL_CODE   Detail code that the determined charges for this rule will be posted to. VARCHAR2(4 CHAR)      
ENTRY_TYPE   Assessment type. Valid values are 'R' for registration or 'P' for pre-registration assessment. VARCHAR2(1 CHAR)      
FLAT_FEE_AMOUNT   Flat fee amount to charge for students whose course hours are within the flat hour range for the rule. NUMBER(11,3)      
FROM_CRED_HRS   Low end of the course hours range to use when determining if a student qualifies for this rule. NUMBER(10)      
FROM_FLAT_HRS   Low end of the hours range to use when determining if a student qualifies for a flat fee. NUMBER(10)      
LEVL_CODE   Student's level code. VARCHAR2(2 CHAR) STVCOLL    
LEVL_CODE_CRSE   Course level code. VARCHAR2(2 CHAR) STVLEVL    
LFST_PRIM_SEC_CDE   MAJOR PRIMARY: Code value to indicate to select the primary field of study, or any secondary or all. VARCHAR2(2 CHAR)      
MAX_CHARGE   Maximum charge that can be posted when this rule is being applied. NUMBER(11,3)      
MIN_CHARGE   Minimum charge that can be posted when this rule is being applied. NUMBER(11,3)      
PER_CRED_CHARGE   Per hour charge amount to use when calculating per credit charges for this rule. NUMBER(11,3)      
PRIM_SEC_CDE   PRIMARY SECONDARY CURRICULUM: A code value P(primary),S(secondary) or A(any) for choice of curriculum the rules should apply to. VARCHAR2(1 CHAR)      
PROGRAM   Student's general student program. VARCHAR2(63 CHAR) SMRPRLE_PROGRAM    
PTRM_CODE   Part-of-term code for the student's course registration. VARCHAR2(10 CHAR) STVPTRM    
RESD_CODE   Student's residency code. VARCHAR2(1 CHAR) STVRESD    
SEQNO   Unique one up number defined within term code and rule type. This will uniquely identify the rule. NUMBER(10)      
STYP_CODE   Student's general student - student type code. VARCHAR2(1 CHAR) STVSTYP    
TERM_CODE   Registration term. VARCHAR2(10 CHAR)      
TERM_CODE_ADMIT   Student's general student admit term code. VARCHAR2(10 CHAR)      
TO_CRED_HRS   High end of the course hours range to use when determining if a student qualifies for this rule. NUMBER(10)      
TO_FLAT_HRS   This field is the high end of the hours range to use when determining if a student qualifies for a flat fee. These hours also serve as the starting point for additional per credit charges for flat plus per credit processing or for a high credit hour charge. NUMBER(10)      
TO_STUD_HRS   High end of the total course hours range to use when determining if a student qualifies for this rule. NUMBER(10)      
TYPE   Type of assessment rule. Valid values are STUDENT, LEVEL (course level), CAMPUS (course campus) and ATTR (course attribute). VARCHAR2(63 CHAR)      
USER_ID   ID of the user who created or last updated this record. VARCHAR2(10 CHAR)      


Ver: 9.0