SCT SIS Tables Training

SIS Plus DB2 Tables

AAFILE:Attributes File

AAAPTS: SIS_ACAD_PGM_TB - Academic Program Table

Contains information about student academic programs.

AABSTS: SIS_STU_BILLING_TB - Student Billing Summary Table

Contains information about student billing. This does not conflict with the Billing/Receivables system, but rather contains some basic information related to billing.
SIS 88.1 -- part of BRFILE

AANSTS: SIS_NAME_SORT_TB - Student Name Sort Table

The table name is a bit of a misnomer. The table does contain name information for purposes of sorting reports. But it also contains some other miscellaneous information including some external indicators.
SIFILE "01" record

AARTTS: SIS_STU_ATTR_TB - Student Attributes Table

Includes certain basic information about a student, including birth date, sex, ethnicity, next of kin, etc. It also contains various information flags.
SIFILE "02" record

ACFILE:System Control File

ACRTTS: SIS_CONTROL_TB - SIS Control Tables
Contains the various SIS "non" DB2 tables that control the SIS system. See the copy member ACACRC for a list of the tables contained here.

ADFILE:Address File

ADADTS: SIS_ADDR_DATA_TB - Student Address Table

Contains address information for students and others defined to the SIS system in the AAFILE.
SIFILE "01", "03", "05" records
SIS 88.1 - part of AAFILE

AIFILE:School Index File

AIRTTS: SIS_INSTIT_INDX_TB - External Institution Table

Contains information about the external "school" table. This table, as used by AU, is based on FICE code information.
See AIMS tables HSC and FCx

AJFILE:Job Parameter File

AJKWTS: SIS_JOB_KEYWORD_TB - Batch Job Keyword Table

Contains keyword information for batch program execution.
SIS 88.1 - in SISPRM

AJPVTS: SIS_JOB_PARM_TB - Batch Job Parameter Table

Contains selection parameters for batch program execution.
SIS 88.1 - Defaults in SISPRM

AJRTTS: SIS_JOB_DESC_TB - Batch Job Description Table
Contains miscellaneous values for batch program execution.

AMFILE:Student Miscellaneous File

AMADTS: SIS_ADM_CHANGE_TB - Admissions Change Table
Admissions change information.

AMAUTS: SIS_REG_AUDIT_TB - Registration Audit Table

Audit information about student registration.
STULOG file

AMECTS: SIS_ENRL_RQST_TB - Enrollment Request Table

Enrollment request information.
SIFILE "06" records

AMEMTS: SIS_EMAIL_ADDR_TB - Email Address Table

Student email address information.
GID file (and will stay there)

AMGRTS: SIS_GRADE_CHG_TB - Grade Change Table

Information about student grade changes.
STULOG file

AMHCTS: SIS_STU_HLD_COM_TB - Student Holds Comments Table

Any hold placed on a student can have associated comments. This table contains those comments.
SIS 88.1 - in AAFILE

AMIMTS: SIS_IMMUNIZE_TB - Student Immunization Table
Student immunization information (Polio, Mumps, etc.).

AMTRTS: SIS_TRNSCR_RQST_TB - Transcript Request Table
Information about requests for a student's transcript.

AOFILE:Building/Room Facilities File

AOCOTS: SIS_ROOM_COLL_TB - Classroom Information Table
Contains room information and priorities assigned to those rooms by colleges.

AONOTS: SIS_ROOM_NOTES_TB - Classroom Notes Table
Contains text notes about rooms and room usage.

AORTTS: SIS_BLDG_ROOM_TB - Classroom Capacity Table

Contains room capacity information and accessibility information.
BKFILE

AOSCTS: SIS_ROOM_SPCL_TB - Room Special Conditions Table
Contains special codes indicating special equipment associated with the room.

AOSDTS: SIS_ROOM_DEPT_TB - Departmental Room Table
Contains departmental room prioritization information.

APFILE:Building/Room Posting File

APRTTS: SIS_ROOM_POST_TB - Classroom Posting Table
Control information about room posting.

APUSTS: SIS_ROOM_USAGE_TB - Classroom Usage Table
Information about how a room is to be used. It includes a beginning and ending date, so a room can have multiple usage schedules.

