Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

C) STDNT_CAR_TERM is created when the student is term activated.  A student MUST be term activated in order to enroll in class. There is a one-to-many relationship between STDNT_CAR_TERM and STDNT_ENRL; for each term a student may have one or more classes. STDNT_CAR_TERM contains the following keys:

 

Field                                               Description

EMPLID                                          - Empl ID
ACAD_CAREER                            - Academic Career
INSTITUTION                                - Academic Institution
STRM                                            - Term
REG_CARD_DATE                       - Registration Card Date
WITHDRAW_CODE                     - Withdrawal \ Cancel
WITHDRAW_REASON                - Withdrawal \ Cancel Reason
WITHDRAW_DATE                      - Withdrawal \ Cancel Date
LAST_DATE_ATTENDED            - Last Date of Attendance
STDNT_CAR_NBR                      - Student Career Nbr
ACAD_PROG_PRIMARY            - Primary Academic Program
ACAD_LOAD_APPR                   - Approved Academic Load
ACADEMIC_LOAD                      - Academic Load
FA_LOAD                                    - Financial Aid Load
ACAD_LEVEL_PROJ                 - Academic Level - Projected
ACAD_LEVEL_BOT                   - Academic Level - Term Start
ACAD_LEVEL_EOT                   - Academic Level - Term End
NSLDS_LOAN_YEAR               - NSLDS Loan Year
OVRD_ACAD_LVL_PROJ         - Override Projected Level
OVRD_ACAD_LVL_ALL            - Override All Academic Levels
ELIG_TO_ENROLL                    - Eligible to Enroll
OVRD_MAX_UNITS                  - Override Maximum Units
MAX_TOTAL_UNIT                   - Max Total Units
MAX_NOGPA_UNIT                  - Max No GPA Units
MAX_AUDIT_UNIT                    - Max Audit Units
MAX_WAIT_UNIT                      - Max Wait List Units
MIN_TOTAL_UNIT                     -  Min Total Units
OVRD_BILL_UNITS                  - Override Billing Units
PROJ_BILL_UNT                      - Projected Bill Units
UNT_TAKEN_PRGRSS            - Units Taken for Progress
UNT_PASSD_PRGRSS            - Units Passed for Progress
UNT_TAKEN_GPA                    - Units Taken Toward GPA
UNT_PASSD_GPA                    - Units Passed Toward GPA
UNT_TAKEN_NOGPA              - Units Taken Not Toward GPA
UNT_PASSD_NOGPA               - Units Passed Not Toward GPA
UNT_INPROG_GPA                 - Units In Progress - GPA
UNT_INPROG_NOGPA           - Unit In Progress - Not for GPA
GRADE_POINTS                     - Grade Points
UNT_AUDIT                             - Units Audited
UNT_TRNSFR                         - Units Transferred
TRF_TAKEN_GPA                   - Transfer Taken for GPA
TRF_TAKEN_NOGPA              - Transfer Taken Not for GPA
TRF_PASSED_GPA                 - Transfer Passed for GPA
TRF_PASSED_NOGPA            - Transfer Passed Not for GPA
TRF_GRADE_POINTS            - Transfer Grade Points
UNT_TEST_CREDIT               - Units from Test Credit
UNT_OTHER                          - Units from Other Credit
UNT_TAKEN_FA                     - Fin Aid Progress Units Taken
UNT_PASSD_FA                    - Fin Aid Progress Units Passed
UNT_TAKEN_FA_GPA           - FA Units Taken Toward GPA
GRADE_POINTS_FA             - Financial Aid Grade Points
UNT_TERM_TOT                   - Total Term Units
RESET_CUM_STATS            - Reset Cum Stats at Term Start
TOT_TAKEN_PRGRSS         - Total Taken for Progress
TOT_PASSD_PRGRSS         - Total Passed for Progress
TOT_TAKEN_GPA                  - Total Taken Toward GPA
TOT_PASSD_GPA                 - Total Passed Toward GPA
TOT_TAKEN_NOGPA            - Total Taken Not Toward GPA
TOT_PASSD_NOGPA            - Total Passed Not Toward GPA
TOT_INPROG_GPA               - Total In Progress - GPA
TOT_INPROG_NOGPA          - Total In Progress -Not for GPA
TOT_AUDIT                            - Total Audited
TOT_TRNSFR                        - Total Transferred
TOT_TEST_CREDIT              - Total From Test Credit
TOT_OTHER                          - Total from Other Credit
TOT_CUMULATIVE               - Total Cumulative Units
TOT_GRADE_POINTS           - Total Grade Points
TOT_TAKEN_FA                     - Total Fin Aid Units Taken
TOT_PASSD_FA                     - Total Fin Aid Units Passed
TOT_TAKEN_FA_GPA            - Total Fin Aid Taken Toward GPA
TOT_GRD_POINTS_FA          - Total Fin Aid Grade Points
FORM_OF_STUDY                 - Form of Study
TERM_TYPE                           - Term Unit Type
CLASS_RANK_NBR               - Class Rank Nbr
CLASS_RANK_TOT               - Class Rank Total
SEL_GROUP                          - Tuition Group
TUIT_CALC_REQ                   - Tuition Calc Required
TUIT_CALC_DTTM                 - Tuit Calc Date Time
FA_STATS_CALC_REQ         - FA Stats Calculation Required
FA_STATS_CALC_DTTM        - FA Stats Calc Date Time
FA_ELIGIBILITY                      - Program Eligibility Flag
BILLING_CAREER                  - Billing Career
UNIT_MULTIPLIER                 - Unit Multiplier
ACAD_YEAR                           - Academic Year
ACAD_GROUP_ADVIS          - Academic Group of Advisor
CUR_RESIDENT_TERMS      - Current In Residence Terms
TRF_RESIDENT_TERMS       - Transfer In Residence Terms
CUM_RESIDENT_TERMS      - Cumulative In Residence Terms
REFUND_PCT                        - Refund Percentage
REFUND_SCHEME                - Refund Scheme
PRO_RATA_ELIGIBLE            - Pro-Rata Eligible
FULLY_ENRL_DT                    - Fully Enrolled Date
ENRL_ON_TRANS_DT           - Show Enrollment on Transcript
STATS_ON_TRANS_DT          - Show Statistics on Transcript
FULLY_GRADED_DT              - Fully Graded Date
EXT_ORG_ID                          - External Org ID
COUNTRY                               - Country
STUDY_AGREEMENT            - Study Agreement
START_DATE                          - Start Date for Gen Standing PO
END_DATE                              - End Date
MAX_CRSE_COUNT               - Max Total Courses
CUR_GPA                                - Current GPA
CUM_GPA                               - Cumulative GPA
REGISTERED                         - Registered
OVRD_TUIT_GROUP             - Override Tuition Group
OVRD_WDRW_SCHED         - Override Withdrawal Schedule
TUITION_RES_TERMS         - Tuition Residency
OVRD_INIT_ADD_FEE          - Override Initial Add Fees
OVRD_INIT_ENR_FEE          - Override Initial Enroll Fee
TC_UNITS_ADJUST              - TC Units Adjustment
LOCK_IN_AMT                       - Lock In Amount
LOCK_IN_DT                         - Lock In Date
ACAD_CAREER_FIRST         - First Time in Career
ACADEMIC_LOAD_DT           - Academic Load Change Date
UNTPRG_CHG_NSLC_DT      - Unit Progrss Changed Date NSC
SSR_ACTIVATION_DT           - Term Activation Date
SSR_TRF_CUR_GPA             - Transfer Credit Current GPA
SSR_COMB_CUR_GPA         - Combined Current GPA
SSR_CUM_EN_GPA              - Enrollment Cumulative GPA
SSR_TOT_EN_GRDPTS       - Enrollment Grade Points
SSR_TOT_EN_TKNGPA        - Units Taken Toward GPA
SSR_CUM_TR_GPA              - Transfer Credit Cumulative GPA
SSR_TOT_TR_GRDPTS       - Transfer Credit Grade Points
SSR_TOT_TR_TKNGPA        - Units Taken Toward GPA


A student must be active in a program in order to be term activated. That process creates the STDNT_CAR_TERM record and a student will have one of these records for each term he/she is term activated. Finally, for each term and each class in which a student is enrolled, a STDNT_ENRL record is created.

...