Standard Jet DBnb` Ugr@?~1y0̝cßFNQh7ל(%`{6"߱gC<3y[E&|*|e/Df_Љ$g'DeFx -bT4.0f dv YS  Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniYYIdParentIdName        OY7SY Y Y  Y 2ACMFInheritableObjectIdSID YObjectId YSY  Y Y Y  Y T Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y T Y : Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/  @@@@w   @OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^QkiQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^mJL^Qk`kvkJMMQkkdL[QMmk`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkqYkmJkOL:mJL^QOQkMJMMQkk^Jvdom`kvkOLko``JivYbSd okQiOQSYbQO  okQiOQSYbQO u  @ @     1  @ @ @ @ @ @ @ !"#$%&'()*+,-./0123  CDE           d _ Z 7 T  _ _ʼ ɼɼɼM 82=L@z$?L@VistasDB2TableDesc1@&RRRFFFFFFF`@l@VistasDB2TableDesc1{@&RRRFFFFFFFD @ kS{@4@AccessLayout14MR2KeepLocal T"@%zz:::::::8 @z*0z@z*0z@DataAccessPages1@@@@@@@@@@> z*0z@z*0z@SysRel1.........., z*0z@z*0z@Modules10000000000. z*0z@z*0z@Scripts10000000000. z*0z@z*0z@Reports10000000000. z*0z@z*0z@Forms1,,,,,,,,,,*  z*0z@z*0z@UserDefined1A@DDD88888886 @ z*0z@z*0z@SummaryInfo1@DDD88888886 @/z@/z@MSysAccessObjects1DDDDDDDDDDB /z@/z@MSysRelationships3DDDDDDDDDDB /z@/z@MSysQueries388888888886 /z@/z@MSysACEs322222222220 /z@/z@MSysObjects388888888886 /z@/z@MSysDb1@:::......., @/z@/z@Relationships3<<<<<<<<<<: /z@/z@Databases344444444442 /z@/z@Tables3.........., uF{hUB/A S @ ,  |  B /   l Y 2 o\IƬƬƬƬƬƬƬƬƬƬƬƬƬƬƙ"81 81 8c)Ui$_ByYMR2JOMR2,OrientationOrderByOnNameMap"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColorColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControl$UnicodeCompression(    UFHײF;fCU~@VistasDB2TableDescm_Ffw!FHײF;fDB2_TABLEkLN氤FHײF;fTYPEu-uB36= FHײF;fSEMESTER].UNAAFHײF;fOFFLINEĺr%؆K]o2FHײF;fDESCRIPTIONR$Eu#4FHײF;fSYSTEM  Arial       "  hDESCRIPTION  R5       m ^ SYSTEM         m dDB2_TABLE         m bSEMESTER  e       m ZTYPE  6      MR2,OrientationOrderByOnNameMap"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColorColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControl$UnicodeCompression^    UFHײF;f~K0@VistasDB2TableDescm_Ffw!FHײF;fDB2_TABLEkLN氤FHײF;fTYPEu-uB36= FHײF;fSEMESTERosJ(;5oFHײF;fCAMPUS].UNAAFHײF;fOFFLINEĺr%؆K]o2FHײF;fDESCRIPTIONR$Eu#4FHײF;fSYSTEM  Arial       "  hDESCRIPTION  R5       m ^ SYSTEM         m dDB2_TABLE         m bSEMESTER  e       m ZTYPE  6       m `OFFLINEMR2^ANSI Query ModeAccessVersion BuildProjVerB   08.50 . #MR2^ANSI Query ModeAccessVersion BuildProjVerB   08.50 . #MR2( ReplicateProject MR20 Title AuthorCompany, $VistasDB2TableDesc aalgahmi> 6New Mexico State University YNY Y DataIDYAOIndexv1  K[80B x"DDDDS@D Hp""""0"tttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttttt""@""MSysAccounts c^6xlUePf_fK[ࡱ> Root Entry09 PropData Forms  b bReports b bModules b bScripts b bVBA b09Cmdbars b bCustomGroups  b bDirDataVBAProject`)b09AcessVBAData   !"#$%&'()*+,-.DataAccessPages  b bDatabases btb0 btbBlob ijMSysDbID="{94A1345A-C840-420C-BDB7-51D524079519}" Name="VistasDB2TableDesc" HelpContextID="0" VersionCompatible32="393222000" CMG="7B79D867576B576B576B576B" DPB="F6F455ECAB1C271D271D27" GC="7173D217D317D3E8" [HostK[ Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 00 Root Entry`)b PropData Forms  b bReports b b  Modules b bScripts b bVBA b`)bCmdbars b bCustomGroups  b bDirDataVBAProject`)b`)bAcessVBAData ijMSysDbID="{94A1345A-C840-420C-BDB7-51D524079519}" Name="VistasDB2TableDesc" HelpContextID="0" VersionCompatible32="393222000" CMG="FAF859615765576557655765" DPB="F4F65763AB5CAC5CAC5C" GC="EEEC4D75BD95B696B69649" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000   !"#$%&'()*+,-.VBA`)b`)bPROJECTwmPROJECT/_VBA_PROJECT0* pHdVistasDB2TableDescT@ j =  '@ J< 9stdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\Syst em32\e2.tlb#OLE AutomatiLon0hADODB> K[ADOBDDE1D10-8DAA006D2EA4D1DProgram Files\CommonM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 Li`braryH dir am  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office10\MSACC.OLB#Microsoft Access 10.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library'@x %AccessVBAWin16~Win32MacVBA6#Project1 stdole`VistasDB2TableDescxGADODBs<  VBA`)b09PROJECTwmPROJECT+_VBA_PROJECT0* pHdVistasDB2TableDescT@ j =  '@ J< 9stdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\Syst em32\e2.tlb#OLE AutomatiLon0hADODB> ADOBDDE1D10-8DAA006D2EA4D1DProgram Files\CommonM\ado\ms21NMicrosoft ActiveX Data Objects 2.1 Li`braryH dir dYN Y d Y d Y d Y d Y d Y  Y <DB2_TABLETYPESEMESTER CAMPUSOFFLINEDESCRIPTION SYSTEMdv:Xf M U 4.X/RVITMCCAMaster CourseCampusMaster course campus table. Contains the campus and campus course fee associated with every campus approved to offer the NMSU master courseVISTASF:"" kVITMCELMaster CourseElective course table. Contains the title of every offering of an elective courseVISTAS cVITMCDEMaster CourseMaster course description table. Contains title and description information for every offering of an NMSU master courseVISTAS  cVITTNEWField SupportNewspaper codesVISTASD8 cVITTSCRField SupportSchedule change action reason codesVISTASl` cVITTRDCField SupportTransfer credit evaluation denial codesVISTASth cVITXFERStudentSemesterTransfer credit evaluation semester course table. Contains course information such course prefix and number for both the transfer course and its NMSU equivalentVISTASl` gVITNMCPStudentSemesterCampusNMSU campus enrollment table. Contains enrollment summary schedule information such as hours enrolled for each actual semester (regular or mini) of enrollment for a campus and trailVISTAS&& oVITXTRSStudentSemesterTransfer credit evaluation semester summary table. Contains transfer semester summary information such as the university (or CLEP, ADPL, etc) and approver for a semester and university or institutionVISTAS gVITSCLRStudentCrimson and centennial scholar application and pin tableVISTAS cVITSCLSStudentSemesterCrimson and centennial scholar honors tableVISTASt gVITTDHNField SupportCampusDegree honor codesVISTASRF"" kVITERORSystemVistas online screens and batch processing error message tableVISTAS cVITNSESStudentSemesterTransient history tableVISTASXL gVITPUNVStudentSemesterPrevious university or institution history tableVISTAS~ gVITTSEMField SupportSemester codesVISTASB6 cVITDTGRStudentThesis/dissertation degree tableVISTAS`T cVITOTRHStudentOfficial transcript hold tableVISTAS\P cVITEPEREmployeeHRMS employee table. Contains instructor and employee spouse informationVISTAS c  , i.X7VITATHXStudentOfflineIntercollegiate athlete table for offline students (not included in DED)VISTAS sVITADRYStudentOfflineAddress cross-reference table for offline students (not included in DED). Contains address usage codes (RS, MA, BI, etc) for a student and associates each code with an address. One record exists for each usage codeVISTAS sVITDISCStudentDisciplinary sanction tableVISTASVJ cVITTDISField SupportDisciplinary sanction codesVISTAS\P cVITTGDEField SupportSemesterLetter grade codesVISTASTH$$$ gVITTDFEField SupportSemesterDegree type and associated fee codesVISTASxl$$$ gVITTCFAField SupportHousing facility codesVISTASRF cVITTAACField SupportAdmissions action codesVISTASTH cVITSCHDCourse ScheduleSemesterCampusCourse schedule table. Contains course call number, credit hours, meeting days and times, subtitle, course fee, etc, for every course sectionVISTASVJ..& oVITSCXLCourse ScheduleSemesterCampusCourse schedule cross-listed course table. Contains the name and section of every course being cross-listed with a particular course the same semesterVISTASh\..& oVITCLSSStudentSemesterCampusClass list table. Contains students enrolled in recent coursesVISTAS&& oVITTWHOSystemVistas operators (users) table. Contains base information for every operatorVISTAS cVITLWHOSystemOperators (users) security table. Contains screen security privileges for every Vistas operatorVISTAS cVITMCXIMaster CourseMaster course cross-listed course table. Contains the name of every course that is cross-listed with the NMSU master courseVISTAS cVITMCSUMaster CourseSubtitle course table. Contains subtitles for NMSU master coursesVISTAS cVITMCRSMaster CourseMaster course table. Contains course title, fixed/variable credits, instructor approval flag, subtitle approval flag, maximum cumulative credit indicator, gen ed flag, lecture hours, etc, for each offering of an NMSU master courseVISTAS cVITMCRPMaster CourseMaster course repeat table. Contains the name of every previous course that the NMSU master course replaces/repeatsVISTAS cK[Nam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\System32\stdole2.tlb#OLE Automation*\G{00000201-0000-0010-8000-00AA006D2EA4}#2.1#0#C:\Program Files\Common Files\System\ado\msado21.tlb#Microsoft ActiveX Data Objects 2.1 Library '@x $AccessVBAWin16~Win32MacVBA6#VistasDB2TableDescxGstdole`ADODBs<    Z z . "bRVITPUNXStudentSemesterOfflinePrevious university or institution history table for offline students (not included in DED)VISTAS' wVITPADXStudentOfflineAddress table for offline students (not included in DED). Contains address information such as street and city for a student. An address may be associated with multiple address usage codesVISTAS sVITOTRXStudentOfflineOfficial transcript hold table for offline students (not included in DED)VISTAS sVITNSEXStudentSemesterOfflineTransient history table for offline students (not included in DED)VISTAS' wVITNMCXStudentSemesterCampusOfflineNMSU campus enrollment table for offline students (not included in DED). Contains enrollment summary schedule information such as hours enrolled for each actual semester (regular or mini) of enrollment for a campus and trailVISTAS/& VITHOLXStudentOfflineRegistration hold table for offline students (not included in DED)VISTAS sVITGRSXStudentOfflineGraduate scholastic table for offline students (not included in DED). Contains graduate student information such as classification, admissions type and status, test scores and total cumulative graduate GPAVISTAS sVITDTYXStudentSemesterCampusOfflineDisability semester table for offline students (not included in DED). Contains disabilities identified to a campusVISTAS!/& VITDSVXStudentSemesterCampusOfflineDisability services table for offline students (not included in DED). Contains services provided to students with disabilitiesVISTAS9-/& VITDSBXStudentCampusOfflineDisability table for offline students (not included in DED). Contains disabilities identified to a campusVISTAS% {VITDISXStudentOfflineDisciplinary sanction table for offline students (not included in DED)VISTAS sVITCUMXStudentSemesterOfflineTranscript semester cumulative table for offline students (not included in DED). Contains student cumulative information such as hours earned and GPA for a semester and trailVISTAS' w   ,VITXFEXStudentSemesterOfflineTransfer credit evaluation semester course table for offline students (not included in DED). Contains course information such course prefix and number for both the transfer course and its NMSU equivalentVISTAS' wVITVPEXStudentOfflinePersonal and demographic table for offline students (not included in DED). Contains student base information such as ethnicity, RSA, SLR and previous student ID number and namesVISTAS sVITUGSXStudentOfflineUndergraduate scholastic table for offline students (not included in DED). Contains undergraduate student information such as classification, admissions type and status, test scores and English and Math eligibility informationVISTAS sVITTRSXStudentSemesterOfflineTranscript semester summary table for offline students (not in DED). Contains student semester information such as registration college and campus, classification, admissions type and status, hours earned and GPA for a semester, university and trailVISTAS'' wVITTRCXStudentSemesterCampusOfflineTranscript semester course detail table for offline students (not included in DED). Contains student course information such as course campus, prefix, number, indicator, section and grade for a semester, university, and trailVISTAS/& VITSINXStudentOfflineAcademic interest table for offline students (not included in DED). Contains student academic interest and academic interest indicator information such as BIOL MJ for a student and trail. Up to 6 academic interests may exist per trailVISTAS sVITSCLYStudentOfflineCrimson and centennial scholar application and pin table for offline students (not included in DED)VISTAS sVITSCLXStudentSemesterOfflineCrimson and centennial scholar honors table for offline students (not included in DED)VISTAS' w [ =   VITTSFHField SupportCampus housing facility unitsVISTAS`T cVITHOUSStudentCampusHousing facility table. Contains housing facility occupation information such as the check-in date, unit number, and phoneVISTAS kVITACTVSystemActivity table. Contains information related to Vistas activities to be performed for students such as the generation of advising documents and grade mailersVISTAS[O cVITOTRRStudentOfficial transcript recipients table. Contains recipient information such as the recipient name and address, number of copies printed, and total chargesVISTASRF cVITOTRNStudentOfficial transcript order table. Contains order information such as the student name to be printed and the payment amount and typeVISTAS& cVITAUDTSystemAudit table. Contains information related to Vistas transactions that are audited by the system for tracking purposesVISTAS  cVITDSVCStudentSemesterCampusDisability services table. Contains services provided to students with disabilitiesVISTAS&& oVITDTYPStudentSemesterCampusDisability semester table. Contains disabilities identified to a campusVISTAS&& oVITTDSVField SupportDisability service codesVISTASVJ cVITTDAGField SupportCodes for agencies that provide services to students with disabilitiesVISTAS cVITDSBLStudentCampusDisability table. Contains disabilities identified to a campusVISTAS kVITTDSBField SupportDisability codesVISTASF: cVITHOLDStudentRegistration hold tableVISTASNB cVITTSDTSystemCampusNMSU academic semestersVISTASUI kVITDGREStudentSemesterDegree tableVISTASB6 gVITDGHNStudentSemesterDegree honor tableVISTASNB gVITDGAIStudentSemesterDegree academic interest tableVISTASfZ gVITXTRXStudentSemesterOfflineTransfer credit evaluation semester summary table for offline students (not included in DED). Contains transfer semester summary information such as the university (or CLEP, ADPL, etc) and approver for a semester and university or institutionVISTAS ' w 1 W ] Ya;_5Sk]VITBLSPBuildingUtilization of rooms associated with NMSU buildings tablePPD cVITBLRMBuildingRooms associated with NMSU buildings tablePPDoi cVITBLDGBuildingNMSU buildings and associated acronyms tableVISTASym cVITALFRSystemSemesterCampusAlpha registration student last name character ranges by day and time period tableVISTAS%% oVITCHARSystemAlpha registration counts for each unique first 3 characters of student last names tableVISTAS cVITGRPSSystemAlpha registration group sequences by set tableVISTAS}q cVITSEMSSystemSemesterCampusAlpha registration percentages by day tableVISTAS{%% oVITALFASystemAlpha registration groups and associated first characters of student last names tableVISTAS cVITTRC2Field SupportCampusSecondary accounts receivable transaction codesSAR"" kVITTRC1Field SupportPrimary accounts receivable transaction codesSARzt cVITTRFDField SupportSemesterCampusStandard refund percentages by student typeSAR,,$ oVITTUITField SupportSemesterCampusTuition feesSARJD,,$ oVITTTIMField SupportSemesterCampusDay of the week class time block codesVISTASx,,$ oVITTMRFField SupportSemesterCampusMedical refund codesSARZT,,$ oVITTMPCField SupportSemesterCampusMeal plan codes by effective dateSARtn,,$ oVITTMARField SupportSemesterCampusMiscellaneous fee codesSAR`Z,,$ oVITTINRField SupportSemesterCampusInsurance plan codesSARZT,,$ oVITTHOLField SupportCampusNMSU observed holidaysVISTASZN"" kVITTHEAField SupportSemesterCampusHealth/activity fee codesSARd^,,$ oVITTDAZField SupportDays of the week codesVISTASRF cVITTDAYField SupportCampusClass day and time period codesVISTASl`"" kVITTCLGField SupportCommencement college codesVISTASZN cVITENRLStudentEnrollment verification table. Contains request information such as recipient name and whether classification, class ranking, semester and cumulative GPA, etc, should be listed on the enrollment verificationVISTAS cVITFFDTSystemSemesterCampusFall Freshman Recruiting and Registration Program table. Contains date file information such as program dates and timesVISTAS!%% od  #  l  {0Nb4~VITNMPNSystemVistas program narrative table (not currently used and not included in DED)VISTAS cVITNMCOSystemVistas batch program control card table (not currently used and not included in DED)VISTAS cVITKEYSSystemVistas session information by operator table (not included in DED)VISTAS cVITBTPASystemVistas batch program execution statistics table (not currently used and not included in DED)VISTAS cVITBTERSystemVistas batch program error information table (not currently used and not included in DED)VISTAS cVITPGVWSystemComputer programs tableVISTASMA cVITERRACourse ScheduleSemesterCampusCourse schedule errata tableVISTASrf..& oVITCHESStudentSemesterCampusCHE student tableVISTASTH&& oVITCHECCourse ScheduleSemesterCampusCHE course tableVISTASZN..& oVITCHETStudentSemesterCampusCHE student course tableVISTASbV&& oVITARIBStudentCampusAccounts receivable individual balances tableSAR|v kVITACDMSystemGraduation honors GPA calculations by college and academic year tableVISTAS cVITARUSCampusAccounts receivable daily user logon summary by date tableSAR iVITARSYCampusAccounts receivable system totals by date tableSARwq iVITARLPStudentCampusAccounts receivable transactions additional detail by date and time tableSAR kVITARSPStudentCampusAccounts receivable transactions by date and time tableSAR kVITFRISStudentSemesterCampusIndividual fee records tableSARd^&& oVITFRLPStudentSemesterCampusFee record transactions additional detail tableSAR&& oVITBDBTStudentCampusAccounts receivable bad debts tableSARhb kVITFRSTStudentSemesterCampusFee record transactions tableSARf`&& oVITARCHStudentCampusAccounts receivable collection history table (table is not currently used)SAR kVITARMEStudentCampusAccounts receivable memorandum table (table is not currently used)SAR kVITRGGDStudentSemesterCampusGrade sheet table by actual semester sort code, campus, and courseVISTAS&& oVITSCBRBuildingSemesterCampusNMSU building room assignments by day tableVISTAS}'' oSNh  Q > 8R|YVITTINDField SupportCourse indicator codesVISTASRF cVITTNMCField SupportNew Mexico county codesVISTASTH cVITTHSCField SupportACT high school codesVISTASPD cVITTATPField SupportAdmissions type codesVISTASPD cVITTBSKField SupportBasic skills codesVISTASJ> cVITTATLField SupportIntercollegiate athlete codesVISTAS`T cVITDTFLSystemSemesterCampusDate file table. Contains registration dates for a campus and a semester or mini-semesterVISTAS%% oVITPERXStudentPerson cross-reference table. Contains student base information such as name, owning college, owning campus, undergraduate type code and graduate type codeVISTASXL cVITTFSPField SupportForeign sponsor codesVISTASPD cVITTCTYField SupportCountry codesVISTAS@4 cVITTAINField SupportAcademic interest indicator codesVISTASh\ cVITSINTStudentAcademic interest table. Contains student academic interest and academic interest indicator information such as BIOL MJ for a student and trail. Up to 6 academic interests may exist per trailVISTAS cVITADRXStudentAddress cross-reference table. Contains address usage codes (RS, MA, BI, etc) for a student and associates each code with an address. One record exists for each usage codeVISTASzn cVITGRSCStudentGraduate scholastic table. Contains graduate student information such as classification, admissions type and status, test scores and total cumulative graduate GPAVISTASfZ cVITTACSField SupportAcademic standing codesVISTASTH cVITTTRAField SupportTransient student codesVISTASTH cVITCUMSStudentSemesterTranscript semester cumulative table. Contains student cumulative information such as hours earned and GPA for a semester and trailVISTAS2& gVITTCLSField SupportClassification codesVISTASNB cVITTETHField SupportEthnicity codesVISTASD8 cVITTADRField SupportAddress usage codesVISTASL@ cVITPERRSystemVistas online program error information table (not currently used and not included in DED)VISTAS cVITNMSYSystemSOLAR program table (not currently used and not included in DED)VISTAS c2 & D / YP/ VITATHLStudentSemesterIntercollegiate athlete tableVISTASdX gVITTSTEField SupportState codesVISTAS<0 cVITTPREField SupportCourse prefix codesVISTASL@ cVITTCMPField SupportCampus codesVISTAS>2 cVITTTHDField SupportOfficial transcript hold codesVISTASbV cVITTSUFField SupportName suffix codesVISTASH< cVITTDEGField SupportDegree codesVISTAS>2 cVITTENSField SupportAdmissions status codesVISTASTH cVITTOFCField SupportOffice codesVISTAS>2 cVITFDSPField SupportField support tableVISTASL@ cVITTDPTField SupportDepartment codesVISTASF: cVITUGSCStudentUndergraduate scholastic table. Contains undergraduate student information such as classification, admissions type and status, test scores and English and Math eligibility informationVISTAS cVITTRSSStudentSemesterTranscript semester summary table. Contains student semester information such as registration college and campus, classification, admissions type and status, hours earned and GPA for a semester, university and trailVISTAS gVITVPERStudentPersonal and demographic table. Contains student base information such as ethnicity, RSA, SLR and previous student ID number and namesVISTAS." cVITTVSAField SupportVISA codesVISTAS:. cVITTGRDField SupportGrade type codesVISTASF: cVITTVBNField SupportVeteran benefit codesVISTASPD cVITTUNVField SupportUniversity codesVISTASF: cVITTTUWField SupportTuition waiver codesVISTASNB cVITTCRMField SupportCrimson and centenniel scholar codesVISTASnb cVITPADRStudentAddress table. Contains address information such as street and city for a student. An address may be associated with multiple address usage codesVISTASF: cVITTRCDStudentSemesterCampusTranscript semester course detail table. Contains student course information such as course campus, prefix, number, indicator, section and grade for a semester, university, and trailVISTAS&& oVITTHLDField SupportRegistration hold codesVISTASTH cVITTIICField SupportAcademic interest codesVISTASTH cVITBFATStudentSemesterCourse activity audit table sometimes referred to as the Business Office and Financial Aid registration audit trailVISTAS gLVALNʾistasDB2TableDesc^3uLVALMR2lOrientationOrderByOnNameMap"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColorColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControl$UnicodeCompressionGUID FilterOrderByDefaultView    U0KLp:ȩd@VistasDB2TableDesc6I)OK%#fmo~0KLp:ȩDB2_TABLEo_1e%B{k0KLp:ȩTYPEsHAG_Xȵl]o0KLp:ȩSEMESTERtxZJ #_S0KLp:ȩCAMPUSeP%BMBQ!0KLp:ȩOFFLINEsLwU~0KLp:ȩDESCRIPTIONLfEuK3>ܬ40KLp:ȩSYSTEM  Arial       "    5M\R*.f@ 8VistasDB2TableDesc.DB2_TABLE DESCRIPTION  R5       m  sLwU~v SYSTEM         m  LfEuK3>ܬ4|DB2_TABLE         m  6I)OK%#fmo~zSEMESTER  e       m  sHAG_Xȵl]orTYPE  6       m  o_1e%B{kxOFFLINE         m  eP%BMBQ!v CAMPUS         m  txZJ #_S LVALʾVistasDB2TableDescign view]V=^3"=z I78VITTHEAField SupportSemesterHealth/activity fee codes by campusSARpj$$ 7VITTDAZField SupportDays of the week codesVISTASRF 3VITTDAYField SupportClass day and time period codes by campusVISTASxl 3VITTCLGField SupportCommencement college codesVISTASZN 3VITENRLStudentEnrollment verification table. Contains request information such as recipient name and whether classification, class ranking, semester and cumulative GPA, etc, were printed on the enrollment verificationVISTAS 3VITFFDTSystemSemesterFall Freshman Recruiting and Registration Program table. Contains date file information such as program dates and times for a semester and campusVISTASMA 7VITTSFHField SupportCampus housing facility unitsVISTAS`T 3VITHOUSStudentCampus housing facility table. Contains housing facility occupation information such as the check-in date, unit number, and phoneVISTAS$ 3VITACTVSystemActivity table. Contains information related to Vistas activities to be performed for students such as the generation of advising documents and grade mailersVISTAS[O 3VITOTRRStudentOfficial transcript recipients table. Contains recipient information such as the recipient name and address, number of copies printed, and total chargesVISTASRF 3VITOTRNStudentOfficial transcript order table. Contains order information such as the student name to be printed and the payment amount and typeVISTAS& 3VITAUDTSystemAudit table. Contains information related to Vistas transactions that are audited by the system for tracking purposesVISTAS  3VITDSVCStudentSemesterDisability services table. Contains services provided to students with disabilities for a semester and campusVISTAS 7VITDTYPStudentSemesterDisability semester table. Contains disabilities that were identified to a campus for a semesterVISTAS 7VITTDSVField SupportDisability service codesVISTASVJ 3VITTDAGField SupportCodes for agencies that provide services to students with disabilitiesVISTAS 3VITDSBLStudentDisability table. Contains disabilities that were identified to a campusVISTAS 3" Q \ ,I8+VITTACSField SupportAcademic standing codesVISTASTH 3VITTTRAField SupportTransient student codesVISTASTH 3VITCUMSStudentSemesterTranscript semester cumulative table. Contains student cumulative information such as hours earned and GPA for a semester and trailVISTAS2& 7VITTCLSField SupportClassification codesVISTASNB 3VITTETHField SupportEthnicity codesVISTASD8 3VITTADRField SupportAddress usage codesVISTASL@ 3VITRGGDStudentSemesterGrade sheets by actual semester sort code, campus, and courseVISTAS 7VITSCBRBuildingSemesterNMSU building room assignments by day and campusVISTAS 7VITBLSPBuildingUtilization of rooms associated with NMSU buildingsPPD{ 3VITBLRMBuildingRooms associated with NMSU buildingsPPDc] 3VITBLDGBuildingNMSU buildings and associated acronymsVISTASma 3VITALFRSystemSemesterAlpha registration student last name character ranges by day and time period and campusVISTAS 7VITCHARSystemAlpha registration counts for each unique first 3 characters of student last namesVISTAS 3VITGRPSSystemAlpha registration group sequences by setVISTASqe 3VITSEMSSystemSemesterAlpha registration percentages by dayVISTASsg 7VITALFASystemAlpha registration groups and associated first characters of student last namesVISTAS 3VITTRC2Field SupportSecondary accounts receivable transaction codes by campusSAR 3VITTRC1Field SupportPrimary accounts receivable transaction codesSARzt 3VITTRFDField SupportSemesterStandard refund percentages by campus and student typeSAR$$ 7VITTUITField SupportSemesterTuition fees by campusSARVP$$ 7VITTTIMField SupportSemesterDay of the week class time block codes by campusVISTAS$$ 7VITTMRFField SupportSemesterMedical refund codes by campusSARf`$$ 7VITTMPCField SupportSemesterMeal plan codes by campus and effective dateSAR|$$ 7VITTMARField SupportSemesterMiscellaneous fee codes by campusSARlf$$ 7VITTINRField SupportSemesterInsurance plan codes by campusSARf`$$ 7VITTHOLField SupportNMSU observed holidays by campusVISTASfZ 3+" K _2l ??aVITTTUWField SupportTuition waiver codesVISTASNB 3VITTCRMField SupportCrimson and centenniel scholar codesVISTASnb 3VITPADRStudentAddress table. Contains address information such as street and city for a student. An address may be associated with multiple address usage codesVISTASF: 3VITTRCDStudentSemesterTranscript semester course detail table. Contains student course information such as course campus, prefix, number, indicator, section and grade for a semester, university, and trailVISTAS 7VITTHLDField SupportRegistration hold codesVISTASTH 3VITTIICField SupportAcademic interest codesVISTASTH 3VITTINDField SupportCourse indicator codesVISTASRF 3VITTNMCField SupportNew Mexico county codesVISTASTH 3VITTHSCField SupportACT high school codesVISTASPD 3VITTATPField SupportAdmisions type codesVISTASNB 3VITTBSKField SupportBasic skills codesVISTASJ> 3VITTATLField SupportIntercollegiate athletic codesVISTASbV 3VITDTFLSystemSemesterDate file table. Contains current semester indicators and system dates for a campus and semester or mini-semester. DED Status: IN PROGRESSVISTASC7 7VITPERXStudentPerson cross-reference table. Contains student base information such as name, current college, current campus, undergraduate type code and graduate type codeVISTAS\P 3VITTFSPField SupportForeign sponsor codesVISTASPD 3VITTCTYField SupportCountry codesVISTAS@4 3VITTAINField SupportAcademic interest indicator codesVISTASh\ 3VITSINTStudentAcademic interest table. Contains student academic interest and academic interest indicator information such as BIOL MJ for a student and trail. Up to 6 academic interests may exist per trailVISTAS 3VITADRXStudentAddress cross-reference table. Contains address usage codes (RS, MA, BI, etc) for a student and associates each code with an address. One record exists for each usage codeVISTASzn 3VITGRSCStudentGraduate scholastic table. Contains graduate student information such as classification, admissions type and status, test scores and total cumulative graduate GPAVISTASfZ 3H"Hg | 9( a~VITBFATStudentSemesterCourse activity audit table sometimes referred to as the Business Office and Financial Aid registration audit trailVISTAS 7VITATHLStudentSemesterIntercollegiate athlete tableVISTASdX 7VITTSTEField SupportState codesVISTAS<0 3VITTPREField SupportCourse prefix codesVISTASL@ 3VITTCMPField SupportCampus codesVISTAS>2 3VITTTHDField SupportOfficial transcript hold codesVISTASbV 3VITTSUFField SupportName suffix codesVISTASH< 3VITTDEGField SupportDegree codesVISTAS>2 3VITTENSField SupportAdmissions status codesVISTASTH 3VITTOFCField SupportOffice codesVISTAS>2 3VITFDSPField SupportField support codesVISTASL@ 3VITTDPTField SupportDepartment codesVISTASF: 3VITFRISStudentSemesterFee record table. Contains student accounts receivable billing and fee information for a semester and campus. DED Status: IN PROGRESSVISTAS:. 7VITUGSCStudentUndergraduate scholastic table. Contains undergraduate student information such as classification, admissions type and status, test scores and English and Math eligibility informationVISTAS 3VITTRSSStudentSemesterTranscript semester summary table. Contains student semester information such as registration college and campus, classification, admissions type and status, hours earned and GPA for a semester, university and trailVISTAS 7VITVPERStudentPersonal and demographic table. Contains student base information such as ethnicity, RSA, SLR and previous student ID number and namesVISTAS." 3VITTVSAField SupportVISA codesVISTAS:. 3VITTGRDField SupportGrade type codesVISTASF: 3VITTVBNField SupportVeteran benefit codesVISTASPD 3VITTUNVField SupportUniversity codesVISTASF: 3 LVAL MR2TOrientationOrderByOnNameMap"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColorColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControl$UnicodeCompressionGUID FilterOrderBy@    UFHײF;fCU~@VistasDB2TableDescm_Ffw!FHײF;fDB2_TABLEkLN氤FHײF;fTYPEu-uB36= FHײF;fSEMESTER].UNAAFHײF;fOFFLINEĺr%؆K]o2FHײF;fDESCRIPTIONR$Eu#4FHײF;fSYSTEM  Arial       "   vMԮHWF,DESCRIPTION  R5       m  (ENļj{^v SYSTEM         m  &9(L:C IG|DB2_TABLE         m  鼐eM7= zSEMESTER  e       m  $+O47R rTYPE  6       m  *VYH,Q/*xOFFLINE         m  MR2TOrientationOrderByOnNameMap"DatasheetFontName&DatasheetFontHeight&DatasheetFontWeight&DatasheetFontItalic,DatasheetFontUnderlineTabularCharSetTabularFamily$DatasheetForeColorColumnWidthColumnOrderColumnHiddenRequiredAllowZeroLengthDisplayControl$UnicodeCompressionGUID FilterOrderBy@    UFHײF;fCU~@VistasDB2TableDescm_Ffw!FHײF;fDB2_TABLEkLN氤FHײF;fTYPEu-uB36= FHײF;fSEMESTER].UNAAFHײF;fOFFLINEĺr%؆K]o2FHײF;fDESCRIPTIONR$Eu#4FHײF;fSYSTEM  Arial       "   vMԮHWF,DESCRIPTION  R5       m  (ENļj{^v SYSTEM         m  &9(L:C IG|DB2_TABLE         m  鼐eM7= zSEMESTER  e       m  $+O47R rTYPE  6       m  *VYH,Q/*xOFFLINE         m  !,"HF$ LVALʾVistasDB2TableDescign view{#[|^3dYN99 Y  d Y sd Y d Y Sd Y  d Y " Y <DB2_TABLETYPESEMESTER CAMPUSOFFLINEDESCRIPTION SYSTEM8:Xf K S 2,V-PVITMCCAMaster CourseCampusMaster course campus table. Contains the campus and campus course fee associated with every campus approved to offer the NMSU master courseVISTASF:"" kVITMCELMaster CourseElective course table. Contains the title of every offering of an elective courseVISTAS cVITMCDEMaster CourseMaster course description table. Contains title and description information for every offering of an NMSU master courseVISTAS  cVITTNEWField SupportNewspaper codesVISTASD8 cVITTSCRField SupportSchedule change action reason codesVISTASl` cVITTRDCField SupportTransfer credit evaluation denial codesVISTASth cVITXFERStudentSemesterTransfer credit evaluation semester course table. Contains course information such course prefix and number for both the transfer course and its NMSU equivalentVISTASl` gVITNMCPStudentSemesterCampusNMSU campus enrollment table. Contains enrollment summary schedule information such as hours enrolled for each actual semester (regular or mini) of enrollment for a campus and trailVISTAS&& oVITXTRSStudentSemesterTransfer credit evaluation semester summary table. Contains transfer semester summary information such as the university (or CLEP, ADPL, etc) and approver for a semester and university or institutionVISTAS gVITSCLRStudentCrimson and centennial scholar application and pin tableVISTAS cVITSCLSStudentSemesterCrimson and centennial scholar honors tableVISTASt gVITTDHNField SupportCampusDegree honor codesVISTASRF"" kVITERORSystemVistas on-line screens and batch processing error message tableVISTAS cVITNSESStudentSemesterTransient history tableVISTASXL gVITPUNVStudentSemesterPrevious university or institution history tableVISTAS~ gVITTSEMField SupportSemester codesVISTASB6 cVITDTGRStudentThesis/dissertation degree tableVISTAS`T cVITOTRHStudentOfficial transcript hold tableVISTAS\P cVITEPEREmployeeHRMS employee table. Contains instructor and employee spouse informationVISTAS c8  , i.X7VITATHXStudentOfflineIntercollegiate athlete table for offline students (not included in DED)VISTAS sVITADRYStudentOfflineAddress cross-reference table for offline students (not included in DED). Contains address usage codes (RS, MA, BI, etc) for a student and associates each code with an address. One record exists for each usage codeVISTAS sVITDISCStudentDisciplinary sanction tableVISTASVJ cVITTDISField SupportDisciplinary sanction codesVISTAS\P cVITTGDEField SupportSemesterLetter grade codesVISTASTH$$$ gVITTDFEField SupportSemesterDegree type and associated fee codesVISTASxl$$$ gVITTCFAField SupportHousing facility codesVISTASRF cVITTAACField SupportAdmissions action codesVISTASTH cVITSCHDCourse ScheduleSemesterCampusCourse schedule table. Contains course call number, credit hours, meeting days and times, subtitle, course fee, etc, for every course sectionVISTASVJ..& oVITSCXLCourse ScheduleSemesterCampusCourse schedule cross-listed course table. Contains the name and section of every course being cross-listed with a particular course the same semesterVISTASh\..& oVITCLSSStudentSemesterCampusClass list table. Contains students enrolled in recent coursesVISTAS&& oVITTWHOSystemVistas operators (users) table. Contains base information for every operatorVISTAS cVITLWHOSystemOperators (users) security table. Contains screen security privileges for every Vistas operatorVISTAS cVITMCXIMaster CourseMaster course cross-listed course table. Contains the name of every course that is cross-listed with the NMSU master courseVISTAS cVITMCSUMaster CourseSubtitle course table. Contains subtitles for NMSU master coursesVISTAS cVITMCRSMaster CourseMaster course table. Contains course title, fixed/variable credits, instructor approval flag, subtitle approval flag, maximum cumulative credit indicator, gen ed flag, lecture hours, etc, for each offering of an NMSU master courseVISTAS cVITMCRPMaster CourseMaster course repeat table. Contains the name of every previous course that the NMSU master course replaces/repeatsVISTAS c8 Z z . "bRVITPUNXStudentSemesterOfflinePrevious university or institution history table for offline students (not included in DED)VISTAS' wVITPADXStudentOfflineAddress table for offline students (not included in DED). Contains address information such as street and city for a student. An address may be associated with multiple address usage codesVISTAS sVITOTRXStudentOfflineOfficial transcript hold table for offline students (not included in DED)VISTAS sVITNSEXStudentSemesterOfflineTransient history table for offline students (not included in DED)VISTAS' wVITNMCXStudentSemesterCampusOfflineNMSU campus enrollment table for offline students (not included in DED). Contains enrollment summary schedule information such as hours enrolled for each actual semester (regular or mini) of enrollment for a campus and trailVISTAS/& VITHOLXStudentOfflineRegistration hold table for offline students (not included in DED)VISTAS sVITGRSXStudentOfflineGraduate scholastic table for offline students (not included in DED). Contains graduate student information such as classification, admissions type and status, test scores and total cumulative graduate GPAVISTAS sVITDTYXStudentSemesterCampusOfflineDisability semester table for offline students (not included in DED). Contains disabilities identified to a campusVISTAS!/& VITDSVXStudentSemesterCampusOfflineDisability services table for offline students (not included in DED). Contains services provided to students with disabilitiesVISTAS9-/& VITDSBXStudentCampusOfflineDisability table for offline students (not included in DED). Contains disabilities identified to a campusVISTAS% {VITDISXStudentOfflineDisciplinary sanction table for offline students (not included in DED)VISTAS sVITCUMXStudentSemesterOfflineTranscript semester cumulative table for offline students (not included in DED). Contains student cumulative information such as hours earned and GPA for a semester and trailVISTAS' w8   ,VITXFEXStudentSemesterOfflineTransfer credit evaluation semester course table for offline students (not included in DED). Contains course information such course prefix and number for both the transfer course and its NMSU equivalentVISTAS' wVITVPEXStudentOfflinePersonal and demographic table for offline students (not included in DED). Contains student base information such as ethnicity, RSA, SLR and previous student ID number and namesVISTAS sVITUGSXStudentOfflineUndergraduate scholastic table for offline students (not included in DED). Contains undergraduate student information such as classification, admissions type and status, test scores and English and Math eligibility informationVISTAS sVITTRSXStudentSemesterOfflineTranscript semester summary table for offline students (not in DED). Contains student semester information such as registration college and campus, classification, admissions type and status, hours earned and GPA for a semester, university and trailVISTAS'' wVITTRCXStudentSemesterCampusOfflineTranscript semester course detail table for offline students (not included in DED). Contains student course information such as course campus, prefix, number, indicator, section and grade for a semester, university, and trailVISTAS/& VITSINXStudentOfflineAcademic interest table for offline students (not included in DED). Contains student academic interest and academic interest indicator information such as BIOL MJ for a student and trail. Up to 6 academic interests may exist per trailVISTAS sVITSCLYStudentOfflineCrimson and centennial scholar application and pin table for offline students (not included in DED)VISTAS sVITSCLXStudentSemesterOfflineCrimson and centennial scholar honors table for offline students (not included in DED)VISTAS' w8 [ =   VITTSFHField SupportCampus housing facility unitsVISTAS`T cVITHOUSStudentCampusHousing facility table. Contains housing facility occupation information such as the check-in date, unit number, and phoneVISTAS kVITACTVSystemActivity table. Contains information related to Vistas activities to be performed for students such as the generation of advising documents and grade mailersVISTAS[O cVITOTRRStudentOfficial transcript recipients table. Contains recipient information such as the recipient name and address, number of copies printed, and total chargesVISTASRF cVITOTRNStudentOfficial transcript order table. Contains order information such as the student name to be printed and the payment amount and typeVISTAS& cVITAUDTSystemAudit table. Contains information related to Vistas transactions that are audited by the system for tracking purposesVISTAS  cVITDSVCStudentSemesterCampusDisability services table. Contains services provided to students with disabilitiesVISTAS&& oVITDTYPStudentSemesterCampusDisability semester table. Contains disabilities identified to a campusVISTAS&& oVITTDSVField SupportDisability service codesVISTASVJ cVITTDAGField SupportCodes for agencies that provide services to students with disabilitiesVISTAS cVITDSBLStudentCampusDisability table. Contains disabilities identified to a campusVISTAS kVITTDSBField SupportDisability codesVISTASF: cVITHOLDStudentRegistration hold tableVISTASNB cVITTSDTSystemCampusNMSU academic semestersVISTASUI kVITDGREStudentSemesterDegree tableVISTASB6 gVITDGHNStudentSemesterDegree honor tableVISTASNB gVITDGAIStudentSemesterDegree academic interest tableVISTASfZ gVITXTRXStudentSemesterOfflineTransfer credit evaluation semester summary table for offline students (not included in DED). Contains transfer semester summary information such as the university (or CLEP, ADPL, etc) and approver for a semester and university or institutionVISTAS ' w8 1 W ] Ya;_5Sk]VITBLSPBuildingUtilization of rooms associated with NMSU buildings tablePPD cVITBLRMBuildingRooms associated with NMSU buildings tablePPDoi cVITBLDGBuildingNMSU buildings and associated acronyms tableVISTASym cVITALFRSystemSemesterCampusAlpha registration student last name character ranges by day and time period tableVISTAS%% oVITCHARSystemAlpha registration counts for each unique first 3 characters of student last names tableVISTAS cVITGRPSSystemAlpha registration group sequences by set tableVISTAS}q cVITSEMSSystemSemesterCampusAlpha registration percentages by day tableVISTAS{%% oVITALFASystemAlpha registration groups and associated first characters of student last names tableVISTAS cVITTRC2Field SupportCampusSecondary accounts receivable transaction codesSAR"" kVITTRC1Field SupportPrimary accounts receivable transaction codesSARzt cVITTRFDField SupportSemesterCampusStandard refund percentages by student typeSAR,,$ oVITTUITField SupportSemesterCampusTuition feesSARJD,,$ oVITTTIMField SupportSemesterCampusDay of the week class time block codesVISTASx,,$ oVITTMRFField SupportSemesterCampusMedical refund codesSARZT,,$ oVITTMPCField SupportSemesterCampusMeal plan codes by effective dateSARtn,,$ oVITTMARField SupportSemesterCampusMiscellaneous fee codesSAR`Z,,$ oVITTINRField SupportSemesterCampusInsurance plan codesSARZT,,$ oVITTHOLField SupportCampusNMSU observed holidaysVISTASZN"" kVITTHEAField SupportSemesterCampusHealth/activity fee codesSARd^,,$ oVITTDAZField SupportDays of the week codesVISTASRF cVITTDAYField SupportCampusClass day and time period codesVISTASl`"" kVITTCLGField SupportCommencement college codesVISTASZN cVITENRLStudentEnrollment verification table. Contains request information such as recipient name and whether classification, class ranking, semester and cumulative GPA, etc, should be listed on the enrollment verificationVISTAS cVITFFDTSystemSemesterCampusFall Freshman Recruiting and Registration Program table. Contains date file information such as program dates and timesVISTAS!%% o8d  #  l  {0Nb4~VITNMPNSystemVistas program narrative table (not currently used and not included in DED)VISTAS cVITNMCOSystemVistas batch program control card table (not currently used and not included in DED)VISTAS cVITKEYSSystemVistas session information by operator table (not included in DED)VISTAS cVITBTPASystemVistas batch program execution statistics table (not currently used and not included in DED)VISTAS cVITBTERSystemVistas batch program error information table (not currently used and not included in DED)VISTAS cVITPGVWSystemComputer programs tableVISTASMA cVITERRACourse ScheduleSemesterCampusCourse schedule errata tableVISTASrf..& oVITCHESStudentSemesterCampusCHE student tableVISTASTH&& oVITCHECCourse ScheduleSemesterCampusCHE course tableVISTASZN..& oVITCHETStudentSemesterCampusCHE student course tableVISTASbV&& oVITARIBStudentCampusAccounts receivable individual balances tableSAR|v kVITACDMSystemGraduation honors GPA calculations by college and academic year tableVISTAS cVITARUSCampusAccounts receivable daily user logon summary by date tableSAR iVITARSYCampusAccounts receivable system totals by date tableSARwq iVITARLPStudentCampusAccounts receivable transactions additional detail by date and time tableSAR kVITARSPStudentCampusAccounts receivable transactions by date and time tableSAR kVITFRISStudentSemesterCampusIndividual fee records tableSARd^&& oVITFRLPStudentSemesterCampusFee record transactions additional detail tableSAR&& oVITBDBTStudentCampusAccounts receivable bad debts tableSARhb kVITFRSTStudentSemesterCampusFee record transactions tableSARf`&& oVITARCHStudentCampusAccounts receivable collection history table (table is not currently used)SAR kVITARMEStudentCampusAccounts receivable memorandum table (table is not currently used)SAR kVITRGGDStudentSemesterCampusGrade sheet table by actual semester sort code, campus, and courseVISTAS&& oVITSCBRBuildingSemesterCampusNMSU building room assignments by day tableVISTAS}'' oQ8Nf O < 6PzWVITTINDField SupportCourse indicator codesVISTASRF cVITTNMCField SupportNew Mexico county codesVISTASTH cVITTHSCField SupportACT high school codesVISTASPD cVITTATPField SupportAdmissions type codesVISTASPD cVITTBSKField SupportBasic skills codesVISTASJ> cVITTATLField SupportIntercollegiate athlete codesVISTAS`T cVITDTFLSystemSemesterCampusDate file table. Contains registration dates for a campus and a semester or mini-semesterVISTAS%% oVITPERXStudentPerson cross-reference table. Contains student base information such as name, owning college, owning campus, undergraduate type code and graduate type codeVISTASXL cVITTFSPField SupportForeign sponsor codesVISTASPD cVITTCTYField SupportCountry codesVISTAS@4 cVITTAINField SupportAcademic interest indicator codesVISTASh\ cVITSINTStudentAcademic interest table. Contains student academic interest and academic interest indicator information such as BIOL MJ for a student and trail. Up to 6 academic interests may exist per trailVISTAS cVITADRXStudentAddress cross-reference table. Contains address usage codes (RS, MA, BI, etc) for a student and associates each code with an address. One record exists for each usage codeVISTASzn cVITGRSCStudentGraduate scholastic table. Contains graduate student information such as classification, admissions type and status, test scores and total cumulative graduate GPAVISTASfZ cVITTACSField SupportAcademic standing codesVISTASTH cVITTTRAField SupportTransient student codesVISTASTH cVITCUMSStudentSemesterTranscript semester cumulative table. Contains student cumulative information such as hours earned and GPA for a semester and trailVISTAS2& gVITTCLSField SupportClassification codesVISTASNB cVITTETHField SupportEthnicity codesVISTASD8 cVITTADRField SupportAddress usage codesVISTASL@ cVITPERRSystemVistas on-line program error information table (not currently used and not included in DED)VISTAS cVITNMSYSystemSOLAR program table (not currently used and not included in DED)VISTAS c82 & D / YP/ VITATHLStudentSemesterIntercollegiate athlete tableVISTASdX gVITTSTEField SupportState codesVISTAS<0 cVITTPREField SupportCourse prefix codesVISTASL@ cVITTCMPField SupportCampus codesVISTAS>2 cVITTTHDField SupportOfficial transcript hold codesVISTASbV cVITTSUFField SupportName suffix codesVISTASH< cVITTDEGField SupportDegree codesVISTAS>2 cVITTENSField SupportAdmissions status codesVISTASTH cVITTOFCField SupportOffice codesVISTAS>2 cVITFDSPField SupportField support tableVISTASL@ cVITTDPTField SupportDepartment codesVISTASF: cVITUGSCStudentUndergraduate scholastic table. Contains undergraduate student information such as classification, admissions type and status, test scores and English and Math eligibility informationVISTAS cVITTRSSStudentSemesterTranscript semester summary table. Contains student semester information such as registration college and campus, classification, admissions type and status, hours earned and GPA for a semester, university and trailVISTAS gVITVPERStudentPersonal and demographic table. Contains student base information such as ethnicity, RSA, SLR and previous student ID number and namesVISTAS." cVITTVSAField SupportVISA codesVISTAS:. cVITTGRDField SupportGrade type codesVISTASF: cVITTVBNField SupportVeteran benefit codesVISTASPD cVITTUNVField SupportUniversity codesVISTASF: cVITTTUWField SupportTuition waiver codesVISTASNB cVITTCRMField SupportCrimson and centenniel scholar codesVISTASnb cVITPADRStudentAddress table. Contains address information such as street and city for a student. An address may be associated with multiple address usage codesVISTASF: cVITTRCDStudentSemesterCampusTranscript semester course detail table. Contains student course information such as course campus, prefix, number, indicator, section and grade for a semester, university, and trailVISTAS&& oVITTHLDField SupportRegistration hold codesVISTASTH cVITTIICField SupportAcademic interest codesVISTASTH c8VITBFATStudentSemesterCourse activity audit table sometimes referred to as the Business Office and Financial Aid registration audit trailVISTAS g