AQFILE:Building/Room Search Parameters

This file contains information about search criteria specified for specific courses. This is used to match and schedule rooms for use.

ARFILE:Calculation Rules File

ARAATS: SIS_ACDMC_RULES_TB - Academic Actions Table

Contains rules for academic actions.
Generally hardcoded in current system

ARADTS: SIS_ADM_RULES_TB - Admissions Rules Table
Contains information about admissions rules. Used for automatic admissions decisions.

ARRTTS: SIS_RTS_AND_RLS_TB - Rules Control Table
Contains control information for other ARFILE tables.

ARSPTS: SIS_SCHED_RULES_TB - Academic Schedule Table
Contains rules about the academic schedule.

ARTRTS: SIS_RATE_TABLES_TB - Rates Table

Contains various rates used by the SIS system.
AIMS FEE table

ATFILE:Temporary Table Storage

ATRTTS: SIS_TABLE_STORE_TB - Temporary Storage Table
Used for temporary storage of SIS tables.

AUFILE:Audit File

AUDTTS: SIS_AUDIT_DETL_TB - Audit Detail Table

The SIS system has the ability to store auditability information about several items. This table contains the detail audit information.
STULOG file

AURTTS: SIS_CORE_AUDIT_TB - Core Audit Table
Contains basic control information about the detail audit records.

AVFILE:SIS Value Translation File

AVRTTS: SIS_AV_TABLE_TB - Value Translations Table

Online value translation table.
SIS 88.1 - in DTFILE
Current system - in various AIMS tables

AYFILE:Faculty File

AYCDTS: SIS_FAC_CO_DEPT_TB - Faculty Organization Table

Contains information about college and department to which faculty members are assigned.
No real counterpart in current system, but some of the information is in the HRS system

AYNTTS: SIS_NON_TEACH_TB - Non-Teaching Activities Table
Information about non-teaching related activities of faculty members.

AYRTTS: SIS_FACULTY_TB - Faculty Information Table
Faculty information (Name, Address, etc.)

BCFILE:BRS Subcode File

BCRTTS: SIS_SUBCD_DESC_TB - Billing Subcodes Table
Contains information about various subcodes used by the Billine/Receivables and Financial Aid modules.

BDFILE:BRS Financial Detail File

BDRTTS: SIS_BILL_DETL_TB - Billing Detail Table
Student billing detail information.

BDTXTS: SIS_BILL_TEXT_TB - Billing Text Table
Free-format text information associated with a student's detailed billing information.

BIFILE:BRS Income Distribution File

BIDSTS: SIS_INCOME_DETL_TB - Income Distribution Detail Table
Detail information about distributiob of monies received in the Billing/Receivables system.

BIRTTS: SIS_INCOME_DSTR_TB - Distribution Control Table
Control information about income distribution.

BMFILE:BRS Cashier File

BMARTS: SIS_CASH_ARCHIV_TB - Cash Received Archive Table
Contains information about actual cash received by the Bursar's Office. The information here no longer represents a "current" time frame.

BMCATS: SIS_CASH_ACTV_TB - Cash Received Table
Contains information about actual cash received by the Bursar's Office. The information here represents a "current" time frame.

BSFILE:BRS Financial Summary File

BSCOTS: SIS_CNTRCT_DETL_TB - Contractor Detail Table
Students can have tuition and fees paid by external parties. This table contains the basic information about who will pay, what will be paid and how much will be paid. This was previously called "third-party billing".

BSRTTS: SIS_FIN_SUMMARY_TB - Financial Summary Table
Contains summary billing information for a student for each term.

DPFILE:On-Course Student Degree Plan FIle

DPCOTS: SIS_COMM_MEMB_TB - Graduate Committee Member Table
Contains information about committee members for students in graduate programs and the degree plan the student is following.

DPCRTS: SIS_DEG_PLN_CRS_TB - Student Degree Plan Table
Information, by term, of the plan the student is following in order to obtain a specific degree.

DPEXTS: SIS_CRS_EXCEPT_TB - Degree Plan Exception Table
Degree plans permit exceptions to be made. This tbale contains information about such exceptions.

