SIS Data Element Reference List

• Shared Components
  • Attributes File
    • Academic Program Table (AAAPTS)
    • Student Billing Summary Table AABSTS)
    • Student Name Sort Table (AANSTS)
    • Student Attributes Table (AARTTS)
  • SEVIS Batch Table (ABRTTS)
  • System Control File (ACRTTS)
  • Address File
    • Address Data Table (ADADTS)
    • Address Root Table (ADRTTS)
  • School Index File
    • Payer Address Table (AIPATS)
    • Payer Media Table (AIPMTS)
    • External Institution Table (AIRTTS)
  • Job Parameter File
    • Batch Job Keyword Table (AJKWTS)
    • Batch Job Parameter Table (AJPVTS)
    • Batch Job Description Table (AJRTTS)
  • Student Miscellaneous File
    • Admissions Change Table (AMADTS)
    • Registration Audit Table (AMAUTS)
    • Enrollment Request Table (AMECTS)
    • SEVIS Dependent Table (AMEDTS)
    • SEVIS Financial Table (AMEFTS)
    • SEVIS Employment History Table (AMEHTS)
    • Email Address Table (AMEMTS)
    • SEVIS Program Table (AMEPTS)
    • SEVIS Tracking Table (AMETTS)
    • Grade Change Table (AMGRTS)
    • Student Holds Comments Table (AMHCTS)
    • Student Immunization Table (AMIMTS)
    • International Students Table (AMINTS)
    • Student Personal Contact Table (AMPCTS)
    • Student Personal Reference Table (AMPRTS)
    • SEVIS EV Dependent Table (AMSDTS)
    • SEVIS EV Financial Table (AMSFTS)
    • SEVIS EV Program Table (AMSPTS)
    • SEVIS EV Tracking Table (AMSTTS)
    • Transcript Request Table (AMTRTS)
    • Tax Year Table (AMTXTS)
  • Building/Room Facilities File
    • Classroom Information Table (AOCOTS)
    • Classroom Capacity Table (AONOTS)
    • Classroom Root Table (AORTTS)
    • Room Special Conditions Table (AOSCTS)
    • Departmental Room Table (AOSDTS)
  • Building/Room Posting File
    • Classroom Posting Table (APRTTS)
    • Classroom Usage Table (APUSTS)
  • Calculation Rules File
    • Academic Actions Table (ARAATS)
    • Admissions Rules Table (ARADTS)
    • Rules Control Table (ARRTTS)
    • Academic Schedule Table (ARSPTS)
    • Rates Table (ARTRTS)
  • Audit File
    • Audit Detail Table (AUDTTS)
    • Core Audit Table (AURTTS)
  • Value Translations File File (AVRTTS)
  • Faculty File
    • Faculty Organization Table (AYCDTS)
    • Non-Teaching Activities Table (AYNTTS)
    • Faculty Information Table (AYRTTS)
• Billing/Receivables Files
  • Billing Subcodes Table (BCRTTS)
  • Billing Detail Table (BDRTTS)
  • Billing Text Table (BDTXTS)
  • Income Distribution Detail Table (BIDSTS)
  • Income Distributiion Control Table (BIRTTS)
  • Cash Received Archive Table (BMARTS)
  • Cash Received Table (BMCATS)
  • Contractor Detail Table (BSCOTS)
  • Financial Summary Table (BSRTTS)
• On Course Files
  • Graduate Committee Member Table (DPCOTS)
  • Student Degree Plan Table (DPCRTS)
  • Degree Plan Exception Table (DPEXTS)
  • Degree Plan Notes Table (DPNTTS)
  • Degree Requirements Exception Table (DPRQTS)
  • Student Degree Plan Control Table (DPRTTS)
  • Degree Requirements Table (DRITTS)
  • Degree Requirements Control Table (DRRTTS)
• Housing Files
  • Housing Building Table (HABLTS)
  • Housing Room Assignments Table (HARATS)
  • Housing Assignments Table (HARTTS)
  • Housing Control Table (HCRTTS)
  • Housing Inventory Table (HIRTTS)
  • Housing Log Table (HLRTTS)
  • Housing Rates Table (HRORTS)
  • Housing Rates Control Table (HRRTTS)
• Admissions Files
  • Addmisssion Applicant Information Table (MMAPTS)
  • Admission Prospect Table (MMPRTS)
  • Admission Applicant Attribute Table (MMRTTS)
  • Admission Control Table (MMSCTS)
  • Test Load Rejects Table (MRRTTS)
  • Admission Tracking Table MTRTTS)
  • Admission Tracking Control Table (MTTRTS)
