| FMS |
APDIST |
DISTRIBUTION RECORDS (AUD) |
PV0108.A143200.P40.M3208U |
PDF File |
Current year distribution file. File contains mixed records but retrieval of records is restricted to SUBDBID EQ 'AUD'. The historical file has the same fields as the current file. See APDISTH. |
| FMS |
APDISTH |
ACCOUNTS PAYABLE DISTRIBUTION HISTORY (AHD) |
PV0108.A143200.P40.M3207U |
|
Distribution file history. File contains mixed records but MFD restricts retrieval of records to WHERE SUBDBID EQ 'AHD'. Same fields as in APDIST (Current Distribution file). |
| FMS |
APINV |
INVOICE RECORDS (AUI) |
PV0108.A143200.P40.M3208U |
PDF File |
Current year invoice file. File contains mixed records but retrieval of records is restricted to SUBDBID EQ 'AUI'. The historical file has the same fields as the current file. See APINVH. |
| FMS |
APINVH |
ACCOUNTS PAYABLE INVOICE HISTORY (AHI) |
PV0108.A143200.P40.M3207U |
|
Invoice file history. File contains mixed records but MFD restricts retrieval of records to WHERE SUBDBID EQ 'AHI'. Same fields as in APINV (Current Invoice file). |
| FMS |
COMMODIT |
COMMODITY FILE (AAC) |
PV0108.A143200.P39.PART.PU0360 |
PDF File |
Retrieval is restricted based on DBID = 'AAC'. |
| FMS |
DISTTAPE |
AP DISTRIBUTION ARCHIVE - TAPE |
PN0108.A143200.P40048.P4004806.M01 |
|
This file retains copies of AP distribution and Master File records that have been archived to tape. Use records where the ACTION code is 9. This is a tape dataset. |
| FMS |
FMSGAT |
GRANT ATTRIBUTE TABLE |
PV0108.A143200.P44.GRNTATTR.FMSGAT |
PDF File |
This file contains data on grants and contracts. |
| FMS |
FMSGER |
GL ERROR RECYCLE FILTER FILE |
PV0108.A143200.P44.M3096U |
PDF File |
This file contains GL records that were in error and are in the process of being corrected and resubmitted. |
| FMS |
FMSPEM |
PARS EMPLOYEE MASTER FILE |
PV0108.A143200.P44.PAREMPM.FMSPEM |
PDF File |
This file is used to support regulatory reporting requirements through the generation of the PARS report. This PARS should not be confused with the Personnel Activity Record (PAR) in the Human Resource System. |
| FMS |
FMSSIG |
SIGNATURE AUTHORIZATION FILE |
PV0108.A143200.P44.AUTH.FMSSIG |
PDF File |
|
| FMS |
FMSTEXT |
TEXT FILE (ATA) |
PV0108.A143200.P39.DESC.PU0350 |
PDF File |
Text file contains text associated with various FMS transactions. |
| FMS |
FOCUSPO |
PURCHASE ORDER FILE (FOCUS FORMAT) |
MSO.U772400.P02.FOCUSPO |
PDF File |
This is an extract of the current year's PO BASE, PO LINE, and TEXT databases. This is a single database in native Focus format that includes both parts of the Purchase Order (base and line). This file is updated every friday evening. It can be updated at other times by request. |
| FMS |
GLCURR |
GENERAL LEDGER - CURRENT ACTIVITY |
PV0108.A143200.P44.CURTRN20.GL0043 |
PDF File |
General Ledger master file. Contains all GL activity for current fiscal year. |
| FMS |
GLCURR1 |
PERSONNEL EXTRACT OF CURRENT GL ACTIVITY |
PV0108.A143200.P44.CURTRN.EXTRACT |
|
Personnel Office needs to reconcile benefit data on GL with HRS. Extract includes records that are associated with Personnel Office or benefits. Extract program is run every night. |
| FMS |
GLHIST |
GENERAL LEDGER - HISTORICAL ACTIVITY |
PV0108.A143200.P44.M3252U |
PDF File |
General Ledger master file which contains all GL activity in years prior to the current fiscal year. |
| FMS |
GLHIST1 |
PERSONNEL EXTRACT OF GL HISTORY |
PV0108.A143200.P44.GPH.EXTRACT |
|
Personnel Office needs to reconcile benefit data on GL with HRS. Extract includes records that are associated with Personnel Office or benefits. |
| FMS |
GLMASTER |
GENERAL LEDGER MASTER |
PV0108.A143200.P44.MASTER20.GL0003 |
PDF File |
This is a reformatted GL Master file. See GLCURR. This file has a very complicated structure which has been simplified for easier use. |
| FMS |
INVTAPE |
AP INVOICE ARCHIVE - TAPE |
PN0108.A143200.P40048.P4004806.M01(0) |
|
This file contains archived AP Master File Invoice records that have been archived to tape. Use records where the ACTION code is 1 thru 7. This is a tape dataset. |
| FMS |
ONLNWORK |
ON LINE WORK (OPERATOR FILE - AWO) |
PV0108.A143200.P40.ONLNWRK.AP0200 |
PDF File |
|
| FMS |
PART |
PART FILE (AAP) |
PV0108.A143200.P39.PART.PU0360 |
PDF File |
Retrieval is restricted based on DBID = 'AAP'. |
| FMS |
PERSONL |
PERSONNEL FILE (ACH) |
PV0108.A143200.P39.SYSCTL.PU0001 |
PDF File |
|
| FMS |
POBASE |
PO BASE RECORDS |
PV0108.A143200.P39.POMAST.PU0002 |
PDF File |
Purchase Order Base record. Entire PO file is accessed. Retrieval is restricted based on SUBDBID = 'APB'. Same fields as in POBASEH (History file). |
| FMS |
POBASEH |
PURCHASING ORDER BASE RECORD HISTORY (AHB) |
PV0108.A143200.P39.M3277U |
|
Same fields as in POBASE |
| FMS |
POHIST |
TEXT HISTORY FILE |
PN0100.A143200.P39001.P2X080.M01(0) |
|
Retrieval of records is restricted based on RESTRICT_VAR = APLT or APBT. This is a tape dataset. |
| FMS |
POLINE |
PO LINE RECORDS |
PV0108.A143200.P39.POMAST.PU0002 |
PDF File |
Purchase Order Line record. Entire PO file is accessed. Retrieval is restricted based on SUBDBID = 'APL'. Same fields as in POLINEH (History file). |
| FMS |
POLINEH |
PURCHASING ORDER LINE RECORD HISTORY (AHL) |
PV0108.A143200.P39.M3277U |
|
Same fields as in POLINE |
| FMS |
POVENDOR |
AP VENDOR MASTER FILE |
PV0108.A143200.P40.VENMSTR.AP0001 |
|
|
| FMS |
RECEIVE |
RECEIVING RECORDS (APR) |
PV0108.A143200.P39.POMAST.PU0002 |
PDF File |
|
| FMS |
SCHED10 |
SCHEDULE 10 ROLL-UP STRUCTURE |
MSO.U772400.P02.SCHED10 |
|
This is a reformatting of the schedule 10 structure used to roll-up summary data from the lowest account level up through the VP levels. It is a flat file. There is one record for each base center account which has all of the reporting levels. |
| FMS |
SHIPTO |
SHIP TO/1099/PAYER FILE (ACK) |
PV0108.A143200.P39.SYSCTL.PU0001 |
PDF File |
Retrieval is restricted based on SUBDBID = 'ACK'. |
| FMS |
UNCOMMIT |
UNFULFILLED COMMITMENTS |
PV0108.A143200.P39.COMMIT.PUCOMM |
PDF File |
These are the outstanding transactions that have not been booked but are committed. |
| FMS |
VENDORA |
PURCHASING VENDOR MASTER RECORDS |
PV0108.A143200.P40.VENMSTR.AP0001 |
PDF File |
Purchasing Departments Vendor master file. File contains mixed records but MFD restricts retrieval of records WHERE SEGMENT_ID EQ 'A'. |
| FMS |
VENDORB |
ACCOUNTS PAYABLE VENDOR MASTER RECORDS |
PV0108.A143200.P40.VENMSTR.AP0001 |
PDF File |
Accounts Payable Vendor master file. File contains mixed records but MFD restricts retrieval of records to WHERE SEGMENT_ID EQ 'B'. |
| FMS |
VENDORC |
CURRENT YEAR VENDOR HISTORY (AVC) |
PV0108.A143200.P40.VENMSTR.AP0001 |
PDF File |
Current year vendor history file. File contains mixed records but MFD restricts retrieval of records to WHERE SEGMENT_ID EQ 'C'. |
| FMS |
VENDORD |
PRIOR YEARS VENDOR HISTORY RECORD (AVD) |
PV0108.A143200.P40.VENMSTR.AP0001 |
PDF File |
File contains mixed records but MFD restricts retrieval of records to SEGMENT_ID EQ 'D'. |
| FMS |
VENDORE |
AP BANK RECORDS (AVE) (Not Available) |
PV0108.A143200.P40.VENMSTR.AP0001 |
PDF File |
|
| HRS |
CDBACC |
ACCRUAL TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBBEN |
BENEFITS TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBBUT1 |
BARGAINING UNIT TABLE |
PV0104.A143200.P41.CTLC |
|
File contains the translation of BU codes for each ORG ID. |
| HRS |
CDBCAL1 |
SYSTEM CALENDAR TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBDET |
DATA ELEMENT TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBDPT |
DEPARTMENT TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBEDT |
EDIT CONTROL TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBERN |
EARNING CODE TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBFIT |
FINANCIAL INSTITUTION TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBGTN |
GROSS TO NET TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBJOB |
JOB TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBMSG |
SYSTEM MESSAGES TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBNRA |
|
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBORG |
ORGANIZATION TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBPRM |
SYSTEM PARAMETER TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBPRN |
PRN CONTROL TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBRDT |
REPORT DESCRIPTION TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBREF |
REFERRAL SOURCE TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBSAL |
SALARY CONTROL TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBSDT |
SCREEN DESCRIPTION TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBTABLE |
HRS SYSTEM TABLES |
MSO.U772400.P02.CDBTABLE |
|
This is the companion file to the FOCEDB file. It is a native FOCUS file which contains all of the system tables associated with the HRS system. |
| HRS |
CDBTET |
TAX ENTITY TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBTRT |
TAX RATE TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBVEN |
VENDOR TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CDBWAG |
WAGE TABLE |
PV0104.A143200.P41.CTLC |
|
|
| HRS |
CHGFIL |
CHANGE FILE |
PN0100.A143200.P41008.CHGFILE (NON-HOSPITAL) |
|
The file contains records on specific changes that have been made to the HRS files. |
| HRS |
EDB |
EMPLOYEE DATABASE |
PV0104.A143200.P41.EDBC |
PDF File |
The EDB is the master database for HRS. It is accessed through various combinations of fields (aka views). These are usually named EDB94xx where xx is a number for a view. The EDB is not an extract. It contains actual, up-to-the-minute data. The FOCEDB file is an extract of the EDB and is run every evening. |
| HRS |
EDBDEPT |
DEPARTMENTAL DATA EXTRACT |
|
|
Extract of data from the EDB intended to be used at the departmental level. Companion file is JOBDATA. |
| HRS |
FOCDEPT |
EDB/JOB EXTRACT FOR DEPARTMENTAL ACCESS (NATIVE FOCUS) |
MSO.U772400.P02.FOCDEPT |
|
This is an extract of the EDB and associated files that can be used for departmental access. It is in native FOCUS format and is indexed on EMPLID for quick response. This file is refreshed weekly. |
| HRS |
FOCEDB |
EDB/JOB EXTRACT (IN NATIVE FOCUS FORMAT) |
MSO.U772400.P02.FOCEDB |
PDF File |
This file is an extract of the EDB and associated files. It is in native FOCUS format and is indexed on EMPLID for quick response. This file is refreshed nightly. FOCEDB has cross references to the CDBTABLE file. Both files need to be allocated. Data from the control tables are included so translations of job class and department data are available without having to explicity JOIN the file. |
| HRS |
FOCHDB |
HISTORICAL EMPLOYEE DATABASE |
MSO.U772400.P02.FOCHDB |
PDF File |
This database contains the historical job records of employees. This is a native Focus database with an index on ID. HDBALLOC is a Focexec that will allocate the main file and the cross referenced system tables (Job, Dept,BU). Fields in these system tables may not appear in the dictionary but are available nevertheless. |
| HRS |
JOBDATA |
JOB SEGMENT EXTRACT |
|
|
Extract of Job Segment of EDB. The extract makes it easier to report from the job segment. The extract creates a single record for each unique combination of Job and Distribution account. For example, a person with two jobs where one job has three distribution accounts would have 4 complete records. |
| HRS |
JOBMFD |
JOB EXTRACT |
|
|
|
| HRS |
JOBSGMT |
JOB SEGMENT DATA |
UN0100.racfid.JOBSGMT (where racfid is user i |
|
This extract was created in order to allow easier access to the Job Segment data of the EDB. For each distribution account, for each job, there is a record with root and job segment data duplicated for each distribution ACCOUNT. This extract is created by the JOBSGMT Focexec. This structure optimizes the extraction of job segment data based on distribution account data. See the online HELPFILE entry for more details. |
| HRS |
NEWHIRES |
NEWLY HIRED EMPLOYEES |
PV0104.A143200.P41.NWHIREC |
PDF File |
This file contains newly hired employee data. It is an extract file that is run nightly. |
| HRS |
PAR |
PAYROLL AUDIT RECORD |
PN0100.A143200.P42015.INFabc.FNLPAR |
PDF File |
The PAR file contains details of transactions that have occurred in the HRS that affect the payroll. In the DSNAME, abc = EM1 (Executive Monthly), HW1 (Hospital Weekly), HB1 (Hospital Biweekly), HXX (Hospital Special), UW1 = University Weekly, UM1 = University Monthly, etc. |
| HRS |
PARFOCUS |
EXTRACT OF PAR FILE (NATIVE FOCUS) |
MSO.U772400.P02.PARyyyya |
PDF File |
This is an extract of the PAR file along with data from the system tables. There are a series of these files and each has a separate MFD. The MFD name is PARyyyya where yyyy is the desired year and a is the desired organization. For example, PAR1994U refers to the 1994 PAR records for the University. PAR1994H refers to the 1994 PAR records for the Hospital. |
| HRS |
PARHIST |
PERSONNEL ACTIVITY RECORDS (HISTORICAL) |
PN0100.A143200.P42092.INFHOS.PAYHIST (HOSPITA |
|
|
| HRS |
SUMVERIF |
SUMMER SCHOOL PAYROLL & TUITION VERIFICATION FILE |
|
|
This file contains HRS and FMS data and is used to process summer school pay. |
| HRS |
TERMMSTR |
TERMINATED EMPLOYEES |
PV0104.A143200.P41.TERMSTRC |
|
This file contains data on recently terminated employees. It is an extract file that is run nightly. |
| HRS |
TIME |
TIME REPORTING |
PN0100.A143200.P42083.TMRF(0) |
|
This file is used to record the hours worked by staff who are paid on an hourly basis. |
| ISIS |
ABFMVSAM |
ASSESSMENT/BILLING FORMULA FILE |
PN0100.A143200.P87.TOTAL.ABFM |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
ADDRESS |
STUDENT ADDRESS DATABASE |
MSO.U772400.P02.ADDRESS |
PDF File |
This file is created on a weekly basis. Only the permanent, billing, mailing, and last known address are extracted. A record is created for every student who has been assigned a PIN. This is a native Focus database. |
| ISIS |
ADDRVSAM |
STUDENT ADDRESS DETAIL (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.ADDR |
PDF File |
This file contains one record per address type per student. A student can have any number of address types. This is an online Total file accessed as a VSAM file. |
| ISIS |
ADMFOCUS |
ADMISSIONS - MULTIYEAR FILE |
MSO.U772400.P02.ADMFOCUS |
PDF File |
This file is a native Focus format file and contains one record per admissions applicant per semester. File contains both undergrad and grad admissions data for all admissions semesters beginning in 1990. |
| ISIS |
ADMMVSAM |
ADMISSIONS MASTER FILE |
PN0100.A143200.P87.TOTAL.ADMM |
PDF File |
This file contains one record per admissions applicant This is an online Total file accessed as a VSAM file. It is linked to the admissions transaction file (ATRN), the admissions transfer college file (ATRV), and the admissions requirements file (AREQ). |
| ISIS |
ADMVVSAM |
ADMISSIONS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.ADMV |
PDF File |
This file contains one record per application per student per semester. Each application is identified with a unique sequence number. This is an online Total file accessed as a VSAM file. |
| ISIS |
ALTTERM1 |
TAPE - STERM EXTRACT (FOR DATASETS PRIOR TO 1987) |
PN0100.A143200.P87.P87800.STERM.xxx.SEMyyww |
|
Tape dataset where xxx is BEG, MID, END or FNL and where YYWW is the semester. See ALTTERM2 for datasets after 1986. This extract does not include all address information. 750 byte record. Reports against taped datasets should only be run in batch mode. |
| ISIS |
ALTTERM2 |
TAPE - STERM EXTRACT (FOR DATASETS LATER THAN 1986) |
PN0100.A143200.P87.P87800.STERM.xxx.SEMyyww |
|
Tape dataset where xxx is BEG, MID, END or FNL and where YYWW is the semester. See ALTTERM1 for datasets prior to 1987. This extract contains extensive address info. 2500 byte record. Reports against taped datasets should only be run in batch mode. |
| ISIS |
ARELVSAM |
STUDENT EMERGENCY RELATION FILE |
PN0100.A143200.P87.TOTAL.AREL |
PDF File |
This file contains one record per relationship code per student. This is an online Total file accessed as a VSAM file. |
| ISIS |
AREQVSAM |
ADMISSIONS REQUIREMENTS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TREQ |
|
This file contains one record per requirement code per application per student. Data about each requirement are stored in the record. This is an online Total file accessed as a VSAM file. |
| ISIS |
ATRNVSAM |
APPLICATION ACTIVITY LOG (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.ATRN |
|
This file contains one record per action code per application per student. This is an online Total file accessed as a VSAM file. |
| ISIS |
ATRVVSAM |
ADMISSIONS TRANSFER COLLEGE (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.ATRV |
|
This file contains one record per previous college (transfer instituition) per student. This is an online Total file accessed as a VSAM file. |
| ISIS |
BEDVVSAM |
BED DETAIL FILE |
PN0100.A143200.P87.TOTAL.BEDV |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
CASM |
CASM & CASV CASH REGISTER FILE |
PN0100.A143200.P87.TOTAL.CASM |
|
This file contains one record per terminal ID per user ID per department ID per date. Each record indicates a cashier terminal that was open for processing on the date. This is a Total file that can only be accessed in batch mode. |
| ISIS |
CASMVSAM |
CASHIER MASTER FILE |
PN0100.A143200.P87.TOTAL.CASM |
PDF File |
This file contains one record per terminal ID per user ID per department ID per date. Each record indicates a cashier terminal that was open for processing on the date. This is an online Total file accessed as a VSAM file. It can be linked to the cashier summary file (CASS) and the cashier detail file (CASV). |
| ISIS |
CASSVSAM |
CASHIER SUMMARY FILE |
PN0100.A143200.P87.TOTAL.CASS |
PDF File |
This is a cashier summary report with one record per payment method per session per terminal per user per department per date. Associated with each payment method is the number of payments and the total amount for that payment method. This is an online Total file accessed as a VSAM file. |
| ISIS |
CASVVSAM |
CASHIER DETAIL FILE |
PN0100.A143200.P87.TOTAL.CASV |
PDF File |
There is one record for each unique combination of sequence number, control number, session, terminal, user, department, and date. Each control number can have 1 to 4 records. This file records every transaction at the register of each cashier. This is an online Total file accessed as a VSAM file. |
| ISIS |
CHGDATA |
CREDIT HOUR/SECTION DATA EXTRACT FILE |
MSO.U772400.P02.SECTyyww.XXrundate |
PDF File |
This is an extract of the section file data where yyww is the year and semester week and rundate is the date on which the extract of the extract was created (yymmdd). This file is generated daily during peak periods and weekly just prior to that period and after midsemester. |
| ISIS |
CLASS |
CLASS LIST EXTRACT |
MSO.U772400.P02.fall/spring/sum1/sum2 |
PDF File |
This is an extract of the section extract. It is in native Focus format. The four extracts for all four current semesters are recreated anytime a SECTION extract transmittal is submitted. The COLL and CURR systems tables are crossreferenced by this file and the ISISTABL must be allocated along with the CLASS database. |
| ISIS |
CONTVSAM |
FERPA CONTACT FILE |
PN0100.A143200.P87.TOTAL.CONT |
PDF File |
This file contains up to 4 contacts for a student that has indicated that they waive their FERPA rights. This is an online Total file accessed as a VSAM file. |
| ISIS |
CRSAVSAM |
COURSE CATALOG MASTER FILE |
PN0100.A143200.P87.TOTAL.CRSA |
PDF File |
The file contains one record per course per department. This is an online Total file accessed as a VSAM file. This file can be linked to the catalog detail file (CRSE), the catalog text file (CRSD), the catalog comments file (CRSC), and the course schedule detail file (CSMF). |
| ISIS |
CRSCVSAM |
COURSE CATALOG COMMENT FILE |
PN0100.A143200.P87.TOTAL.CRSC |
|
Each record is a comment line for a specific course for a set of semesters. There is one record per sequence number per effective term per course per department. This is an online Total file accessed as a VSAM file. |
| ISIS |
CRSDVSAM |
COURSE CATALOG TEXT FILE |
PN0100.A143200.P87.TOTAL.CRSD |
PDF File |
Each reocrd is a line of a description of a specific course for a set of semesters. There is one record per sequence number per effective term per course per department. This is an online Total file accessed as a VSAM file. |
| ISIS |
CRSEVSAM |
COURSE CATALOG DETAIL FILE |
PN0100.A143200.P87.TOTAL.CRSE |
PDF File |
This file contains one record per term per course per department. The file contains a great deal of detail about the section. This is an online Total file accessed as a VSAM file. |
| ISIS |
CSMCVSAM |
COURSE SECTION DESIGNATION MASTER FILE |
PN0100.A143200.P87.TOTAL.CSMC |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
CSMDVSAM |
SECTION COMMENT DETAIL (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.CSMD |
|
This file contains one record per sequence number per section per term. This is an online Total file accessed as a VSAM file. |
| ISIS |
CSMFVSAM |
COURSE SCHEDULE DETAIL (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.CSMF |
PDF File |
This file contains course information, one record per section. Each record is uniquely identified with semester and CRN. This is an online Total file accessed as a VSAM file. The contents are purged periodically. The file usually contains current year, one future year, and 2 past years of data. |
| ISIS |
CSTMVSAM |
COURSE SCHEDULE TIME MASTER FILE |
PN0100.A143200.P87.TOTAL.CSTM |
|
This file contains one record per AM/PM indicator per start time per class days per course per department per semester. This is an online Total file accessed as a VSAM file. This file can be linked to the course schedule detail file (CSMF) |
| ISIS |
CXRMVSAM |
CROSS REFERENCE MASTER FILE |
PN0100.A143200.P87.TOTAL.CXRM |
|
This file contains one record per cross reference type per effective semester per course per department. This is an online Total file accessed as a VSAM file. This file can be linked to the course cross reference detail file (CXRV). |
| ISIS |
CXRVVSAM |
CROSS REFERENCE LISTING (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.CXRV |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
DEGREE |
DEGREES AWARDED EXTRACT |
PN0100.A143200.P87749.DEGREE.Yrxxxx |
PDF File |
This is an extract of student data associated with an awarded degree. The file includes some student characteristics at the time when the degree was awarded. Data about the degree are taken from the H2 screen. The file is based on a fiscal year. For example, 9596 in the last part of the file name, refers to degrees awarded between 7/1/95 and 6/30/96. THIS IS A TAPE DATASET AND CAN ONLY BE ACCESSED IN BATCH MODE. |
| ISIS |
DEGRVSAM |
DEGREE BY NUMBER FILE |
PN0100.A143200.P87.TOTAL.DEGR |
PDF File |
This file contains up to 20 degrees sought or awarded to the student. This is an online Total file accessed as a VSAM file. |
| ISIS |
DEPTVSAM |
DEPARTMENT MASTER FILE |
PN0100.A143200.P87.TOTAL.DEPT |
|
This file contains one record per department (I.e., the five character field where the first three characters are the college code and the last two characters are the department. This is an online Total file accessed as a VSAM file. This file can be linked to the department detail file (DEPV). |
| ISIS |
DEPVVSAM |
DEPARTMENT COURSE (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.DEPV |
PDF File |
This file contains one record per course. This is an online Total file accessed as a VSAM file. |
| ISIS |
DGMRVSAM |
DEGREE MASTER FILE |
PN0100.A143200.P87.TOTAL.DGMR |
PDF File |
This file contains one record per degree awarded or sought per student. The record is uniquely identifed by a combination of student id and degree sequence number. The record is added when the degree information is added on the H2 screen. This is an online Total file accessed as a VSAM file. |
| ISIS |
DMSTVSAM |
DIRECT DEPOSIT MASTER FILE |
PN0100.A143200.P87.TOTAL.DMST |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
DORMVSAM |
DORM APPLICATION MASTER FILE |
PN0100.A143200.P87.TOTAL.DORM |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
ECAEVENT |
ECA ROOM SCHEDULING EVENTS |
PV0102.A143200.P08.F4500 |
|
|
| ISIS |
ECAROOMS |
ECA ROOM SCHEDULING ROOMS |
PV0102.A143200.P08.F1100 |
|
|
| ISIS |
ELIGIBLE |
SEMESTER TO SEMESTER REGISTRATION ELIGIBILITY |
MSO.U772400.P02.ELIGIBLE |
PDF File |
These are daily extracts. It uses the latest STERM for the SOURCE semester. The live HOLD, DGMR, and ETRM files are used to gather data on the current status of these students in the TARGET semester. The DGMR (degree) record with the highest associated date is used. The ETRM record in the semesters following the source semester, with the highest date is used to determine the last registration data. |
| ISIS |
ELIGVSAM |
PHONE REGISTRATION ELIGIBILITY |
PN0100.A143200.P87.TOTAL.ELIG |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
ERRSVSAM |
ERROR MESSAGE MASTER FILE |
PN0100.A143200.P87.TOTAL.ERRS |
PDF File |
This file contains one record per error number. This is an online Total file accessed as a VSAM file. |
| ISIS |
ETRM |
ETERM & SFMV (VARIABLE) FILE |
|
PDF File |
|
| ISIS |
ETRMVSAM |
STUDENT REGISTRATION MASTER FILE |
PN0100.A143200.P87.TOTAL.ETRM |
PDF File |
This file contains one record per student per semester (WWYY). This file is purged periodically. This a master file linked to the following variable files: STCR, STRN. SBIL, SFMV This is an online Total file accessed as a VSAM file. This file can be linked to the Student/Course Registration file (STCR), the Student Transaction file (STRN), the Student Course Billing file (SBIL), and the Student Financial Memo file (SFMV). |
| ISIS |
EVNTVSAM |
EVENT FILE |
PN0100.A143200.P87.TOTAL.EVNT |
PDF File |
This file contains one record per event per student. This is an online Total file accessed as a VSAM file. |
| ISIS |
EXCPVSAM |
DARS EXCEPTION (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.EXCP |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
EXEMVSAM |
DARS EXCEPTION MASTER FILE |
PN0100.A143200.P87.TOTAL.EXEM |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
EXEXVSAM |
DARS EXCEPTION PERS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.EXEX |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
FA9899S |
PHEAA NEED ANALYSIS FILE FOR 98/99 |
PN0100.A143200.P87613.NA9899 |
PDF File |
This file allows for the presence of 21 types of funds for each individual who has expressed an interest in Temple U. All of the students on the file may not be Temple students. |
| ISIS |
FAARVSAM |
FINANCIAL AID APPLICATION MASTER FILE |
PN0100.A143200.P87.TOTAL.FAAR |
PDF File |
This is a live ISIS file that stores financial aid data. There is one record per student per semester (YYWW). This is an online Total file accessed as a VSAM file. This file can be linked to the Financial Aid Award detail file (FAWD). |
| ISIS |
FAFRVSAM |
FINANICIAL AID FUND MASTER FILE |
PN0100.A143200.P87.TOTAL.FAFR |
PDF File |
This is a live ISIS file that stores financial aid award data by funding source. There is one record per semester (YYWW) per fund. This is an online Total file accessed as a VSAM file. This file can be linked to the Financial Aid Award Detail file (FAWD) and the Financial Aid Summary file (FAFS). |
| ISIS |
FAFSVSAM |
FINANCIAL AID FUND SUMMARY BY CAMPUS/COLLEGE |
PN0100.A143200.P87.TOTAL.FAFS |
PDF File |
This is a live ISIS file that stores financial aid award data by campus/college. There is one record per college per campus per fund per semester. This is an online Total file accessed as a VSAM file. |
| ISIS |
FAWDVSAM |
FINANCIAL AID AWARDS PER SEMESTER FILE |
PN0100.A143200.P87.TOTAL.FAWD |
PDF File |
This is a live ISIS file that stores financial aid award data per award by semester for each student. Data from this file appear on the F1 screen. This is an online Total file accessed as a VSAM file. |
| ISIS |
FCCAVSAM |
FACULTY DETAIL (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.FCCV |
|
This file contains one record per instructor per section. This is an online Total file accessed as a VSAM file. |
| ISIS |
FCTRVSAM |
FACULTY LOAD DETAIL (VARIABLE) FILE (Not Available) |
PN0100.A143200.P87.TOTAL.FCTR |
|
This file contains one record per instructor per semester. This is an online Total file accessed as a VSAM file. (Not Available) |
| ISIS |
FINAID |
FINANCIAL AID EXTRACT |
PN0100.A143200.p87842.FINAID.EXT |
PDF File |
This file is an extract of information from ISIS and the PHEAA financial aid tape. |
| ISIS |
FOCDEGR |
DEGREES AWARDED (FOCUS FILE) |
MSO.U772400.P02.FOCDEGR |
|
This is an extract of the Degrees Awarded tape files into a single native Focus database. Includes data from July, 1984. |
| ISIS |
FORM |
FORM DESCRIPTION RECORDS |
PN0100.A143200.P87.TOTAL.FORM |
|
Contains a record for every financial transaction that occurs on ISIS. This is a TOTAL file and can only be accessed in batch mode. TOTAL file. Access is restricted to batch mode. |
| ISIS |
FORMHIST |
HISTORY FILE OF ISIS FINANCIAL TRANSACTIONS (Not Available) |
|
|
NOT YET AVAILABLE |
| ISIS |
FORMPERS |
EXTRACT OF FORM & PERS FILE |
UN0100.userracfid.FORMPERS |
|
This file contains data from the FORM and PERS files. This is an extract that the user can initiate from the ISISTAPE process. |
| ISIS |
FORMVSAM |
CONTROL NUMBER MASTER FILE |
PN0100.A143200.P87.TOTAL.FORM |
PDF File |
This file contains one record per payment type per financial transaction per semester (YYWW). This is an online Total file accessed as a VSAM file. |
| ISIS |
FTRMVSAM |
FACULTY MASTER FILE |
PN0100.A143200.P87.TOTAL.FTRM |
|
This file contains one record per faculty ID per semester IYYWW). This is an online Total file accessed as a VSAM file. This file can be linked to the Faculty Detail file (FCCA). |
| ISIS |
GPERSVAM |
ALTERNATE PERS FILE |
PN0100.A143200.P86.TOTAL.GPER |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
HOLDVSAM |
STUDENT HOLD/DELINQUENCY (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.HOLD |
PDF File |
This file contains one record per hold per student. |
| ISIS |
HOUSING |
HOUSING EXTRACT |
PV0102.A143200.P87499.HOUSING.EXTR |
PDF File |
|
| ISIS |
HOUSVSAM |
STUDENT HOUSING (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.HOUS |
PDF File |
This file contains one record per semester that a student resides in a residence hall or dormitory. This is an online Total file accessed as a VSAM file. |
| ISIS |
INSTVSAM |
TRANSFER INSTITUTION MASTER FILE |
PN0100.A143200.P87.TOTAL.INST |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
INTLVSAM |
INTERNATIONAL STUDENT MASTER FILE |
PN0100.A143200.P87.TOTAL.INTL |
PDF File |
This file mirrors the data on the G8 screen and is updated and maintained by International Services. This is an online Total file accessed as a VSAM file. |
| ISIS |
ISIS |
EXTRACT OF FORM & PERS FILE |
|
|
|
| ISIS |
ISISACTI |
ACTIVITY CODE TABLE |
|
|
|
| ISIS |
ISISADDR |
ADDRESS CODE TABLE |
PV0102.A143200.P87.STBLP |
|
Contains information related to address types including the translation of the code and priority of selection. |
| ISIS |
ISISADRR |
APARTMENT ADDRESS TABLE |
PV0102.A143200.P87.STBLP |
|
Contains the address of University apartments. |
| ISIS |
ISISALET |
ADMISSIONS LETTER TABLE |
PV0102.A143200.P87.STBLP |
|
Contains information associated with the admissions letter code which controls the letters sent to applicants informing them of the admissions decision. |
| ISIS |
ISISBLDG |
BUILDING TABLE |
PV0102.A143200.P87.STBLP |
|
Contains information associated with University buildings. |
| ISIS |
ISISCCOM |
COURSE COMMENT TABLE |
PV0102.A143200.P87.STBLP |
|
Contains information associated with course comments. |
| ISIS |
ISISCNTY |
COUNTY TABLE |
PV0102.A143200.P87.STBLP |
|
Contains information related to county code. |
| ISIS |
ISISCOLL |
COLLEGE TABLE |
PV0102.A143200.P87.STBLP |
|
Contains information related to college code. |
| ISIS |
ISISCTRY |
COUNTRY TABLE |
PV0102.A143200.P87.STBLP |
|
Contains translation of country code. |
| ISIS |
ISISCURR |
CURRICULUM CODE TABLE |
MSO.U772400.P02.ISISTABL - Key is CURRICULUM. |
PDF File |
Contains information related to curriculum codes such as associated department, degrees offerred, etc. |
| ISIS |
ISISDEGC |
DEGREE/CERTIFICATE TABLE |
PV0102.A143200.P87.STBLP |
|
Contains information associated with degrees and certificates that are awarded by the University. |
| ISIS |
ISISDEPT |
DEPARTMENT TABLE |
PV0102.A143200.P87.STBLP |
PDF File |
Contains information associated with departments. |
| ISIS |
ISISEVNT |
EVENT TABLE |
|
|
|
| ISIS |
ISISFEES |
FEES TABLE |
PV0102.A143200.P87.STBLP |
|
This table controls the dollar amount associated with fees. |
| ISIS |
ISISFTRN |
ISIS FINANCIAL TRANSACTION SYSTEM TABLE |
PV0102.A143200.P87.STBLP |
|
Controls how financial transactions are handled including how they appear on the bill. |
| ISIS |
ISISGDEG |
ISIS GRADUATE DEGREE TABLE |
Contained in PV0102.A143200.P87.STBLP |
PDF File |
This file is used to translate the three character degree code into a two character graduate degree code. Use DEGREE_CODE (3 characters) and GDEG_CODE (2 characters) in joins. |
| ISIS |
ISISGPRE |
ISIS GRADUATE PROGRAM SYSTEM TABLE |
Contained in PV0102.A143200.P87.STBLP |
PDF File |
This system table translates curriculum and degree information for Graduate students into programs that have been defined by the Graduate Office. Use CURRICULUM and DEGREE_CODE in joins. |
| ISIS |
ISISHIGH |
ISIS HIGH SCHOOL TABLE |
PV0102.A143200.P87.STBLP |
|
|
| ISIS |
ISISHOLD |
ISIS HOLD TABLE |
PV0102.A143200.P87.STBLP |
|
Hold codes control the disabling of services usually due to financial delinquency. Holds can stop registration, transcript and/or graduation services. |
| ISIS |
ISISMAJR |
ISIS MAJOR TABLE |
Contained in PV0102.A143200.P87.STBLP |
PDF File |
This system table contains information on majors and concentrations (as differentiated from curricula and programs). Use CURR_CODE in joins. |
| ISIS |
ISISOFFC |
OFFICE TABLE |
PV0102.A143200.P87.STBLP |
|
Identifies use office associated with activity or information. |
| ISIS |
ISISPAYM |
PAYMENT METHOD SYSTEM TABLE |
PV0102.A143200.P87.STBLP |
|
This file contains the system table data associated with the PAYMENT METHOD. |
| ISIS |
ISISPROG |
PROGRAM/MAJORS TABLE |
PV0102.A143200.P87.STBLP |
|
|
| ISIS |
ISISREGA |
REGISTRATION ACTION TABLE |
PN0100.A143200.P87.TOTAL.REGA |
|
|
| ISIS |
ISISREQC |
REQUIRED COURSE ID TABLE |
PN0100.A143200.P87.TOTAL.REQC |
|
|
| ISIS |
ISISRESH |
RESIDENCE HALL TABLE |
PV0102.A143200.P87.STBLP |
|
|
| ISIS |
ISISSDEG |
SPECIAL DESIGNATION TABLE |
PV0102.A143200.P87.STBLP |
|
Special designation codes identify students for special processing such as billing exceptions, membership in special groups, etc. |
| ISIS |
ISISSEMS |
SEMESTER TABLE |
PN0100.A143200.P87.TOTAL.SEMS |
|
|
| ISIS |
ISISSORC |
ISIS RECRUITMENT SOURCE TABLE |
PV0102.A143200.P87.STBLP |
|
|
| ISIS |
ISISSTAT |
STATE TABLE |
PN0100.A143200.P87.TOTAL.STAT |
|
|
| ISIS |
ISISTABL |
ISIS SYSTEM TABLES - FOCUS DATABASE |
MSO.U772400.P02.ISISTABL |
|
This file contains all of the ISIS system tables. The field definitions are in the individual files for each system table. FOCUS database. |
| ISIS |
ISISTDIS |
TRANSCRIPT DISTRIBUTION TABLE |
PV0102.A143200.P87.STBLP |
|
Controls activities which use the transcript distribution code, usually sorting and distribution of student related reports. |
| ISIS |
ISISTEST |
TEST TABLE |
|
|
|
| ISIS |
ISISTRNC |
ISIS TRANSFER COLLEGE TABLE |
PV0102.A143200.P87.STBLP |
|
|
| ISIS |
ISISXCTR |
ISIS EXTENSION CENTER TABLE |
PV0102.A143200.P87.STBLP |
|
|
| ISIS |
ISISZIPC |
ISIS ZIP CODE TABLE |
PV0102.A143200.P87.STBLP |
|
|
| ISIS |
MAJOR |
CURRICULUM/MAJOR TABLE |
MSO.U772400.P02.ISIS.MAJOR |
PDF File |
This file combines the curriculum, department, and major tables. |
| ISIS |
MSDVVSAM |
MONTHLY STATEMENT DETAIL FILE |
PN0100.A143200.P87.TOTAL.MSDV |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
MSHMVSAM |
MONTHLY STATEMENT HISTORY MASTER FILE |
PN0100.A143200.P87.TOTAL.MSHM |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
NSERVSAM |
NAME SEARCH MASTER RECORD |
PN0100.A143200.P87.TOTAL.NSER |
|
This file contains a record for each unique combination of the first 3 characters of the student last name and their first initial. The record contains no other data and is used for name searches only. This is an online Total file accessed as a VSAM file. This file can be linked to the Name Search detail file (NSRN). |
| ISIS |
NSRNVSAM |
NAME SEARCH (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.NSRN |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
PASTDUE |
MONTHLY PASTDUE RECEIVABLES EXTRACT |
PN0100.A143200.P87462.PASTDUE.DISK |
PDF File |
This file is a montly extract created for the Student Receivables group. Tape dataset is PN0100.A143200.P87462.PASTDUE.EXT. |
| ISIS |
PER2VSAM |
PER2 DATA - FORMER NAME ? |
PN0100.A143200.P87.TOTAL.PER2 |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
PERSDATA |
PERS EXTRACT (NATIVE FOCUS) |
MSO.U772400.P02.PERSDATA |
PDF File |
This file is created as an extract of the PERS Total database. This is a native Focus file. This file is refreshed weekly. |
| ISIS |
PERSVSAM |
PERSON MASTER FILE |
PN0100.A143200.P87.TOTAL.PERS |
PDF File |
This file contains one record per student. This is an online Total file accessed as a VSAM file. This file can be linked to many files including the following: ADDR, DEGR, EVNT, HOLD, HOUS, PROC, QPNO, TCNV, TEST, TMTP, TRIT, YYTT, FCTR, RTRM, ADMV, AREl, etc. |
| ISIS |
PHEAA |
PHEAA ERROR FILE |
PN0100.A143200.P87947.REPT02 |
PDF File |
This file is a PHEAA financial aid error file and contains one record for each student who has an error which prevents their aid package from being processed. |
| ISIS |
PIDMVSAM |
PERSON ID MASTER RECORD |
PN0100.A143200.P87.TOTAL.PIDM |
PDF File |
This file contains one record per student ID. The record contains the Person ID (PERS) which is needed to link with other files. This is an online Total file accessed as a VSAM file. |
| ISIS |
PINVVSAM |
PIN CONTROL NUMBER MASTER RECORD |
PN0100.A143200.P87.TOTAL.PINV |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
PROCVSAM |
PROCEDURAL MEMO DETAIL (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.PROC |
PDF File |
There is one procedural memo per student with up 99 procedural memo records per office. The record is uniquely identified by the sequence number and office code. This is an online Total file accessed as a VSAM file. |
| ISIS |
QPCRVSAM |
QUALIFYING PAPER COMMENTS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.QPRC |
PDF File |
This file contains one record per line of comment or title per qualifying paper per student. Each qualifying paper can have up to 5 title lines and up to 9 comment lines. This is an online Total file accessed as a VSAM file. |
| ISIS |
QPNMVSAM |
QUALIFYING PAPER MASTER RECORD |
PN0100.A143200.P87.TOTAL.QPNM |
PDF File |
This file contains one record per qualifying paper recorded per student. The record is uniquely identified by the ID and qualifying paper sequence number which can be used to point to the DGMR (Degree Master File) record. This is an online Total file accessed as a VSAM file. This file can be linked with the Qualifying Paper Comments file (QPCR). |
| ISIS |
QPNOVSAM |
QUALIFYING PAPER BY NUMBER (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.QPNO |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
REGCANCL |
REGISTRATION CANCELLATION EXTRACT |
PN0100.A143200.P87413.D.REGCNC |
PDF File |
This file is created after each registration cancellation process. It should exist at least 5 days after it is created. |
| ISIS |
REVDATA |
TUITION REVENUE DATABASE |
MSO.U772400.P02.REVyyyy |
PDF File |
This is an extract of the student term and section files and is designed to optimize the reporting of revenue and credit hours. Data can be easily summed on course or student characteristics. YYYY=calendar year. Each file contains BEG, MID, END, and FNL extracts from all semesters within the selected calendar year. |
| ISIS |
ROOMLKUP |
ROOM LOOKUP |
MSO.U772400.P02.ROOMLKUP |
PDF File |
This file is used for room planning purposes and includes limited data on each room. It is indexed on FAMM year. |
| ISIS |
ROOMPLAN |
ROOM PLANNING FILE |
MSO.U772400.P02.ROOMPLAN |
PDF File |
This file contains data on each course including room data useful for planning purposes. It is indexed on SEMESTER. |
| ISIS |
ROOMUTIL |
ROOM UTILIZATION FILE |
MSO.U772400.P02.ROOMUTIL |
PDF File |
This file contains SECTTYP1, ECA, and Fixed Assets data. It is created each semester based on BEG, MID, and END cycles. |
| ISIS |
RSTCVSAM |
REGISTRATION TOTALS MASTER RECORD |
PN0100.A143200.P87.TOTAL.RSTC |
PDF File |
This file contains one record per campus per semester. This is an online Total file accessed as a VSAM file. This file can be linked with the Registration Daily Totals detail file (RSTV). |
| ISIS |
RTRMVSAM |
REGISTRATION TERM (VARIABLE) RECORD |
PN0100.A143200.P87.TOTAL.RTRM |
PDF File |
This file contains one record per semester attended by the student. This is an online Total file accessed as a VSAM file. |
| ISIS |
SBILVSAM |
STUDENT BILLING FILE |
PN0100.A143200.P87.TOTAL.SBIL |
PDF File |
This file contains one record for every type of payment for every financial transaction per student. This is an online Total file accessed as a VSAM file. |
| ISIS |
SECTTYP1 |
SECTION/COMBINED STUDENT EXTRACT - SECTION/COURSE DATA |
PV0102.A143200.P87360.semester.TYPE1 |
PDF File |
Part of the combined/section extract that stores section/course related data. Data retrieval is limited to RECORD_TYPE = '1'. MFD can be used with either the section or combined extract. Semester, in the DSNAME = Spring, Fall, Sum1 or Sum2. This file is periodically refreshed through a transmittal initiated job. PV0102.A143200.P87360.semester.TYPE1 contains future semester data. |
| ISIS |
SECTTYP2 |
SECTION/COMBINED STUDENT EXTRACT - COURSE COMMENTS |
PV0102.A143200.P87360.semester.TYPE2 |
PDF File |
Part of the combined/section extract that stores comments related to sections/courses. Data retrieval is limited to RECORD_TYPE = '2'. MFD can be used with either the section or combined extract. Semester, in the DSNAME = Spring, Fall, Sum1 or Sum2. This file is periodically refreshed through a transmittal initiated job. It contains the most recently extracted data. PV0102.A143200.P87360.semester.TYPE2 contains future semester data. |
| ISIS |
SECTTYP3 |
SECTION/COMBINED STUDENT EXTRACT - FACULTY DATA |
PV0102.A143200.P87360.semester.TYPE3 |
PDF File |
Part of the combined/section extract that stores data related to the instructor of the section. Data retrieval is limited to RECORD_TYPE = '3'. MFD can be used with either the section or combined extract. Semester, in the DSNAME = Spring, Fall, Sum1 or Sum2. This file is periodically refreshed through a transmittal initiated job. It contains the most recently extracted data. PV0102.A143200.P87360.semester.TYPE3 contains future semester data. |
| ISIS |
SECTTYP4 |
COMBINED SECTION/STUDENT EXTRACT - STUDENT DATA |
PV0102.A143200.P87360.semester.TYPE4 |
PDF File |
Part of the combined extract that stores student related data. This record type is not included in the Section files but is included in the Combined files. Data retrieval is limited to RECORD_TYPE = '4'. MFD cannot be used with section extract. Semester, in the DSNAME = Spring, Fall, Sum1 or Sum2. This file is periodically refreshed through a transmittal initiated job. It contains the most recently extracted data. Check with OSIS to find out when the file was last refreshed. |
| ISIS |
SFMVVSAM |
STUDENT FINANCIAL MEMO (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.SFMV |
PDF File |
There is one record for every financial memo for each student per semester. This is an online Total file accessed as a VSAM file. |
| ISIS |
SPEAVSAM |
ADMISSIONS PERMISSION (VARIABLE) |
PN0100.A143200.P87.TOTAL.SPEA |
PDF File |
There is one record for each student for each semester for each application. This file controls access to the student's admission records. This is an online Total file accessed as a VSAM file. |
| ISIS |
SPEEVSAM |
REGISTRATION PERMISSION (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.SPEE |
PDF File |
There is one record for each current and future semeter for which the student has registered. This is an online Total file accessed as a VSAM file. |
| ISIS |
SPERVSAM |
STUDENT PERMISSION MASTER RECORD |
PN0100.A143200.P87.TOTAL.SPER |
|
This file contains one record per student. This file is an online Total file accessed as a VSAM file. This file can link to the Registration Permission file (SPEE), The Academic History Permission file (SPET), and the Admissions Permission file (SPEA). |
| ISIS |
SPETVSAM |
ACADEMIC PERMISSION (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.SPET |
|
There is one record per student who has academic history. This record controls access to the student's academic history. This is an online Total file accessed as a VSAM file. |
| ISIS |
STCRVSAM |
STUDENT/COURSES REGISTRATION (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.STCR |
PDF File |
There is one record for each course for each semester that the student has registered for. This is an online Total file accessed as a VSAM file. This is a variable file and can be linked to the following master files: ETRM (Student Registration), TTCN (Term/Course Reference) |
| ISIS |
STERM |
STUDENT TERM FILE |
PV0102.A143200.P87340.semester.STERM |
PDF File |
Contains student data for students registered in a specific semester. A file exists for each of the four current semesters. Run WHATSEM Focexec to find out when the extract was done and which semesters are online. Semester, in the DSNAME = Spring, Fall, Sum1 or Sum2. This on-line file is periodically refreshed through a transmittal initiated job. It contains the most recently extracted data. Check with ACS to find out when the file was last refreshed. |
| ISIS |
STR3VSAM |
R3 REGISTRATION ACTIVITY |
PN0100.A143200.P87.TOTAL.STRN |
PDF File |
This file is one of the record types in the STRN file. It is used to populate the R3 screen (registration activity log). The file contains one record for each registration event. |
| ISIS |
STRBVSAM |
RB BILLING TRANSACTIONS |
PN0100.A143200.P87.TOTAL.STRN |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
STRNVSAM |
STUDENT TRANSACTION (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.STRN |
|
Record code B4 contains the student's billing data, R3 contains the student's registration log. There is a B4 record for every bill produced for a specific semester. There is an R3 record for each registration transaction. This is an online Total file accessed as a VSAM file. |
| ISIS |
T90VVSAM |
COMMUNICATIONS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.T90V |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
T97VVSAM |
USER PERMISSION (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.T97V |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
T990VSAM |
COMMUNICATIONS MASTER RECORD |
PN0100.A143200.P87.TOTAL.T990 |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
T997VSAM |
DEPARTMENT PERMISSION MASTER RECORD |
PN0100.A143200.P87.TOTAL.T997 |
|
This file contains one record for each department that is authorized to access ISIS data. Each record contains the department password, the transaction permission array, and the student population selection attributes. Each transaction has a fixed spot in the array which is determined by its number on the screen transaction master file (T998). This is an online Total file accessed as a VSAM file. |
| ISIS |
T998VSAM |
SCREEN (TRANSACTION) MASTER RECORD |
PN0100.A143200.P87.TOTAL.T998 |
|
This file contains one record for each transaction screen in the on-line ISIS system. The record contains an active/inactive indicator, along with up to 5 programs that are executed by the screen. This is an online Total file accessed as a VSAM file. |
| ISIS |
TAPETYP1 |
TAPE - SECTION/COMBINED STDNT EXTRACT - SECTION/COURSE DATA |
PN0100.A143200.P87.P87800.SECT.xxx.SEMyyww |
|
Tape dataset where xxx is BEG, MID, END or FNL and where YYWW is the semester. Section extract, type 1 record which includes data on sections and courses. Reports against taped datasets should only be run in batch mode. |
| ISIS |
TAPETYP2 |
TAPE - SECTION/COMBINED STUDENT EXTRACT - COMMENT DATA |
PN0100.A143200.P87.P87800.SECT.xxx.SEMyyww |
|
Tape dataset where xxx is BEG, MID, END or FNL and where YYWW is the semester. Section extract, type 2 record which includes comments related to sections and courses. Reports against taped datasets should only be run in batch mode. |
| ISIS |
TAPETYP3 |
TAPE - SECTION/COMGINED STUDENT EXTRACT - INSTRUCTOR DATA |
PN0100.A143200.P87.P87800.SECT.xxx.SEMyyww |
|
Tape dataset where xxx is BEG, MID, END or FNL and where YYWW is the semester. Section extract, type 3 record which includes instructor data related to sections and courses. Reports against taped datasets should only be run in batch mode. |
| ISIS |
TAPETYP4 |
TAPE - COMBINED SECTION/STUDENT EXTRACT - STUDENT DATA |
PN0100.A143200.P87.P87800.COMB.xxx.SEMyyww |
|
Tape dataset where xxx is BEG, MID, END or FNL and where YYWW is the semester. Combined Student/Section extract, type 4 record which includes student data related to sections and courses. Reports against taped datasets should only be run in batch mode. |
| ISIS |
TCCOVSAM |
TRANSCRIPT COURSE COMMENTS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TCCO |
|
This file contains one record per course taken per semester per student. Each record in uniquely identified within student by semester and sequence number. This is a Total file accessed as a VSAM file. |
| ISIS |
TCKCVSAM |
COURSE LOG (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TCKC |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
TCKNVSAM |
ISIS COURSE/GRADES FILE |
PN0100.A143200.P87.TOTAL.TCKN |
PDF File |
This file contains one record for each course that a student has been assigned a grade. It includes the original and final grades that were award to the student. This is a live TOTAL file that is accessible interactively. |
| ISIS |
TCNVVSAM |
TRANSCRIPT CONVERSION (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TCNV |
|
A CC record contains the student's graduate or undergrad curriculum codes converted from the old transcript file. Record types CD contains the pre-computer matriculation status for each student. This is an online Total file accessed as a VSAM file. |
| ISIS |
TCRSVSAM |
TERM DEPARTMENT COURSE (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TCRS |
|
This file contains one record per course per department per semester. This is an online Total file accessed as a VSAM file. |
| ISIS |
TDEPVSAM |
TERM/DEPARTMENT MASTER RECORD |
PN0100.A143200.P87.TOTAL.TDEP |
|
This file contains one record per department per semester (YYWW). This is an online Total file accessed as a VSAM file. This file can be linked to the Term/Department/Course detail file (TFCN). |
| ISIS |
TERMDATA |
ABBREVIATED STUDENT TERM DATA |
MSO.U772400.P02.TERMyyww |
PDF File |
This file contains a subset of STERM data for multiple reporting periods for a single semester for years since 1989. Multiple files can be concatenated for historical comparisons. |
| ISIS |
TERMVSAM |
STUDENT TERM INFORMATION |
PN0100.A143200.P87.TOTAL.TERM |
PDF File |
This file contains one record for every semester and academic year contained in the Transcript Term Master file (TTRM). This is an online Total file accessed as a VSAM file. |
| ISIS |
TESTVSAM |
STUDENT TEST SCORE INFORMATION |
PN0100.A143200.P87.TOTAL.TEST |
PDF File |
This file contains one record per test score. This is an online Total file accessed as a VSAM file. |
| ISIS |
TFCNVSAM |
COURSE SCHEDULE (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TFCN |
|
This file contains one record per section per course per department per semester. This is an online Total file accessed as a VSAM file. |
| ISIS |
TFCOVSAM |
TERM/DEPARTMENT/COURSE MASTER FILE |
PN0100.A143200.P87.TOTAL.TFCO |
|
This file contains one record per course per department per semester. This is an online Total file accessed as a VSAM file. This file can be linked to the Term/Department/Course detail file (TFCN). |
| ISIS |
TMCMVSAM |
TRANSCRIPT COMMENTS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TMCM |
PDF File |
This file contains one record per comment line per matriculation status per student. There can be up to 99 lines per comment and 99 comments per matric code. This is an online Total file accessed as a VSAM file. |
| ISIS |
TMCSVSAM |
TRANSCRIPT CUM SUMMARY MASTER FILE |
PN0100.A143200.P87.TOTAL.TMCS |
PDF File |
This file contains one record per matric code for which a student has history. Information includes cumulative credit hours and GPA for each matric code. This is an online Total file accessed as a VSAM file. This file can be linked to the Transcript Term detail file (TRTM) and the Transcript Matriculation Comments file (TMCM). |
| ISIS |
TMTPVSAM |
TRANSCRIPT MATRIC DETAIL (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TMTP |
PDF File |
This file contains one record for each matric code for which the student has history. There can be upto 8 matric types. This is an online Total file accessed as a VSAM file. |
| ISIS |
TOTCASH |
EXTRACT OF ISIS CASH AND PERS FILE |
UN0100.userfacfid.TOTCASH |
PDF File |
This file contains data from the CASM, CASV, and PERS files. The oldest 30 days of data are purged at the beginning of each month. NOTE: This file is an extract that the user must create using the ISISTAPE utility. |
| ISIS |
TPPMVSAM |
3RD PARTY BILLING INFORMATION |
PN0100.A143200.P87.TOTAL.TPPM |
PDF File |
This is an online Total file accessed as a VSAM file. |
| ISIS |
TRAEVSAM |
TRANSFER COURSE EQUIVALENCY (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TRAE |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
TRAIVSAM |
TRANSFER COURSE EQUIVALENCY FILE |
PN0100.A143200.P87.TOTAL.TRAI |
PDF File |
|
| ISIS |
TRAMVSAM |
TRANSFER ATTENDANCE PERIOD SUMMARY FILE |
PN0100.A143200.P87.TOTAL.TRAM |
PDF File |
The file contains one record per attendance period per transfer institution per student. Each record contains the credits for the period described by the record. This is an online Total file accessed as a VSAM file. This file can be linked to the Transfer Course Detail file (TRCR). |
| ISIS |
TRCRVSAM |
TRANSFER COURSE DETAIL (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TRCR |
PDF File |
This file contains the course detail of the transfer credit history. This is an online Total file accessed as a VSAM file. |
| ISIS |
TRITVSAM |
TRANSFER INSTITUTION INFORMATION |
PN0100.A143200.P87.TOTAL.TRIT |
PDF File |
This file contains one record for each transfer institution attended by the student. This is an online Total file accessed as a VSAM file. |
| ISIS |
TRTMVSAM |
TRANSCRIPT TERMS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TRTM |
PDF File |
This file contains one record per semester per matric code per student. These three fields can be used to point to the associated records in the TTRM (Transcript Term Master). This is an online Total file accessed as a VSAM file. |
| ISIS |
TTCMVSAM |
TRANSCRIPT TERM COMMENTS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.TTCM |
PDF File |
This file contains one record per comment line per comment per semester per student. |
| ISIS |
TTCNVSAM |
TERM/COURSE REFERENCE MASTER FILE |
PN0100.A143200.P87.TOTAL.TTCN |
|
This file contains one record per section per semester. Each record is uniquely identified by the CRN within semester. This is an online Total file accessed as a VSAM file. This file can be linked with the Course Schedule Detail (CSMF), the Section Comments Detail (CSMD), the Faculty Detail (FCCA), and the Student Course Enrollment Detail (STCR) files. |
| ISIS |
TTRCVSAM |
COURSE LOG MASTER RECORD |
PN0100.A143200.P87.TOTAL.TTRC |
|
This is an online Total file accessed as a VSAM file. |
| ISIS |
TTRMVSAM |
TRANSCRIPT TERM MASTER FILE |
PN0100.A143200.P87.TOTAL.TTRM |
PDF File |
This file contains one record per semester attended per matriculation code per student. A semester is added after grades are processed. The combination of ID and matric code can be used as a link to the Transcript Cumulative Summary file (TMCS) This is an online Total file accessed as a VSAM file. This file can be linked to the Transcript Courses Taken detail file (TCKN) and the Transcript Term Comments file (TTCM). |
| ISIS |
TUEM2 |
FACULTY INFORMATION |
PV0102.A143200.P87.TUEM |
PDF File |
This file contains instructor data that has been brought over from the HRS files. |
| ISIS |
UADMFOC |
ABBREVIATED UNDERGRADUATE ADMISSIONS EXTRACT |
MSO.U772400.P02.UADM(or GADM).semester |
PDF File |
This is an abbreviated extract of the Undergrad Admissions extract. It eliminates fields that are not used in an attempt to reduct the size of the file. In the dataset name, semester = fall, spring. Historical files are in MSO.U772400.P02.UADMHIST.HISTyyww |
| ISIS |
UADMISS |
ADMISSIONS EXTRACT (ON-LINE) |
PV0102.A143200.P87325.UADM (or GADM).semester |
PDF File |
The Undergraduate/Graduate Admissions extract is refreshed periodically. The two files contain only the most recent semesters' data. In the DATASET NAME, semester = Fall or Spring. The undergradate extract is PV0102.A143200.P87325.UADM.semester. The graduate extract is PV0102.A143200.P87325.GADM.semester. |
| ISIS |
UADMTAPE |
ADMISSIONS EXTRACT (TAPE) |
PN0100.A143200.P87803.UADM (or GADM).HISTxxxx |
|
Historical extracts of the Undergraduate/Graduate Admissions date are available on tape as FIXed type files. UADMISS MFD cannot be used with non-VSAM files. In the DATASET NAME, xxxx is the year followed by the semester code (spring = 03, fall = 36) starting with Spring, 1973 (7303). |
| ISIS |
WDRWVSAM |
WITHDRAWAL FILE |
PN0100.A143200.P87.TOTAL.WDRW |
PDF File |
This file contains one record for each course that the student has withdrawn from since 9/1/2003. This is used to prevent a student from withdrawing from a course a second time. This is an online Total file accessed as a VSAM file. |
| ISIS |
YYTTVSAM |
TRANSCRIPT TERMS (VARIABLE) FILE |
PN0100.A143200.P87.TOTAL.YYTT |
|
This is an online Total file accessed as a VSAM file. |
| SRIS |
DISKSRIS |
SRIS FILES |
PV0102.A143200.P86321.UADM.FALL (or SPRING) |
PDF File |
This is an extract of the SRIS database. Use TAPESRIS for data sets on tape and use DISKSRIS for data sets on disk. The dateset name for tape data is PN0100.A143200.P86320.UADM.EXT.xxxx where xxxx is the year and semester. |
| SRIS |
GACAVSAM |
PROSPECT ACADEMIC DATA VARIABLE FILE |
|
|
|
| SRIS |
GCLOVSAM |
|
|
|
|
| SRIS |
GCOMVSAM |
PROSPECT COMMENT VARIABLE FILE |
|
|
|
| SRIS |
GCONVSAM |
SOURCE CONTACT/COUNSELOR FILE |
|
|
|
| SRIS |
GDIRVSAM |
SOURCE TRAVEL DIRECTIONS FILE |
|
|
|
| SRIS |
GMALVSAM |
PROSPECT MAIL VARIABLE FILE |
|
|
|
| SRIS |
GMRQVSAM |
PROSPECT REQUEST VARIABLE FILE |
|
|
|
| SRIS |
GNSVVSAM |
PROSPECT NAME SEARCH MASTER |
|
|
|
| SRIS |
GPERVSAM |
RECRUITMENT PERSON MASTER FILE |
|
|
|
| SRIS |
GPIDVSAM |
PROSPECT ID MASTER RECORD |
|
|
|
| SRIS |
GPROVSAM |
SOURCE YEARLY PROFILE VARIABLE FILE |
|
|
|
| SRIS |
GSORVSAM |
PROSPECT SOURCE/CONTACT VARIABLE FILE |
|
|
|
| SRIS |
GSRCVSAM |
SOURCE MASTER RECORD |
|
|
|
| SRIS |
GTOTVSAM |
SOURCE SEMESTER TOTALS VARIABLE FILE |
|
|
|
| SRIS |
GTSTVSAM |
PROSPECT TEST DATA VARIABLE FILE |
|
|
|
| SRIS |
GVSMVSAM |
SOURCE VISIT MASTER RECORD |
|
|
|
| SRIS |
GVSNVSAM |
SOURCE VISIT CONTROL VARIABLE FILE |
|
|
|
| SRIS |
GVSVVSAM |
SOURCE VISIT COMMENTS FILE |
|
|
|
| SRIS |
TAPESRIS |
SRIS FILES ON TAPE |
PN0100.A143200.P86320.UADM.EXTyyww |
|
This is an extract of the SRIS database for previous semesters. In the dataset name, yy is the year and ww is the week. Use TAPESRIS for data sets on tape and use DISKSRIS for data sets on disk. |
| SRIS |
TRACVSAM |
PROSPECT STUDENT AND INSTITUTION VAR FILE |
|
|
|
| SRIS |
TRAPVSAM |
TRANSFER COURSE EQUIVALENT |
|
|
|
| SRLOG |
FOCCOMM |
SERVICE REQUEST COMMENTS (Not Available) |
PV0103.A143200.P91.SRLOG.COMMENT |
|
This file contains the comment records associated with the Service Request Log records. VSAM |
| SRLOG |
FOCDESCP |
SERVICE REQUEST DESCRIPTION |
PV0103.A143200.P91.SRLOG.DESCP |
|
This file contains the description and justification text for each service request. VSAM |
| SRLOG |
FOCEVENT |
SERVICE REQUEST EVENTS |
PV0103.A143200.P91.SRLOG.EVENT |
|
This file contains events that are associated with the completion of a service request. VSAM |
| SRLOG |
FOCSRLOG |
SERVICE REQUEST LOG |
PV0103.A143200.P91.SRLOG.SRLOG |
|
This file contains data on each service request that is submitted to Administrative Services. VSAM |
| SRLOG |
SRLOG |
SERVICE REQUEST LOG - NATIVE FOCUS FORMAT |
MSO.U772400.P02.SRLOG |
|
This file contains all of the data in the Service Request Log system including event data, general info, and description data. FOCUS |