DPNTTS: SIS_ADV_NOTES_TB - Degree Plan Notes Table
Text notes from advisors about a student's degree plan.

DPRQTS: SIS_RQMNT_EXCPT_TB - Degree Requirements Exception Table
Besides normal exceptions to a degree plan, there can be exceptions to degree requirements. This table contains information about those exceptions.

DPRTTS: SIS_DEGREE_PLAN_TB - Student Degree Plan Control Table
The table contains the basic and control information about a student's degree plan.

DRFILE:On-Course Degree Requirement FIle

DRITTS: SIS_RQMNT_ITEM_TB - Degree Requirements Table
Student degree plans are built around generalized degree plans. This table contains information about generalized degree plans.

DRRTTS: SIS_DEG_RQMNT_TB - Degree Requirements Control Table
The table contains the basic and control information about a degree plan.

HAFILE:Housing Assignment FIle

HABLTS: SIS_HOUS_BL_TB - Housing Building Table
Not used by AU

HARATS: SIS_ROOM_ASSGN_TB - Housing Room Assignments Table
Not used by AU

HARTTS: SIS_HOUS_ASSGN_TB - Housing Assignments Table
Not used by AU

HCFILE:Housing Control FIle

HCRTTS: SIS_HOUS_CNTRL_TB - Housing Control Table
Not used by AU

HIFILE:Housing Room Inventory File

HIRTTS: SIS_HOUS_INVEN_TB - Housing Inventory Table
Not used by AU

HLFILE:Housing Log File

HLRTTS: SIS_HOUS_LOG_TB - Housing Log Table
Not used by AU

HRFILE:Housing Rate Table File

HRORTS: SIS_OCCUP_RATE_TB - Housing Rates Table
Not used by AU

HRRTTS: SIS_HOUS_RATES_TB - Housing Rates Control Table
Not used by AU

MMFILE:Admissions File

MMAPTS: SIS_APPLICATION_TB - Admission Applicant Information Table

Information about an applicant's admissions application.
SIFILE "02", "04" and "09" records

MMPRTS: SIS_PROSPECT_TB - Admission Prospect Table
Contains information about pre-applicants and prospects for admission.

MMRTTS: SIS_ADM_ATTR_TB - Admission Applicant Attribute Table
Basic information about a person applying for admission.

MMSCTS: SIS_SCROLL_CTL_TB - Admission Control Data
System control data.

MRFILE:Admissions Test Score Rejects File

MTFILE:Admissions Tracking File

MTRTTS: SIS_TRACKING_TB - Admission Tracking Table
Control data for admissions tracking.

MTTRTS: SIS_ADM_TRK_TB - Admission Tracking Control Table
Contains information about tracking of admissions applicants.

RAFILE:Academic Auxiliary File

RACSTS: SIS_CUM_STATS_TB - Student Statistics Table

Basic cumulative stats about a student.
SIFILE "07" record

RADGTS: SIS_DEGREES_AWD_TB - Student Honors Table

Degrees and honors a student has received.
SIFILE "07" and "60" records

RAINTS: SIS_INIT_STATS_TB - Student Initial Statistics Table

Initial stats for a student upon enrollment.
SIFILE "02", "04" and "05" records

RARTTS: SIS_AUX_LOCATOR_TB - Student Control (Locator) Table
Control information about RAFILE tables, i.e., counters of multiply occurring segments in other RAFILE tables.

RBFILE:Basis of Admissions File

RBADTS: SIS_AD_INSTIT_TB - Previous Institutions Table
Information about a student's previous institution.

RBCOTS: SIS_COLL_HIST_TB - Previous Institution History Table
Student's previous institution history, including dates, degrees, GPA, etc.

RBGRTS: SIS_HS_GRADE_TB - High School Grade Table

Student's high school grade information.
SIFILE "04" record

RBGSTS: SIS_GR_SUBJECTS_TB - High School Subjects Detail Table
Student's high school course (subject) information (detail).

RBHSTS: SIS_HS_HISTORY_TB - High School Statistics Table
Student's high school history information, including class rank, GPA, class size, etc.

