Versions Compared

Old Version 47

changes.mady.by.user Patrick Ackerman

Saved on

compared with

New Version 48

changes.mady.by.user Tabassum Lodhi

Saved on

Key

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

...

RecordsDescription
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.

...

RecordsDescription
ACAD_DEGR
  • Degree from any CUNY campus.
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.
ADM_APPL_DATA
  • This record contains basic data for an applicant in Student Admissions.  These are applicants, not students, and this record contains the ADMIT_TYPE. 
ADM_APPL_PLAN
  • This record is similar to ACAD_PLAN but on the Student Admissions side.
  • It is a child of ADM_APPL_PROG.
ADM_APPL_PROG
  • This record is similar to ACAD_PROG but on the Student Admissions side.
  • It is a child of ADM_APPL_DATA.
ADM_APPL_SBPLAN
  • This record is similar to ACAD_SUBPLAN but on the Student Admissions side.  
  • It is a child of ADM_APPL_PLAN.
ANTICIPATED_AID
  • This is the table which contains anticipated aid for the students. Because this data can change during the term, it is necessary to grab the latest record for the EMPLID, ITEM_TYPE and TERM.
ITEM_SF
  • This is the student account detail (which rolls up into ACCOUNT_SF).
  • The keys are EMPLID, BUS_UNIT and STRM.
SFA_SAP_STDNT
  • This record is the result of the SAP (student academic progress) process that is run for financial aid.
  • It is stored by EMPLID for each AID_YEAR but the process can be run multiple times in the year, so you must use the latest process date for the year.
STDNT_SRCH / PEOPLE_SEARCH 
  • To check a person by Empl ID.
STDNT_TEST_COMP
  • SAT, Reading etc. test.
TERM_TBL
  • This table contains the calendars for the INSTITUTION and ACAD_CAREER, including the TERM_BEGIN_DT and the TERM_END_DT.
TRNS_CRSE_DTL, TRNS_CRSE_SCH, TRNS_CRSE_TERM 
  • Required for transfer credits.

...