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