RBRTTS: SIS_BASIS_ADMIS_TB - Basis of Admissions Control Table
Control information about RBFILE tables, i.e., counters of multiply occurring segments in other RBFILE tables.

RBSUTS: SIS_HS_SUBJECTS_TB - High School Subjects Summary Table
Student's high school subjects taken.

RBTSTS: SIS_ADMIS_TEST_TB - Test Scores Table
Student's test scores (ACT, SAT, etc.).

RCFILE:Course Term File

RCINTS: SIS_INSTRUCTOR_TB - Course Instructor Table
Basic instructor information for a course in a given term.

RCMDTS: SIS_MEETINGS_TB - Course Meeting Days Table

Course "meeting" information for a term, including days when it meets, times, building and room.
BKFILE

RCRTTS: SIS_COURSE_TERM_TB - Course Term Table

Detail information about a course for a given term including counters of multiply occurring segments in other RCFILE tables.
BKFILE

RCXLTS: SIS_CROSS_LIST_TB - Course Cross-Listing Table
Information about how a course for a given term is corss-listed.

REFILE:Course Equivalency File

REEXTS: SIS_EXTR_EQUIV_TB - External Transfer Equivalency Table
Equivalency information about external courses that are used for transfer credit.

REINTS: SIS_INTR_EQUIV_TB - Internal Transfer Equivalency Table
Equivalency information about internal courses that are used for transfer credit.

RERTTS: SIS_CRS_TRNSFR_TB - Course Equivalency Control Table
Control information about multiply occurring segments on other REFILE tables.

RGFILE:Grade Roster File

RGRTTS: SIS_GRADE_RSTR_TB - Course Roster Table

Course roster information.
GRNDX file

RIFILE:Course Inventory File

RIACTS: SIS_CRS_ACTV_TB - Course Activity Table

Course activity information. It contains maximum enrollment, credit hours, etc.
BKFILE

RIATTS: SIS_CRS_ATTR_TB - Course Attributes Table

Course attribute file, containing credit hour information, course title, terms offered, etc.
BKFILE

RIRTTS: SIS_CRS_INVEN_TB - Course Control Table
Control information about multiply occurring segments on other RIFILE tables.

RIXLTS: SIS_CRS_XLIST_TB - Course Cross-Listing Table
Information about courses cross-listed as other courses.

RJFILE:Course Description File

RJRTTS: SIS_CRS_DESC_TB - Course Description Control Table
Control information about a course description.

RJTXTS: SIS_CRS_DSC_TXT_TB - Course Description Text Table

Text information describing a course.
Current SYstem - contained on the web and in the course catalog

RQFILE:Transcript Text File

RQRTTS: SIS_TRNSCR_TEXT_TB - Transcript Request Control Table
Control information about a student's transcript.

RQTXTS: SIS_TRNSCR_LINE_TB - Transcript Text Table
Text information to be printed on a student's transcript.

RSFILE:Summary Statistics File

RSRTTS: SIS_CRS_STATS_TB - Course Term Statistics Table

Course "term statistics" table, i.e., information about a course for a given term, including requests, drops, etc.
BKFILE

RSSSTS: SIS_TERM_STATS_TB - Course Term Control Information
Contains some "subtitle" basic information, i.e., a counter of the number of segments on other RSFILE tables and a last maintenance date.

RTFILE:Student Term File

RTAFTS: SIS_STU_ATH_FLG_TB - Athlete Term Table

Base student athlete information by term.
AWDFILE (but not by term)

RTCOTS: SIS_STU_CNTRCTS_TB - Student "Contracts" Table

Student "contracts" file. Basically this is BRS information concerning parties who have agreed to pay certain tuition and fees for a student (by term).
SIS 88.1 - BPFILE

RTOFTS: SIS_STU_OPT_FEE_TB - Optional Fees Term Table
Contains information, by term, of optional fees assessed a student.

RTPGTS: SIS_STU_PGM_TB - Student Term Program Table

Contains information about a student for a given term, including majors, minors, hours taken, etc.
SIFILE "06" records

