Microsoft Query(MSQ) is a product that is used with Excel and Access to choose
files from a disk or Server Like the AS400.
MSQ uses AS400 Client Access and ODBC
drivers to connect to the AS400, choose files, sort, use criteria, etc.
to allow
data retrieval with the PC.
Below are some files that have been set up to allow users to download data.
Undergraduate Files: (Field
details are listed below for each file)
|
F_STUDENT |
Active Undergraduate Student File (one record per student) Includes fields such as alpha name, social security number, major, minor, term applied, accepted date |
|
F_HISTORY |
Undergraduate History File (multi records per student) Grade information including social security number, department, course, section, year term |
|
F_MAJOR |
Undergraduate Major File sorted by major code Includes fields such as major code, major name |
|
F_MINOR |
Undergraduate Minor File sorted by minor code Includes fields such as minor code, minor name |
Graduate Files: (Field details
are listed below for each file)
|
F_GRADUATE |
Active Graduate Student File (one record per student) Includes fields such as alpha name, social security number, major, minor, term applied, accepted date |
|
F_GHISTORY |
Graduate History File (multi records per student) Including fields such as social security number, department, course, section, year term |
|
F_GMAJOR |
Graduate Major File sorted by major code Including fields such as major code, major name, |
Other Common Files: (Field
details are listed below for each file)
|
F_ADVISOR |
Advisor Information |
|
F_GEOGRAPH |
State and County Codes Includes fields such as geographic code and name |
|
F_ZCUR1MMM |
Course Information for Semester Includes fields such as section number, department, credit hours, class time, instructor, |
|
F_ZCUR1REM |
Student Course Enrollment Information for Semester |
|
F_NAMEINFO |
Student File for All Students (one record per student) Includes fields such as ID number, name, address, DOB, race Identical to NAME5ZIP file below but home zip code is 9 long |
|
F_NAME5ZIP |
Student File for All Students (one record per student) Includes fields such as ID number, name, address, DOB, race Identical to NAMEINFO file above but home zip code is 5 long |
|
Undergraduate Files: |
|||
|
F_STUDENT: Active Undergraduate Student File
(one record per student) |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_STUDENT |
ACAD COURSE DEFICIEN |
1 |
0 |
|
F_STUDENT |
ACADEMIC RENEW DATE |
5 |
0 |
|
F_STUDENT |
ACCEPTANCE FLAG |
1 |
0 |
|
F_STUDENT |
ACCOUNTING FLAG 1 |
1 |
0 |
|
F_STUDENT |
ACCOUNTING FLAG 2 |
1 |
0 |
|
F_STUDENT |
ACCOUNTING FLAG 3 |
1 |
0 |
|
F_STUDENT |
ACCOUNTING FLAG 4 |
1 |
0 |
|
F_STUDENT |
ACCOUNTING FLAG 5 |
1 |
0 |
|
F_STUDENT |
ACT COMPOSITE |
2 |
0 |
|
F_STUDENT |
ACT ENGLISH |
2 |
0 |
|
F_STUDENT |
ACTMF |
2 |
0 |
|
F_STUDENT |
ADVISOR NUMBER |
3 |
0 |
|
F_STUDENT |
ALPHA NAME |
20 |
0 |
|
F_STUDENT |
ALUMNI FLAG |
1 |
0 |
|
F_STUDENT |
ASSOC. DEG |
1 |
0 |
|
F_STUDENT |
ATH ACTIVE/INACTIVE |
1 |
0 |
|
F_STUDENT |
ATHLETE CODE 1 |
1 |
0 |
|
F_STUDENT |
ATHLETE CODE 2 |
1 |
0 |
|
F_STUDENT |
ATTENDED ORIENTATION
FLA |
1 |
0 |
|
F_STUDENT |
CAMPUS HOUSING FLAG |
1 |
0 |
|
F_STUDENT |
CANCEL DATE |
4 |
0 |
|
F_STUDENT |
CANCELLATION FLAG |
1 |
0 |
|
F_STUDENT |
CAP FLAG 1 |
1 |
0 |
|
F_STUDENT |
CAP SEMESTER |
1 |
0 |
|
F_STUDENT |
CHANGE DATE |
6 |
0 |
|
F_STUDENT |
CLASS |
1 |
0 |
|
F_STUDENT |
COHORT YEAR |
2 |
0 |
|
F_STUDENT |
COL LVL PLACE SCORES |
3 |
0 |
|
F_STUDENT |
COLLATERAL 1 |
4 |
0 |
|
F_STUDENT |
COLLATERAL 2 |
4 |
0 |
|
F_STUDENT |
CON.HI SCORE INDIC |
1 |
0 |
|
F_STUDENT |
CONCURRENT ACC.DATE |
6 |
0 |
|
F_STUDENT |
CONCURRENT H/S FLAG |
1 |
0 |
|
F_STUDENT |
CONCURRENT TERM APP |
3 |
0 |
|
F_STUDENT |
CONTRACT COURSE 1 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 10 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 2 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 3 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 4 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 5 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 6 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 7 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 8 |
1 |
0 |
|
F_STUDENT |
CONTRACT COURSE 9 |
1 |
0 |
|
F_STUDENT |
CONVERTED HI SCORE |
4 |
0 |
|
F_STUDENT |
COURSE 1 |
4 |
0 |
|
F_STUDENT |
COURSE 10 |
4 |
0 |
|
F_STUDENT |
COURSE 2 |
4 |
0 |
|
F_STUDENT |
COURSE 3 |
4 |
0 |
|
F_STUDENT |
COURSE 4 |
4 |
0 |
|
F_STUDENT |
COURSE 5 |
4 |
0 |
|
F_STUDENT |
COURSE 6 |
4 |
0 |
|
F_STUDENT |
COURSE 7 |
4 |
0 |
|
F_STUDENT |
COURSE 8 |
4 |
0 |
|
F_STUDENT |
COURSE 9 |
4 |
0 |
|
F_STUDENT |
CREDIT 1 |
1 |
0 |
|
F_STUDENT |
CREDIT 10 |
1 |
0 |
|
F_STUDENT |
CREDIT 2 |
1 |
0 |
|
F_STUDENT |
CREDIT 3 |
1 |
0 |
|
F_STUDENT |
CREDIT 4 |
1 |
0 |
|
F_STUDENT |
CREDIT 5 |
1 |
0 |
|
F_STUDENT |
CREDIT 6 |
1 |
0 |
|
F_STUDENT |
CREDIT 7 |
1 |
0 |
|
F_STUDENT |
CREDIT 8 |
1 |
0 |
|
F_STUDENT |
CREDIT 9 |
1 |
0 |
|
F_STUDENT |
CUM ATT GROSS HOURS |
3 |
0 |
|
F_STUDENT |
CUM EARNED HRS |
2 |
0 |
|
F_STUDENT |
CUM GPA |
3 |
3 |
|
F_STUDENT |
CUM GRADE POINT |
3 |
1 |
|
F_STUDENT |
CUM GROSS HOURS |
2 |
0 |
|
F_STUDENT |
CUM NET HOURS |
2 |
0 |
|
F_STUDENT |
CURRENT HOURS |
2 |
0 |
|
F_STUDENT |
DEGREE OF PERSUIT 1 |
3 |
0 |
|
F_STUDENT |
DEGREE OF PERSUIT 2 |
3 |
0 |
|
F_STUDENT |
DELETE FLAG |
1 |
0 |
|
F_STUDENT |
DEPARTMENT 1 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 10 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 2 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 3 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 4 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 5 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 6 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 7 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 8 |
4 |
0 |
|
F_STUDENT |
DEPARTMENT 9 |
4 |
0 |
|
F_STUDENT |
DROP DATE 1 |
4 |
0 |
|
F_STUDENT |
DROP DATE 10 |
4 |
0 |
|
F_STUDENT |
DROP DATE 2 |
4 |
0 |
|
F_STUDENT |
DROP DATE 3 |
4 |
0 |
|
F_STUDENT |
DROP DATE 4 |
4 |
0 |
|
F_STUDENT |
DROP DATE 5 |
4 |
0 |
|
F_STUDENT |
DROP DATE 6 |
4 |
0 |
|
F_STUDENT |
DROP DATE 7 |
4 |
0 |
|
F_STUDENT |
DROP DATE 8 |
4 |
0 |
|
F_STUDENT |
DROP DATE 9 |
4 |
0 |
|
F_STUDENT |
DROP/ADD FLAG |
1 |
0 |
|
F_STUDENT |
ENG. PLACE. SCORES |
3 |
0 |
|
F_STUDENT |
EVALUATION FLAG |
1 |
0 |
|
F_STUDENT |
F/A NO CREDIT FLAG |
1 |
0 |
|
F_STUDENT |
FA_STFEH SUB GRD X |
3 |
0 |
|
F_STUDENT |
FIN AID ENT INT |
1 |
0 |
|
F_STUDENT |
FINAL ACCEPT. DATE |
4 |
0 |
|
F_STUDENT |
FLAG 1 |
1 |
0 |
|
F_STUDENT |
FLAG 10 |
1 |
0 |
|
F_STUDENT |
FLAG 2 |
1 |
0 |
|
F_STUDENT |
FLAG 3 |
1 |
0 |
|
F_STUDENT |
FLAG 4 |
1 |
0 |
|
F_STUDENT |
FLAG 5 |
1 |
0 |
|
F_STUDENT |
FLAG 6 |
1 |
0 |
|
F_STUDENT |
FLAG 7 |
1 |
0 |
|
F_STUDENT |
FLAG 8 |
1 |
0 |
|
F_STUDENT |
FLAG 9 |
1 |
0 |
|
F_STUDENT |
FMU ATT GROSS HOURS |
3 |
0 |
|
F_STUDENT |
FMU EARNED HRS |
2 |
0 |
|
F_STUDENT |
FMU GPA |
3 |
3 |
|
F_STUDENT |
FMU GRADE POINT |
3 |
1 |
|
F_STUDENT |
FMU GROSS HOURS |
2 |
0 |
|
F_STUDENT |
FMU NET HOURS |
2 |
0 |
|
F_STUDENT |
FRAT/SOC. CODE |
2 |
0 |
|
F_STUDENT |
FRESH. REQ. COURSES |
1 |
0 |
|
F_STUDENT |
GRADE 1 |
2 |
0 |
|
F_STUDENT |
GRADE 10 |
2 |
0 |
|
F_STUDENT |
GRADE 2 |
2 |
0 |
|
F_STUDENT |
GRADE 3 |
2 |
0 |
|
F_STUDENT |
GRADE 4 |
2 |
0 |
|
F_STUDENT |
GRADE 5 |
2 |
0 |
|
F_STUDENT |
GRADE 6 |
2 |
0 |
|
F_STUDENT |
GRADE 7 |
2 |
0 |
|
F_STUDENT |
GRADE 8 |
2 |
0 |
|
F_STUDENT |
GRADE 9 |
2 |
0 |
|
F_STUDENT |
HIGH SCH. GRAD DATE |
4 |
0 |
|
F_STUDENT |
HIGH SCH. RANK |
3 |
0 |
|
F_STUDENT |
HIGH SCH. SIZE |
3 |
0 |
|
F_STUDENT |
HIGH SCHOOL CODE |
6 |
0 |
|
F_STUDENT |
HIGH SCHOOL GPA |
3 |
3 |
|
F_STUDENT |
HONOR SOC. 1 |
2 |
0 |
|
F_STUDENT |
HONOR SOC. 2 |
2 |
0 |
|
F_STUDENT |
HONOR SOC. 3 |
2 |
0 |
|
F_STUDENT |
HOUSING FLAG |
1 |
0 |
|
F_STUDENT |
HOUSING NUMBER |
3 |
0 |
|
F_STUDENT |
ID NUMBER |
9 |
0 |
|
F_STUDENT |
INFO. CARD PRINT |
1 |
0 |
|
F_STUDENT |
KEY DATE |
4 |
0 |
|
F_STUDENT |
LABEL FLAG |
1 |
0 |
|
F_STUDENT |
LAST TERM ATTENDED |
3 |
0 |
|
F_STUDENT |
LIFE EARNED HOURS COL
1 |
3 |
0 |
|
F_STUDENT |
LIFE EARNED HOURS COL
2 |
3 |
0 |
|
F_STUDENT |
LIFE EARNED HOURS COL
3 |
3 |
0 |
|
F_STUDENT |
LIFE EARNED HOURS COL
4 |
3 |
0 |
|
F_STUDENT |
LIFE EARNED HOURS COL
5 |
3 |
0 |
|
F_STUDENT |
LIFE HOUR COLL 1 |
3 |
0 |
|
F_STUDENT |
LIFE HOUR COLL 2 |
3 |
0 |
|
F_STUDENT |
LIFE HOUR COLL 3 |
3 |
0 |
|
F_STUDENT |
LIFE HOUR COLL 4 |
3 |
0 |
|
F_STUDENT |
LIFE HOUR COLL 5 |
3 |
0 |
|
F_STUDENT |
LIFE QP COLL 1 |
4 |
1 |
|
F_STUDENT |
LIFE QP COLL 2 |
4 |
1 |
|
F_STUDENT |
LIFE QP COLL 3 |
4 |
1 |
|
F_STUDENT |
LIFE QP COLL 4 |
4 |
1 |
|
F_STUDENT |
LIFE QP COLL 5 |
4 |
1 |
|
F_STUDENT |
LIFE SCHOLAR GPA |
3 |
2 |
|
F_STUDENT |
LIFE SCHOLAR HOURS |
5 |
2 |
|
F_STUDENT |
LIFE SCHOLAR YRTR |
5 |
0 |
|
F_STUDENT |
LIMITED HOURS |
1 |
0 |
|
F_STUDENT |
MAJOR |
5 |
0 |
|
F_STUDENT |
MAJOR 2 |
5 |
0 |
|
F_STUDENT |
MATH PLACE SCORES |
3 |
0 |
|
F_STUDENT |
MAX ATTEMPTED HOURS |
3 |
0 |
|
F_STUDENT |
MID/PERM REG. CLEAR |
1 |
0 |
|
F_STUDENT |
MILITARY SCIENCE |
1 |
0 |
|
F_STUDENT |
MINIMUM ACAD. |
1 |
0 |
|
F_STUDENT |
MINOR |
4 |
0 |
|
F_STUDENT |
MINOR 2 |
4 |
0 |
|
F_STUDENT |
MISC FLAG 2 |
1 |
0 |
|
F_STUDENT |
MISC FLAG 3 |
1 |
0 |
|
F_STUDENT |
MISC FLAG 4 |
1 |
0 |
|
F_STUDENT |
MISSING COURSES 1 |
3 |
0 |
|
F_STUDENT |
MISSING COURSES 2 |
3 |
0 |
|
F_STUDENT |
MONITOR FLAG |
1 |
0 |
|
F_STUDENT |
MOST VALUABLE PLAYER |
1 |
0 |
|
F_STUDENT |
NAP FLAG |
1 |
0 |
|
F_STUDENT |
NEW MAJOR |
5 |
0 |
|
F_STUDENT |
NEW STUDENT |
1 |
0 |
|
F_STUDENT |
NEW STUDENT LABEL |
1 |
0 |
|
F_STUDENT |
NEW YRTR |
3 |
0 |
|
F_STUDENT |
NOT USED |
1 |
0 |
|
F_STUDENT |
NOT USED |
1 |
0 |
|
F_STUDENT |
NOT USED |
1 |
0 |
|
F_STUDENT |
NOT USED |
1 |
0 |
|
F_STUDENT |
NOT USED |
2 |
0 |
|
F_STUDENT |
NOT USED |
3 |
0 |
|
F_STUDENT |
NOT USED |
3 |
0 |
|
F_STUDENT |
NOT USED |
4 |
0 |
|
F_STUDENT |
NOT USED |
4 |
0 |
|
F_STUDENT |
NOT USED |
4 |
0 |
|
F_STUDENT |
NOT USED |
4 |
0 |
|
F_STUDENT |
NOT USED |
9 |
0 |
|
F_STUDENT |
NOT USED |
12 |
0 |
|
F_STUDENT |
NOT USED |
27 |
0 |
|
F_STUDENT |
NOT USED |
36 |
0 |
|
F_STUDENT |
NOT USED |
48 |
0 |
|
F_STUDENT |
ON-LINE FLAG |
1 |
0 |
|
F_STUDENT |
ORIENTATION DATE |
6 |
0 |
|
F_STUDENT |
ORIG YEAR TERM |
3 |
0 |
|
F_STUDENT |
ORIGINAL CLASS |
1 |
0 |
|
F_STUDENT |
ORIGINAL TYPE |
1 |
0 |
|
F_STUDENT |
PART/FULL TIME LTA |
1 |
0 |
|
F_STUDENT |
PRE-REG. FALL |
1 |
0 |
|
F_STUDENT |
PRE-REG. LT.SPR |
1 |
0 |
|
F_STUDENT |
PRE-REG. SPRING |
1 |
0 |
|
F_STUDENT |
PRE-REG. SUM I |
1 |
0 |
|
F_STUDENT |
PRE-REG. SUM II |
1 |
0 |
|
F_STUDENT |
PREV COL GPA |
5 |
3 |
|
F_STUDENT |
PREVIOUS COL 5 |
6 |
0 |
|
F_STUDENT |
PREVIOUS COL. 1 |
6 |
0 |
|
F_STUDENT |
PREVIOUS COL. 2 |
6 |
0 |
|
F_STUDENT |
PREVIOUS COL. 3 |
6 |
0 |
|
F_STUDENT |
PREVIOUS COL. 4 |
6 |
0 |
|
F_STUDENT |
PREVIOUS STATUS |
1 |
0 |
|
F_STUDENT |
PRINT FLAG |
1 |
0 |
|
F_STUDENT |
PROGRAM CODE |
4 |
0 |
|
F_STUDENT |
PROGRAM LETTER |
1 |
0 |
|
F_STUDENT |
PROJECTED GPA |
3 |
3 |
|
F_STUDENT |
REG FLAG 100% |
1 |
0 |
|
F_STUDENT |
REG. HOLDS 1 |
1 |
0 |
|
F_STUDENT |
REG. HOLDS 2 |
1 |
0 |
|
F_STUDENT |
REG. HOLDS 3 |
1 |
0 |
|
F_STUDENT |
REG. HOLDS 4 |
1 |
0 |
|
F_STUDENT |
REG. HOLDS 5 |
1 |
0 |
|
F_STUDENT |
REGISTER FLAG |
1 |
0 |
|
F_STUDENT |
REGISTERED FLAG |
1 |
0 |
|
F_STUDENT |
REGISTRATION FLAG 1 |
1 |
0 |
|
F_STUDENT |
REGISTRATION FLAG 2 |
1 |
0 |
|
F_STUDENT |
REGISTRATION FLAG 3 |
1 |
0 |
|
F_STUDENT |
REGISTRATION FLAG 4 |
1 |
0 |
|
F_STUDENT |
REGISTRATION FLAG 5 |
1 |
0 |
|
F_STUDENT |
REGISTRATION STATUS |
1 |
0 |
|
F_STUDENT |
REJECT DATE |
4 |
0 |
|
F_STUDENT |
REJECT FLAG |
1 |
0 |
|
F_STUDENT |
RES CARD FLAG |
1 |
0 |
|
F_STUDENT |
RES. AUDIT |
1 |
0 |
|
F_STUDENT |
RESIDENCE 1 |
1 |
0 |
|
F_STUDENT |
RESIDENCE 2 |
1 |
0 |
|
F_STUDENT |
RETENTION FLAG |
1 |
0 |
|
F_STUDENT |
SAT CHANGE FLAG |
1 |
0 |
|
F_STUDENT |
SAT MATH |
2 |
0 |
|
F_STUDENT |
SAT RECENTERED FLAG |
1 |
0 |
|
F_STUDENT |
SAT TOTAL |
3 |
0 |
|
F_STUDENT |
SAT VERBAL |
2 |
0 |
|
F_STUDENT |
SAT WRITING |
3 |
0 |
|
F_STUDENT |
SATISFACT. PROG. YR |
2 |
0 |
|
F_STUDENT |
SATISFACTORY PROG |
1 |
0 |
|
F_STUDENT |
SECTION 1 |
2 |
0 |
|
F_STUDENT |
SECTION 10 |
2 |
0 |
|
F_STUDENT |
SECTION 2 |
2 |
0 |
|
F_STUDENT |
SECTION 3 |
2 |
0 |
|
F_STUDENT |
SECTION 4 |
2 |
0 |
|
F_STUDENT |
SECTION 5 |
2 |
0 |
|
F_STUDENT |
SECTION 6 |
2 |
0 |
|
F_STUDENT |
SECTION 7 |
2 |
0 |
|
F_STUDENT |
SECTION 8 |
2 |
0 |
|
F_STUDENT |
SECTION 9 |
2 |
0 |
|
F_STUDENT |
SEM EARNED HRS |
2 |
0 |
|
F_STUDENT |
SEM GPA |
3 |
3 |
|
F_STUDENT |
SEM GRADE POINT |
3 |
1 |
|
F_STUDENT |
SEM GROSS HOURS |
2 |
0 |
|
F_STUDENT |
SEM GROSS HRS FALL |
2 |
0 |
|
F_STUDENT |
SEM GROSS HRS SPR |
2 |
0 |
|
F_STUDENT |
SEM NET HOURS |
2 |
0 |
|
F_STUDENT |
SEM NET HRS SPR |
2 |
0 |
|
F_STUDENT |
SEM. NET HRS. FALL |
2 |
0 |
|
F_STUDENT |
SENIOR FLAG |
1 |
0 |
|
F_STUDENT |
SPECIAL REG. FLAG |
1 |
0 |
|
F_STUDENT |
SPECIAL REVIEW |
1 |
0 |
|
F_STUDENT |
SPEECH 101 REQ. FLAG |
1 |
0 |
|
F_STUDENT |
SPRING CUM GPA |
3 |
3 |
|
F_STUDENT |
STANTON PLAN |
1 |
0 |
|
F_STUDENT |
STATUS 1 |
1 |
0 |
|
F_STUDENT |
STATUS 10 |
1 |
0 |
|
F_STUDENT |
STATUS 2 |
1 |
0 |
|
F_STUDENT |
STATUS 3 |
1 |
0 |
|
F_STUDENT |
STATUS 4 |
1 |
0 |
|
F_STUDENT |
STATUS 5 |
1 |
0 |
|
F_STUDENT |
STATUS 6 |
1 |
0 |
|
F_STUDENT |
STATUS 7 |
1 |
0 |
|
F_STUDENT |
STATUS 8 |
1 |
0 |
|
F_STUDENT |
STATUS 9 |
1 |
0 |
|
F_STUDENT |
STUD. EHRS C+ |
2 |
0 |
|
F_STUDENT |
TENT ACCEPT DATE |
4 |
0 |
|
F_STUDENT |
TERM APPLIED |
2 |
0 |
|
F_STUDENT |
TERM ATTENDING - IEI |
7 |
0 |
|
F_STUDENT |
TOEFL SCORE |
3 |
0 |
|
F_STUDENT |
TOTAL SEM. HOURS |
2 |
0 |
|
F_STUDENT |
TRANSFER EARNED HRS |
2 |
0 |
|
F_STUDENT |
TRANSFER EVAL |
1 |
0 |
|
F_STUDENT |
TRANSFER GPA |
3 |
3 |
|
F_STUDENT |
TRANSFER GRADE POINT |
3 |
1 |
|
F_STUDENT |
TRANSFER GROSS HOURS |
2 |
0 |
|
F_STUDENT |
TRANSFER NET HOURS |
2 |
0 |
|
F_STUDENT |
TRANSIENT FLAG |
1 |
0 |
|
F_STUDENT |
TSWE SCORE |
2 |
0 |
|
F_STUDENT |
TYPE |
1 |
0 |
|
F_STUDENT |
VERIFIED HOURS |
2 |
0 |
|
F_STUDENT |
VET FLAG |
1 |
0 |
|
F_STUDENT |
VET FREE TUITION |
1 |
0 |
|
F_STUDENT |
VETERAN FLAG |
1 |
0 |
|
F_STUDENT |
WEEK APPLIED |
2 |
0 |
|
F_STUDENT |
WRIT. PROG. CHANGED |
1 |
0 |
|
F_STUDENT |
WRITING PROF. FLAG |
1 |
0 |
|
F_STUDENT |
YEAR APPLIED |
2 |
0 |
|
F_STUDENT |
YRT ENG. 100R |
3 |
0 |
|
F_STUDENT |
YRT MATH 100R |
3 |
0 |
|
F_HISTORY:
Undergraduate History File (multi records per student) |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_HISTORY |
COURSE |
4 |
0 |
|
F_HISTORY |
CREDIT HOURS |
3 |
1 |
|
F_HISTORY |
DELETE FLAG |
1 |
0 |
|
F_HISTORY |
DEPARTMENT |
4 |
0 |
|
F_HISTORY |
GRADE |
2 |
0 |
|
F_HISTORY |
ID NUMBER |
9 |
0 |
|
F_HISTORY |
NEW GRADE |
2 |
0 |
|
F_HISTORY |
NOT USED |
1 |
0 |
|
F_HISTORY |
NOT USED |
1 |
0 |
|
F_HISTORY |
NOT USED |
1 |
0 |
|
F_HISTORY |
PREVIOUS COLLEGE |
4 |
0 |
|
F_HISTORY |
SECTION |
2 |
0 |
|
F_HISTORY |
SPECIAL DATE |
4 |
0 |
|
F_HISTORY |
STATUS |
1 |
0 |
|
F_HISTORY |
WRITING INTENS FLAG |
1 |
0 |
|
F_HISTORY |
YEAR/TERM CCYYT |
5 |
0 |
|
F_MAJOR:
Undergraduate Major File Sorted by Major Code |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_MAJOR |
ABBREV MAJOR NAME |
20 |
0 |
|
F_MAJOR |
BLANKS |
4 |
0 |
|
F_MAJOR |
CIP CODE |
6 |
0 |
|
F_MAJOR |
CIP SUFFIX |
3 |
0 |
|
F_MAJOR |
DATE CREATED |
4 |
0 |
|
F_MAJOR |
DELETE CODE |
1 |
0 |
|
F_MAJOR |
DELETE DATE |
4 |
0 |
|
F_MAJOR |
FULL MAJOR NAME |
41 |
0 |
|
F_MAJOR |
MAJOR |
5 |
0 |
|
F_MAJOR |
NOT USED |
6 |
0 |
|
F_MAJOR |
SCHOOL CODE |
1 |
0 |
|
F_MAJOR |
SCHOOL NAME |
55 |
0 |
|
F_MINOR: Undergraduate Minor File Sorted by
Minor Code |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_MINOR |
ABBREV MINOR NAME |
20 |
0 |
|
F_MINOR |
DATE CREATED |
4 |
0 |
|
F_MINOR |
DELETE CODE |
1 |
0 |
|
F_MINOR |
DELETE DATE |
4 |
0 |
|
F_MINOR |
FULL MINOR NAME |
41 |
0 |
|
F_MINOR |
MINOR |
4 |
0 |
|
F_MINOR |
NOT USED |
20 |
0 |
|
F_MINOR |
SCHOOL CODE |
1 |
0 |
|
F_MINOR |
SCHOOL NAME |
55 |
0 |
|
GRADUATE FILES: |
|||
|
F_GRADUATE:
Active Graduate Student File (one record per student) |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_GRADUATE |
ACCEPT DATE |
4 |
0 |
|
F_GRADUATE |
ACCOUNTING FLAG 1 |
1 |
0 |
|
F_GRADUATE |
ACCOUNTING FLAG 2 |
1 |
0 |
|
F_GRADUATE |
ACCOUNTING FLAG 3 |
1 |
0 |
|
F_GRADUATE |
ACCOUNTING FLAG 4 |
1 |
0 |
|
F_GRADUATE |
ACCOUNTING FLAG 5 |
1 |
0 |
|
F_GRADUATE |
ADMISSIONS FLAG 1 |
1 |
0 |
|
F_GRADUATE |
ADMISSIONS FLAG 2 |
1 |
0 |
|
F_GRADUATE |
ADMISSIONS FLAG 3 |
1 |
0 |
|
F_GRADUATE |
ADMISSIONS FLAG 4 |
1 |
0 |
|
F_GRADUATE |
ADVISOR NUMBER |
4 |
0 |
|
F_GRADUATE |
ALPHA NAME |
24 |
0 |
|
F_GRADUATE |
ALUMNI FLAG |
1 |
0 |
|
F_GRADUATE |
ANALYTICAL |
3 |
0 |
|
F_GRADUATE |
ATH ACTIVE/INACTIVE |
1 |
0 |
|
F_GRADUATE |
ATHLETE CODE 1 |
1 |
0 |
|
F_GRADUATE |
ATHLETE CODE 2 |
1 |
0 |
|
F_GRADUATE |
CAMPUS HOUSING FLAG |
1 |
0 |
|
F_GRADUATE |
CANDIDACY DATE |
4 |
0 |
|
F_GRADUATE |
CBC |
1 |
0 |
|
F_GRADUATE |
COHORT YEAR |
2 |
0 |
|
F_GRADUATE |
CONTRACT COURSE 1 |
1 |
0 |
|
F_GRADUATE |
CONTRACT COURSE 2 |
1 |
0 |
|
F_GRADUATE |
CONTRACT COURSE 3 |
1 |
0 |
|
F_GRADUATE |
CONTRACT COURSE 4 |
1 |
0 |
|
F_GRADUATE |
CONTRACT COURSE 5 |
1 |
0 |
|
F_GRADUATE |
COURSE 1 |
4 |
0 |
|
F_GRADUATE |
COURSE 2 |
4 |
0 |
|
F_GRADUATE |
COURSE 3 |
4 |
0 |
|
F_GRADUATE |
COURSE 4 |
4 |
0 |
|
F_GRADUATE |
COURSE 5 |
4 |
0 |
|
F_GRADUATE |
CPR |
1 |
0 |
|
F_GRADUATE |
CREDIT 1 |
2 |
0 |
|
F_GRADUATE |
CREDIT 2 |
2 |
0 |
|
F_GRADUATE |
CREDIT 3 |
2 |
0 |
|
F_GRADUATE |
CREDIT 4 |
2 |
0 |
|
F_GRADUATE |
CREDIT 5 |
2 |
0 |
|
F_GRADUATE |
CUM ATT GROSS HOURS |
2 |
0 |
|
F_GRADUATE |
CUM EARNED HRS |
2 |
0 |
|
F_GRADUATE |
CUM GPA |
3 |
3 |
|
F_GRADUATE |
CUM GRADE POINT |
3 |
1 |
|
F_GRADUATE |
CUM GROSS HOURS |
2 |
0 |
|
F_GRADUATE |
CUM NET HOURS |
2 |
0 |
|
F_GRADUATE |
CURR REGISTER FLAG |
1 |
0 |
|
F_GRADUATE |
CURRENT HOURS |
2 |
0 |
|
F_GRADUATE |
DEPARTMENT 1 |
4 |
0 |
|
F_GRADUATE |
DEPARTMENT 2 |
4 |
0 |
|
F_GRADUATE |
DEPARTMENT 3 |
4 |
0 |
|
F_GRADUATE |
DEPARTMENT 4 |
4 |
0 |
|
F_GRADUATE |
DEPARTMENT 5 |
4 |
0 |
|
F_GRADUATE |
DROP DATE 1 |
4 |
0 |
|
F_GRADUATE |
DROP DATE 2 |
4 |
0 |
|
F_GRADUATE |
DROP DATE 3 |
4 |
0 |
|
F_GRADUATE |
DROP DATE 4 |
4 |
0 |
|
F_GRADUATE |
DROP DATE 5 |
4 |
0 |
|
F_GRADUATE |
DROP/ADD FLAG |
1 |
0 |
|
F_GRADUATE |
DS |
1 |
0 |
|
F_GRADUATE |
EARNED HRS |
2 |
0 |
|
F_GRADUATE |
EDPD FLAG |
1 |
0 |
|
F_GRADUATE |
ENDORSEMENTS 1 |
2 |
0 |
|
F_GRADUATE |
ENDORSEMENTS 2 |
2 |
0 |
|
F_GRADUATE |
ENDORSEMENTS 3 |
2 |
0 |
|
F_GRADUATE |
ENDORSEMENTS 4 |
2 |
0 |
|
F_GRADUATE |
F/A NO CREDIT FLAG |
1 |
0 |
|
F_GRADUATE |
FIN ASSIS ENT INT |
1 |
0 |
|
F_GRADUATE |
FLAG 1 |
1 |
0 |
|
F_GRADUATE |
FLAG 2 |
1 |
0 |
|
F_GRADUATE |
FLAG 3 |
1 |
0 |
|
F_GRADUATE |
FLAG 4 |
1 |
0 |
|
F_GRADUATE |
FLAG 5 |
1 |
0 |
|
F_GRADUATE |
FMU ATT GROSS HOURS |
2 |
0 |
|
F_GRADUATE |
FMU EARNED HRS |
2 |
0 |
|
F_GRADUATE |
FMU GPA |
3 |
3 |
|
F_GRADUATE |
FMU GRADE POINT |
3 |
1 |
|
F_GRADUATE |
FMU GROSS HOURS |
2 |
0 |
|
F_GRADUATE |
FMU NET HOURS |
2 |
0 |
|
F_GRADUATE |
GMAT QUAN |
2 |
0 |
|
F_GRADUATE |
GRADE 1 |
2 |
0 |
|
F_GRADUATE |
GRADE 2 |
2 |
0 |
|
F_GRADUATE |
GRADE 3 |
2 |
0 |
|
F_GRADUATE |
GRADE 4 |
2 |
0 |
|
F_GRADUATE |
GRADE 5 |
2 |
0 |
|
F_GRADUATE |
GRADUATE DEGREE |
4 |
0 |
|
F_GRADUATE |
GRADUATE SCHOOL |
20 |
0 |
|
F_GRADUATE |
GRADUATION DATE |
4 |
0 |
|
F_GRADUATE |
GRE - MATH |
2 |
0 |
|
F_GRADUATE |
GRE - TOTAL |
3 |
0 |
|
F_GRADUATE |
GRE - VERBAL |
2 |
0 |
|
F_GRADUATE |
HH |
1 |
0 |
|
F_GRADUATE |
ID NUMBER |
9 |
0 |
|
F_GRADUATE |
IMMUNIZATION CODE |
1 |
0 |
|
F_GRADUATE |
INFO CARD PRINT |
1 |
0 |
|
F_GRADUATE |
KEY DATE |
4 |
0 |
|
F_GRADUATE |
LABEL |
1 |
0 |
|
F_GRADUATE |
LAST TERM ATTENDED |
3 |
0 |
|
F_GRADUATE |
MAX ATTEMPTED HOURS |
2 |
0 |
|
F_GRADUATE |
MILLER ANALOGIES |
3 |
0 |
|
F_GRADUATE |
MOST VALUABLE PLAYER |
1 |
0 |
|
F_GRADUATE |
MPI |
1 |
0 |
|
F_GRADUATE |
NEW FLAG |
1 |
0 |
|
F_GRADUATE |
NEW MAJOR |
4 |
0 |
|
F_GRADUATE |
NEW MAJOR YRT |
3 |
0 |
|
F_GRADUATE |
NON-DEGREE |
2 |
0 |
|
F_GRADUATE |
NOT USED |
1 |
0 |
|
F_GRADUATE |
NOT USED |
1 |
0 |
|
F_GRADUATE |
NOT USED |
1 |
0 |
|
F_GRADUATE |
NOT USED |
1 |
0 |
|
F_GRADUATE |
NOT USED |
4 |
0 |
|
F_GRADUATE |
NOT USED |
4 |
0 |
|
F_GRADUATE |
NOT USED |
5 |
0 |
|
F_GRADUATE |
NOT USED |
5 |
0 |
|
F_GRADUATE |
NOT USED |
10 |
0 |
|
F_GRADUATE |
NOT USED |
11 |
0 |
|
F_GRADUATE |
NOT USED |
22 |
0 |
|
F_GRADUATE |
NOT USED |
25 |
0 |
|
F_GRADUATE |
NOT USED |
28 |
0 |
|
F_GRADUATE |
NOT USED |
29 |
0 |
|
F_GRADUATE |
NOT USED |
32 |
0 |
|
F_GRADUATE |
NOT USED |
43 |
0 |
|
F_GRADUATE |
NTE - COM |
2 |
0 |
|
F_GRADUATE |
NTE - TEACH |
2 |
0 |
|
F_GRADUATE |
NTE - TOTAL |
3 |
0 |
|
F_GRADUATE |
NTE AREA |
2 |
0 |
|
F_GRADUATE |
ON-LINE FLAG |
1 |
0 |
|
F_GRADUATE |
PART/FULL TIME LTA |
1 |
0 |
|
F_GRADUATE |
PRE-REG. FALL |
1 |
0 |
|
F_GRADUATE |
PRE-REG. SPRING |
1 |
0 |
|
F_GRADUATE |
PRE-REG. SUM I |
1 |
0 |
|
F_GRADUATE |
PRE-REG. SUM II |
1 |
0 |
|
F_GRADUATE |
PRE-REG.LATE SPRING |
1 |
0 |
|
F_GRADUATE |
PREVIOUS COL |
18 |
0 |
|
F_GRADUATE |
PREVIOUS COL ADD |
18 |
0 |
|
F_GRADUATE |
PREVIOUS COL STATE |
2 |
0 |
|
F_GRADUATE |
PROBATION DATE |
4 |
0 |
|
F_GRADUATE |
PROBATION FLAG |
1 |
0 |
|
F_GRADUATE |
PROBATION HOURS |
2 |
0 |
|
F_GRADUATE |
PROGRAM LETTER |
1 |
0 |
|
F_GRADUATE |
PROV ACCEPT DATE |
4 |
0 |
|
F_GRADUATE |
REG MATERIAL |
1 |
0 |
|
F_GRADUATE |
REGISTERED FLAG |
1 |
0 |
|
F_GRADUATE |
REGISTRATION FLAG 1 |
1 |
0 |
|
F_GRADUATE |
REGISTRATION FLAG 2 |
1 |
0 |
|
F_GRADUATE |
REGISTRATION FLAG 3 |
1 |
0 |
|
F_GRADUATE |
REGISTRATION FLAG 4 |
1 |
0 |
|
F_GRADUATE |
REGISTRATION FLAG 5 |
1 |
0 |
|
F_GRADUATE |
REGISTRATION STAT |
1 |
0 |
|
F_GRADUATE |
REJECT DATE |
4 |
0 |
|
F_GRADUATE |
RES AUDIT |
1 |
0 |
|
F_GRADUATE |
RES CODE 1 |
1 |
0 |
|
F_GRADUATE |
RESIDENCE 2 |
1 |
0 |
|
F_GRADUATE |
SATIS PROGRESS FLAG |
1 |
0 |
|
F_GRADUATE |
SATIS PROGRESS YEAR |
2 |
0 |
|
F_GRADUATE |
SECTION 1 |
2 |
0 |
|
F_GRADUATE |
SECTION 2 |
2 |
0 |
|
F_GRADUATE |
SECTION 3 |
2 |
0 |
|
F_GRADUATE |
SECTION 4 |
2 |
0 |
|
F_GRADUATE |
SECTION 5 |
2 |
0 |
|
F_GRADUATE |
SEM EARNED HRS |
2 |
0 |
|
F_GRADUATE |
SEM GPA |
3 |
3 |
|
F_GRADUATE |
SEM GRADE POINT |
3 |
1 |
|
F_GRADUATE |
SEM GROSS HOURS |
2 |
0 |
|
F_GRADUATE |
SEM NET HOURS |
2 |
0 |
|
F_GRADUATE |
SENIOR FLAG |
1 |
0 |
|
F_GRADUATE |
SPEC |
2 |
0 |
|
F_GRADUATE |
STATUS |
1 |
0 |
|
F_GRADUATE |
STATUS 1 |
1 |
0 |
|
F_GRADUATE |
STATUS 2 |
1 |
0 |
|
F_GRADUATE |
STATUS 3 |
1 |
0 |
|
F_GRADUATE |
STATUS 4 |
1 |
0 |
|
F_GRADUATE |
STATUS 5 |
1 |
0 |
|
F_GRADUATE |
TAXONOMY CODE |
4 |
0 |
|
F_GRADUATE |
TAXONOMY CODE 2 |
4 |
0 |
|
F_GRADUATE |
TEACHING CARD NO |
6 |
0 |
|
F_GRADUATE |
TERM APPLIED |
2 |
0 |
|
F_GRADUATE |
TOEFL SCORES |
3 |
0 |
|
F_GRADUATE |
TOTAL |
3 |
0 |
|
F_GRADUATE |
TRANSFER EARNED HRS |
2 |
0 |
|
F_GRADUATE |
TRANSFER GPA |
3 |
3 |
|
F_GRADUATE |
TRANSFER GRADE POINT |
3 |
1 |
|
F_GRADUATE |
TRANSFER GROSS
HOUR S |
2 |
0 |
|
F_GRADUATE |
TRANSFER NET HOURS |
2 |
0 |
|
F_GRADUATE |
TYPE |
1 |
0 |
|
F_GRADUATE |
UNDERGRADUATE DEGREE |
4 |
0 |
|
F_GRADUATE |
UNDERGRADUATE MAJOR |
4 |
0 |
|
F_GRADUATE |
VERBAL |
2 |
0 |
|
F_GRADUATE |
VETERAN FLAG |
1 |
0 |
|
F_GHISTORY:
Graduate History File (multi records per student) |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_GHISTORY |
COURSE |
4 |
0 |
|
F_GHISTORY |
CREDIT HOURS |
3 |
1 |
|
F_GHISTORY |
DELETE FLAG |
1 |
0 |
|
F_GHISTORY |
DEPARTMENT |
4 |
0 |
|
F_GHISTORY |
GRADE |
2 |
0 |
|
F_GHISTORY |
ID NUMBER |
9 |
0 |
|
F_GHISTORY |
NEW GRADE |
2 |
0 |
|
F_GHISTORY |
NOT USED |
1 |
0 |
|
F_GHISTORY |
NOT USED |
1 |
0 |
|
F_GHISTORY |
NOT USED |
1 |
0 |
|
F_GHISTORY |
PREVIOUS COLLEGE |
4 |
0 |
|
F_GHISTORY |
SECTION |
2 |
0 |
|
F_GHISTORY |
SPECIAL DATE |
4 |
0 |
|
F_GHISTORY |
STATUS |
1 |
0 |
|
F_GHISTORY |
WRITING INTENS FLAG |
1 |
0 |
|
F_GHISTORY |
YEAR/TERM CCYYT |
5 |
0 |
|
F_GMAJOR:
Graduate Major File Sorted by Major Code |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_GMAJOR |
ABBREV MAJOR NAME |
20 |
0 |
|
F_GMAJOR |
BLANKS |
4 |
0 |
|
F_GMAJOR |
CIP CODE |
6 |
0 |
|
F_GMAJOR |
CIP SUFFIX |
3 |
0 |
|
F_GMAJOR |
DATE CREATED |
4 |
0 |
|
F_GMAJOR |
DELETE CODE |
1 |
0 |
|
F_GMAJOR |
DELETE DATE |
4 |
0 |
|
F_GMAJOR |
FULL MAJOR NAME |
41 |
0 |
|
F_GMAJOR |
NOT USED |
6 |
0 |
|
F_GMAJOR |
PROGRAM LET |
1 |
0 |
|
F_GMAJOR |
SCHOOL CODE |
1 |
0 |
|
F_GMAJOR |
SCHOOL NAME |
55 |
0 |
|
F_GMAJOR |
TAXONOMY CODE |
4 |
0 |
|
Other Common Files: |
|||
|
F_ADVISOR:
Advisor Information |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_ADVISOR |
ADVISOR MAIL NAME |
35 |
0 |
|
F_ADVISOR |
ADVISOR NUMBER |
4 |
0 |
|
F_ADVISOR |
ADVISOR PHONE NUMBER |
7 |
0 |
|
F_ADVISOR |
ADVISOR SORT NAME |
30 |
0 |
|
F_ADVISOR |
ADVISOR SSNO |
9 |
0 |
|
F_ADVISOR |
BUILDING LETTER |
1 |
0 |
|
F_ADVISOR |
BUILDING NAME |
4 |
0 |
|
F_ADVISOR |
BUILDING NUMBER |
3 |
0 |
|
F_ADVISOR |
DELETE FLAG |
1 |
0 |
|
F_GEOGRAPH:
State/County Codes |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_GEOGRAPH |
DELETE CODE |
1 |
0 |
|
F_GEOGRAPH |
GEOGRAPHIC CODE |
4 |
0 |
|
F_GEOGRAPH |
GEOGRAPHIC NAME |
20 |
0 |
|
F_NAMEINFO:
Student File for All Students |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_NAMEINFO |
|
112 |
0 |
|
F_NAMEINFO |
ALPHA NAME |
25 |
0 |
|
F_NAMEINFO |
AMERICAN INDIAN/ALASKA
|
1 |
0 |
|
F_NAMEINFO |
ASIAN FLAG |
1 |
0 |
|
F_NAMEINFO |
ATHELETE HOURS |
2 |
0 |
|
F_NAMEINFO |
BIRTH DATE |
8 |
0 |
|
F_NAMEINFO |
BLACK/AFRICAN AMERICAN
F |
1 |
0 |
|
F_NAMEINFO |
BLANK XX |
9 |
0 |
|
F_NAMEINFO |
BUSINESS PHONE |
10 |
0 |
|
F_NAMEINFO |
CALL NAME |
12 |
0 |
|
F_NAMEINFO |
CHECK SSN FLAG |
1 |
0 |
|
F_NAMEINFO |
CITIZENSHIP CODE |
2 |
0 |
|
F_NAMEINFO |
CITIZENSHIP DATE YMD |
8 |
0 |
|
F_NAMEINFO |
CITIZENSHIP FLAG |
1 |
0 |
|
F_NAMEINFO |
CONTACT ADDRESS 1 |
35 |
0 |
|
F_NAMEINFO |
CONTACT ADDRESS 2 |
35 |
0 |
|
F_NAMEINFO |
CONTACT CITY |
20 |
0 |
|
F_NAMEINFO |
CONTACT NAME |
35 |
0 |
|
F_NAMEINFO |
CONTACT PHONE |
10 |
0 |
|
F_NAMEINFO |
CONTACT RELATIONSHIP |
1 |
0 |
|
F_NAMEINFO |
CONTACT STATE |
2 |
0 |
|
F_NAMEINFO |
CONTACT ZIP |
9 |
0 |
|
F_NAMEINFO |
DECEASED FLAG |
1 |
0 |
|
F_NAMEINFO |
DRIVER LICENSE NUM |
9 |
0 |
|
F_NAMEINFO |
E-MAIL ADDRESS |
40 |
0 |
|
F_NAMEINFO |
FOREIGN COUNTRY |
35 |
0 |
|
F_NAMEINFO |
GENDER |
1 |
0 |
|
F_NAMEINFO |
GEOGRAPHIC CODE |
4 |
0 |
|
F_NAMEINFO |
HISPANIC FLAG |
1 |
0 |
|
F_NAMEINFO |
HISPANIC YN |
1 |
0 |
|
F_NAMEINFO |
HOME ADDRESS 1 |
35 |
0 |
|
F_NAMEINFO |
HOME ADDRESS 2 |
35 |
0 |
|
F_NAMEINFO |
HOME CITY |
20 |
0 |
|
F_NAMEINFO |
HOME PHONE |
10 |
0 |
|
F_NAMEINFO |
HOME STATE |
2 |
0 |
|
F_NAMEINFO |
HOME ZIP |
9 |
0 |
|
F_NAMEINFO |
ID NUMBER |
9 |
0 |
|
F_NAMEINFO |
IMMUNIZATION FLAG |
1 |
0 |
|
F_NAMEINFO |
INSURANCE FLAG |
1 |
0 |
|
F_NAMEINFO |
LOCAL ADDRESS 1 |
35 |
0 |
|
F_NAMEINFO |
LOCAL ADDRESS 2 |
35 |
0 |
|
F_NAMEINFO |
LOCAL CITY |
20 |
0 |
|
F_NAMEINFO |
LOCAL PHONE |
10 |
0 |
|
F_NAMEINFO |
LOCAL STATE |
2 |
0 |
|
F_NAMEINFO |
LOCAL ZIP |
9 |
0 |
|
F_NAMEINFO |
MAIL GRADES FLAG |
1 |
0 |
|
F_NAMEINFO |
MAIL NAME |
35 |
0 |
|
F_NAMEINFO |
MOBILE NUMBER |
10 |
0 |
|
F_NAMEINFO |
NATIVE
HAWAIIAN/PACIFIC I |
1 |
0 |
|
F_NAMEINFO |
NEW SITE LOCATION |
3 |
0 |
|
F_NAMEINFO |
NO MAIL FLAG |
1 |
0 |
|
F_NAMEINFO |
NON-RESIDENT ALIEN |
1 |
0 |
|
F_NAMEINFO |
RACE |
1 |
0 |
|
F_NAMEINFO |
RACE SPARE FLAG |
1 |
0 |
|
F_NAMEINFO |
SEQUITUR FLAG |
1 |
0 |
|
F_NAMEINFO |
SITE LOCATION |
3 |
0 |
|
F_NAMEINFO |
SITE LOCATION YRT |
3 |
0 |
|
F_NAMEINFO |
TITLE |
4 |
0 |
|
F_NAMEINFO |
UNKNOWN FLAG |
1 |
0 |
|
F_NAMEINFO |
VISA CODE |
15 |
0 |
|
F_NAMEINFO |
VISA TYPE |
3 |
0 |
|
F_NAMEINFO |
WHITE FLAG |
1 |
0 |
|
F_NAME5ZIP:
Student File for All Students |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_NAME5ZIP |
|
112 |
0 |
|
F_NAME5ZIP |
ALPHA NAME |
25 |
0 |
|
F_NAME5ZIP |
AMERICAN INDIAN/ALASKA
|
1 |
0 |
|
F_NAME5ZIP |
ASIAN FLAG |
1 |
0 |
|
F_NAME5ZIP |
ATHELETE HOURS |
2 |
0 |
|
F_NAME5ZIP |
BIRTH DATE |
8 |
0 |
|
F_NAME5ZIP |
BLACK/AFRICAN AMERICAN
F |
1 |
0 |
|
F_NAME5ZIP |
BLANK XX |
9 |
0 |
|
F_NAME5ZIP |
BUSINESS PHONE |
10 |
0 |
|
F_NAME5ZIP |
CALL NAME |
12 |
0 |
|
F_NAME5ZIP |
CHECK SSN FLAG |
1 |
0 |
|
F_NAME5ZIP |
CITIZENSHIP CODE |
2 |
0 |
|
F_NAME5ZIP |
CITIZENSHIP DATE YMD |
8 |
0 |
|
F_NAME5ZIP |
CITIZENSHIP FLAG |
1 |
0 |
|
F_NAME5ZIP |
CONTACT ADDRESS 1 |
35 |
0 |
|
F_NAME5ZIP |
CONTACT ADDRESS 2 |
35 |
0 |
|
F_NAME5ZIP |
CONTACT CITY |
20 |
0 |
|
F_NAME5ZIP |
CONTACT NAME |
35 |
0 |
|
F_NAME5ZIP |
CONTACT PHONE |
10 |
0 |
|
F_NAME5ZIP |
CONTACT RELATIONSHIP |
1 |
0 |
|
F_NAME5ZIP |
CONTACT STATE |
2 |
0 |
|
F_NAME5ZIP |
CONTACT ZIP |
9 |
0 |
|
F_NAME5ZIP |
DECEASED FLAG |
1 |
0 |
|
F_NAME5ZIP |
DRIVER LICENSE NUM |
9 |
0 |
|
F_NAME5ZIP |
E-MAIL ADDRESS |
40 |
0 |
|
F_NAME5ZIP |
FOREIGN COUNTRY |
35 |
0 |
|
F_NAME5ZIP |
GENDER |
1 |
0 |
|
F_NAME5ZIP |
GEOGRAPHIC CODE |
4 |
0 |
|
F_NAME5ZIP |
HISPANIC FLAG |
1 |
0 |
|
F_NAME5ZIP |
HISPANIC YN |
1 |
0 |
|
F_NAME5ZIP |
HOME ADDRESS 1 |
35 |
0 |
|
F_NAME5ZIP |
HOME ADDRESS 2 |
35 |
0 |
|
F_NAME5ZIP |
HOME CITY |
20 |
0 |
|
F_NAME5ZIP |
HOME PHONE |
10 |
0 |
|
F_NAME5ZIP |
HOME STATE |
2 |
0 |
|
F_NAME5ZIP |
HOME ZIP |
5 |
0 |
|
F_NAME5ZIP |
HOME ZIPE |
4 |
0 |
|
F_NAME5ZIP |
ID NUMBER |
9 |
0 |
|
F_NAME5ZIP |
IMMUNIZATION FLAG |
1 |
0 |
|
F_NAME5ZIP |
INSURANCE FLAG |
1 |
0 |
|
F_NAME5ZIP |
LOCAL ADDRESS 1 |
35 |
0 |
|
F_NAME5ZIP |
LOCAL ADDRESS 2 |
35 |
0 |
|
F_NAME5ZIP |
LOCAL CITY |
20 |
0 |
|
F_NAME5ZIP |
LOCAL PHONE |
10 |
0 |
|
F_NAME5ZIP |
LOCAL STATE |
2 |
0 |
|
F_NAME5ZIP |
LOCAL ZIP |
9 |
0 |
|
F_NAME5ZIP |
MAIL GRADES FLAG |
1 |
0 |
|
F_NAME5ZIP |
MAIL NAME |
35 |
0 |
|
F_NAME5ZIP |
MOBILE NUMBER |
10 |
0 |
|
F_NAME5ZIP |
NATIVE
HAWAIIAN/PACIFIC I |
1 |
0 |
|
F_NAME5ZIP |
NEW SITE LOCATION |
3 |
0 |
|
F_NAME5ZIP |
NO MAIL FLAG |
1 |
0 |
|
F_NAME5ZIP |
NON-RESIDENT ALIEN |
1 |
0 |
|
F_NAME5ZIP |
RACE |
1 |
0 |
|
F_NAME5ZIP |
RACE SPARE FLAG |
1 |
0 |
|
F_NAME5ZIP |
SEQUITUR FLAG |
1 |
0 |
|
F_NAME5ZIP |
SITE LOCATION |
3 |
0 |
|
F_NAME5ZIP |
SITE LOCATION YRT |
3 |
0 |
|
F_NAME5ZIP |
TITLE |
4 |
0 |
|
F_NAME5ZIP |
UNKNOWN FLAG |
1 |
0 |
|
F_NAME5ZIP |
VISA CODE |
15 |
0 |
|
F_NAME5ZIP |
VISA TYPE |
3 |
0 |
|
F_NAME5ZIP |
WHITE FLAG |
1 |
0 |
|
F_ZCUR1MMM:
Course Information for Semester |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_ZCUR1MMM |
|
1 |
0 |
|
F_ZCUR1MMM |
|
31 |
0 |
|
F_ZCUR1MMM |
|
31 |
0 |
|
F_ZCUR1MMM |
ACTUAL SEATS |
4 |
0 |
|
F_ZCUR1MMM |
BEGINNING DATE |
4 |
0 |
|
F_ZCUR1MMM |
BUILDING |
4 |
0 |
|
F_ZCUR1MMM |
COMPUTER FEE |
4 |
0 |
|
F_ZCUR1MMM |
CONTR L CARD |
1 |
0 |
|
F_ZCUR1MMM |
CONTRACT COURSE |
1 |
0 |
|
F_ZCUR1MMM |
CONTRACT HOURS |
3 |
0 |
|
F_ZCUR1MMM |
COURSE NUMBER |
3 |
0 |
|
F_ZCUR1MMM |
COURSE TITLE |
24 |
0 |
|
F_ZCUR1MMM |
CREDIT HOURS |
2 |
0 |
|
F_ZCUR1MMM |
CROSS LISTED COURSE |
1 |
0 |
|
F_ZCUR1MMM |
DAYS CLASS MEETS |
6 |
0 |
|
F_ZCUR1MMM |
DELETE FLAG |
1 |
0 |
|
F_ZCUR1MMM |
DEPTARTMENT |
4 |
0 |
|
F_ZCUR1MMM |
DONT USE |
1 |
0 |
|
F_ZCUR1MMM |
ENDING AM PM |
1 |
0 |
|
F_ZCUR1MMM |
ENDING DATE |
4 |
0 |
|
F_ZCUR1MMM |
ENDING TIME |
4 |
0 |
|
F_ZCUR1MMM |
ENG LIT WRITE FLAG |
1 |
0 |
|
F_ZCUR1MMM |
FINE ARTS FEE |
4 |
0 |
|
F_ZCUR1MMM |
FRESHMAN ONLY |
1 |
0 |
|
F_ZCUR1MMM |
FULL CHAG AUDITS |
1 |
0 |
|
F_ZCUR1MMM |
GRADUATE FLAG |
1 |
0 |
|
F_ZCUR1MMM |
INSTRUCTOR |
18 |
0 |
|
F_ZCUR1MMM |
INSTRUCTOR NUM 1 |
5 |
0 |
|
F_ZCUR1MMM |
INSTRUCTOR NUM 2 |
5 |
0 |
|
F_ZCUR1MMM |
INSTRUCTOR NUM 3 |
5 |
0 |
|
F_ZCUR1MMM |
INSTRUCTOR PER 1 |
2 |
0 |
|
F_ZCUR1MMM |
INSTRUCTOR PER 2 |
2 |
0 |
|
F_ZCUR1MMM |
INSTRUCTOR PER 3 |
2 |
0 |
|
F_ZCUR1MMM |
LAB ASSOC COURSE |
4 |
0 |
|
F_ZCUR1MMM |
LAB ASSOC DEPT |
4 |
0 |
|
F_ZCUR1MMM |
LAB ASSOC SECTION |
2 |
0 |
|
F_ZCUR1MMM |
LAB INDICATOR |
1 |
0 |
|
F_ZCUR1MMM |
MAXIMUM SEATS |
4 |
0 |
|
F_ZCUR1MMM |
MUSIC FEE |
4 |
0 |
|
F_ZCUR1MMM |
NUMBER GRAD LEVEL |
4 |
0 |
|
F_ZCUR1MMM |
NUMBER LOWER LEVEL |
4 |
0 |
|
F_ZCUR1MMM |
NUMBER OF AUDITS |
4 |
0 |
|
F_ZCUR1MMM |
NUMBER UPPER LEVEL |
4 |
0 |
|
F_ZCUR1MMM |
OFF CAMPUS LOCATION |
15 |
0 |
|
F_ZCUR1MMM |
OFF SITE NUMBER |
5 |
0 |
|
F_ZCUR1MMM |
ROOM |
4 |
0 |
|
F_ZCUR1MMM |
SECOND TERM |
1 |
0 |
|
F_ZCUR1MMM |
SECTION CODE |
2 |
0 |
|
F_ZCUR1MMM |
SECTION NUMBER |
4 |
0 |
|
F_ZCUR1MMM |
STARTING AM PM |
1 |
0 |
|
F_ZCUR1MMM |
STARTING TIME |
4 |
0 |
|
F_ZCUR1MMM |
SUFFIX 1 |
1 |
0 |
|
F_ZCUR1MMM |
SUFFIX 2 |
1 |
0 |
|
F_ZCUR1MMM |
WRITING INT CRS |
1 |
0 |
|
F_ZCUR1REM: Student Course Enrollment
Information for Semester |
|||
|
File Name |
Field Name |
Field Length |
Decimal Positions |
|
F_ZCUR1REM |
|
3 |
0 |
|
F_ZCUR1REM |
ID NUMBER |
9 |
0 |
|
F_ZCUR1REM |
POSTED STUD MAST |
1 |
0 |
|
F_ZCUR1REM |
R |
1 |
0 |
|
F_ZCUR1REM |
RECOGNIZE REV |
1 |
0 |
|
F_ZCUR1REM |
RESIDENCY CODE |
1 |
0 |
|
F_ZCUR1REM |
SECTION NUMBER |
4 |
0 |
|
F_ZCUR1REM |
SEQUENCE NUMBER |
2 |
0 |
|
F_ZCUR1REM |
STATUS CODE |
1 |
0 |
|
F_ZCUR1REM |
TIME FLAG |
1 |
0 |
|
F_ZCUR1REM |
TRANSACTION CODE |
1 |
0 |
|
F_ZCUR1REM |
TRANSACTION DATE |
6 |
0 |
|
F_ZCUR1REM |
UPD 3R HIST |
1 |
0 |