• Records and Registration Files
  • Academic Auxiliary File
    • Student Cumulative Statistics Table (RACSTS)
    • Student Honors Table (RADGTS)
    • Student Initial Statistics Table (RAINTS)
    • Student Control (Locator) Table (RARTTS)
  • Basis of Admissons File
    • Previous Institutions Table (RBADTS)
    • Previous Institutions History Table (RBCOTS)
    • High School Grade Table (RBGRTS)
    • High School Subjects Detail Table (RBGSTS)
    • High School Statistics Table (RBHSTS)
    • Basis of Admissions Control Table (RBRTTS)
    • High School Subjects Summary Table (RBSUTS)
    • Test Scores Table (RBTSTS)
  • Course Term File
    • Course Instructor Table (RCINTS)
    • Course Meeting Days Table (RCMDTS)
    • Course Term Control Table (RCRTTS)
    • Course Cross-Listing Table (RCXLTS)
  • Course Equivalency File
    • External Transfer Equivalency Table (REEXTS)
    • Internal Transfer Equivalency Table (REINTS)
    • Course Equivalency Control Table (RERTTS)
  • Course File
    • Course Activity Table (RIACTS)
    • Course AAttributes Table (RIATTS)
    • Course Control Table (RIRTTS)
    • Course Cross-Listing Table (RIXLTS)
  • Course Description File
    • Course Description Control Table (RJRTTS)
    • Course Description Text Table (RJTXTS)
  • Transcript Request File
    • Transcript Request Control Table (RQRTTS)
    • Transcript Text Table (RQTXTS)
  • Summary Stats File
    • Course Term Statistics Control Table (RSRTTS)
    • Course Term Control Information Table (RSSSTS)
  • Student Term File
    • Athlete Term Table (RTAFTS)
    • Student Contracts Table (RTCOTS)
    • Optional Fees Term Table (RTOFTS)
    • Student Term Program Table (RTPGTS)
    • Student Term Control Table (RTRTTS)
    • Student Term Grade Table (RTSPTS)
  • Subtitles File
    • Course Subtitle Control Table (RURTTS)
    • Course Subtitle Table (RUSUTS)
  • Transfer Equivalency File
    • Internal Transfer Credit Table (RVINTS)
    • Internal Transfer Credit Control Table (RVRTTS)
  • Transfer Credit File
    • External Transfer Credit Table (RXEXTS)
    • External Transfer Credit Control Table (RXRTTS)
• Financial Aid Files
  • Attributes File
    • FAM Institutional Budgets Table (SABGTS)
    • FAM Computed Data Table (SACDTS)
    • FAM Family Resources Table (SAFRTS)
    • FAM IRS Table (SAIRTS)
    • FAM Pell Grant Table (SAPGTS)
    • FAM Packaging Table (SAPKTS)
    • FAM Attributes Control Table (SARTTS)
  • Direct Loan Common File (SCRTTS)
  • Direct Loan File
    • Direct Loan Disbursements Detail Table (SDDDTS)
    • Direct Loan General Disbursements Table (SDLDTS)
    • Direct Loan Parent Information Table (SDPLTS)
    • Direct Loan Origination Table (SDRTTS)
  • Financial Aid Fund File
    • FAM Fund Text Notes Table (SFFNTS)
    • FAM Fund Fuscal Year Information Table (SFFYTS)
    • FAM Fun Information Control Table (SFRTTS)
  • Loan File
    • FAM Borrower Table (SGBRTS)
    • FAM Disbursements Table (SGCKTS)
    • FAM Loan ET Table (SGETTS)
    • FAM Student Loan Table (SGLNTS)
    • FAM Student Loan Control Table (SGRTTS)
  • COD Borrower Table
    • FAM COD Borrower Table (SKBRTS)
    • FAM Borrower Control Table
    • Student Locator File
      • FAM Aggregate Aid Table (SLFATS)
      • FAM Aggregate Locator Table (SLFLTS)
      • FAM Transcript Table (SLFTTS)
      • FAM Aggregate Locator Control Table (SLRTTS)
    • Student Loan File
      • Loan ID Table (SNLITS)
      • Promissory Note Table (SNRTTS)
    • OAR Rejects Files
      • OAR Rejects File, Part 1 (SRRTTS)
      • OAR Rejects File, Part 2 (SRR2TS)
    • Student Aid Tracking File
      • FAM Tracking Control Table (STRTTS)
      • FAM Tracking Table Table (STTKTS)
    • Award File
      • FAM Award Summary Table (SWAPTS)
      • FAM Award Disbursement Table (SWDBTS)
      • FAM Award Disbursements Detail Table (SWDDTS)
      • FAM Award Control Table (SWRTTS)
      • FAM Disbursement Transaction Table (SWTRTS)
    • Fiscal Year '94 & Before Tables
      • Institutional Budget Table (S4BGTS)
      • SCT Computed Data Table (S4CDTS)
      • Family Resources Table (S4FRTS)
      • IRS Table (S4IRTS)
      • Pell Table (S4PGTS)
      • Packaging Table (S4PKTS)
      • Student Aid Root Table (S4RTTS)
    • Fiscal Year '95 and After Tables
      • Institutional Budget Table (S5BGTS)
      • SCT Computed Data Table (S5CDTS)
      • Family Resources Table (S5FRTS)
      • IRS Table (S5IRTS)
      • NSLDS EDE Table (S5NETS)
      • NSLDS EDE #2 Table (S5NSTS)
      • Pell Table (S5PGTS)
      • Packaging Table (S5PKTS)
      • Student Aid Root Table (S5RTTS)

  ---

  OIT Applications Support

  
  Last Modified: Wednesday, 16-Jul-2003 10:45:55 CDT

  ©2000 All Rights Reserved