RTRTTS: SIS_STU_TERM_TB - Student Term Table
Contains some basic information about a student for a given term. This includes reporting flags, FAM hours, attempted hours, passed hours, term GPA, etc.

RTSPTS: SIS_STU_PGM_ENT_TB - Student Term Grade Table

RUFILE:Subtitles File

RURTTS: SIS_CRS_SUBTTL_TB - Course Subtitle Control Table
Contains some "subtitle" basic information, i.e., a counter of the number of segments on other RUFILE tables and a last maintenance date.

RUSUTS: SIS_SUBTTL_DESC_TB - Course Subtitle Table

Contains "subtitle" information about SIS courses.
BKFILE

RVFILE:Transfer Equivalents File

RVINTS: SIS_INTR_CRS_CR_TB - Internal Transfer Credit Table

Internal student transfer credit information.
TCFILE

RVRTTS: SIS_TRANSFER_EQ_TB - Internal Transfer Credit Control Table
Basic student internal credit information. Contains counters of the number of segments in other RVFILE tables.

RXFILE:Transfer Credit File

RXEXTS: SIS_EXTR_CRS_CR_TB - ExternalTransfer Credit Table

External student transfer credit information.
TCFILE

RXRTTS: SIS_TRANSFER_CR_TB - External Transfer Credit Control Table
Basic student external credit information. Contains counters of the number of segments in other RXFILE tables.

SAFILE:Student Aid File

SABGTS: SIS_INSTIT_BDGT_TB - FAM Institutional Budgets Table

Information about institutional budgets calculated for a student for financial aid calculation.
SIS 88.1 - SAFILE budget segment

SACDTS: SIS_FMLY_R_CALC_TB - FAM Computed Data Table

Information about the family of a student applying for or receiving financial aid. This table contains calculated data.
SIS 88.1 - SAFILE computed data segment

SAFRTS: SIS_FMLY_RESOUR_TB - FAM Family Resources Table

Information about the family of a student applying for or receiving financial aid. This table contains self-reported data.
SIS 88.1 - SAFILE family resources segment

SAIRTS: SIS_STU_AID_IRS_TB - FAM IRS Data

Information about a student and/or a student's family for those applying for or receiving financial aid. Information stored here represents information reported to the Internal Revenue Service.
SIS 88.1 - SAFILE IRS segment

SAPGTS: SIS_PELL_GRANT_TB - FAM Pell Grant Data

Information about a student and/or a student's family for those applying for or receiving financial aid. Information stored here information for Pell Grant determination and processing.
SIS 88.1 - SAFILE Pell segment

SAPKTS: SIS_AID_PACKGNG_TB - FAM Packaging Table

Information about a student and/or a student's family for those applying for or receiving financial aid. Information stored here is used for determination of and packaging of financial aid.
SIS 88.1 - SAFILE packaging segment

SARTTS: SIS_STUDENT_AID_TB - FAM Attributes Control Table

This table contains base information for all other tables associated with the SAFILE. Basically, it contains counters of the number of occurrences of the other SAFILE tables.
SIS 88.1 - SAFILE root segment

SCFILE:Direct Loan Common File

SCRTTS: SIS_DL_COMMAN_TB - Direct Loan Demographic Table
Dirent Loan demographic information.

SDFILE:Direct Loan File

SDDDTS: SIS_DL_DET_DISB_TB - Direct Loan Disbursement Detail Table
Detail disbursement information about student direct loans.

SDLDTS: SIS_DL_LN_DISB_TB - Direct Loan General Disbursement Table
General disbursement information about a student direct loan.

SDPLTS: SIS_DL_PAR_LOAN_TB - Direct Loan Parent Information Table
Direct Loan parent demographic information.

SDRTTS: SIS_DL_LN_ORIG_TB - Direct Loan Origination Table
Student direct loan origination information.

SFFILE:Financial Aid Fund File

SFFNTS: SIS_FUND_NOTE_TB - FAM Fund Text Notes Table

Text notes associated with specific funds.
SIS 88.1 - SFFILE fund note segment

SFFYTS: SIS_FISC_YR_ACT_TB - FAM Funds Fiscal Year Information Table

Basic financial information about funds by fiscal year.
SIS 88.1 - SFFILE fiscal year activity segment

