In order to be a student in CUNYfirst, certain records must exist. These records are ACAD_PROG, ACAD_PLAN, STDNT_CAR_TERM and STDNT_ENRL. An enrolled student means that the student is taking one or more classes for a certain term. An active student means that the student is active in a program. An enrolled student is always active but an active student is not always enrolled.
...
The EFFDT allows history for the student to be stored and EFFSEQ allows multiple transactions for the same EFFDT. These are reserve words in PeopleSoft and have special functions. Query recognizes this special-ness and creates code accordingly. STDNT_CAR_NBR is important in the CUNYfirst environment because a student may have multiple careers. Another important field, but not a key, is INSTITUTION. Because CUNfirst CUNYfirst has many institutions, this field MUST be considered in order to narrow down the selection and to join to other tables.
...
Field Description
EMPLID - Empl ID (key; should must equal that of ACAD_PROG.)
ACAD_CAREER - Academic Career (key; should must equal that of ACAD_PROG.)
INSTITUTION - Academic Institution (key; should must equal that of ACAD_PROG.)
STRM - Term (key)
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 (NOT a key; should must equal that of ACAD_PROG.)
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 (if the student is enrolled in credit-bearing courses, this number will be greater than zero.)
UNT_PASSD_PRGRSS - Units Passed for Progress (*** any field starting with UNT is a term total.)
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 (*** any field starting with TOT is a career total.)
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 (term GPA, after grades are posted.)
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
...