...
Every student must have a program record, ACAD_PROG, the layout of which appears below.
About Effective Date - 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 CUNYfirst has many institutions, this field MUST be considered in order to narrow down the selection and to join to other tables.
Other important fields in this table are: ACAD_PROG (i.e., UGRD, MBA, etc.), ADMIT_TERM, DEGR_CHKOUT_STAT and PROG_STATUS. Another field of interest is the ADM_APPL_NBR. If this ACAD_PROG record was created through the application process (Admissions), this field will have a value. It allows the user to return to the application to find data captured there, such as the ADMIT_TYPE.
...
A student may have multiple plans but one is required.
| Field Name | Description/Notes |
|---|---|
| EMPLID | Empl ID (key; must be the same as the owning ACAD_PROG.) |
| ACAD_CAREER | Academic Career (key; must be the same as the owning ACAD_PROG.) |
| STDNT_CAR_NBR | Student Career Nbr (key; must be the same as the owning ACAD_PROG.) |
| EFFDT | Effective Date (key; must be the same as the owning ACAD_PROG.) |
| EFFSEQ | Effective Sequence (key; must be the same as the owning ACAD_PROG.) |
| ACAD_PLAN | Academic Plan (the student's major or minor.) |
| DECLARE_DT | Declare Date |
| PLAN_SEQUENCE | Plan Sequence |
| REQ_TERM | Requirement Term |
| COMPLETION_TERM | Completion Term |
| STDNT_DEGR | Student Degree Nbr |
| DEGR_CHKOUT_STAT | Degree Checkout Status |
| ADVIS_STATUS | Advisement Status |
| SSR_APT_INSTANCE | APT Instance |
| SSR_YR_OF_PROG | Year of Program |
| SCC_ROW_ADD_OPRID | Created By |
| SCC_ROW_ADD_DTTM | Created |
| SCC_ROW_UPD_OPRID | Updated By |
| SCC_ROW_UPD_DTTM | Last Update Date/Time |
...
STDNT_CAR_TERMis created when the student is term activated. A student MUST be term activated in order to enroll in class and that student MUST be active in a program to be term activated.
STDNT_CAR_TERM contains a running total of the student's activity at the institution. The layout is below.
...
STDNT_ENRL is created when a student enrolls in a class or is waitlisted for that class. Even if the student subsequently drops the class, the record remains, but the status changes. STDNT_ENRL is owned by STDNT_CAR_TERM. The layout is below.
For each class, a student will have one of these records. This does not mean that the student is enrolled. For that, the field STDNT_ENRL_STATUS must be checked. If a student is enrolled, the status will be 'E'; if a student is waitlisted for a class, the status will be 'W'; if the student was enrolled and subsequently dropped the class, the status would be 'D'. Therefore, you must check the STDNT_ENRL_STATUS for 'E' to determine in which classes a student is enrolled or even if this is an enrolled student for the term.
STDNT_ENRL is missing some class information, such as subject, catalog number and description. For this detail, you must join STDNT_ENRL to CLASS_TBL, which contains that class information. Or, instead of using STDNT_ENRL, use the view CLASS_TBL_SE_VW, which joins STDNT_ENRL to CLASS_TBL for you.
...