SFRTTS: SIS_FUND_TB - FAM Fund Information Table

Basic information about a particular fund (maximum award, restrictions, donor, etc.).
SIS 88.1 - SFFILE root segment

SGFILE:Loan File

SGCKTS: SIS_STU_PAYMENT_TB - FAM Disbursements Table

Information about checks received for students for loans the student has received as part of their financial aid package.
SIS 88.1 - SGFILE payments segment

SGLNTS: SIS_STU_LOAN_TB - FAM Student Loan Table

Basic information about each loan a student has been offered or has received as part of his/her financial aid package.
SIS 88.1 - SGFILE student loan segment

SGRTTS: SIS_LOAN_TB - FAM Student Loan Control Table

The base table for other SGFILE tables. It contains counters of the number of occurrences of the other tables that are part of the SGFILE.
SIS 88.1 - SGFILE root segment

SLFILE:Student Locator File

SLFATS: SIS_FAM_AGGR_TB - FAM Aggregate Aid Table

Contains aggregate information about each kind of financial aid received by a student, either here at Auburn or elsewhere (if recorded).
SIS 88.1 - SLFILE aggregate segment

SLFLTS: SIS_FAM_LOCATOR_TB - FAM Aggregate Locator Table

Contains basic indicators. These indicators show whether this student has SAFILE, STFILE (tracking) and/or SWFILE (award) records.
SIS 88.1 - SLFILE locator segment

SLFTTS: SIS_FAM_TRNSCR_TB - FAM Transcript Table

Contains information about financial aid transcript requests received by AU.
SIS 88.1 - SGFILE financial aid transcript segment

SLRTTS: SIS_STU_LOCATOR_TB - FAM Locator Control Table

Contains some base "locator" information. This includes entrance and exit interview flags as well as counters for the number of occurrences of other table segments within the SGFILE.
SIS 88.1 - SGFILE root segment

SPFILE:PARS Student Master File

This is not a DB2 table, but is a VSAM file containing information needed and used in the PARS (Packaging and Resource System) process.

STFILE:Student Aid Tracking File

STRTTS: SIS_FAM_STU_AID_TB - FAM Tracking Control Table

Base tracking information. It contains a counter of the number of tracking segments in the other tables composing the STFILE.
SIS 88.1 - STFILE tracking segment

STTKTS: SIS_STU_AID_TRK_TB - FAM Tracking Table

Contains various tracking items for students requesting and/or receiving financial aid.
SIS 88.1 - STFILE root segment

SWFILE:Award File

SWAPTS: SIS_AWD_PERIOD_TB - FAM Award Summary Table

Contains information about aid offered, accepted and/or received by a student.
SIS 88.1 - SWFILE from root segment (award period array)

SWDBTS: SIS_AWD_DISB_TB - FAM Award Disbursement Table

Contains disbursement information for a student receiving financial aid.
SIS 88.1 - SWFILE from root segment (disbursement array)

SWRTTS: SIS_FAM_AWARD_TB - FAM Award Control Information

Basic and control information about a student award.
SIS 88.1 - SWFILE transaction segment

SWTRTS: SIS_AWD_TRAN_TB - FAM Disbursement Transaction Table

Contains disbursement information for a student receiving financial aid. This shows the individual disbursements.
SIS 88.1 - SWFILEfrom root segment (attributes)

Old Student Files

SIS Plus File Cross-Reference

AWDFILE

RTFILE (athlete information)

BKFILE

RCFILE
RIFILE
RJFILE
RSFILE
RUFILE

GRNDX

RGFILE

SIFILE

01 Record

AAFILE
ADFILE

02 Record

AAFILE
MMFILE
RAFILE

03 Record

ADFILE

04 Record

MMFILE
RBFILE

05 Record

ADFILE
RAFILE

06 Record

AMFILE
RTFILE

07 Record

RAFILE

08 Record

AAFILE (handicaped information)

09 Record

AAFILE (information release flags)
ADFILE (telephone area codes)
MMFILE

60 Records

RAFILE

STULOG

AMFILE
AUFILE

TCFILE

REFILE
RVFILE
RXFILE