SIS Training: Technical Documentation

This page is used to provide access to technical documents, web pages and other resources for use by technical campus personnel.

Access to the documentation is gained through entering your Unity ID and password. If you should have access but are unable to reach the SIS databases or documentation, please contact us using the Submit Feedback page.

*Sybase extracts will be available until February 28, 2010:
curr_vue
dept_vue
special_grp_vue
stu_crs_vue
superext_vue
schedule_vue

Mainframe Decommission website: http://oit.ncsu.edu/mainframe.

SIS Reporting Tables/ Denormalized Tables

Table Name	Descr	File Name	Updated
NC_DNRM_ADMAPPL	Admission Denorm	NC_DNRM_ADMAPPL.xls	2/22/10
NC_DNRM_ADMTEST	CampusCommunity TestScr Denorm	NC_DNRM_ADMTEST.xls	6/23/09
NC_STU_DNRM_BIO	CampusCommunity BioDemo Denorm	NC_DRM_STU_BIO.xls	9/01/09
NC_DNRM_EDUC	Graduate Education Data	NC_DNRM_EDUC.xls	6/26/09
NC_DNRM_EDUC_UG	Undergraduate Education Data	NC_DNRM_EDUC_UG.xls	9/01/09
NC_DNRM_ENRL_VW	Enrollment by Course Info	NC_DNRM_ENRL_VW.xls	2/18/09
NC_DNRM_GRE	GRE Scores/Data	NC_DNRM_GRE.xls	1/26/09
NC_DNRM_PROG_VW	Student Program/Plan/SubPlan data	NC_DNRM_PROG_VW.xls	2/12/09
NC_DNRM_SCHE_VW	Schedule of Courses (no Student Data)	NC_DNRM_SCHE_VW.xls	10/1/09
NC_DNRM_TERM_VW	General Student Term Info	NC_DNRM_TERM_VW.xls	2/27/09
NC_DNRM_TOEFL.xls	TOEFL Scores/Data	NC_DNRM_TOEFL.xls	10/16/08

Other Tables

Table Name	Descr	File Name	Updated
SIS_ACAD_PLAN_XWALK	SIS Legacy Academic Plan / Subplan to Major Cross Walk	SIS_ACAD_PLAN_XWALK.xls	3/9/09