...
| Records | Description |
|---|
| ACAD_CAR_TBL | - To Prompt for Career. Institution prompt required.
|
| ACAD_PLAN_TBL | This is the set-up table where the academic plans are defined and stored. All plans must be added to this set-up table before they can be assigned to a student. The keys to this table are INSTITUTION, ACAD_PLAN & EFFDT. This table contains such fields as DEGREE (BS, MBA, etc.), CIP_CODE, HEGIS_CODE and the SSR_NSC_CRD_LVL (degree level - Associate's, Bachelor's, etc.).
|
| ACAD_SUBPLN_TBL | - This is the set-up table where the academic subplans are defined and stored.
- All subplans must be added to this set-up table before they can be assigned to a student.
- The keys to this table are INSTITUTION, ACAD_PLAN, ACAD_SUBPLAN & EFFDT.
|
| ACCOUNT_SF | - This is a student account summary by term.
- The keys are EMPLID, BUS_UNIT and STRM. BUS_UNIT is the same as INSTITUTION, but used in the student's financial records.
|
| ITEM_TYPE_TBL | - This is the set-up table where the item types are defined and stored.
- All item types must be added to this set-up table before they can be assigned to a student.
- The keys to this table are INSTITUTION, ITEM_TYPE & EFFDT.
|
| SRVC_IN_CD_TBL | - This is the set-up table where the service indicators are defined and stored.
- All service indicators must be added to this set-up table before they can be assigned to a student.
- The keys to this table are INSTITUTION, SRVC_IND_CD & EFFDT.
|
| SRVC_IND_RSN_TBL | - This is the set-up table where the service indicator reason code are defined and stored.
- All service indicators must be added to this set-up table before they can be assigned to a student.
- The keys to this table are INSTITUTION, SRVC_IND_CD & EFFDT.
|
| TERM_TBL | - This table contains the calendars for the INSTITUTION and ACAD_CAREER, including the TERM_BEGIN_DT and the TERM_END_DT.
|
| TERM_VAL_TBL | - This table contains all the valid terms in the CUNY system.
- Use it for editing term prompts.
|
| RQ_GRP_TBL | - This table contains prerequisite courses along with courses.
|
The records below are used for Student Admission, Financial Aid, Transfer credits, degree audit
...