Get documents about "Sample Letter Special Immigrant Minister
Description
Sample Letter Special Immigrant Minister document sample
Document Sample
Core To Do’s
Worksheet Heading
Dem. Val Codes Formatted.name.types
Health.conditions
IMMUNIZAITONS
INTERESTS
Person.origin.codes
PERSON.GOVT.BENEFITS
PHONE.TYPES
PREFIXES
PRIVACY.CODES
SOURSES
SPECIAL.NEEDS
VETRAN.TYPE
Dem.code.files DISABILITY
ETHNICS (MIS)
OCCUPATIONS
OTHER.ACAD.LEVELS
OTHER.CCDS (MIS)
OTHER.DEGREES (MIS)
OTHER.DIVISIONS
OTHER.HONORS
OTHER.MAJORS
OTHER.MINORS
OTHER.SPECIALIZAITONS
ZIP.CODE.XLAT (MIS)
Inst. Codes Files CIP
Inst.hierachy DEPTS
Facilities Val Codes BUILDING.TYPES
ROOM.CHARACTERISTICS
ROOM.RATE.CLASSES
Facilities Code Files
Feasibility Inventory
Example
Scheduling Val Codes
Scheduling Code Files
SEVIS Parameters
SEVIS Code Files
Financials Code Files
Act & Events Val Codes
A&E Code Files
Use as Delivered Code Files
Tasks after CORE consulting 12/04
What does the NM and the NE code mean? And
how will you get the info - who will add it to
Mail Rules Colleague?
AKA Names
If you want to store names for lookup purposes -
store historic names just for that - then use the
other name field on NAE or BIO. BUT, if you
need to pull any of those names to show up as
AKA names or anything on transcripts or
something, then detail from NAE to the FNM
screen and link the name to the AKA type.
Name Changes What docs and process do you have for that?
Health form info? Store on the EMER screen?
Field Level Security for Zip code field perhaps?
Zip codes only partial list - why?
Who
Mariann, Andy And Sue
Phase 2 - Jim will contact Jack
Phase 2 - Jim will contact Jack
Defer to ST consulting
Discuss during Admissions Training
Laith to review
Discuss at next meeting
Meeting Discussion
Phase 2
Meeting Discussion
Brad to discuss with DSPS
might be MIS also
Laith
Brad
Andy
Phase 2
Laith and Beth
Laith and Beth
Laith and Beth
Laith and Beth
Laith and Beth
Laith and Beth
Laith and Beth
Laith and Beth
Andy
Mariann
Andy needs to fill out the worksheet
from data collected
Questions for Cindy
Andy will make a list from R25
Andy will find Rate List
Review spreadsheet
Review spreadsheet
Ask Cindy
Laith and Nancy
Laith and Nancy
Andy and Sue
Andy and Sue
After GL Training
Andy will send a note to Cindy
CORE Team
CORE Team
Beth, Laith, and Nancy
Madelaine
Andy
Cindy
Core Application Decision Workbook
Objectives: Use this workbook to review, discuss and determine coding decisions for the
Core application. Separate tabs are provided for each of the business
function areas in Colleague. Remember to include a cross-functional team of
individuals in these discussions as codes are shared among business areas.
To aid in your decision making, screens in the Colleague Education Account
are populated with sample data. Your consultant will provide "best practices"
and additional guidance.
Checklist to Accomplish
Item Name Entered into Entered into
TEST Account LIVE Account
Core Validation Code Tables
Core Code Files
Core Parameters
Core Reports
Default Campus Calendar defined
Facilities Set Up
STAFF Record Set Up
Institutional Hierarchy Set Up
Core Decision Workbook Datatel Confidential 5 of 235
CORE Task List
CORE Task Name Start End Date Resource Name(s)
Date
Defining the CORE Team
Confirm CORE Team and Assign CORE Team Leader 9/10/04 Andy and Marianne
Attend Planning for and Using Core Training 9/10/04
Attend Shared Codes Consulting
Documentation and Assessment
Document Current Data Entry Procedures and Workflows 12/6/04
Name
Address and Phone Numbers
Relationship Information
Academic History and Credentials
Divorce/Deaths
Employment outside of the University
Identify Inefficiencies and Unusual Circumstances
Document Reporting Needs Ongoing
Federal and State Reports
Management Reports
Operational Reports
Correspondence & Communication
Labels
Assess Custom Needs
Define CORE Codes and Parameters
Phase 1
Define Parameters (PID Screens) 11/1/04 10/1/04
International Parameter (INTL) 11/1/04 10/1/05
International Defaults (PID1) 11/1/04 10/1/06
Define Client Institution on ORGP Screen 11/1/04 10/1/07
Create Default Campus Calendar on CMPC Screen 11/1/04 10/1/08
ID & LookUp (PID2) 11/1/04 10/1/09
Capitalization Rules (PID3) 11/1/04 10/1/10
Document Decisions on Codes Spreadsheet 11/1/04
Enter parameters in TEST 11/1/04 12/6/04
Define Institutional Hierarchy 11/1/04 12/6/04
Schools 11/1/04 12/6/04
Divisions 11/1/04 12/6/04
Departments 11/1/04 12/6/04
Enter hierarchy in TEST (SCHL, DIV, DEPT) 11/1/04 1/31/05 Curriculum team
Define Codes (Refer to Codes Spreadsheet)
Define Person & Organization Demographic Codes 11/1/04
Define Institution Codes
Define Facility Codes 11/1/04
Create Facility Inventory 11/1/04
Test Code Decisions on the following processes: 12/6/04
Name searches
Person entry/edit
Address entry/edit
Record deaths and divorces
Relationship entry/edit
Outside Employment information entry/edit
Standard Reports
Begin Work on Internal Documentation 12/6/04
Data Entry Standards & Procedures Manual (Refer to the
outline in the Planning for and Using CORE Guide)
Phase 2
Evaluate Delivered Name and Address Hierarchy
Define CORE Codes (Refer to Codes Spreadsheet)
Define Scheduling Codes
Define Activities and Events Codes - After A/E Training N/A
Define Financials Codes - After Financials Training N/A
Modify hierarchy as needed to match Client Code decisions
Define Parameters
Person Privacy Warnings (PID5)
Communications Mgmt(CM) (PID7) - After CM Training
Layout Address Security for Offices (ADRS Screen) -
after OFFICE.CODES have been defined
Review Inquiry Only Codes
Document Decisions on Codes Spreadsheet
Enter Codes in TEST
Test Decisions related to the following:
Integration with Financial System N/A
Integration with Student System
Integration with Human Resources System N/A
Correspondence tracks through Communications Mgmt
Integration with Activities and Events (Scheduling) N/A
Continue to work on Internal Documentation
Phase 3
Review and Test
Inquiry Screens
Data Entry Screens
Workflows and Processing
Integrated testing and review with other modules
Data Entry workflows
Print Menu-Based Reports
Run Query Reports
Produce Sample Correspondence
Finalize All Codes and Parameters
Enter Codes and Parameters to LIVE
Test Procedures in TEST
Finalize Data Entry Standards & Procedures Manual
Train End Users on CORE
Create training plan
Schedule training dates/locations
Design materials
Populate TEST with CORE decisions
Notify users: training dates, practice dates
Train users
Practice sessions
Simulate live processing
This worksheed is finished
SCREEN PARAMETER FIELD PARAMETER SETTING
INTL INTERNATIONAL PARAMETERS
Country USA
Short Date Format MDY
Zero Pad Short Dates Yes
Short Date Delimiter /
Done
9/8/2004 Long Date Format MDY
TEST Zero Pad Long Dates No
12/6/2004
Use Whole Month Name Yes
Use 4-Digit Year Yes
PID1 INTERNATIONAL DEFAULTS (Field Label)
Zip/Postal Code Text String Zip
Done Social ID Validation Subroutine
9/8/2004 Used with Canadian Clients
Social ID Number Text String SSN
State/Province/Regional Unit Text String State
City-State-Zip or Equivalent Text String Cty/St/Zp
Employer Tax Number Text String EIN
Alien or Landed Immigrant Text String Alien Status/Reg#
Core Parameters Datatel Confidential 9 of 235
PID2 ID AND LOOKUP PARAMETERS
Person/Organization ID's Assigned Automatic Only
Default Indexing to Use for LookUp Partial Name
Person ID's Check Digit Subroutine
Done
9/8/2004 Alternate Next Person ID Subroutine
Additional Person LookUp Subroutine
Used with Benefactor
Fixed Length for Person LookUp 7
Organization ID's Check Digit Subroutine
Alternate Next Organization ID Subroutine
Additional Organiation LookUp Subroutine
Used with Benefactor
Fixed Length for Organization LookUp 7
Host Organization ID GCCCD
Mail Label Name Width 35
Update Activity Counters in Batch Yes
Email Check on Startup No
Fixed length for PIN 6
Default Campus Calendar Calendar
Default Secondary School CCD N/A
Address Householding Off
Single Hit Resolution Off
Core Parameters Datatel Confidential 10 of 235
PID3 CAPITALIZATION RULES
Word Substitutions apt=apartment
dr=drive
9/8/2004 ct=court
Tammy to review list with post office / business services st=street
ave=avenue
blvd=boulevard
TEST hwy=highway
12/6/2004 pky=parkway
hwy=highway
po=post office
rm=room
bldg=building
rt=route
rr=rural route
ste=suite
cir=circle
ln=lane
Convert To Upper Case
Always Capitalize po,vu,llc, rr, nw, ne, sw, se
ii, iii, iv, v, mba, jd,md,cfo,ceo,cio
Never Capitalize c/o, and, in, the,
by, for, of, a, an,
on, de, la, to
Always Capitalize Next Word apt, box, rm, ste
Always Capitalize Prefixes as Indicated Mc, Mac, O', D'
Capitalize After These Delimiters "-","/"
Not Converted to Upper Case
Number Suffixes th, st, nd, rd
Next Letter Word Macon
Machine
Machines
Machinists
Core Parameters Datatel Confidential 11 of 235
Core Parameters Datatel Confidential 12 of 235
PID5 PERSON PRIVACY WARNINGS
System Login Message: "Disclosure of information protected by
privacy laws is prohibited. Unauthorized
Done access and/or use of this system is
12/6/2004 prohibited."
Privacy Warning Messages:
B Banned from Campus
X Duplicate Record - Do Not Use!
Record Denial Message: Access denied to this record.
Core Parameters Datatel Confidential 13 of 235
Core Parameters Datatel Confidential 14 of 235
Core Parameters Datatel Confidential 15 of 235
Core Parameters Datatel Confidential 16 of 235
Core Parameters Datatel Confidential 17 of 235
Core Parameters Datatel Confidential 18 of 235
Steps for Creating Address Record Security
1. Create adrel.types valcode table of address types in CORE
2. Create office.codes valcode table of offices in CORE
3. Create address matrix on the ADRS screen in CORE to list which office has access to ADDING & MAINTAINING addresse
Counseling/Transfer Center
Community Learning (CE)
Office of Instruction
Business Services
Admissions
Foundation
Library
Home/Permanent (Legal) X X
Mailing X X
Alternate (Summer) X X
Foreign X
I-20 Address X
Business (org, institution) X X X
G & MAINTAINING addresses
Cashier (front end staff)
IT
X
X
X
X
X
X
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL APPLICABLE
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
ADDRESS.CHANGE.SOURCES GC Grossmont Signed Form ADR
CC Cuyumaca Signed Form NAE
Done CL Community Learning Signed Form ORGP
9/8/2004 SC Scantron
RTM Return Mail
Entered in Test 9/10/04 CO Correction
CCC CCC Apply
WEB Web Connect
ADREL.TYPES B Business/Employment 2 ORGP
H Home/Permanent (mailing) 1 ADR
Special Processing Definitions: TEM Temporary
1 = Home addresses DO NOT CHANGE FOR SEVIS Foreign
2 = Business addresses DO NOT CHANGE IMM I-20 Mailing Address
3 = For Web Addresses (include FAC Faculty Office (hours) 2; FAC
"WEB" in 2nd column of Sp Prcs.) WEB Web Advisor 3;WEB
7 = Correction
13 = Room Assignments (also include
RMA in 2nd column)
FAC = faculty office hours
Done 9/10/04
Entered in test 9/10/04
ALT.ID.TYPES OSSN Old SSN DADD
SRS GCCCD SRS System ID AORG
TEDI Test EDI partner type SEVP
Done PEDI Prod EDI partner type
9/8/2004 SEVIN Sevis Institution ID
SEVST Sevis Student ID
**LEG will be used for all those who have SEVDS Sevis DSO ID
fake SSN #'s that are pulled from the legacy
system.
FORMATTED.NAME.TYPES AKA Also Known As y;35 FNM
Special Processing Definition: FAC Faculty n;35 ORGP
y = to allow soundex lookup and
indexing of these names. (enter "n"
if you do not wish to utilize this option)
35 = # of characters to allow for this name
Core Demographic Validation Codes Datatel Confidential 21 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL APPLICABLE
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
9/10 - Marianne, Andy and Sue to research
3rd party billing.
But entered in test as is 9/10/04
12/6/04 - Updated and done in test
HEALTH.CONDITIONS EMER
9/10 - will look at in phase II
Jim will contact Jack
12/6/04 - Will not use - done in test
IMMUNIZATIONS EMER
9/10 - will look at in phase II
Jim will contact Jack
12/6/04 - Will not use - done in test
INTERESTS YEAR Yearbook INTR
Used primarily to track interests STGV Student Government ASPR
for prospective students. DRAM Drama HACT
BAND Band AORG
9/10 - Defer to ST consulting
MAIL.RULES NP No Phone Calls NAE
NM No Mail ADR
May consider adding no solicitations NE No Email
depending on how marketing/ BA Bad Address
communication changes with time DE Deceased
**Think about how NE and NM will be used
9/10/04 - Done If student contacts you, then NM could be added.
Entered in test 9/10/04 BA will be added if mail is returned to you.
MARITAL.STATUSES M Married 2 CLIENT SPO
Special Processing Definition: S Single 1
1 = Single D Divorced 3
2 = Married W Widowed 4
3 = Divorced SP Separated 5
Core Demographic Validation Codes Datatel Confidential 22 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL APPLICABLE
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
4 = Widowed CO Correction 7
5 = Separated Y N/A Not a Care Student
7 = Correction (when incorrectly entered) X Unknown
12/6/04 - Done - in test
MIS Code
OFFICE.CODES ADM Admissions and Records DOC
ADS Administrative Services CMC
Used on the SVM Screen to group BUS Business Office CRRD
staff members for communications CSH Cashier TRC
management, rules, processing, and CL Community Learning RLDE
address record level security. CNS Counseling /Transfer Center SVM
EVAL Evaluations ADRS
This list will expand when you learn INTL International Services REST
Communications Management and HR Human Resources/Staff Development
Rules OUTR Outreach
In test 9/10/04 IS Information Systems
Done 9/1/04- will expand with VET Veterans
future training. FA Financial Aid
INST Instruction
12/6/04 - Mariann and Andy to review and addSCHD Scheduling
to this list
OVERALL.EMP.STATUS EMPL
12/6/04 - Won't use
PERSON.EMAIL.TYPES PRI Primary NAE
ALT Alternate PID
12/6/04 - Done and in test COL GCCCD Email
PERSON.ORIGIN.CODES RE Recruitment Activities APPN
CC Corporate Contact IPC
Goal of field is to track outreach and ML Mailing List NAE
recruitment activities. WB Web-Obtained
FA Financial Aid
Discuss further during admissions FR Fundraising Activity
training. 9/10/04 IC Institutional Contact
Each school has different ideas on how CC Apply
they'd like tou se this field. Need to find In person
Core Demographic Validation Codes Datatel Confidential 23 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL APPLICABLE
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
fields in admissions area to track each High School Fair
method and then determine best way Community Learning
to use Origin.codes Web
CL Preview
Friend
PERSON.GOVT.BENEFITS SS Social Security MINF
UE Unemployment
9/10 - Laith to review FS Food Stamps
12/6/04 - Done - in test MA Medical Assistance
PERSON.MILITARY.BRANCHES AF Air Force MINF
ARMY Army
Done 10/1/04 CG Coast Guard
12/6/04 - Test M Marines
NG National Guard
NAVY Navy
PERSON.MILITARY.STATUSES A Active MINF
AR Active Reserve
Done 10/1/04 R Reserve
12/6/04 - Test
PHONE.TYPES BU Business P; B NAE
Special Processing Definition: CP Cell P
P = Primary - for all phone numbers FH Fax Home P
that are person phone numbers HO Home P;H
H = Home (only 1 type can have 'H') FB Fax Business
B = Business (only 1 type can have 'B') TD Hearing Impaired
Dialing hierarchy (Laith) EM Emergency
9/10/2004
12/6/04 - Check with Carmen/Brad for DSPS info
Done and in test
PREFIXES Mr. M NAE
Enter Prefix codes on the PPS Screen. Mrs. F PPS
Miss F
Determine these values if Ms. F
prefixes are used. Dr.
President
Core Demographic Validation Codes Datatel Confidential 24 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL APPLICABLE
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
Special Processing Definition: Chancellor
M = Male
F = Female
9/10/04 - Defer to first meeting
12/6/04 - Done and in test
PRIVACY.CODES B Banned from Campus PID5
Determine these values if X Duplicate BIO
privacy will be used.
12/6/04 - Done and in test
SOURCES STU Student NAE
PRO Prospective Student ORGP
Special Processing Definition: INS Corporation / Institution
A = Alumni FAC Faculty
9/10/04 - Discuss during first meeting STA Staff
Once a person or an organization is entered TRU Trustee
in Colleague, who are they in relationship CNT Outside Contact
to the institution ALU Alumni A
12/6/04 - Done and in test
Multivalued field
SPECIAL.NEEDS DISD
9/10/2004 EMER
Brad will work with DSPNS
12/6/04 - Done and in test
SUFFIXES Jr NAE
PPS Screen Sr PPS
12/6/04 - done and in test II
III
IV
VETERAN.TYPES CH30 Chapter 30 MINF
Determine if needed. CH31 Chapter 31/VAVR SHAP
CH32 Chapter 32/VEAP
Client can change max code size CH35 Chapter 35/Dependent
to 4. 1606 Chapter 1606/National Guard
DOAD Dependent of Active Duty Mil.
9/10/04 - Laith to look at DOD Dept. of Defense Employee
Core Demographic Validation Codes Datatel Confidential 25 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL APPLICABLE
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
TA Tuition Assistance
12/6/04 - Done - in test VA Veteran's Assistance/Active Duty
VAWS VA Workstudy
Core Demographic Validation Codes Datatel Confidential 26 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
APPLICABLE
CORE CODE FILES CODE CODE DESCRIPTION SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
CHAPTERS CHP
12/6/04 - Done and in test ADR
COUNTIES N/A CNTY
List your state's counties NAE
Done - 9/10/2004 ADR
Andy to delete values in test account
12/6/04 - Done and in test
MIS Code
For Cal-MIS reporting the county code is
used to build the high school last attended
code if the high school is in California but
the system does not have the 6-digit CDS
code for that school.
DENOMINATIONS DENO
DADD
12/6/04 - Done and Test
DISABILITY B Acquired Brain Injury DISD
**NOTE: Code listed here are examples D Development - Delayed Learner EMER
H Hearing Impairment
MIS Code L Learning Disabled
M Mobility Impairment
9/10/04 - Brad to look at N No Secondary Disability
O Other Disability
12/6/04 - DONE and in test P Psychological Disability
Core Demographic Code Files Datatel Confidential 27 of 235
S Speech / Language Impairment
V Visual Impairment
ETHNICS ETH
**NOTE: Code listed here are examples See Test account for MIS codes NAE
Standard Codes for IPEDS Reporting
Additional Codes can be added to
define more specific enthnicities. If
this is done, be sure to go to the FLTT
screen in Core and create the translate
table for ELF for
IPEDS.ETHNIC.CATEGORIES
9/10/04 - Andy to look at what's currently
used
12/6/04 - Done and in test
MIS Code
OCCUPATIONS OCC
**NOTE: Code listed here are examples DADD
12/6/04 - Phase II if ever
OTHER.ACAD.LEVELS OACD
First populate Acad.levels in ST module AACR
with your institution acad. Levels. Those
will populate this code file. Then add
to this code file other academic levels
not at your institution.
**NOTE: Code listed here are examples
Core Demographic Code Files Datatel Confidential 28 of 235
9/10/04 - Laith and Beth to review
12/6/04 - Done and in test
OTHER.CCDS OCCD
First populate CCD's in ST module See Test account for MIS Codes AACR
with your institution CCD's. Those
will populate this code file. Then add
to this code file CCD's not offered
by your institution.
**NOTE: Code listed here are examples
9/10/04 - Laith and Beth to review
12/6/04 - Done and in test
MIS Code
OTHER.DEGREES ODEG
First populate degrees in ST module See Test account for MIS codes AACR
with your institution degrees. Those
will populate this code file. Then add
to this code file degrees not offered
by your institution.
**NOTE: Code listed here are examples
9/10/04 - Laith and Beth to review
12/6/04 - Done and in test
MIS Code
OTHER.DIVISIONS ODIV
Additional divisions not in your DIVISIONS AACR
file which is part of your Institutional Hierarchy
can be added here
**NOTE: Code listed here are examples
9/10/04 - Laith and Beth to review
Core Demographic Code Files Datatel Confidential 29 of 235
12/6/04 - Done and in test
OTHER.HONORS OHON
First populate honors in ST module ADCR
with your institution honors. Those
will populate this code file. Then add
to this code file honors not offered
by your institution.
**NOTE: Code listed here are examples
9/10/04 - Laith and Beth to review
12/6/04 - Done and in test
OTHER.MAJORS OMAJ
First populate Majors in ST module AACR
with your institution majors. Those
will populate this code file. Then add
to this code file majors not offered
by your institution.
**NOTE: Code listed here are examples
9/10/04 - Laith and Beth to review
12/6/04 - Done and in test
OTHER.MINORS OMIN
First populate Minors in ST module AACR
with your institution Minors. Those
will populate this code file. Then add
to this code file Minors not offered
by your institution.
**NOTE: Code listed here are examples
Core Demographic Code Files Datatel Confidential 30 of 235
9/10/04 - Laith and Beth to review
12/6/04 - Done and in test
OTHER.SPECIALIZATIONS OSPC
First populate Specializations in ST module AACR
with your institution Specializations. Those
will populate this code file. Then add
to this code file other specializatons not offered
by your institution.
9/10/04 - Laith and Beth to review
12/6/04 - Done and in test
REUNION.CLASSES RCLS
12/6/04 - Done and in test RELE
VOCATIONS SEVCPT Sevis Curric Practical Train VOCD
SEVOFF Sevis Off Campus Employment EMPD
SEVOPT Sevis Optional Practical Train
Phase II - probably won't use
12/6/04 - Will only use for SEVIS
Employment
ZIP.CODE.XLAT PCDX
**NOTE: Code listed here are examples
MIS Reporting
9/10/04 - Andy has Zip Code table
12/6/04 - Done and in test
Core Demographic Code Files Datatel Confidential 31 of 235
Core Demographic Code Files Datatel Confidential 32 of 235
Core Demographic Code Files Datatel Confidential 33 of 235
Core Demographic Code Files Datatel Confidential 34 of 235
Core Demographic Code Files Datatel Confidential 35 of 235
Core Demographic Code Files Datatel Confidential 36 of 235
Core Demographic Code Files Datatel Confidential 37 of 235
Core Demographic Code Files Datatel Confidential 38 of 235
Core Demographic Code Files Datatel Confidential 39 of 235
Core Demographic Code Files Datatel Confidential 40 of 235
Core Demographic Code Files Datatel Confidential 41 of 235
Core Demographic Code Files Datatel Confidential 42 of 235
Core Demographic Code Files Datatel Confidential 43 of 235
Core Demographic Code Files Datatel Confidential 44 of 235
Core Demographic Code Files Datatel Confidential 45 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING APPLICABLE SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
COMMENCEMENT.SITES OC On Campus ST-GRHM
ST-GADJ
9/10/04 - Done ST-UACF
9/10/04 - Entered in test ST-GDAU
IASU - AACR
GRADUATION.TYPES Y Yes - HS Graduated ST-SHAP
N Not Grad / Not in HS IASU - HSA
MIS Code G GED Equivalency
12/6/04 - Done and in test A Adult High School
C Current HS/GED Student
P CA High School Proficienc
F Foreign High School Prof
X Special Admissions
D AA/AS Degree
B BA/BS or Higher
U Unknown
Core Institution Validation Codes Datatel Confidential 46 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
APPLICABL
CORE CODE FILES BENEFACTOR VALCODES CODE CODE DESCRIPTION E SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
CIP 01.0101 Agricultural Bus & Mgmt, Genrl CIPD
1.0102 Ag Business/Agribusiness Oper RMSM
Link to web site for codes: 1.0103 Agricultural Economics DEPT
http://nces.ed.gov/pubs2002/cip2000/ 1.0104 Farm and Ranch Management
1.0199 Agricultural Bus & Mgmt, Other ST-CRSE
**NOTE: CIP Codes should be attached 1.0201 Ag Mechanization,General ST-SECT
to Programs (PROG) as set up in the ST 1.0204 Ag Power Machinery Operator ST-PROG
(Student) Application for IPEDS reporting 1.0299 Ag Mechanization, Other
1.0301 Ag Prod Workers & Managers, Gn
9/10/04 - Mariann will look into this 1.0302 Ag Animal Husbandry/Prod Mgmt
1.0303 Aquaculture Oprtns & Prod Mgmt
12/6/04 - Done and in test 1.0304 Crop Production Oprtns & Mgmt
**TOP Codes - where to store them? - CMB looking into this 1.0399 Ag Prod Workers & Managers,Oth
1.0401 Ag & Food Prod Process Op/Mgmt
1.0501 Ag Supplies Retail/Wholesale
1.0505 Animal Trainer
1.0507 Eques/Equine Stds,Horse Mg/Trn
1.0599 Ag Supplies & Related Svcs,Oth
1.0601 Horticulture Svcs Ops & Mgmt
1.0603 Ornamental Horticulture Ops/Mg
1.0604 Greenhouse Operations & Mgmt
1.0605 Landscaping Operations & Mgmt
1.0606 Nursery Operations & Managment
1.0607 Turf Management
1.0699 Horticulture Svcs Ops/Mgmt,Oth
1.0701 International Agriculture
1.9999 Ag Business & Production, Oth
10.0101 Educational/Instruct Media Tec
10.0103 Photographic Tech./Technician
Core Institution Code Files Datatel Confidential 47 of 235
10.0104 Radio & TV Broadcasting Tech
10.0199 Communications Technol/Tech,Ot
11.0101 Computer & Info Sciences, Gen
11.0201 Computer Programming
11.0301 Data Processing Tech/Techncian
11.0401 Information Sciences & Systems
11.0501 Computer Systems Analysis
11.0701 Computer Science
11.9999 Computer & Info Sciences, Oth
12.0203 Card Dealer
12.0204 Umpires & Other Sports Officls
12.0299 Gaming/Sports Officiating Svcs
12.0301 Funeral Svcs/Mortuary Science
12.0401 Cosmetic Services, General
12.0402 Barber/Hairstylist
12.0403 Cosmetologist
12.0404 Electrolysis Technician
12.0405 Massage
12.0406 Make-Up Artist
12.0499 Cosmetic Services, Other
12.0501 Baker/Pastry Chef
12.0502 Bartender/Mixologist
12.0503 Culinary Arts/Chef Training
12.0504 Food/Beverage/Rstrnt Opns Mgr
12.0505 Kitchen Persnl/Cook & Asst Trn
12.0506 Meatcutter
12.0507 Waiter/Waitress/Dining Rm Mgr
12.0599 Culinary Arts & Rltd Srvcs,Oth
12.9999 Personal & Misc Services, Oth
13.0101 Education, General
13.0201 Bilingual/Bicultural Education
13.0301 Curriculum and Instruction
13.0401 Educ Admin & Supervision, Gen
13.0402 Admin of Special Education
13.0403 Adult & Continuing Ed Admin
13.0404 Educational Supervision
13.0405 Elementry/Middle/Secndry Ed Ad
Core Institution Code Files Datatel Confidential 48 of 235
13.0406 Higher Education Administratn
13.0407 Community & Jr College Admin
13.0499 Education Admin & Supervsn,Oth
13.0501 Educ/Instructnal Media Design
13.0601 Eductnal Evaluation & Research
13.0603 Ed Statistics & Research Methd
13.0604 Educ Assessmnt/Testing/Measure
13.0699 Ed Eval, Research & Stats, Oth
13.0701 International & Comparative Ed
13.0802 Educational Psychology
13.0901 Social/Philosophical Foundatns
13.1001 Special Education, General
13.1003 Ed of the Deaf & Hearing Imprd
13.1004 Ed of the Gifted & Talented
13.1005 Ed of the Emotionally Hndicapd
13.1006 Ed of the Mentally Handicapped
13.1007 Ed of the Multiple Handicapped
13.1008 Ed of the Physically Handicapd
13.1009 Ed of Blind & Visually Hndicpd
13.1011 Ed of Specific Lrning Disabled
13.1012 Educ of the Speech Impaired
13.1013 Education of the Autistic
13.1099 Special Education, Other
13.1101 Counselor Ed,Counslng & Guidnc
13.1102 College/Postscndry Stud Counsl
13.1201 Adult & Continuing Teacher Ed
13.1202 Elementary Teacher Education
13.1203 Jr High/Intrmd/Mdl Schl Teach
13.1204 Pre-Elem/Early Child/KG Teach
13.1205 Secondary Teacher Education
13.1206 Teacher Ed, Multiple Levels
13.1299 General Teacher Educatn, Other
13.1301 Agric Teacher Ed (Vocational)
13.1302 Art Teacher Education
13.1303 Business Teacher Ed (Vocation)
13.1304 Driver & Safety Teacher Educat
13.1305 English Teacher Education
Core Institution Code Files Datatel Confidential 49 of 235
13.1306 Foreign Languages Teacher Educ
13.1307 Health Teacher Education
13.1308 Home Ec Teacher Ed (Vocation)
13.1309 Tech/Industrial Arts Teachr Ed
13.131 Mkt Op/Mkt & Distrb Teacher Ed
13.1311 Mathematics Teacher Education
13.1312 Music Teacher Education
13.1314 Phys Ed Teaching & Coaching
13.1315 Reading Teacher Education
13.1316 Science Teacher Ed, General
13.1317 Social Science Teacher Ed
13.1318 Social Studies Teacher Ed
13.1319 Technical Teacher Ed (Vocatnl)
13.132 Trade/Industrial Tchr Ed (Voc)
13.1321 Computer Teacher Education
13.1322 Biology Teacher Education
13.1323 Chemistry Teacher Education
13.1324 Drama/Dance Teacher Education
13.1325 French Language Teacher Ed
13.1326 German Language Teacher Ed
13.1327 Health Occup Teacher Ed (Voc)
13.1328 History Teacher Education
13.1329 Physics Teacher Education
13.133 Spanish Language Teacher Ed
13.1331 Speech Teacher Education
13.1399 Teacher Ed/Spec Acad & Voc Pgm
13.1401 Teaching ESL/Foreign Language
13.1501 Teacher Assistant/Aide
13.9999 Education, Other
14.0101 Engineering, General
14.0201 Aerospace/Aeronautic/Astronaut
14.0301 Agricultural Engineering
14.0401 Architectural Engineering
14.0501 Bioengineering/Biomedical Eng
14.0601 Ceramic Sciences & Engineering
14.0701 Chemical Engineering
14.0801 Civil Engineering, General
Core Institution Code Files Datatel Confidential 50 of 235
14.0802 Geotechnical Engineering
14.0803 Structural Engineering
14.0804 Transportation/Highway Enginrg
14.0805 Water Resources Engineering
14.0899 Civil Engineering, Other
14.0901 Computer Engineering
14.1001 Electrical/Electronic/Cmmuncat
14.1101 Engineering Mechanics
14.1201 Engineering Physics
14.1301 Engineering Science
14.1401 Environmental/Health Enginerng
14.1501 Geological Engineering
14.1601 Geophysical Engineering
14.1701 Industrial/Manufacturing Eng
14.1801 Material Engineering
14.1901 Mechanical Engineering
14.2001 Metallurgical Engineering
14.2101 Mining and Mineral Engineering
14.2201 Naval Arch & Marine Engineerng
14.2301 Nuclear Engineering
14.2401 Ocean Engineering
14.2501 Petroleum Engineering
14.2701 Systems Engineering
14.2801 Textile Sciences & Engineering
14.2901 Engineering Design
14.3001 Engineering/Industrial Mgt
14.3101 Materials Science
14.3201 Polymer/Plastics Engineering
14.9999 Engineering, Other
15.0101 Architectural Engineering Tech
15.0201 Civil Engineering/Civil Tech
15.0301 Computer Engnrng Tech/Technicn
15.0303 Elec, Electronic Comm Eng Tech
15.0304 Laser & Optical Tech/Technicn
15.0399 Electrcal/Electronic Enginrng
15.0401 Biomedical Enginring-Rltd Tech
15.0402 Computer Main Tech/Technician
Core Institution Code Files Datatel Confidential 51 of 235
15.0403 Electromechanical Tech/Techncn
15.0404 Instrumentation Tech/Technicn
15.0405 Robotics Tech./Technician
15.0499 Electromchnical Inst/Maint Tch
15.0501 Heating/Air Cndtning/Refrig Tc
15.0503 Energy Mngmnt & Systems Tech
15.0505 Solar Tech./Technician
15.0506 Water Qlty/Wastwater Trtmnt Tc
15.0507 Envrnmntl & Pollution Cntrl Tc
15.0599 Environmental Control Tech,Oth
15.0603 Indstrl/Manfctring Tech/Technc
15.0607 Plastics Tech./Technician
15.0611 Metallurgical Tech./Technician
15.0699 Indstrl Product Tech/Techncn
15.0701 Occup Safety/Health Tech/Techn
15.0702 Quality Control Tech/Technicn
15.0799 Qlty Cntrl & Safety Tech/Techn
15.0801 Aeronautical/Aerospace Eng Tec
15.0803 Automotive Enginrng Tech/Techn
15.0805 Mechanical Engnrng/Mechnc Tech
15.0899 Mech Enginrng-Related Tech,Oth
15.0901 Mining Tech./Technician
15.0903 Petroleum Tech./Technician
15.0999 Mining/Petroleum Tech/Tech,Oth
15.1001 Construction/Bldng Tech/Tchncn
15.1101 Enginrng-Reltd Tech/Techncn,Gn
15.1102 Surveying
15.1103 Hydraulic Tech./Technician
15.9999 Enginring-Rltd Tech/Technc,Oth
16.0101 Foreign Lang & Literatures,Gen
16.0102 Linguistics
16.0103 Foreign Lang Interpret/Translt
16.0301 Chinese Language & Literature
16.0302 Japanese Language & Literature
16.0399 East/SE Asian Lang & Lit, Oth
16.0402 Russian Language & Literature
16.0403 Slavic Lang & Lit (Non-Russian
Core Institution Code Files Datatel Confidential 52 of 235
16.0499 East Europe Langs & Lits, Oth
16.0501 German Language and Literature
16.0502 Scandinavian Languages & Lits
16.0599 Germanic Languages & Lits, Oth
16.0602 Greek Lang and Lit (Modern)
16.0703 South Asian Languages and Lits
16.0901 French Language and Literature
16.0902 Italian Language & Literature
16.0904 Portuguese Language and Lit
16.0905 Spanish Language & Literature
16.0999 Romance Languages and Lits,Oth
16.1101 Arabic Language and Literature
16.1102 Hebrew Language and Literature
16.1199 Mid Eastern Langs & Lits, Oth
16.1201 Classics/Classical Langs & Lit
16.1202 Greek Lang & Lit (Ancient)
16.1203 Latin Lang & Lit (Ancient)
16.1299 Clssical/Ancient Nr Eastrn Lng
16.9999 Foreign Langs and Lits, Other
18.2201 Public Health
19.0101 Home Economics, General
19.0201 Business Home Economics
19.0202 Home Economics Communications
19.0301 Family and Community Studies
19.0401 Family Resource Mngmnt Studies
19.0402 Consumer Economics and Science
19.0499 Family/Cnsmr Resource Mgmt,Oth
19.0501 Foods & Nutrition Studies, Gen
19.0502 Foods and Nutrition Science
19.0503 Dietetics/Human Nutritional Sv
19.0505 Food Systems Administration
19.0599 Foods & Nutrition Studies, Oth
19.0601 Housing Studies, General
19.0603 Interior Environments
19.0699 Housing Studies, Other
19.0701 Indvdl/Family Dvl Studies, Gen
19.0703 Family and Marriage Counseling
Core Institution Code Files Datatel Confidential 53 of 235
19.0704 Family Life/Relations Studies
19.0705 Gerontological Services
19.0706 Child Growth, Care/Dvl Studies
19.0799 Ind/Family Dev Studies, Oth
19.0901 Clothing/Apparel/Textile Stud
19.9999 Home Economics, Other
2.0101 Agriculture/Agri Science, Gen
2.0102 Agricultural Extension
2.0201 Animal Sciences, General
2.0202 Ag Animal Breeding & Genetics
2.0203 Agricultural Animal Health
2.0204 Agricultural Animal Nutrition
2.0205 Agricultural Animal Physiology
2.0206 Dairy Science
2.0209 Poultry Science
2.0299 Animal Sciences, Other
2.0301 Food Sciences and Tech.
2.0401 Plant Sciences, General
2.0402 Agronomy and Crop Science
2.0403 Horticulture Science
2.0405 Plant Breeding and Genetics
2.0406 Agricultural Plant Pathology
2.0407 Agricultural Plant Physiology
2.0408 Plant Protection (Pest Mgmt)
2.0409 Range Science and Management
2.0499 Plant Sciences, Other
2.0501 Soil Sciences
2.9999 Ag/Agricultural Science, Oth
20.0201 Child Care/Gdnce Wrkr & Mgr,Gn
20.0202 Child Care Provider/Assistant
20.0203 Child Care Services Manager
20.0299 Child Care/Gdnc Wkr & Mngr,Oth
20.0301 Clthng/Apparel/Textile Wkr/Mgr
20.0303 Commercial Garment/Apparel Wrk
20.0305 Custom Tailor
20.0306 Fashion and Fabric Consultant
20.0309 Drycleaner/Launderer (Cmrcial)
Core Institution Code Files Datatel Confidential 54 of 235
20.0399 Clothing/Apparel/Txtl Wkr/Mgr
20.0401 Inst Food Wrkrs & Admin, Gen
20.0404 Dietician Assistant
20.0405 Food Caterer
20.0409 Institutional Food Srvcs Admin
20.0499 Inst Food Wrkrs & Admin, Oth
20.0501 Home Furnishings & Eqpmnt Inst
20.0502 Window Treatment Maker/Instlr
20.0599 Home Furnishings & Eqpmnt Inst
20.0601 Custodial/Hsekpng/Home Service
20.0602 Elder Care Provider/Companion
20.0604 Custodian/Caretaker
20.0605 Executive Housekeeper
20.0606 Homemaker's Aide
20.0699 Custodial, Hskeepng & Home Svc
20.9999 Vocational Home Economics, Oth
22.0101 Law (LL.B., J.D.)
22.0102 Pre-Law Studies
22.0103 Paralegal/Legal Assistant
22.0104 Juridical Science/Legal Spcl
22.0199 Law and Legal Studies, Other
23.0101 English Language and Lit, Gen
23.0301 Comparative Literature
23.0401 English Composition
23.0501 English Creative Writing
23.0701 American Literature (U S)
23.0801 English Lit (British/Cmnwlth)
23.1001 Speech and Rhetorical Studies
23.1101 English Technical/Busns Wrtng
23.9999 English Language & Lit/Ltrs
24.0101 Lib Arts & Sciences/Lib Studys
24.0102 General Studies
24.0103 Humanities/Humanistic Studies
24.0199 Lib Art&Sci,Gen Stud&Human,Oth
25.0101 Library Science/Librarianship
25.0301 Library Assistant
25.9999 Library Science, Other
Core Institution Code Files Datatel Confidential 55 of 235
26.0101 Biology, General
26.0202 Biochemistry
26.0203 Biophysics
26.0301 Botany, General
26.0305 Plant Pathology
26.0307 Plant Physiology
26.0399 Botany, Other
26.0401 Cell Biology
26.0402 Molecular Biology
26.0499 Cell & Molecular Biology, Oth
26.0501 Microbiology/Bacteriology
26.0601 Anatomy
26.0603 Ecology
26.0607 Marine/Aquatic Biology
26.0608 Neuroscience
26.0609 Nutritional Sciences
26.061 Parasitology
26.0611 Radiation Biology/Radiobiology
26.0612 Toxicology
26.0613 Genetics, Plant and Animal
26.0614 Biometrics
26.0615 Biostatistics
26.0616 Biotechnology Research
26.0617 Evolutionary Biology
26.0618 Biological Immunology
26.0619 Virology
26.0699 Misc Biological Specialization
26.0701 Zoology, General
26.0702 Entomology
26.0704 Pathology, Human and Animal
26.0705 Pharmacology, Human and Animal
26.0706 Physiology, Human and Animal
26.0799 Zoology, Other
26.9999 Biological Sci/Life Sci, Oth
27.0101 Mathematics
27.0301 Applied Mathematics, General
27.0302 Operations Research
Core Institution Code Files Datatel Confidential 56 of 235
27.0399 Applied Mathematics, Other
27.0501 Mathematical Statistics
27.9999 Mathematics, Other
29.0101 Military Technologies
3.0101 Nat Resources Conservation,Gen
3.0102 Environmental Science/Studies
3.0201 Nat Resources Mgmt & Policy
3.0203 Nat Resrc Law Enfrc/Protect Sv
3.0299 Nat Rsrcs Mgmt & Protect Sv,Ot
3.0301 Fishing/Fisheries Sci & Mgmt
3.0401 Forest Harvesting & Prod Tech
3.0404 Forest Prod Tech./Technician
3.0405 Logging/Timber Harvesting
3.0499 Forest Prod & Processing, Oth
3.0501 Forestry, General
3.0502 Forestry Sciences
3.0506 Forest Management
3.0509 Wood Science & Pulp/Paper Tech
3.0599 Forestry/Related Sciences, Oth
3.0601 Wildlife & Wildlands Managemnt
3.9999 Conservatn/Renewable Nat Rsrcs
30.0101 Biological & Physical Sciences
30.0501 Peace and Conflict Studies
30.0601 Systems Science and Theory
30.0801 Mathematics & Computer Science
30.1001 Biopsychology
30.1101 Gerontology
30.1201 Historic Preservation, Conserv
30.1301 Medieval & Renaissance Studies
30.1401 Museology/Museum Studies
30.1501 Science, Tech. and Society
30.9999 Multi/Interdiscplnry Stud, Oth
31.0101 Parks, Recreation/Leisure Stud
31.0301 Parks/Rec/Leisure Facilts Mgmt
31.0501 Health&Physical Education, Gen
31.0502 Adaptd Phys Ed/Therapeutic Rec
31.0503 Athletic Training/Sports Medcn
Core Institution Code Files Datatel Confidential 57 of 235
31.0504 Sport and Fitness Admin/Mgmt
31.0505 Exercise Sci/Physiology & Mvmt
31.0506 Socio-Psychological Sports Std
31.0599 Health & Phys Ed/Fitness, Oth
31.9999 Parks,Rec,Leisure&Fitness Std
38.0101 Philosophy
38.0201 Religion/Religious Studies
38.9999 Philosophy and Religion
39.0101 Biblical&Oth Theolgcl Lang&Lit
39.0201 Bible/Biblical Studies
39.0301 Missions/Msnry Stud & Misology
39.0401 Religious Education
39.0501 Religious/Sacred Music
39.0601 Theology/Theological Studies
39.0602 Divinity/Ministry (B D, M Div)
39.0603 Rabnical/Talmudic Std(MHL/Rav)
39.0604 Pre-Theologicl/Pre-Ministerl S
39.0605 Ordination, Other
39.0606 Talmudic Studies
39.0699 Theologic/Minister Studies,Oth
39.0701 Pastoral Cnslng/Spclzd Minist
39.9999 Theological Stud&Rel Voctns,Ot
4.0201 Architecture
4.0301 City/Urban/Community/Reg Plan
4.0401 Architectural Environmntl Dsgn
4.0501 Interior Architecture
4.0601 Landscape Architecture
4.0701 Arch Urban Design & Planning
4.9999 Architecture & Related Pgms,Ot
40.0101 Physical Sciences, General
40.0201 Astronomy
40.0301 Astrophysics
40.0401 Atmospheric Sci & Meteorology
40.0501 Chemistry, General
40.0502 Analytical Chemistry
40.0503 Inorganic Chemistry
40.0504 Organic Chemistry
Core Institution Code Files Datatel Confidential 58 of 235
40.0505 Medicinal/Pharmaceutical Chem
40.0506 Physical and Theoretical Chem
40.0507 Polymer Chemistry
40.0599 Chemistry, Other
40.0601 Geology
40.0602 Geochemistry
40.0603 Geophysics and Seismology
40.0604 Paleontology
40.0699 Geological & Related Sci, Oth
40.0701 Metallurgy
40.0702 Oceanography
40.0703 Earth and Planetary Sciences
40.0799 Misc Physical Sciences, Other
40.0801 Physics, General
40.0802 Chemical&Atomic/Molecular Phys
40.0804 Elementary Particle Physics
40.0805 Plasma and High-Temp Physics
40.0806 Nuclear Physics
40.0807 Optics
40.0808 Solid State & Low-Temp Physics
40.0809 Acoustics
40.081 Theoretical & Mathmtcl Physics
40.0899 Physics, Other
40.9999 Physical Sciences, Other
41.0101 Biological Tech./Technician
41.0204 Indstrl Radiologic Tech/Technc
41.0205 Nuclear/Nuclear Pwr Tech/Techn
41.0299 Nuclear&Ind Radiologic Tech,Ot
41.0301 Chemical Tech./Technician
41.0399 Phys Science Tech/Techncn, Oth
41.9999 Science Tech/Technicians, Oth
42.0101 Psychology, General
42.0201 Clinical Psychology
42.0301 Cognitive Psych&Psycholngstics
42.0401 Community Psychology
42.0601 Counseling Psychology
42.0701 Developmental&Child Psychology
Core Institution Code Files Datatel Confidential 59 of 235
42.0801 Experimental Psychology
42.0901 Industrial & Organizatnl Psych
42.1101 Physiologcl Psych/Psychobiolgy
42.1601 Social Psychology
42.1701 School Psychology
42.9999 Psychology, Other
43.0101 Criminal Justice
43.0102 Corrections/Correctional Admin
43.0103 Crim Justice/Law Enforcmnt Adm
43.0104 Criminal Justice Studies
43.0106 Forensic Tech./Technician
43.0107 Law Enforcement/Police Science
43.0109 Security & Loss Prvntn Srvcs
43.0199 Criminal Just&Corrections, Oth
43.0201 Fire Protect&Safety Tech/Tchnc
43.0202 Fire Services Administration
43.0203 Fire Science/Firefighting
43.0299 Fire Protection, Other
43.9999 Protective Services, Other
44.0201 Cmty Organization,Rsrcs & Serv
44.0401 Public Administration
44.0501 Public Policy Analysis
44.0701 Social Work
44.9999 Public Administration&Srv, Oth
45.0101 Social Sciences, General
45.0201 Anthropology
45.0301 Archeology
45.0401 Criminology
45.0501 Demography/Population Studies
45.0601 Economics, General
45.0602 Applied and Resource Economics
45.0603 Econometrics/Quantitv Econmics
45.0604 Dvlpmnt Econ&International Dev
45.0605 International Economics
45.0699 Economics, Other
45.0701 Geography
45.0702 Cartography
Core Institution Code Files Datatel Confidential 60 of 235
45.0801 History, General
45.0802 American (U S) History
45.0803 European History
45.0804 History & Phil of Science&Tech
45.0805 Public/Apld Hist&Archival Admn
45.0899 History, Other
45.0901 Internatnl Relations & Affairs
45.1001 Political Science, General
45.1002 American Government & Politics
45.1099 Political Sci & Government,Oth
45.1101 Sociology
45.1201 Urban Affairs/Studies
45.9999 Social Science & History, Oth
46.0101 Mason and Tile Setter
46.0201 Carpenter
46.0301 Elec&Power Trans Installer,Gen
46.0302 Electrician
46.0303 Lineworker
46.0399 Elec&Power Trans Installer,Oth
46.0401 Building/Property Maint & Mngr
46.0403 Construction/Buildng Inspector
46.0408 Painter and Wall Coverer
46.0499 Const&Bldg Finshrs & Mngrs,Oth
46.0501 Plumber and Pipefitter
46.9999 Construction Trades, Other
47.0101 Electricl&Electrnics Equip Ins
47.0102 Business Machine Repairer
47.0103 Comnctn Sys Installer/Repairer
47.0104 Computer Installer & Repairer
47.0105 Indus Electrnics Instlr & Repr
47.0106 Maj Applnc Installer&Repairer
47.0199 Electricl/Electrncs Equip Ins
47.0201 Heating/Air Conditning/Refrig
47.0302 Heavy Equip Main and Repairer
47.0303 Indstrl Machinery Main&Repair
47.0399 Indus Equip Main&Repairers,Oth
47.0401 Instrmnt Calibration&Repairer
Core Institution Code Files Datatel Confidential 61 of 235
47.0402 Gunsmith
47.0403 Locksmith and Safe Repairer
47.0404 Musical Instrument Repairer
47.0408 Watch, Clock&Jewelry Repairer
47.0499 Misc Mechanics & Repairers,Oth
47.0501 Stnry Energy Srcs Install/Oper
47.0603 Auto/Automotive Body Repairer
47.0604 Auto/Automotive Mechanic/Tech
47.0605 Diesel Engne Mechanic/Repairer
47.0606 Small Engine Mechanic/Repairer
47.0607 Aircraft Mech/Tech, Airframe
47.0608 Aircraft Mech/Tech, Powerplnt
47.0609 Aviation Sys&Avionics Main Tch
47.061 Bicycle Mechanic and Repairer
47.0611 Motorcycle Mechanic & Repairer
47.0699 Vehicle&Mobile Equip-Mech&Rpr
47.9999 Mechanics and Repairers, Other
48.0101 Drafting, General
48.0102 Architectural Drafting
48.0103 Civil/Structural Drafting
48.0104 Electrical/Electronics Draftng
48.0105 Mechanical Drafting
48.0199 Drafting, Other
48.0201 Graphic&Printing Equip Opr,Gen
48.0205 Mechanical Typesetter/Composer
48.0206 Lithographer and Platemaker
48.0208 Printing Press Operator
48.0211 Cmputr Typog/Composition Equip
48.0212 Desktop Publishing Equip Opr
48.0299 Graphic & Prntg Equip Oper,Oth
48.0303 Upholsterer
48.0304 Shoe, Boot & Leather Repairer
48.0399 Leatherworkers&Upholsterers,Ot
48.0501 Machinist/Machine Technologist
48.0503 Machine Shop Assistant
48.0506 Sheet Metal Worker
48.0507 Tool & Die Maker/Technologist
Core Institution Code Files Datatel Confidential 62 of 235
48.0508 Welder/Welding Technologist
48.0599 Precision Metal Workers, Other
48.0701 Woodworkers, General
48.0702 Furniture Designer and Maker
48.0703 Cabinet Maker and Millworker
48.0799 Woodworkers, Other
48.9999 Precision Productn Trades, Oth
49.0101 Aviation and Airway Science
49.0102 Aircraft Pilot & Navgtr (Prof)
49.0104 Aviation Management
49.0105 Air Traffic Controller
49.0106 Flight Attendant
49.0107 Aircraft Pilot (Private)
49.0199 Air Transportation Wrkrs, Oth
49.0202 Construction Equipment Operatr
49.0205 Truck, Bus & Oth Cmrcl Vhcl Op
49.0299 Vehicle & Equip Operators, Oth
49.0303 Fishing Tech/Comercial Fishing
49.0304 Diver (Professional)
49.0306 Marine Main. and Ship Repairer
49.0309 Marine Sci/Merchant Marine Off
49.0399 Water Transportation Wrkrs,Oth
49.9999 Transprtn&Materials Movng Work
5.0101 African Studies
5.0102 American Studies/Civilization
5.0103 Asian Studies
5.0104 East Asian Studies
5.0105 Eastern European Area Studies
5.0106 European Studies
5.0107 Latin American Studies
5.0108 Middle Eastern Studies
5.0109 Pacific Area Studies
5.011 Russian & Slavic Area Studies
5.0111 Scandinavian Area Studies
5.0112 South Asian Studies
5.0113 Southeast Asian Studies
5.0114 Western European Studies
Core Institution Code Files Datatel Confidential 63 of 235
5.0115 Canadian Studies
5.0199 Area Studies, Other
5.0201 Afro-American (Black) Studies
5.0202 Am Indian/Nat American Studies
5.0203 Hispanic-American Studies
5.0204 Islamic Studies
5.0205 Jewish/Judaic Studies
5.0206 Asian-American Studies
5.0207 Women's Studies
5.0299 Ethnic & Cultural Studies, Oth
5.9999 Area/Ethnic/Cultural Stud, Oth
50.0101 Visual and Performing Arts
50.0201 Crafts, Folk Art and Artisanry
50.0301 Dance
50.0401 Design & Visual Communications
50.0402 Graphic Design,Cmrcl Art&Illus
50.0404 Industrial Design
50.0406 Commercial Photography
50.0407 Fashion Design & Illustration
50.0408 Interior Design
50.0499 Design and Applied Arts, Other
50.0501 Drama/Theater Arts, General
50.0502 Tech Theater/Theatr Dsgn&Stage
50.0503 Acting and Directing
50.0504 Playwriting and Screenwriting
50.0505 Drama/Theatr Lit,Hist&Critcism
50.0599 Drama/Theater Arts&Stgcrft,Oth
50.0601 Film/Cinema Studies
50.0602 Film-Video Mkng/Cinematog&Prod
50.0605 Photography
50.0699 Film/Video/Photographc Arts,Ot
50.0701 Art, General
50.0702 Fine/Studio Arts
50.0703 Art History, Criticism&Conserv
50.0704 Arts Management
50.0705 Drawing
50.0706 Intermedia
Core Institution Code Files Datatel Confidential 64 of 235
50.0708 Painting
50.0709 Sculpture
50.071 Printmaking
50.0711 Ceramics Arts and Ceramics
50.0712 Fiber, Textile & Weaving Arts
50.0713 Metal and Jewelry Arts
50.0799 Fine Arts and Art Studies, Oth
50.0901 Music, General
50.0902 Music History and Literature
50.0903 Music - General Performance
50.0904 Music Theory and Composition
50.0905 Musicology and Ethnomusicology
50.0906 Music Conducting
50.0907 Music-Piano&Organ Performance
50.0908 Music-Voice&Choral/Opera Prfrm
50.0909 Music Bus Mngmnt&Merchandising
50.0999 Music, Other
50.9999 Visual and Performing Arts,Oth
51.0101 Chiropractic (D.C., D.C.M.)
51.0201 Communication Disorders, Genrl
51.0202 Audiology/Hearing Sciences
51.0203 Speech-Language Pathology
51.0204 Speech-Lang Patholgy&Audiology
51.0205 Sign Language Interpreter
51.0299 Comnctn Disorders Sci&Serv,Oth
51.0301 Community Health Liaison
51.0401 Dentistry (D.D.S., D.M.D.)
51.0501 Dntl Clinical Sci/Grad Dentist
51.0601 Dental Assistant
51.0602 Dental Hygienist
51.0603 Dental Laboratory Technician
51.0699 Dental Services, Other
51.0701 Health Sys/Health Srvcs Admin
51.0702 Hospital/Health Faclties Admin
51.0703 Health Unit Coord/Ward Clerk
51.0704 Health Unit Mngr/Ward Suprvsr
51.0705 Medical Office Management
Core Institution Code Files Datatel Confidential 65 of 235
51.0706 Medical Records Administration
51.0707 Medical Records Tech/Technicn
51.0708 Medical Transcription
51.0799 Health&Medical Admin Srvcs,Oth
51.0801 Medical Assistant
51.0802 Medical Laboratory Assistant
51.0803 Occupational Therapy Assistant
51.0804 Ophthalmic Medical Assistant
51.0805 Pharmacy Technician/Assistant
51.0806 Physical Therapy Assistant
51.0807 Physician Assistant
51.0808 Veterinarian Asst/Animl Health
51.0899 Health&Medical Assistants, Oth
51.0901 Cardiovascular Tech/Technician
51.0902 Electrocardiograph Tech/Technc
51.0903 Electroencephalograph Tech
51.0904 Emergency Medical Tech/Techncn
51.0905 Nuclear Medical Tech/Techncian
51.0906 Perfusion Tech./Technician
51.0907 Medical Radiologic Tech/Technc
51.0908 Respiratory Therapy Technician
51.0909 Surgical/Operating Room Technc
51.091 Diagnostic Medical Sonography
51.0999 Health&Med Diag & Treat Svc,Ot
51.1001 Blood Bank Tech./Technician
51.1002 Cytotechnologist
51.1003 Hematology Tech./Technician
51.1004 Medical Laboratory Technician
51.1005 Medical Technology
51.1006 Optometric/Ophthalmic Lab Tech
51.1099 Health & Medical Lab Tech, Oth
51.1101 Pre-Dentistry Studies
51.1102 Pre-Medicine Studies
51.1103 Pre-Pharmacy Studies
51.1104 Pre-Veterinary Studies
51.1199 Health & Med Prep Pgms, Oth
51.1201 Medicine (M.D.)
Core Institution Code Files Datatel Confidential 66 of 235
51.1301 Medical Anatomy
51.1302 Medical Biochemistry
51.1303 Medical Biomath and Biometrics
51.1304 Medical Physics/Biophysics
51.1305 Medical Cell Biology
51.1306 Medical Genetics
51.1307 Medical Immunology
51.1308 Medical Microbiology
51.1309 Medical Molecular Biology
51.131 Medical Neurobiology
51.1311 Medical Nutrition
51.1312 Medical Pathology
51.1313 Medical Physiology
51.1314 Medical Toxicology
51.1399 Basic Medical Sciences, Other
51.1401 Medical Clinical Sci (MS, PhD)
51.1501 Alcohol/Drug Abuse Counseling
51.1502 Psychiatric/Mental Hlth Svc Tc
51.1503 Clinical & Medical Social Work
51.1599 Mental Health Services, Other
51.1601 Nursing (R.N. Training)
51.1602 Nursing Administration/Post-RN
51.1603 Nursing, Adult Health/Post-RN
51.1604 Nursing Anesthetist (Post-RN)
51.1605 Nursing, Family Prac (Post-RN)
51.1606 Nursing, Maternal/Child Health
51.1607 Nursing Midwifery (Post-R.N.)
51.1608 Nursing Science (Post-R.N.)
51.1609 Nursing, Pediatric (Post-R.N.)
51.161 Nursing, Psych/Mental Health
51.1611 Nursing, Public Health/Post-RN
51.1612 Nursing, Surgical (Post-R.N.)
51.1613 Practical Nurse (LPN Training)
51.1614 Nurse Assistant/Aide
51.1615 Home Health Aide
51.1699 Nursing, Other
51.1701 Optometry (O.D.)
Core Institution Code Files Datatel Confidential 67 of 235
51.1801 Opticianry/Dispensing Optician
51.1802 Optical Technician/Assistant
51.1803 Ophthalmic Medical Technolgist
51.1804 Orthoptics
51.1899 Ophthalmic/Optometric Svcs,Oth
51.1901 Osteopathic Medicine (D.O.)
51.2001 Pharmacy (B. Pharm., Pharm.D.)
51.2002 Pharmacy Admin & Pharmaceutics
51.2003 Med Pharmacology&Pharmaceut Sc
51.2099 Pharmacy, Other
51.2101 Podiatry (DPM, DP, PodD)
51.2201 Public Health, General
51.2202 Environmental Health
51.2203 Epidemiology
51.2204 Health & Medical Biostatistics
51.2205 Health Physics/Radiologic Hlth
51.2206 Occup Health&Industry Hygiene
51.2207 Public Health Educ & Promotion
51.2299 Public Health, Other
51.2301 Art Therapy
51.2302 Dance Therapy
51.2303 Hypnotherapy
51.2304 Movement Therapy
51.2305 Music Therapy
51.2306 Occupational Therapy
51.2307 Orthotics/Prosthetics
51.2308 Physical Therapy
51.2309 Recreational Therapy
51.231 Vocational Rehab Counseling
51.2399 Rehab/Therapeutic Services,Oth
51.2401 Veterinary Medicine (D.V.M.)
51.2501 Vet Clinical Science (MS, PhD)
51.2601 Health Aide
51.2701 Acupuncture and Oriental Medcn
51.2702 Medical Dietician
51.2703 Medical Illustrating
51.2704 Naturopathic Medicine
Core Institution Code Files Datatel Confidential 68 of 235
51.2705 Psychoanalysis
51.9999 Health Professions&Rel Sci,Oth
52.0101 Business, General
52.0201 Business Admin & Mgmt, Gen
52.0202 Purchasng,Procrmnt&Cntrcts Mgm
52.0203 Logistics and Materials Mgmnt
52.0204 Office Supervision &Management
52.0205 Operations Mgmnt & Supervision
52.0206 Non-Profit & Public Management
52.0299 Business Admin & Mgmt, Oth
52.0301 Accounting
52.0302 Accounting Technician
52.0399 Accounting, Other
52.0401 Admin Asst/Secretarial Sci
52.0402 Executive Assistant/Secretary
52.0403 Legal Admin Asst/Secretary
52.0404 Medical Admin Asst/Secretary
52.0405 Court Reporter
52.0406 Receptionist
52.0407 Info Processng/Data Entry Tech
52.0408 Gen Office/Clerical&Typing Srv
52.0499 Admin & Secretarial Serv, Oth
52.0501 Business Communications
52.0601 Business/Managerial Economics
52.0701 Enterprise Mgmt & Operation,Gn
52.0702 Franchise Operation
52.0799 Enterprise Mgmt&Operation, Oth
52.0801 Finance, General
52.0802 Actuarial Science
52.0803 Banking &Financial Support Srv
52.0804 Financial Planning
52.0805 Insurance and Risk Management
52.0806 International Finance
52.0807 Investments and Securities
52.0808 Public Finance
52.0899 Financial Mgmt & Services, Oth
52.0901 Hospitality/Admin Management
Core Institution Code Files Datatel Confidential 69 of 235
52.0902 Hotel/Motel & Restaurant Mgmt
52.0903 Travel-Tourism Management
52.0999 Hospitality Services Mgmt, Oth
52.1001 Human Resources Management
52.1002 Labor/Personnel Rlatns&Studies
52.1003 Organizational Behavior Studys
52.1099 Human Resources Management,Oth
52.1101 International Business
52.1201 Mgmt Info Systems & Businss DP
52.1202 Bus Cmptr Programing/Progrmmer
52.1203 Business Sys Analysis & Design
52.1204 Bus Sys Networking & Telecomm
52.1205 Business Cmptr Facilities Oper
52.1299 Business Info & Data Processng
52.1301 Management Science
52.1302 Business Statistics
52.1399 Bus Quantitative Meth&Mgmt,Oth
52.1401 Bsnss Marketing/Marketing Mgmt
52.1402 Marketing Research
52.1403 Internatnal Business Marketing
52.1499 Marketing Mgmt & Research, Oth
52.1501 Real Estate
52.1601 Taxation
52.9999 Business Mgmt & Admin Serv,Oth
6.0101 Business & Man
6.0201 Accounting
6.0301 Banking & Finance
6.0401 Marketing
8.0101 Apparel/Accessories Mkt Opn,Gn
8.0102 Fashion Merchandising
8.0103 Fashion Modeling
8.0199 Apparel/Accessories Mkt Opn/Ot
8.0204 Bus Svcs Marketing Operations
8.0205 Personal Svcs Marketing Operat
8.0299 Bus & Prsnl Svc Mrkt Opns, Oth
8.0301 Entrepreneurship
8.0401 Financial Svcs Mrkting Operatn
Core Institution Code Files Datatel Confidential 70 of 235
8.0503 Floristry Marketing Operations
8.0601 Food Prod Retail & Whlsle Opns
8.0701 Auctioneering
8.0704 General Buying Operations
8.0705 General Retailing Operations
8.0706 Gen Selling Skills & Sales Opn
8.0708 General Marketing Operations
8.0709 Genrl Distribution Operations
8.0799 Gen Retail/Whlsl Opns & Skills
8.0809 Home Products Marktng Operatns
8.081 Office Products Mrktng Operatn
8.0899 Home & Office Prod Mrktng Opns
8.0901 Hospitality/Rec Mrktng Opns,Gn
8.0902 Hotel/Motel Svc Mrktng Operatn
8.0903 Recreation Prod/Svcs Mrktng Op
8.0906 Food Sales Operations
8.0999 Hospitality/Rec Mrkt Opns, Oth
8.1001 Insurance Marketing Operations
8.1104 Tourism Promotion Operations
8.1105 Travel Srvcs Marketing Operatn
8.1199 Tourism/Travel Srvc Mrktng, Ot
8.1203 Vehicle Parts & Access Mrkt Op
8.1208 Vehicle Marketing Operations
8.1209 Petroleum Products Retail Opns
8.1299 Vehicle & Petrol Prod Mrkt Ops
8.1301 Health Products/Srvcs Mrkt Ops
8.9999 Mrktng Opns/Mrkt & Distrib, Ot
9.0101 Communications, General
9.0201 Advertising
9.0401 Journalism
9.0402 Broadcast Journalism
9.0403 Mass Communications
9.0499 Journalism/Mass Communications
9.0501 Public Relatns & Organiz Comm
9.0701 radio & television broadcastng
9.9999 Communications, Other
Core Institution Code Files Datatel Confidential 71 of 235
INSTITUTIONS file
The following contact information is provided for assistance in obtaining a file of secondary and post-secondary institutions
College Board ATP
Order Services Department
PO Box 6212
Princeton, NJ 08541
609-771-7243
Core Institution Code Files Datatel Confidential 72 of 235
***Departments are the only required piece of Institutional Hierarchy required by Colleague.
Is it a Department?
Does it have courses attached?
Does it have faculty attached?
(Is there a budget?)
12/6/04 - See Test account for complete up to date list
DESCRIPTION
SCHOOL ASSOCIATED CORE - DEPT
CODE DESCRIPTION DIVISION DESCRIPTION ASSOCIATED DEPT. ST - CRSE, FCTY, PROG,
Max 5 Letters (SCHL screen) Max 5 Letters (DIV, DEPT screens) Max 5 letters TRAN
GC Grossmont College CFA Communication / Fine Arts GANTH Anthropology
GART Art
GCOMM Communication
GDANC Dance
GMM Multi-media
GMUS Music
GSPCH Speech (old)
GTHTR Theater
Math / Natural Sciences /
MNS Exercise Sciences GASTR Astronomy
GBIO Biology
GCHEM Chemistry
GES Exercise Science
GGEOG Geography
GGEOL Geology
GHED Health Education
GMATH Math
GOCEA Oceanography
GPE Physical Education (old)
GPHYC Physics
GPSC Physical Science
GRECR Recreation (old)
GSCI Science
Humanities / Social and
HSB Behavioral Sciences
GARBC Arabic
GASL American Sign Language
GCCS Cross Cultural Studies
GCHIN Chinese
GECON Economics
GED Education
GENGL English
GESL English as a Second Language
GFORL Foreign Language
Core Institutional Hierarchy Datatel Confidential 73 of 235
GFREN French
GGERM German
GHEBR Hebrew
GHIST History
GHUM Humanities
GITAL Italian
GJAPN Japanese
GPHIL Philosophy
GPOSC Political Science
GPSY Psychology
GRELG Religious Studies
GRUSS Russian
GSOC Sociology
GSOSC Social Science
GSPAN Spanish
GTAB ????
Personal Development Special
PDV Personal Development GPDSS Services
Personal Development
GPDC Counseling
Business Professional
BPS Studies
GAOJ Administration of Justice
GBUS Business
GBOT Business Office Technology
GCA Culinary Arts
GCD Child Development
GCSIS Computer Science
GCVTE Cardiovascular Technology
GFACS Family & Consumer Studies
GFS Family Studies
GFSM Food Service Management
GHESC Health Sciences
GNURS Nursing
GOT Occupational Therapy (old)
GOTA Occupational Therapy Asst.
GRESP Respiratory Therapy
Speech Language Pathology
GSLPA Asst
**May combine with
business** GBUSA Business Administration
LR Learning Resources GRAP
IDS
Core Institutional Hierarchy Datatel Confidential 74 of 235
LI
LIR
CC Cuyamaca College DVI Division 1 CAUTO Auto
DVII Division 2 CBUS Business
COH Ornamental Horticulture
DVIII Division 3 CCD Child Development
CHED Health education
CES Exercise Science
CED Education
DVIV Division 4 PDC PDC
CPDSS PDSS
NC Non-Credit CDRV Driver's Education
CHAZ Hazmat
CL Community Learning (CE) CE Contract Education CE Contract Ed
FB Fee-Based FB Fee-Based
Core Institutional Hierarchy Datatel Confidential 75 of 235
Core Institutional Hierarchy Datatel Confidential 76 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
BENEFACTOR SPECIAL APPLICABLE
CORE.VALCODES VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
ACCESS.STATUSES NW No Wheelchair Access BLDG
Used for room scheduling AD Automatic Doors RMSM
CE Coding Entry
12/6/04 - Done and in test HA Handrail Access
RA Ramp Access
TDD TDD Communications
SA Security Alarm
EL Elevator
BLDG.OWNERSHIP.STATUSES BLDG
12/6/04 - Done and in test
not used for right now
BUILDING.CONDITIONS BLDG
12/6/04 - Done and in test
not used for right now
BUILDING.SECTORS BLDG
Done 10/1/04 in test
BUILDING.TYPES Pool BLDG
City Hall
12/6/04 - Track the types of buildings Hospital
where your courses are held - High School
Nursing Home
Marie to review this list Storage
Conference
Musuem
CONSTRUCTION.TYPES BLDG
Done 10/1/04
not needed
INSTITUTION.CODES BLDG
(Inst to which BLDG belongs)
Done 10/1/04
Not Needed
LOCATION.TYPES LOCN
Special Processing used with
Texas State Reporting
Done 10/1/04
Not needed
ROOM.CATEGORIES 10 Instruction Program RMSM
Can be used with Sched25/ 11 General Acad Instruction
Resource25 12 Voc'l/Technical Instr
13 Requisite Prepatory/Remedial Instr
More Follow-up for Resouce25 14 General Studies
15 Ocupational-Related Instr
12/6/04 - Andy has list from Resource25 16 Social Roles/Interaction Instr
to populate these 17 Home and Family Life Instr
18 Personal Interest and Leisure Instr
20 Research Program
21 Institutes & Research Ctr
22 Indiv or Project Research
30 Public Service
31 Direct Patient Care
32 Health Care Supportive Services
33 Community Services
34 Cooperative Extension Services
35 Public Broadcasting Services
40 Academic Support
41 Library Services
42 Museums and Galleries
43 Educational Media Services
44 Academic Computing Support
45 Ancilliary Support
46 Academic Admininstration
47 Course & Curriculum Devmt
48 Academic Personnel Devmt
50 Student Services
51 Student Services Admin
52 Social and Cultural Devmt
53 Counseling & Career Guid
54 Financial Aid Admin
55 Student Auxillary Services
56 Intercollegiate Athletics
57 Student Health/Medical Services
60 Institutional Administration Program
61 Executive Management
62 Financial Mgmt and Operations
63 General Admin and Logistical Services
64 Administrative Computing Support
65 Faculty & Staff Auxillary Services
66 Public Relations/Development
67 Student Recruitment and Admissions
68 Student Records
70 Physical Plant Operations
71 Physical Plant Administration
72 Building Maintenance
73 Custodial Services
74 Utilities
75 Landscape and Ground Maintenance
76 Major Repairs and Renovations
Although part of Program Classification Structure, 80 Student Financial Support
applies only to funds and not to space or activities.
90 Independent Operations
91 Independent Operations/Institutional
92 Independent Operations/External Agencies
0 Unassigned
01 Capable of use
02 Incapable of use
ROOM.CHARACTERISTICS Smart Classroom RMSM
LT Natural Lighting
Core Facilities Validation Codes Datetel Confidential 77 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
BENEFACTOR SPECIAL APPLICABLE
CORE.VALCODES VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
Andy is going to make a list MA Male Room
from R25 FE Female Room
IA Internet Access
12/6/04 - Andy to work on CT Cable/Closed Circuit TV
with Marsha and Joan NA Not Air-Conditioned
FC Carpeted
**Smart Classroom could just be FF Fixed Furniture
tracked with equipment. Maybe a generic FS Food Service Equip Avail
piece of equipment called "Smart Classroom" DSN DSN/Cable Connection
and then also have specific equipment.
BUT doublecheck how you are tracking
this kind of info in R25.
ROOM.RATE.CLASSES
12/6/04 - Done and in test
ROOM.WINGS RMSM
RESD
12/6/04 - Done and in test ARAS
ROOMS.MISC1 RMSM
12/6/04 - Done and in test
ROOMS.MISC2 A MISC2 A CODE
B MISC2 B CODE
C MISC2 C CODE
ROOMS.MISC3 A MISC3 A CODE
B MISC3 B CODE
C MISC3 C CODE
ROOMS.MISC4 A MISC4 A CODE
B MISC4 B CODE
C MISC4 C CODE
ROOMS.MISC5 A MISC5 A CODE
B MISC5 B CODE
C MISC5 C CODE
ROOMS.MISC6 A MISC6 A CODE
B MISC6 B CODE
C MISC6 C CODE
ROOMS.MISC7 A MISC7 A CODE
B MISC7 B CODE
C MISC7 C CODE
ROOMS.MISC8 A MICS8 A CODE
B MISC8 B CODE
C MISC8 C CODE
Core Facilities Validation Codes Datetel Confidential 78 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
APPLICABLE
CORE CODE FILES CODE CODE DESCRIPTION SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
BUILDINGS BLDG
Get Info from Sheila and others
12/6/04 - Andy and scheduling to enter buildings in Colleague
Add a good smattering of rooms - you don't need every room - this is for testing purposes only
LOCATIONS OC Off Campus LOCN
CC Cuyamaca College
Done 10/1/04 in test GC Grossmont College
LOCATION.REGIONS LCRG
12/6/04 - Done in test
OTHER.LOCATIONS OC Off Campus OLOC
12/6/04 - Done in test CC Cuyamaca College
GC Grossmont College
ROOM.TYPES CL Classroom RTYP
Can be used with Sched25/ LEC Lecture RMSM
Resource25 SCLB Science Lab
CMLB Computer Lab
12/6/04 - Scheduling and Andy STU Studio
Core Facilities Code Files Datatel Confidential 79 of 235
SHOP Shop/Mechanic
AV A/V Lab
MUSC Music
Check with Resource 25 DANC Dance
OFF Office
Room Type, Room Category, and Room CONF Conference Room
Usage codes - all ways to differentiate your SPEC Special
rooms. Start with Room Types - you may GEN General Use
not need anything else. FOOD Food Facility
ROOM.USAGES RMUD
12/6/04 - Probably won't use RMSM
ROOMS RMSM
These are associated to the
building ie. AND*101 with AND
equal to Anderson Hall and 101
equal to Room 101
12/6/04 - To be entered with buildings
EQUIPMENT Computer EQPM
Projector
12/6/04 - Andy and scheduling Document Cameras
Defer to R25 list Overheads
Chalkboards
**See Room Characteristics for add'l note White Board
Map
Sink
Dark Room
Drawing Table
Athletic Equipment
Core Facilities Code Files Datatel Confidential 80 of 235
** = Codes that are mandatory if using Resource 25/Schedule 25
^ = Optional Codes if using Resource 25/Schedule 25
9/10/04 - Madelaine, Marsha, Joan, Marie, Bill and Stan Moore will think about these codes before second CORE team meeting.
These codes relate to the building itself and are connected to buildings on the BLDG screen These codes are related to Rooms. They are attached to a room on the RMSM screen
Bldg Building Ownership Construction Construction Renovation Building Gross/Net Room Room Phone / Nat'l ID Max # Min #
Location Code Name/Address Bldg Type Sector Status Type Yr Yr Condition Access Code Size Area Perimeter Rooms Desc Room Cat Primary Use Secondary Use Characteristic ^ Access Codes Extension/Type Wing Floor (CIP Code) Rm Type ^ ** ^ Area Rate Class Box # Equipment
Defer to
WA - Wheelchair Residence
SC - South DER John Deere Complex AC - Academic Owned Brick Satisfactory Accessible 101 Office 4.6 AcadAdm 46-AcadAdmin WA - Wheelchair Accessible 310-Office 4 1 Life Training
<vocational> 102 Office 4.6 AcadAdm 46-AcadAdmin WA - Wheelchair Accessible 310-Office 4 1
1200 Old Cedar Dr 110 Lecture 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 111-Lecture 300 50 1-TV;1-PROJ;1-PROSC;1-VCR
Waldorf, MD 20602 120 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
125 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
130 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
DIS-District 800 Building 800 135 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
900 Building 900 140 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
145 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
150 Shop 1.2 VocInst 12-Voc/TechInst NA - No A/C WA - Wheelchair Accessible 213-Shop/Mech 50 5 1-CALBR;1-CMPSR;1-SOLD;1-WELD
GRS-
Grossmont 100 Building 100 155 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
100-CLMPS;1-CMPSR;5-RDSAW;2-
ROUTR;5-SANDR;2-SOLD;5-TBSAW;1-
200 Building 200 160 Shop 1.2 VocInst 12-Voc/TechInst NA - No A/C WA - Wheelchair Accessible 213-Shop/Mech 50 5 WELD
Field Baseball Field 165 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
GPOOL Grossmont Pool 170 Barn 1.2 VocInst 12-Voc/TechInst NA - No A/C WA - Wheelchair Accessible 570-AnimalQtr 50 5 10-LIVE; 2-TRAC;1-TRAL;1-TACK
GTRCK Grossmont Track 175 Class 1.2 VocInst 12-Voc/TechInst WA - Wheelchair Accessible 110-Classrm 30 5
CUY-
Cuyamaca A Building A
B Building B
C Building C
CGYM Cuyumaca Gym
CTRCK Cuyumaca Track
OFF - Off
Campus El Cajon City Hall
Singing Hall Golf
Course
Parkway Bowl
Regency Conv Home
Viejas Casino
Web
Frogs Pool
Water Districts
Core Facilities Inventory Worksheet Datatel Confidential 81 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
SPECIAL APPLICABLE
CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
CALENDAR.DAY.TYPES FLEX Mandatory Flex Day CMPS
Special Processing Definition: VFLX Variable Flex Day
HO = In 1st column of sp. prcs SHOL State Mandated Holiday HO;HO
this denotes a holiday for LHOL Local Clg/Dist Holiday HO
scheduling purposes. DEXM Final Exam - Day Classes
HO = In 2nd column of sp. prcs EEXM Final Exam - Evening Cls
this denotes a holiday for EXAM Final Exam - All Classes
refund purposes.
MIS Code
12/6/04 - Done and in test
CONTACT.RESULTS CON
12/6/04 - Done and in test
CONTACT.ROLES CON
12/6/04 - Done and in test
EVENT.TYPES AE Activities/Events AE; 136 CMPS
This code is linked to other modules. Act. & Events
The special processing code permits BK Block out time BK Fac. Info
this link. COM Committee Meetings Scheduling
CS Course Sections Meetings CS; 96
Special Processing Definition: NSO New Student Orientation
BK = Block out time FAO Faculty Office Hours FI
CS = Course Section Meetings (include GLC Guest Lecture
96 in 2nd column for linkage) GRH Graduation Rehearsal
HO = Holiday HO Holiday HO
AE = Activities and Events (include REM Reminders/Appointments REM
136 in 2nd column for linkage) SV Student Visit
FI = Faculty Office Hours VIP VIP Tour
REM = Appointment Reminders ST Staff Activity
Can we change the code to HOL from HO
12/6/04 - Discuss further with Curriculum/course section meeting date creation.
You won't need this full list
REMINDER.PURPOSES C Cultivation CASM
S Solicitation APPT
12/6/04 - Done and in test I Involvement
P Personal
F Professional
R Recruitment
REMINDER.STATUS O Open APPT
C Closed
12/6/04 - Done and in test P Postponed
R Rescheduled
C Cancelled
STAFF.REMINDER.TYPES RI Reception Invitation CON
CA Call for Appointment
12/6/04 - Won't use TH Thank You
Leave codes here since MIS CR Check Research
PV Personal Visit
MIS Code PH Phone Call
LT Letter
**There are a lot of required fields IN Interview
in this process. See chapter 10 ME Meeting
of CORE Learning Guide. PD Professional Development
MS Mobility Services
VS Visually Impaired Service
HS Hearing Impaired Service
SS Speech/Language Service
DS Devel Delayed Service
BS Acquired Brain Injury Svc
LS Learning Disability Svc
PS Psych Disability Service
OS Other Disability Service
AC Acad Counseling/Advisemt
CC Career Counseling
PC Personal Counseling
PT Placement Testing
OR Orientation
EP Student Educational Plan
AF Academic Follow-up
OA Other Assessment Service
AT Aptitude Test
SL Study/Learning Assessment
TR Transfer Service
VA VATEA Contact
Core Scheduling Validation Codes Datatel Confidential 82 of 235
Codes and Descriptions in BOLD type indicate highest priority; decisions should be made, tested and entered in
Live account by first Live date.
Other codes are secondary in priority and not required for going Live; determine use after decisions are made as
to use of screen and/or field.
APPLICABLE
CORE CODE FILES CODE CODE DESCRIPTION SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
CAMPUS.CALENDAR GCCCD GCCCD Default Calendar CMPC
12/6/04 - Nancy and Andy to add calendar ACTM
on CMPC screen for the default calendar PID2
Core Scheduling Code Files Datatel Confidential 83 of 235
d entered in
are made as
Core Scheduling Code Files Datatel Confidential 84 of 235
When implementing the Colleague SEVIS Batch Process, the following parameters will need to be completed. If you a
implementing the SEVIS Batch Process, then you do NOT need to complete this information.
Defer to Laith & Nancy
SCREEN PARAMETER FIELD
SEVP SEVIS Parameters
Inst Alt ID Type
Person Alt ID Type
DSO Alt ID Type
RO Alt ID Type
Sponsor Alt ID Type
Local Addr Hierarchy
Foreign Addr Hierarchy
Visa Types
Default DSO
Default RO
Default Sponsor
Default Sponsoring Agencies
English Proficiency Tests
English Proficiency Rules
Term Length
St/End Invalid SSNs
Expense Rules
SEVA SEVIS Additional Parameters
Dependent Add Statuses
Dependent Reactivate Statuses
Vacation Term Sessions
Vacation Hiatus Codes
Days Before Start
Term Completion Date Used
Commuter Rules
Employer ID
Default PDSO
PDSO Rule
DSO Rule
School Code Rule
Get Request Comm
Get Request Test
following parameters will need to be completed. If you are not
ed to complete this information.
PARAMETER SETTING
Inst SEVIS ID
SEVIS ID
SEVIS ID
SEVIS ID
Inst SEVIS ID
SEVIS.LOCAL
FOREIGN
F1
The reasons on the I-20 to say why English is not
required, should be entered on each individual
program on the APRI screen.
9
Active
Reactivate
Summer
7
egov.immigration.gov
443
/sbtsevisbatcu/action/batchDownload
Yes
To track international student data in Colleague, the following codes should be discussed and added into Colleague. Many of these
codes will be discussed as part of CORE, though some of them lie in ST. We compiled all international student codes here for you
to see them as a whole.
Laith & Nancy to review
SPECIAL APPLICABLE
ST & CORE.VALCODES CODE CODE DESCRIPTION PROCESSING SCREENS
ALIEN.STATUSES (CORE) N Non-Resident Alien FINF
R Resident Alien FPER
12/6/04 Done and in test NIIS
EMPLOYMT.REASONS (CORE) ECON Economic Hardship
INTL International Organization
Use As Delivered RELIF Student Relief
Do NOT change these codes.
EMPLOYMT.STATUSES (CORE) PT Part Time C EMPD
Linked with the translation table FT Full Time C
for OPT/CPT and off Campus Emp. FO Former F
Be sure to have PT and FT in your
valcode table
12/6/04 Done and in test
FOREIGN.FUND.SOURCES (CORE) PERS Personal funds 1 FPFN
FAMILY Family funds EXVS
Special Processing as follows: SPON Sponsor funds 2
1 - personal funds STEMPL Student employment 5
2 - institution or sponsor funds STCOM Student community aid
3 - US government agency EVSPON Exchange visitor sponsor 2
4 - international organization EVGOVT Exchange visitor's govt 6
5 - employment EVBICO Exchange binatl Commissn 7
6 - foreign government AID Agency for Intl Dev 3
7 - foreign binational Commission USIA US Info Agency 3
null = other funds ECOSOC UN Econ & Social Council 4
OAS Org of American States 4
Core SEVIS Validation Codes Datatel Confidential 89 of 235
12/6/04 Done and in test
IMMIGRATION.STATUSES (CORE) 2 Permanent Resident FINF
12/6/04 Done and in test 3 Temporary Resident FPER
4 Refugee / Asylee
MIS Code 5 Student Visa (w/F1 or M1)
This field is not reported to SEVIS but 6 Other
is used for internal tracking purposes 7 Status Unknown
The VISA.TYPES Valcode is reported
for international students.
LANGUAGES (CORE) E English FINF
N Not English DADD
Add any languages you wish to track X Unknown / Uncollected SHAP
in Colleague. Not a required code for LANG
SEVIS
12/6/04 Done and in test
MIS Code
PORTS.OF.ENTRY (CORE) ABG Alburg VT POM TRVD
ABQ Albuquerque NM
If you will track the Port of Entry in Colleague ABS Alburg Springs VT
Please ensure that Colleague has the ADT Amistad Dam TX
COMPLETE list of POE's to select from. AGA Agana Guam
The delivered list is NOT complete. ALB Albany NY
The complete list can be found from the AMB Ambrose ND
ICE Gov't Website. ANC Anchorage AK
BAL Baltimore MD
12/6/04 Done and in test BBM Brownsville-Matamor TX
COW Headquarters
CRP Corpus Christi TX
CRY Carbury ND
DAC Daltons Cache AK
DAL Dallas TX
DCB Detroit MI (bridge)
DCT Detroit MI (tunnel)
Core SEVIS Validation Codes Datatel Confidential 90 of 235
DEN Denver CO
DER Derby Line VT (I-91)
DET Detroit MI
DLB Del Bonita MT
GAL Galveston TX
GUL Gulfport MS
HAR Hartford CT
HHW Honolulu HI
HOU Houston TX
INT International Falls MN
IVP Calexico-East CA
JAC Jacksonville FL
KAN Kansas City MO
KEY Key West FL
LOU Louisville KY
LVG Las Vegas NV
MIA Miami FL
MIL Milwaukee WI
MOB Mobile AL
NEW Newark NJ
NIA Niagara Falls NY
NOL New Orleans LA
NOR Norfolk VA
NSV Nashville TN
NYC New York NY
OKC Oklahoma City OK
OMA Omaha NE
ORL Orlando FL
OTT Ottawa, Canada
PHI Philadelphia PA
PHO Phoenix AZ
PIT Pittsburgh PA
POM Portland ME
POO Portland OR
PRO Providence RI
PTL Porthill ID
RDU Raleigh/Durham NC
Core SEVIS Validation Codes Datatel Confidential 91 of 235
SAV Savannah GA
SDP San Diego CA
SEA Seattle WA
SET Seattle WA
SFR San Francisco CA
SLC Salt Lake City UT
SPM St Paul MN
SPO Spokane WA
TOL Toledo OH
TOR Toronto, Canada
WAS Washington DC
RELATION.STATUSES (CORE) A Active RELE
L Left Country SPO
Use As Delivered O Over 21 SEVA
Do NOT change these codes. D Divorced
E Estranged
G Principal graduated
T Principal terminated
R Reactivate
REMARK.TYPES (CORE) SVADP SEVIS Add Dependent 2 PREM
Sp processing will link remark with SVUDP SEVIS Update Dependent 8
SEVIS reporting as follows: SVTDP SEVIS Terminate Dependent 7
Discuss as part of SEVIS Training SVRTI SEVIS Real Time Entry
AM.REMARK.TYPES (STUDENT) SVFND SEVIS Funding Remarks 1 AREM
SVPRG SEVIS Program Remarks 9
Discuss as part of SEVIS Training SVTER SEVIS Terminate Student 7
SVADD SEVIS Create Student 2
SVDEF SEVIS Defer Program 12
SVOTH SEVIS Other Remark 4
SVUPF SEVIS Update Funding 16
SVRTI SEVIS Real Time Entry
STUDENT.REMARK.TYPES (STUDENT) SVFND SEVIS Funding Remarks 1 STRK
SVPRG SEVIS Program Remarks 9
Core SEVIS Validation Codes Datatel Confidential 92 of 235
Discuss as part of SEVIS Training SVTER SEVIS Terminate Student 7
SVADD SEVIS Create Student 2
SVDEF SEVIS Defer Program 12
SVOTH SEVIS Other Remark 4
SVUPF SEVIS Update Funding 16
SVGRD SEVIS Graduation Remark 6
SVPOE SEVIS Port of Entry 3
SVDFT SEVIS Drop Below FT 11
SVRFT SEVIS Resume FT 16
SVDIS SEVIS Disciplinary Action 13
SVEXT SEVIS Extend Program 5
SVEMP SEVIS OPT/CPT Employment 18
SVRTI SEVIS Real Time Entry
SEVIS.EDUC.LEVELS (STUDENT) 01 Primary
02 Secondary
Use As Delivered 03 Associate
Do NOT change these codes. 04 Bachelor's
05 Master's
12/6/04 Done and in test 06 Doctorate
07 Language Training
08 High School
09 Flight Training
10 Other Vocational School
11 Other Vocational School
SEVIS.EXPENSE.TYPES (STUDENT) TUI Tuition 1
Special Processing: LIV Living 2
1 = Tuition DEP Dependent 3
2 = Living
3 = Dependent
4 = Other
Will put the expenses on the correct line
of the I-20
12/6/04 Done and in test
Core SEVIS Validation Codes Datatel Confidential 93 of 235
SEVIS.FORM.PURPOSES (CORE) 0 Work in progress EXVS
1 Initial reporting 1 NIIS
Sp processing is used to 2 Continue at school 2
triggering specific documents for 2a Continue at school (alt) 2
SEVIS reporting. 1611 Failure to Enroll 1611
1605 Authorize Below FT Exceed 1605
Do NOT change these codes. 1604 Unauthorize Drop Below FT 1604
12/6/04 Done and in test 3 Extend current program 3
Be sure your valcode table in CORE 4 Transfer to another pgm 4
has the following: 5 School transfer 5
2a 601 Replace - traveling 6; 01
1611 602 Replace - lost 6; 02
1604 603 Replace - stolen 6; 03
1605 604 Replace - damaged 6; 04
605 Replace - other 6; 05
These were part of a post-install 7 Add dependent 7
instructions in a software update for the 8 Pending reinstatement 8
SEVC process. 9 Defer attendance 9
10 Extend failure 10
11 Conclude failure 11
12 Approval failure 12
13 Correct minor infraction 13
14 Other 14
15 Resume full course 15
16 Terminated 16
SEVIS.PART.TIME.REASONS (STUDENT) 01 Illness / Medical Condition
02 English Difficulties
Use As Delivered 03 Reading Difficulties
Do NOT change these codes. 04 Teaching Difficulties
05 Improper Placement
12/6/04 Done and in test 06 Finishing in Current Term
07 Part Time Commuter Student
SEVIS.PROGRAM.CATEGORIES (CORE) 1A Student Secondary EXVS
Core SEVIS Validation Codes Datatel Confidential 94 of 235
1B Student Associate
Codes should be taken 1C Student Bachelors
from BCIS "SEVIS Lookup 1D Student Masters
Tables" document that is 1E Student Doctorate
downloadable from the BCIS 1F Student Non-Degree
website. 2A Trainee: Specialty
2B Trainee: Non-Specialty
3 Teacher
Setup only if reporting and/or tracking 4 Professor
J-1 exchange visitors. 5 International Visitor
12/6/04 Done and in test 6 Alien Physician
Won't use J-Program, but no need to delete these7 Government Visitor
since the J-program Colleage Screens won't be 8 Research Scholar
used 9 Short-term Scholar
10 Specialist
11 Camp Counselor
12 Summer/Work/Travel
13 Au Pair
SEVIS.PROGRAM.END.REASONS (CORE) 1 Withdrawal EXVS
2 Unable to continue
Setup only if reporting and/or tracking 3 Death
J-1 exchange visitors. 4 Finished early
Codes should be taken 12/6/04 Done and in test
from BCIS "SEVIS Lookup Won't use J-Program, but no need to delete these
Tables" document that is since the J-program Colleage Screens won't be
downloadable from the BCIS used
website.
SEVIS.TRANS.STATUSES (CORE) S Sent SEVM
Use As Delivered U Updated SVRS
Do NOT change these codes. E Error
12/6/04 Done and in test D Delete
SEVIS.VISITOR.END.REASONS (CORE) 1 Program activity failure EXVS
2 No health insurance
Core SEVIS Validation Codes Datatel Confidential 95 of 235
Setup only if reporting and/or tracking 3 Criminal conviction
J-1 exchange visitors. 4 Disciplinary action
5 Unauthorized employment
Codes should be taken 6 Sponsor rule violation
from BCIS "SEVIS Lookup 7 Program rule violation
Tables" document that is 8 Drop to part time
downloadable from the BCIS 9 Suspension
website. Won't use J-Program, but no need to delete these
12/6/04 Done and in test since the J-program Colleage Screens won't be
used
VISA.TYPES (CORE) Complete list in test account TRVD
SEVP
The VISA.TYPES Valcode is reported FPER
for international students.
Immigration Status is not reported to
SEVIS but is used for internal
tracking purposes
12/6/04 Done and in test
Core SEVIS Validation Codes Datatel Confidential 96 of 235
Core SEVIS Validation Codes Datatel Confidential 97 of 235
To track international student data in Colleague, the following codes should be discussed and added into Colleague. Many of these
codes will be discussed as part of CORE, though some of them lie in ST. We compiled all international student codes here for you
to see them as a whole.
Laith and Nancy to review
CODE FILES CODE CODE DESCRIPTION
VOCATIONS SVOPT SEVIS OPT Employment
3 recommended vocation codes SVCPT SEVIS CPT Employment
to be used specifically for SEVIS SVOFF SEVIS Off Campus Employment
12/6/04 Done and in test
EXCHANGE VISITOR POSITIONS 100 CATEGORY - GOV'T
110 CENTRAL GOV'T GROUP
Codes should be taken 111 HEAD OF GOV'T
from BCIS "SEVIS Lookup 112 MINISTERIAL LEVEL OFFICIAL
Tables" document that is 113 EXEC LEVEL OFFICIAL
downloadable from the BCIS 114 CIVIL SERVICE EMPLOYEE IN CENTRAL GOV'T
website. 115 PROFESSIONALS & SCIENTISTS IN CENTRAL GOV'T
116 LEGISLATOR IN CENTRAL GOV'T
117 JUDGES IN CENTRAL GOV'T
118 MANAGER OF STATE ENTERPRISE
Setup only if reporting and/or tracking 119 CENTRAL GOV'T, OTHER
J-1 exchange visitors. 120 REGIONAL, STATE OR PROVINCIAL GOV'T GROUP
121 GOVERNOR OR OTHER CHIEF OF REGIONAL UNIT
12/6/04 Done and in test 122 SENIOR HEAD OF REGIONAL DEPT.
123
Won't use J-Program, but no need to delete these EXEC LEVEL REGIONAL OFFICIALS
124
since the J-program Colleage Screens won't be CIVIL SERVICE EMPLOYEE IN REGIONAL/STATE GOV'T
used 125 PROFESSIONALS & SCIENTISTS IN REGIONAL GOV'T
126 LEGISLATOR IN REGIONAL OR STATE GOV'T
127 JUDGES IN REGIONAL OR STATE GOV'T
128 MANAGER OF REGIONAL ENTERPRISE
129 OTHER, REGIONAL GOV'T
130 CITY OR TOWN GOV'T GROUP
131 MAYOR OR CITY MANAGER
132 HEAD OF CITY DEPARTMENT
133 EXEC LEVEL CITY OR TOWN OFFICIALS
Core SEVIS Code Files Datatel Confidential 98 of 235
134 CIVIL SERVICE EMPLOYEE IN CITY OR TOWN GOV'T
135 PROFESSIONALS & SCIENTISTS IN CITY OR TOWN GOV'T
136 LEGISLATOR IN CITY OR TOWN GOV'T
137 JUDGES IN CITY OR TOWN GOV'T
138 MANAGER OF CITY ENTERPRISE
139 OTHER, CITY OR TOWN GOV'T
140 INT'L ORGANIZATION GROUP
141 HEAD OF INT'L ORGANIZATION GROUP
142 SENIOR OFFICIAL OF INT'L ORGANIZATION
143 EMPLOYEE OF INT'L ORGANIZATION
200 CATEGORY - ACADEMIC COMMUNITY
210 UNIV LEVEL GROUP
211 UNIV PRESIDENT OR RECTOR
212 UNIV ADMINISTRATIVE STAFF
213 UNIV TEACHING STAFF INCLUDING RESEARCHERS
214 UNIV GRADUATE STUDENTS
215 UNIV UNDERGRADUATE STUDENTS
216 UNIV MEDICAL SCHOOL STUDENTS
217 UNIV SCHOOL STUDENTS IN OTHER PROFESSIONS
218 UNIV POST GRAD MEDICAL TRAINEE
219 OTHER UNIV
220 SECONDARY SCHOOL GROUP
221 SECONDARY SCHOOL PRINCIPAL
222 SECONDARY SCHOOL TEACHER OR STAFF
223 SECONDARY SCHOOL STUDENT
229 OTHER SECONDARY SCHOOL
230 ELEMENTARY SCHOOL GROUP
231 TEACHER OR STAFF" ELEMENTARY PRINCIPAL
239 OTHER ELEMENTARY SCHOOL
240 SPECIAL SCHOOLS, INSTITUTES, OR VOCATIONAL SCHOOL GROUPS
241 SPECIAL SCHOOL, INSTITUTE, OR VOCATIONAL HEAD
242 SPECIAL SCHOOL, INSTITUTE, OR VOCATIONAL TEACHER OR STAFF
249 SPECIAL SCHOOL, INSTITUTE, OR VOCATIONAL - OTHER
300 CATEGORY - PRIVATE SECTOR
310 PRIVATE BUSINESS GROUP
311 PRIVATE BUSINESS ENTREPRENEUR
312 CORPORATE EXEC
Core SEVIS Code Files Datatel Confidential 99 of 235
313 MANAGER EMPLOYED BY PRIV.BUS
314 EMPLOYEE OF PRIVATE BUSINESS
315 PROFESSIONAL OR SCIENTISTS IN PRIVATE BUSINESS
319 PRIVATE BUSINESS, OTHER
320 SELF-EMPLOYED PROFESSIONALS GROUP
321 SELF-EMPL.PROFES.(LEGAL FIELD)
322 SELF-EMPL.PROFES.(MEDICAL FLD)
323 SELF-EMPL.PROFES.(TECH.FIELD)
329 SELF-EMPL.PROFES.-OTHER
330 INDEPENDENT, NON-PROFIT, HOSPITALS, OR OTHER ORGANIZATION GROUPS
331 DIR. OF INSTIT/CORP.OR HOSPITAL
332 MANAGER-EXEC EMPL.BY INST/CORP
334 EMPLOYEE OF IND.INSTIT OR CORP
335 INSTIT/CORP PROFESS.NAL/SCIEN.
339 INDEPENDENT, NON-PROFIT, HOSPITALS, OR SIMILAR ORGANIZATION - OTHER
340 AGRICULTURE (INCL. FORRESTRY & FISHERIES) GROUP
341 AGRICULTURAL ENTREPRENEUR
342 EXEC OF AGRICULT BUSINESS
343 AGRICULTURAL MANAGER
344 EMPLOYEE OF AGRICUL.ENTERPRISE
345 PROFESSIONAL OR SCIENTISTS IN AGRICULTURE
349 AGRICULTURE, OTHER
350 RELIGION GROUP
351 MINISTER OF RELIGION
352 RELIGIOUS ORDER/CONGREGAT.MBER
353 THEOLOGIAN
400 CATEGORY - THE ARTS & SPORTS
410 THE ARTS GROUP
411 ARTIST (GRAPHIC ARTS)
412 AUTHOR (PLAYWRIGHT POET)
413 STAGE OR FILM ACTOR
414 FILM (OR STAGE) PRODUCER
415 COMPOSER OR MUSICIAN
419 ARTS OTHER
420 THE SPORTS GROUP
421 ATHLETE
422 COACH
Core SEVIS Code Files Datatel Confidential 100 of 235
429 SPORTS OTHER
500 CATEGORY - LABOR
510 LABOR UNION GROUP
511 LABOR UNION HEAD
512 LABOR UNION OFFICIAL
513 LABOR UNION OTHER
520 LABOR UNION MINISTRY GROUP
521 LABOR MINISTER(OR LAB.AG.HEAD)
522 SENIOR MINISTERIAL OFFICIAL
523 MINISTERIAL OR LABOR AG.EMPL.
529 MINISTRY OF LABOR OTHER
530 LABOR EXPERTS IN ACADEMIA GROUP
531 CODE DELETED - SEE 213
539 LABOR EXPERTS IN ACADEMIA OTHER
540 LABOR ORGANIZATION & OTHER LABOR GROUPS
541 HEAD OF LABOR ORGANIZATION
542 EMPLOYEE OF LABOR ORGANIZATION
600 CATEGORY - COMMUNICATIONS
610 ELECTRONIC MEDIA GROUP
611 HEAD OF TV OR RADIO STATION
612 RADIO OR TV JOURNALIST
613 ELECTRONIC MEDIA TECHNICIAN
619 ELECTONIC MEDIA OTHER
620 PRINTED MEDIA GROUP
621 EDITOR &/OR PUBLISHER
622 JOURNALIST
623 TECH.OFFI.IN PRINTED MEDIA FLD
629 PRINTED MEDIA OTHER
630 FILM AS NEWS MEDIA GROUP
631 FILM MAKER
639 FILM AS NEWS MEDIA OTHER
700 CATEGORY - IMPORTANT POLITICAL FIGURES NOT CLASSIFIED ELSEWHERE
710 OPPOSITION LEADER(NOT IN GOVT)
720 OPPOSITION LEADER - LEGISLATURE GRP
730 FORMER INFLUENTIAL POLITICAL OFFICIAL
790 IMPORTANT POLITICAL FIGURE
800 CATEGORY - MILITARY
Core SEVIS Code Files Datatel Confidential 101 of 235
900 CATEGORY - OTHER
VISA ISSUING POSTS ABD ABU DHABI
ABJ ABIDJAN
Codes should be taken ABU ABUJA
from BCIS "SEVIS Lookup ACC ACCRA
Tables" document that is ADA ADDIS ABADA
downloadable from the BCIS ADN ADANA
website. AKD ASHGABAT
ALG ALGIERS
Not required to track this information by ALX ALEXANDRIA
SEVIS. AMM AMMAN
AMS AMSTERDAM
ANK ANKARA
12/6/04 Done and in test ANT ANTANANARIVO
APA APIA
ASC ASUNCION
ATA ALMA ATA
ATH ATHENS
ATW ANTWERP
AUC AUCKLAND
BAG BAGHDAD
BAM BAMAKO
BAN BANGKOK
BAR BARRANQUILLA
BDS BANDAR SERI BEGAWAN
BEI BEIJING
BEL BELEM
BER BERLIN
BET BELFAST
BGD BELGRADE
BIL BILBAO
BIS BISSAU
BKK BISHKEK
BKU BAKU
BLA BLANTYRE
BLZ BELIZE CITY
Core SEVIS Code Files Datatel Confidential 102 of 235
BNG BANGUI
BNJ BANJUL
BOG BOGOTA
BOM BOMBAY
BON BONN
BOR BORDEAUX
BRA BRASILIA
BRC BARCELONA
BRE BREMEN
BRI BRIDGETOWN
BRN BERN
BRT BEIRUT
BRU BRUSSELS
BRV BRAZZAVILLE
BSB BRISBANE
BTS BRATISLAVA
BUC BUCHAREST
BUD BUDAPEST
BUE BUENOS AIRES
BUJ BUJUMBURA
BUK BUKAVU
CAI CALI
CAL CALCUTTA
CAN CANBERRA
CAO CAIRO
CAP CAPE TOWN
CAR CARACAS
CAS CASABLANCA
CDJ CIUDAD JUAREZ
CEB CEBU
CHE CHENGDU
CHN CHIANG MAI
CLG CALGARY
COL COLOMBO
CON CONAKRY
COP COPENHAGEN
COT COTONOU
Core SEVIS Code Files Datatel Confidential 103 of 235
CUR CURACAO
DAC DHAKA
DAK DAKAR
DAM DAMASCUS
DAR DAR ES SALAAM
DBI DUBAI
DHA DHAHRAN
DHB DUSHANBE
DJI DJIBOUTI
DOH DOHA
DOU DOUALA
DUB DUBLIN
DUR DURBAN
DUS DUSSELDORF
EDI EDINBURGH
FKT FRANKFURT
FLO FLORENCE
FRE FREETOWNN
FUK FUKUOKA
GAB GABORONE
GEN GENEVA
GNG GUANGZHOU
GOA GENOA
GTW GEORGETOWN
GUA GUATEMALA
GUJ GUADALAJARA
GUQ GUAYAQUIL
HAG HAGUE
HAI HAIFA
HAL HALIFAX
HAM HAMBURG
HAR HARARE
HAV HAVANA
HCM HO CHI MINH CITY, VIETNAM
HEL HELSINKI
HER HERMOSILLO
HKG HONG KONG
Core SEVIS Code Files Datatel Confidential 104 of 235
HMN HAMILTON
HON HONIORA
ISL ISLAMABAD
IST ISTANBUL
IZM IZMIR
JAK JAKARTA
JER JERUSALEM
JID JEDDAH
JOH JOHANNESBURG
KAB KABUL
KAD KADUNA
KAM KAMPALA
KAP KARACHI
KAT KATHMANDU
KEV KIEV
KHA KHARTOUM
KIG KIGALI
KIN KINGSTON
KNS KINSHASA
KNV CHISINAU
KOL KOLONIA
KOR KOROR
KRA KRAKOW
KUL KUALA LUMPUR
KUW KUWAIT
LAG LAGOS
LAH LAHORE
LAP LA PAZ
LEI LIEPZIG
LEN LENINGRAD
LIB LIBREVILLE
LIL LILONGWE
LIM LIMA
LIS LISBON
LIV LIVERPOOL
LOM LOME
LON LONDON
Core SEVIS Code Files Datatel Confidential 105 of 235
LUA LUANDA
LUB LUBUMBASHI
LUS LUSAKA
LUX LUXEMBOURG
LYN LYON
MAA MANAMA
MAD MADRID
MAJ MAJURO
MAL MALABO
MAN MANILA
MAP MAPUTO
MAR MARACAIBO
MAS MASERU
MAT MATAMOROS
MAZ MAZATLAN
MBA MBABANE
MDR MADRAS
MDS MADRAS
MED MEDAN
MEL MELBOURNE
MER MERIDA
MEX MEXICO CITY
MIL MILAN
MNG MANAGUA
MNT MONTREAL
MOG MOGADISHU
MON MONROVIA
MOR MORONI
MOS MOSCOW
MRS MARSEILLE
MRT MARTINIQUE
MSA MOMBASA
MSK MINSK
MTR MONTERREY
MTV MONTEVIDEO
MUN MUNICH
MUS MUSCAT
Core SEVIS Code Files Datatel Confidential 106 of 235
NAH NAHA
NAI NAIROBI
NAP NAPLES
NAS NASSAU
NDJ N.DJAMENA
NDL NEW DELHI
NIA NIAMEY
NIC NICOSIA
NOU NOUAKCHOTT
NUV NUEVO LAREDO
OPO OPORTO
ORN ORAN
OSK OSAKA-KOBE
OSL OSLO
OTT OTTAWA
OUA OUAGADOUGOU
PAG PORTO ALEGRE
PAL PALERMO
PAN PANAMA CITY
PAP PORT-AU-PRINCE
PAR PARIS
PDE PONTA DELGADA
PER PERTH
PES PESHAWAR
PHP U. S. CONSOL PHNPM PENN
PLS PORT LOUIS
PMB PORT MORESBY
POS PORT OF SPAIN
POZ POZNAN
PPO PAGO PAGO
PRA PRAIA
PRB PARAMARIBO
PRE PRETORIA
PRG PRAGUE
PRM PARAMARIBO
PSN PUSAN
QUE QUEBEC
Core SEVIS Code Files Datatel Confidential 107 of 235
QUI QUITO
RAB RABAT
RAN RANGOON
RDJ RIO DE JANEIRO
REC RECIFE
REY REYKJAVIK
RGA RIGA
RID RIYADH
ROM ROME
ROT ROTTERDAM
SAJ SAIPAN
SAL SALISBURY
SAN SANTIAGO
SAP SAO PAULO
SEO SEOUL
SEV SEVILLE
SGE ST. GEORGES
SHA SHANGHAI
SIN SINGAPORE
SLZ SALZBURG
SNA SANAA
SND SANTO DOMINGO
SNJ SAN JOSE
SNS SAN SALVADOR
SNY SHENYANG
SOF SOFIA
SOK SONGKHLA
SPP SAPPORO
SPT ST. PETERSBURG
STJ ST. JOHNS
STO STOCKHOLM
STR STRASBOURG
STU STUTTGART
SUR SURABAYA
SUV SUVA
SVD SALVADOR
SYD SYDNEY
Core SEVIS Code Files Datatel Confidential 108 of 235
TAI TAIPEI
TAL TALLINN
TAN TANGIER
TBL TBILISI
TEG TEGUCIGALPA
TEH TEHRAN
TEL TEL AVIV
THE THESSALONIKI
THT TASHKENT
TIA TIRANA
TIJ TIJUANA
TOK TOKYO
TOR TORONTO
TRI TRIESTE
TRP TRIPOLI
TUN TUNIS
UDN UDORN
ULN ULAANBAATAR
VAL VALLETTA
VAN VANCOUVER
VAT VATICAN CITY
VIC VICTORIA
VIE VIENNA
VIL VILNIUS
VIT VIENTIANE
VW VISA WAIVER
WAR WARSAW
WDC WASHINGTON
WEL WELLINGTON
WHK WINDHOEK
WIN WINNEPEG
YAO YAOUNDE
YRV YEREVAN
ZAG ZAGREB
ZUR ZURICH
Core SEVIS Code Files Datatel Confidential 109 of 235
APPLICABLE
SCREENS
VOCD
EVPO
EXVS
Core SEVIS Code Files Datatel Confidential 110 of 235
Core SEVIS Code Files Datatel Confidential 111 of 235
Core SEVIS Code Files Datatel Confidential 112 of 235
Core SEVIS Code Files Datatel Confidential 113 of 235
VISP
TRVD
Core SEVIS Code Files Datatel Confidential 114 of 235
Core SEVIS Code Files Datatel Confidential 115 of 235
Core SEVIS Code Files Datatel Confidential 116 of 235
Core SEVIS Code Files Datatel Confidential 117 of 235
Core SEVIS Code Files Datatel Confidential 118 of 235
Core SEVIS Code Files Datatel Confidential 119 of 235
Core SEVIS Code Files Datatel Confidential 120 of 235
Core SEVIS Code Files Datatel Confidential 121 of 235
The following codes can be used as delivered.
CORE.VALCODES CODE CODE DESCRIPTION SP PRC DEFN. BY APPLICABLE
Andy will Confirm with Cindy about changes here SCREENS
Note: A detailed description of each code is located in Getting Started With The Core System, pp. 2-29 - 2-152.
ACADEMIC.CALENDARS Q Quarter System CLIENT INST
S Semester System
12/6/04 - Done and in test T Trimester System
O Other
ACKNOWLEDGE.METHODS S Separate DATATEL IPCD
12/6/04 - Defer to Training on C Combined
Communications Management
ACCREDITATION.TYPE REG Regional CLIENT INST
12/6/04 - Done and in test
ACTIVE.STATUSES A Active DATATEL CF-BKCM
Will not use I Inactive HR-BANK
ADMIN.TYPES A Academic DATATEL DEPT
Will not use H HR HR
ADDRESS.ROUTE.CODES CLIENT ADR
12/6/04 - Done and in test
ADDRESS.TOKENS NE NORTHEAST CLIENT**
** use as delivered; do not modify NW NORTHWEST
SE SOUTHEAST
WILL NOT CHANGE SW SOUTHWEST
S SOUTH
N NORTH
E EAST
W WEST
Core Use as Delivered Validation Codes Datatel Confidential 122 of 235
APT APARTMENT
BLDG BUILDING
RT ROUTE
RD ROAD
ST STREET
AVE AVENUE
BLVD BOULEVARD
CT COURT
1ST FIRST
2ND SECOND
3RD THIRD
4TH FOURTH
5TH FIFTH
6TH SIXTH
MT MOUNT
FT FORT
DR DRIVE
ST SAINT
LN LANE
PL PLACE
HWY HIGHWAY
BX BOX
P POST
O OFFICE
ADREL.STATUSES CU Current 1 CLIENT ADR
Special Processing Definitions: FO Former 2
1 = Current; 2 = Former; LK Last Known 3
3 = Last known; 4 = Pending PN Pending 4
12/6/04 - Done and in test
ASSOCIATION.DIRECTIONS Ascending Left DATATEL ELF
Ascending Right
WILL NOT CHANGE Descending Left
Descending Right
Desc Left, Nulls First
Desc Right, Nulls First
Core Use as Delivered Validation Codes Datatel Confidential 123 of 235
Asc Left, Nulls Last
Asc Right, Nulls Last
CC.ACTIONS Add DATATEL CRA
Delete GTA
WILL NOT CHANGE Reset
CC.TYPES Send DATATEL
Receive
WILL NOT CHANGE
CCD.GRANTOR.CODES CLIENT OCCD
12/6/04 - Done and in test
CCD.TYPES CLIENT OCCD
ST-PROG
12/6/04 - Done and in test
CONTROL.RECORD.STATUSES Report Run DATATEL
Report Failed
Will not change Post Run
Post Failed
Transmittal Run
Transmittal Failed
CONV.TYPES Convert Upper Case Word DATATEL CONF
Convert Upper Case ELF
Trim All Spaces
Will not change Trim Trailing Spaces
Trim Leading Spaces
Convert Lower Case
Field Replace
Word Replace
CORP.NAME.TOKENS Used in lookup subroutine DATATEL
Core Use as Delivered Validation Codes Datatel Confidential 124 of 235
Will not change
CORP.STATUSES A Active CLIENT ORGP
I Inactive
12/6/04 - Done and in test M Merged
CORR.STATUSES Received CLIENT** CRI
**Use as delivered Waived
Will not change Incomplete
CORRESPONDENCE.TYPES Individual DATATEL IPCD
Will not change Joint
DB.USAGE.TYPES Key DATATEL ELF
Will not change List RDEL
Associated RFEI
Data
Q Pointer
X Pointer
Text
DEGREE.TYPES BACC Baccalaureate CLIENT ST-DEGR
For use in FISAP report PROF Professional ODEG
Degrees offered by your ASSOC Associates
institution. These will also appear OTHER Other
in the Other.degrees file where
you can add degrees offered
elsewhere.
12/6/04 - Done and in test
DIRECTORY.CODES N Exclude from Directory CLIENT RGPE
12/6/04 - Done and test BIO
DISABILITY.TYPES PRI Primary CLIENT DISD
These are used in CA state SEC Secondary EMER
reporting TEM Temporary
12/6/04 - Done and in Test
Core Use as Delivered Validation Codes Datatel Confidential 125 of 235
DISPLAY.OPTIONS Prospects Maint DATATEL
Applicants Maint
MCAT Applicants
Will not change Prospects Inquiry
Fin. Aid Inquiry
Applicants Inquiry
MCAT Applicants Inq
Alum/Devs Maint
Corp/Founds Maint
Donation Maint
Giving History
Alum/Devs Inquiry
Corp/Founds Inquiry
Giving History Inq
Donation Inquiry
DOC.PRINT.FREQUENCIES Daily DATATEL DOC
Sunday
Monday
Will not change Tuesday
Wednesday
Thursday
Friday
Saturday
DOCUMENT.HISTORY.TYPES Code DATATEL DOC
Full
Will not change None
Note: All EDI codes are used with SPEEDE transcript interface and are Datatel-delivered.
EDI.ACADEMIC.CREDIT.TYPES Adult credits DATATEL
Note: all EDI codes are for use Continuing education unit
with SPEEDE transcript Carnegie units
interface & are Datatel-delivered No credit
Quarter hour credit
Core Use as Delivered Validation Codes Datatel Confidential 126 of 235
Semester hour credit
Units
Vocational credits
Other type of credit
EDI.ACTIVITY.CODES Archery DATATEL
Badminton
Baseball
Basketball
Bowling
Boxing
Crew
Cross country
Diving
Field hockey
Fencing
Football
Golf
Gymnastics
Ice hockey
Lacrosse
Martial arts
Polo
Racquetball
Rugby
Sailing
Skiing
Soccer
Softball
Squash
Swimming
Synchronized swimming
Team handball
Tennis
Track and field
Volleyball
Water polo
Wrestling
Core Use as Delivered Validation Codes Datatel Confidential 127 of 235
Rodeo
Scuba diving
Team manager
Cheerleading
Other sport
Student body president
Student body officer
Class president
Class officer
Other student leadership
Music - vocal
Music - instrumental
Music-theory/composition
Band
Orchestra
Jazz ensemble
Chorus
Other music
Theater/drama
Art and graphic design
Dance
Dance team
Drill team
Other performing arts
Journalism
Broadcasting
Year book
Literary magazine
Other journal/broadcast
Speech/debate
Drama club
Spanish club
Latin club
German club
Russian club
Italian club
French club
Core Use as Delivered Validation Codes Datatel Confidential 128 of 235
Portuguese club
Science club
Art club
Computer club
Future business leaders
Future teachers
Future farmers
Future homemakers
Health occupation student
Distributive ed club
Peer counseling
Tutoring
SADD
Key club
Boy scouts
Girl scouts
4H
Chess club
Sorority
Fraternity
Other club/organization
Community service
Volunteer work
Church service
Other community service
National Forensics League
National Honor Society
Academic Team/Brain Bowl
Beta Club
Mu Alpha Theta
Psi Eta
Thespian society
Other honor society
Full time employment
Part time employment
Internship
Co-curricular experience
Core Use as Delivered Validation Codes Datatel Confidential 129 of 235
Teaching assistantship
Research assistantship
Other employment
Professional article
Prose/short story
Poetry
Novel/book
Professional presentation
Thesis
Dissertation
Unpublished manuscript
Textbook
Other publication
Air Force
Army
Coast Guard
Marine Corp
Navy
Air Force Reserve
Army Reserve
Marine Corp Reserve
Navy Reserve
Air National Guard
Army National Guard
Air Force ROTC
Army ROTC
Marine Corp ROTC
Navy ROTC
Other military
Member professional org
Officer professional org
Committee chair prof org
Committee member prof org
Other professional org
Invention
Patent
Research
Core Use as Delivered Validation Codes Datatel Confidential 130 of 235
Other invention/research
Other activity
EDI.ACTIVITY.DATE.TYPES Effective DATATEL
Expiration
Publication
Received
Confirmed
Issue
Award
Start
End
Completion
Birth
Student Signed
Date Filed
Approved
Referral Date
Evaluation Date
Placement Date
Individual Education Plan
Re-evaluation Date
Dismissal Date
Employment Begin
Employment End
Date of Death
Signature
Action Begin Date
Action End Date
Mutually Defined
EDI.ADDRESS.TYPES Domicile Type Code DATATEL
Current Address
Home Address
Home Base Address
Local Address
Mailing Address
Office Address
Permanent Address
Core Use as Delivered Validation Codes Datatel Confidential 131 of 235
EDI.ARRIVAL.TYPE.CODES Arrival in Country DATATEL
Immigration Date
Estimated Immigration Dte
EDI.AWARD.CODES Scholar Award with Honor DATATEL
Scholar Award w/ Distinct
State Scholar Award
National Scholar Award
Natl & State Scholar Awd
Class Valedictorian
Class Salutatorian
Other Award
EDI.CITIZENSHIP.CODES US Citizen DATATEL
Non-Resident Alien
Resident Alien
Illegal Alien
Alien
US Citizen - Non-Resident
US Citizen - Resident
Citizen
Non-citizen w/ stu auth
Non-perm Resident Alien
Permanent Visa
Temporary Visa
EDI.CONTACT.FUNCTION.CODES School Principal DATATEL
Dental School Adm Office
Evening Programs Office
Emergency Contact
Financial Aid Office
Graduate Fine Arts Office
Graduate Business Office
Guidance Counselor
Graduate Engineering Off
Graduate Admissions Off
Law School Admissions Off
Medical Contact
Medical Admissions Office
Other Adult
Core Use as Delivered Validation Codes Datatel Confidential 132 of 235
Performance Eval Comm
Probation/Legal Officer
Parent or Guardian
Personnel Department
Registrar
Student
Student in Absentia
School Clerk
Special Program Contact
Social Services Worker
Coll of Educ Adm Office
School of Theology Adm
Undergraduate Adm Office
Veterinary Medicine Adm
EDI.COUNTRIES Andorra DATATEL
United Arab Emirates
Afghanistan
Antigua and Barbuda
Anguilla
Albania
Armenia
Netherlands Antilles
Angola
Antarctica
Argentina
American Samoa
Austria
Australia
Aruba
Azerbaijan
Bosnia and Herzegovina
Barbados
Bangladesh
Belgium
Burkina Faso
Bulgaria
Bahrain
Core Use as Delivered Validation Codes Datatel Confidential 133 of 235
Burundi
Benin
Bermuda
Brunei Darussalam
Bolivia
Brazil
Bahamas
Bhutan
Bouvet Island
Botswana
Belarus
Belize
Canada
Cocos (Keeling) Islands
Central African Republic
Congo
Switzerland
Cote D'Ivoire
Cook Islands
Chile
Cameroon
China
Colombia
Costa Rica
Czechoslovakia (former)
Cuba
Cape Verde
Christmas Island
Cyprus
Czech Republic
Germany
Djibouti
Denmark
Dominica
Dominican Republic
Algeria
Ecuador
Core Use as Delivered Validation Codes Datatel Confidential 134 of 235
Estonia
Egypt
Western Sahara
Eritrea
Spain
Ethiopia
Finland
Fiji
Falkland Isls (Malvinas)
Micronesia
Faroe Islands
France
France, Metropolitan
Gabon
Great Britain (UK)
Grenada
Georgia
French Guiana
Ghana
Gibraltar
Greenland
Gambia
Guinea
Guadeloupe
Equatorial Guinea
Greece
S. Georgia/S. Sandwich Is
Guatemala
Guam
Guinea-Bissau
Guyana
Hong Kong
Heard/McDonald Islands
Honduras
Croatia (Hrvatska)
Haiti
Hungary
Core Use as Delivered Validation Codes Datatel Confidential 135 of 235
Indonesia
Ireland
Israel
India
British Indian Ocean Terr
Iraq
Iran
Iceland
Italy
Jamaica
Jordan
Japan
Kenya
Kyrgyzstan
Cambodia
Kiribati
Comoros
Saint Kitts and Nevis
Korea (North)
Korea (South)
Kuwait
Cayman Islands
Kazakhstan
Laos
Lebanon
Saint Lucia
Liechtenstein
Sri Lanka
Liberia
Lesotho
Lithuania
Luxembourg
Latvia
Libya
Morocco
Monaco
Moldova
Core Use as Delivered Validation Codes Datatel Confidential 136 of 235
Madagascar
Marshall Islands
Macedonia
Mali
Myanmar
Mongolia
Macau
Northern Mariana Islands
Martinique
Mauritania
Montserrat
Malta
Mauritius
Maldives
Malawi
Mexico
Malaysia
Mozambique
Namibia
New Caledonia
Niger
Norfolk Island
Nigeria
Nicaragua
Netherlands
Norway
Nepal
Nauru
Neutral Zone
Niue
New Zealand (Aotearoa)
Oman
Panama
Peru
French Polynesia
Papua New Guinea
Philippines
Core Use as Delivered Validation Codes Datatel Confidential 137 of 235
Pakistan
Poland
St. Pierre and Miquelon
Pitcairn
Puerto Rico
Portugal
Palau
Paraguay
Qatar
Reunion
Romania
Russian Federation
Rwanda
Saudi Arabia
Solomon Islands
Seychelles
Sudan
Sweden
Singapore
St. Helena
Slovenia
Svalbard/Jan Mayen Isls
Slovak Republic
Sierra Leone
San Marino
Senegal
Somalia
Suriname
Sao Tome and Principe
USSR (former)
El Salvador
Syria
Swaziland
Turks and Caicos Islands
Chad
French Southern Terrs.
Togo
Core Use as Delivered Validation Codes Datatel Confidential 138 of 235
Thailand
Tajikistan
Tokelau
Turkmenistan
Tunisia
Tonga
East Timor
Turkey
Trinidad and Tobago
Tuvalu
Taiwan
Tanzania
Ukraine
Uganda
United Kingdom
US Minor Outlying Islands
United States
Uruguay
Uzbekistan
Vatican City State
Saint Vincent/Grenadines
Venezuela
Virgin Islands (British)
Virgin Islands (U.S.)
Viet Nam
Vanuatu
Wallis and Futuna Islands
Samoa
Yemen
Mayotte
Yugoslavia
South Africa
Zambia
Zaire
Zimbabwe
EDI.COURSE.LEVEL.CODES Remedial DATATEL
Basic
Core Use as Delivered Validation Codes Datatel Confidential 139 of 235
Teacher's Aide
General
Applied
Survey
Regular
Specialized Topics
Advanced
Honors
Gifted and Talented
Advanced Placement
Special Education
Vocational Education
Independent Study
Work Experience
Adult Basic
Adult Secondary
Intl Baccalaureate
Summary of all courses
Academic Renewal
All crs at sending inst
Dual level (Upper & Grad)
Dual level (Grad & Prof)
All except repeated
Sending inst excl repeat
Graduate (postsecondary)
Higher or upper (postsec)
Institutional Credit
Lower div (postsecondary)
Work in Major or Program
Professional
Remedial (postsecondary)
Summary of transfer work
Undergraduate (postsec)
Transfer work excl repeat
EDI.DEGREE.CCD.CODES Postsec cert/dip (< 1 yr) DATATEL
Postsec cert/dip (1-4 yr)
Associate degree
Core Use as Delivered Validation Codes Datatel Confidential 140 of 235
Baccalaureate degree
Baccalaureate (honors)
Postsec cert/dip (1-2 yr)
Postsec cert/dip (2-4 yr)
First professional degree
Post-professional degree
Graduate certificate
Master's degree
Intermediate grad degree
Doctoral degree
Post-doctoral degree
EDI.ELIG.TO.RETURN.CODES Eligible to continue/ret DATATEL
Suspension or dismissal
Expelled
Susp/Dis; can reapply
EDI.ENROLL.STATUSES Curr enrld/IP crs not inc DATATEL
Not currently enrolled
Unreported/info not avail
Curr enrld/IP crses incl
EDI.ENTITY.TYPES Disciplinary Contact DATATEL
Entity Legally Responsibl
Entity Child Resides With
Entity resp & residing w/
Other associated entity
Parent
Student
Custodial Parent
EDI.ETHNIC.CODES Not provided DATATEL
Asian or Pacific Islander
Black
Caucasian
Subcontinent Asian Amer
Other Race or Ethnicity
Asian Pacific American
Native American
Hispanic
Amer Indian or Alaskan
Core Use as Delivered Validation Codes Datatel Confidential 141 of 235
Native Hawaiian
Black (Non-Hispanic)
White (Non-Hispanic)
Pacific Islander
Mutually Defined
EDI.FIELD.OF.STUDY.TYPES Concentration DATATEL
Endorsement
Graduate Non-degree
Licensing
Major
Minor
Specialization
Teaching
Visiting Scholar
EDI.HONORS Highest honors DATATEL
Second highest honors
Third highest honors
EDI.IMMUNIZATION.SOURCES County Record DATATEL
Health Certificate
Health Clinic Record
State School Imm Records
MSRTS Record
Physician's Report
EDI.IMMUNIZATION.STATUSES First Inoculation DATATEL
Second Inoculation
Third Inoculation
Fourth Inoculation
Fifth Inoculation
Sixth Inoculation
Seventh Inoculation
Eighth Inoculation
Ninth Inoculation
Medical Exemption
Personal Exemption
Religious Exemption
Had the Disease
Has Not Had the Disease
Core Use as Delivered Validation Codes Datatel Confidential 142 of 235
EDI.IMMUNIZATIONS Vac Typhoid-Paratyphoid DATATEL
Vac Tuberculosis
Vac Pertussis
Vac Tetanus Toxoid
Vac Bacterial Dis NEC
Vac Hemophilus InfluenzaB
Vac Streptococcus Pneumon
Vac Single Bacterial Dis
Vac Poliomyelitis
Vac Polio Oral
Vac Polio Immunization
Vac Smallpox
Vac Measles
Vac Rubella
Vac Mumps
Vac Influenza
Vac Viral Hepatitis
Vac DTP
TD Immunization
Vac DTP + Polio
Vac Measles-Mumps-Rubella
Vac other combinations
DTP imm
DT imm
Tetanus imm
Mumps imm
Measles imm
Rubella imm
MMR virus imm
Measles-rubella imm
Oral poliovirus imm
TD imm
BCG imm
Hepatitis B imm
EDI.INST.IDENTIFIER.CODES INST.CEEB DATATEL
CORP.FICE
INST.OTHER.ID
Core Use as Delivered Validation Codes Datatel Confidential 143 of 235
INST.LOCAL.GOVT.ID
EDI.INST.IDENTIFIER.TYPES IPEDS DATATEL
College Board ATP
FICE
American Coll Testing ACT
State/Province Assgned No
NCES Common Core of Data
College Board & ACT 6-dig
Canadian College SIS
Canadian University SIS
EDI.LANGUAGE.IND.CODES NISO Z39.53 DATATEL
ISO 639
EDI.LANGUAGE.SKILL.CODES Status Unknown DATATEL
Excellent or Fluent
Good
Fair
Poor
Unacceptable
EDI.LANGUAGE.USE.CODES Language of Instruction DATATEL
Language of Examination
Language Exam Written in
Language Spoken in Home
Language Reading
Language Writing
Language Speaking
Native Language
EDI.MAJOR.ID.CODES MAJ.CIP DATATEL
MAJ.LOCAL.GOVT.CODES
EDI.MAJOR.ID.TYPES CIP DATATEL
HEGIS
Canadian SIS course codes
Canadian SIS curriculum
Mutually defined
EDI.MARITAL.STATUSES Common Law DATATEL
Regist'd Domestic Partner
Divorced
Single
Core Use as Delivered Validation Codes Datatel Confidential 144 of 235
Unknown
Married
Unreported
Separated
Unmarried
Widowed
Legally Separated
EDI.NAME.IND.CODES Prefix DATATEL
First Name
First Middle Name
Second Middle Name
Last Name
First Initial
First Middle Initial
Second Middle Initial
Suffix
Combined Name
Name of an Agency
Maiden or Former Name
Composite Name
Middle Names
Preferred Name/Nickname
Organization Name
EDI.NAME.TYPES Given Name (Birth Name) DATATEL
Current Legal
Alias
Name of Record
Previous Name
Name of Record Requestor
Married Name
Professional Name
EDI.PHONE.TYPES Alternate Telephone DATATEL
Answering Service
Beeper Number
Cellular Phone
EDI Access Number
Electronic Mail
Core Use as Delivered Validation Codes Datatel Confidential 145 of 235
Telephone Extension
Federal Telecom System
Facsimile User Identifier
Facsimile
Home Facsimile Number
Home Phone Number
International Telephone
Modem Number
Night Telephone
Other Residential Fax No
Other Residential Phone
Appointment Phone
Personal Cellular
Personal Phone
Packet Switching
Telephone
Telex
Telemail
Teletex Number
TWX
Voice Mail
Work Cellular
Work Facsimile Number
Work Phone Number
EDI.REFERENCE.TYPES Employer ID Number DATATEL
U.S. Govt Visa Number
Agency's Student Number
Family Unit Number
Personal ID Number (PIN)
State Student ID Number
Corrected SSN
Prior Incorrect SSN
Employee ID Number
Canadian SIN
Charge Card Number
Original Reference Number
Local Student ID Number
Core Use as Delivered Validation Codes Datatel Confidential 146 of 235
Migrant Number
Credit Card
SSN
Visa Type
State Dept I-20 Form No
State Dept IAP-66 Form No
Mutually Defined
EDI.SEC.SCHOOL.GRAD.CODES Did not complete sec sch DATATEL
Standard high school dipl
Advanced/honors diploma
Vocational diploma
Special education diploma
Cert of completion/attend
Special cert completion
GED
Other high school equiv
Intl diploma/certificate
EDI.TRANSACTION.VERSIONS Version 4010 DATATEL
Version 3052
Version 3041
EDI.TRANSACTIONS Student Transcript DATATEL
Student Record Acknowledg
Request for Student Rec
Resp to Req for Stud Rec
EEO.RPT.RANKS 1 Professors CLIENT FAID
Used to create faculty ID cards 2 Associate Professors POSD
and in HR IPEDS reporting 3 Assistant Professors
4 Instructors
5 Lecturers
6 Other Faculty
7 Teaching Assistant
8 Lab Facilitator
ELF.CARDINALITIES One and only one DATATEL ELF
At least one
Core Use as Delivered Validation Codes Datatel Confidential 147 of 235
Zero, one or many
Zero or one
ELF.FILE.TYPES Colleague DATATEL ELF
Fixed Disk
Fixed Tape
Other
Variable Disk
Variable Tape
ELF.MERGE.ACTIONS Preserve DATATEL ELF
Preserve Unless Null
Replace
Replace Unless Null
Merge/Preserve
Merge/Replace
ELF.TGT.STATUSES Error DATATEL ELF
New
Merged
Ambiguity
Anticipated New
Anticipated Merge
Not Written
ELF.TRANSACTION.STATUSES Not Yet Processed DATATEL ELF
No Ambiguities
Ambiguities
Imported
Error
Import Failure
ELF.TRANSLATE.ACTIONS Keep DATATEL ELF
Null
Error
ELF.VALUE.ERROR.ACTIONS Accept/No value DATATEL ELF
Core Use as Delivered Validation Codes Datatel Confidential 148 of 235
Reject
EMAIL.SUBJECTS CLIENT EMAL
Only use this code if you plan to
use Colleague's email system
12/6/04 - Done and in test
EMPLOYMT.STATUSES PT Part Time C CLIENT EMPL
Special Processing Definitions: FT Full Time C
F = Former FO Former F
C = Current
CO = Correction
Retired = 1 in 2nd column
12/6/04 -using for SEVIS - Done and in test
EMPLOYMT.TYPES CO Counselor 1 CLIENT ORGC
Special Processing Definitions: PR Principal 1 ORCD
Used to rank positions on contact RG Registrars 1
lists. 1 is highest ranking. AO Articulation Officer 1
CL Community Learning Contact 1
Ranking of 5 automatically moves CN Other Contact 2
person from a "contact" to an
"employee".
USED FOR CONTACTS
12/6/04 Done and in Test
Core Use as Delivered Validation Codes Datatel Confidential 149 of 235
FORMS.PROCESSING.TYPES Files Keyed by Person DATATEL EGF
Files NOT keyed by Person
HDR.OPTIONS Id Number DATATEL PHD
Last Name HDR
First Name
Middle Name
Middle Initial
Full Name
Mail Name
Address
City
State
Zip Code
Country
County
City, State Zip
Phone Number
Social Security
Birthdate
Sex
Age
Maiden Name
Prefix
Suffix
Files Used
Former Name
Spacing
INDUSTRY.CLASSES LG Large Corporation CLIENT AORG
SM Small business
MA Manufacturing
SE Services
Core Use as Delivered Validation Codes Datatel Confidential 150 of 235
LS Legal Services
CI Computer Industry
HE Health Care
TR Transportation
HR Hotel/Restaurant
RE Real Estate
RT Retail
BF Banking/Finance
IN Insurance
GV Government
INST.FUNDING.SOURCES 1 Public CLIENT INST
2 Private
INST.NAME.TOKENS For use in lookup subroutine DATATEL
INST.TYPES HS High School H CLIENT INST
Special Processing Definition: CO College C
Codes link to detail screens from UN University C
INST depending on acad. Level. EL Elementary School H
CC Community College C
H = High School level or below MS Middle School H
(HSA Screen) PF Professional School C
C = High Education Level HO Home H
(INAT or HOME screens) VT Vocational/Technical C
ITCI.REPORT.DETAIL.LEVEL Detailed Report DATATEL ELF
All Duplicates
Unresolved Dupls Only
JUSTIFICATION.TYPES Left DATATEL
Right
LABEL.DESTINATIONS Printer DATATEL VENL
Core Use as Delivered Validation Codes Datatel Confidential 151 of 235
Terminal HRLB
HOLD File HRLF
LIST.ALGEB.OPERATORS Union DATATEL SAAL
Difference
Intersection
Union
Difference
LOGIN.REQUEST.STATUSES N Notified CLIENT * LGRP
* use as delivered A Accepted LRPG
R Rejected
LOGIN.REQUEST.TYPES STU Student Access CLIENT * LGRP
* use as delivered FAC Faculty Access LRPG
PER Personnel Access
NEW New Student
LOOKUP.TYPES Partial Name DATATEL PID2
Soundex Name
LTR.BACH.ACTIONS Count DATATEL PCB
Select
Unselect
Test
Process
Delete
History
LTR.BACH.STATUSES Pending DATATEL PCB
In Progress CBS
Cancelled
Completed
LTREQ.STATUSES Currently Processing DATATEL PCB
Error
Selected
Core Use as Delivered Validation Codes Datatel Confidential 152 of 235
Processed
MAIL.GROUPING.TYPES Joint Mail DATATEL SLC
Joint Solicit
Neither
MAIL.TYPES Individual DATATEL NASP
Joint Mail (Either)
Joint Mail (Both)
Joint Solicit (Either)
Joint Solicit (Both)
MAINT.SPEC.PRCS Entire DATATEL MSPS
Window
Page
MISC.CODES CLIENT COM
Defer until Communications Management training
NEW.KEY.FUNCTIONS Subroutine Based DATATEL RKEY
File Based
NEW.KEY.PARSE.TYPES No Parsing DATATEL RKEY
Field Extraction
Substring Extraction
OTHER.CCDS.TITLE.CODES 01 Instruc Administrator CLIENT OCCD
Used in Wisconsin State 02 Instruc Rel Administrator
Core Use as Delivered Validation Codes Datatel Confidential 153 of 235
Reporting Only 03 Instruc Rel Supervisor
04 Instruc Supervisor
06 Counselor
07 ADDA Facilitator
08 Librarian
10 Instruc Specialist
98 Instructor
OUTPUT.ERROR.TYPES Reject invalid data DATATEL FPR
Reject null data PSRT
Ignore errors BPSR
OUTPUT.OPTIONS Hold File DATATEL FPR
Printer PSRT
PERSON.ID.OPTIONS Automatic Only DATATEL PID2
Manual Only
Automatic & Manual
PERSON.RECORD.TYPES Corporation DATATEL SLC
Individual
Both
PERSON.REL.TYPES Grandparent DATATEL RELE
Grandfather
Grandmother
Grandchild
Grandson
Granddaughter
Parent
Father
Mother
Step-Parent
Stepfather
Stepmother
Spouse
Core Use as Delivered Validation Codes Datatel Confidential 154 of 235
Husband
Wife
Sibling
Brother
Sister
Child
Son
Daughter
Stepchild
Stepson
Stepdaughter
Sib/Prnt
Uncle
Aunt
Chld/Prnt
Nephew
Niece
Friend
Cousin
Ex Spouse
Ex Husband
Ex Wife
Late Spouse
Late Husband
Late Wife
Contact
In-laws
Father-in-law
Mother-in-law
In-law/Chld
Son-in-law
Daughtr-in-law
In-law/Sib
Brother-in-law
Sister-in-law
Guardian
Ward
Core Use as Delivered Validation Codes Datatel Confidential 155 of 235
Companion
Executor
Unknown
Family
Great-Grand-Child
Great-Grand-Son
Great-Grand-Daughter
Great-Grand-Parent
Great-Grand-Father
Great-Grand-Mother
Widow(er)
Widower
Widow
Step-Sibling
Step-Brother
Step-Sister
PERSONAL.STATUSES DE Deceased BIO
AC Active
IA Inactive
UD Unverified Death
PIN.CALC.TYPES Random APIN
Birthdate APFI
Last of SSN APTS
POSITIONS COU Counselor EMSU
PRI
Positions outside of client institution Principal EMPD
STE Secondary Teacher
EXE Executive
PLM Plant Manager
HRD HR Director
SRP Sales Representative
INT Intern
POSTAL.SORT.TYPES First Class PPD
Third Class PSRT
Core Use as Delivered Validation Codes Datatel Confidential 156 of 235
Carrier Route ADR
RECORD.TYPES Fixed Length
Variable Length
REGISTRY.LEVELS No Access SASU
Read Only BURE
Read/Write BFRE
RELATION.FIELDS First Field DATATEL RDEL
Second Field
Third Field
Fourth Field
Fifth Field
Lower key first
SCHED.REPEATS Consecutive 1 ;C CLIENT MSCH
Special Processing Definition: Daily 1;D
1st column = # of times to Weekly 1;W
repeat the event. Monthly 1;M
2nd column = the period of the Yearly 1;Y
repeat (yearly, daily, monthly…) Bi-Weekly 2;W
Bi-Monthly 2;M
Quarterly 3;M
Yearly, Same day 52 ; W
SORT.TYPES Ascending Left DATATEL SAAL
Ascending Right
Descending Left
Descending Right
STAFF.STATUSES C Current CLIENT SVM
F Former
Core Use as Delivered Validation Codes Datatel Confidential 157 of 235
STAFF.TYPES E Employee CLIENT SVM
V Volunteer
S Staff
SUBROUTINE.ARGUMENTS Last Name DATATEL CC
First Name
Middle Name
Preferred Address
Preferred City
Preferred State
Preferred Zip Code
Financial Aid Year
LTREQ Custom field 1
LTREQ Custom field 2
LTREQ Custom field 3
LTREQ Custom field 4
LTREQ Custom field 5
2000 Year Return Info.
SUBROUTINE.TYPES Corres Received DATATEL CC
Print Action
History Action
Instance Action
Requests Completed
SUMMARY.OR.DETAIL Summary DATATEL PCR
Detail
TAX.FORM.PROCESSING.STATUS Generated MTG DATATEL
Modified BAL
Verified BND
Certified GDV
Unlocked Certified TGR
Unlocked Verified INT
Purged NEC
Submitted EWP
Core Use as Delivered Validation Codes Datatel Confidential 158 of 235
Frozen ICR
Reopened GRS
Unfrozen IRA
TERMINAL.TYPE Wintegrate DATATEL APTR
Video Terminal
WYSE Terminal
TIME.ZONES EST Eastern 0 CLIENT ADR
CST Central -1
Special Processing Definition: MST Mountain -2
P
Calculation of time difference between ST Pacific -3
client time zone and code time zone. ATL Atlantic 1
HAW Hawaian -5
ALS Alaskan -4
TRANSCRIPT.STATUS OF Official CLIENT INAT
UN Unofficial HAS
PA Partial
TRANSCRIPT.TYPE CT College Transcript CLIENT INAT
HS High School Transcript HAS
FA Financial Aid
CE Continuing Education
MT Military Transcript
GE GED
TRANSFER.METHODS FTP DATATEL TPF
Kermit
Wintegrate
TRIM.TYPES All DATATEL
Front
Back
Standard
Core Use as Delivered Validation Codes Datatel Confidential 159 of 235
VALID.COLUMNS 132 Columns DATATEL ATPR
80 Columns
VOU.STATUSES Not Approved DATATEL AP
Outstanding
Paid
Reconciled
Voided
Canceled
WP.CHARACTER.XLAT 192 ( 001 192 CLIENT**
**use as delivered 192 ) 001 192
192 ; 001 192
192 1 001 192
192 / 001 192
192 A 001 192
192 7 001 192
192 ! 001 192
192 - 001 192
192 ? 001 192
192 031 001 192
192 + 001 192
192 = 001 192
192 3 001 192
192 029 001 192
192 ' 001 192
192 I 001 192
192 I 001 192
192 5 001 192
192 5 001 192
192 G 001 192
192 E 001 192
WEB.PHONE.TYPES DATATEL ADRC
WP.DOCUMENT.TYPES Personal DATATEL DOC
Template
Code Only
Core Use as Delivered Validation Codes Datatel Confidential 160 of 235
YNB Yes DATATEL
No
Blank
Core Use as Delivered Validation Codes Datatel Confidential 161 of 235
Core Use as Delivered Validation Codes Datatel Confidential 162 of 235
Core Use as Delivered Validation Codes Datatel Confidential 163 of 235
Core Use as Delivered Validation Codes Datatel Confidential 164 of 235
Core Use as Delivered Validation Codes Datatel Confidential 165 of 235
Core Use as Delivered Validation Codes Datatel Confidential 166 of 235
Core Use as Delivered Validation Codes Datatel Confidential 167 of 235
Core Use as Delivered Validation Codes Datatel Confidential 168 of 235
Core Use as Delivered Validation Codes Datatel Confidential 169 of 235
Core Use as Delivered Validation Codes Datatel Confidential 170 of 235
Core Use as Delivered Validation Codes Datatel Confidential 171 of 235
Core Use as Delivered Validation Codes Datatel Confidential 172 of 235
Core Use as Delivered Validation Codes Datatel Confidential 173 of 235
Core Use as Delivered Validation Codes Datatel Confidential 174 of 235
Core Use as Delivered Validation Codes Datatel Confidential 175 of 235
Core Use as Delivered Validation Codes Datatel Confidential 176 of 235
Core Use as Delivered Validation Codes Datatel Confidential 177 of 235
Core Use as Delivered Validation Codes Datatel Confidential 178 of 235
Core Use as Delivered Validation Codes Datatel Confidential 179 of 235
Core Use as Delivered Validation Codes Datatel Confidential 180 of 235
Core Use as Delivered Validation Codes Datatel Confidential 181 of 235
Core Use as Delivered Validation Codes Datatel Confidential 182 of 235
Core Use as Delivered Validation Codes Datatel Confidential 183 of 235
Core Use as Delivered Validation Codes Datatel Confidential 184 of 235
Core Use as Delivered Validation Codes Datatel Confidential 185 of 235
Core Use as Delivered Validation Codes Datatel Confidential 186 of 235
Core Use as Delivered Validation Codes Datatel Confidential 187 of 235
Core Use as Delivered Validation Codes Datatel Confidential 188 of 235
Core Use as Delivered Validation Codes Datatel Confidential 189 of 235
Core Use as Delivered Validation Codes Datatel Confidential 190 of 235
Core Use as Delivered Validation Codes Datatel Confidential 191 of 235
Core Use as Delivered Validation Codes Datatel Confidential 192 of 235
Core Use as Delivered Validation Codes Datatel Confidential 193 of 235
Core Use as Delivered Validation Codes Datatel Confidential 194 of 235
Core Use as Delivered Validation Codes Datatel Confidential 195 of 235
Core Use as Delivered Validation Codes Datatel Confidential 196 of 235
Core Use as Delivered Validation Codes Datatel Confidential 197 of 235
Core Use as Delivered Validation Codes Datatel Confidential 198 of 235
Core Use as Delivered Validation Codes Datatel Confidential 199 of 235
Core Use as Delivered Validation Codes Datatel Confidential 200 of 235
Core Use as Delivered Validation Codes Datatel Confidential 201 of 235
Core Use as Delivered Validation Codes Datatel Confidential 202 of 235
Core Use as Delivered Validation Codes Datatel Confidential 203 of 235
Core Use as Delivered Validation Codes Datatel Confidential 204 of 235
Core Use as Delivered Validation Codes Datatel Confidential 205 of 235
Core Use as Delivered Validation Codes Datatel Confidential 206 of 235
Core Use as Delivered Validation Codes Datatel Confidential 207 of 235
Core Use as Delivered Validation Codes Datatel Confidential 208 of 235
Core Use as Delivered Validation Codes Datatel Confidential 209 of 235
Core Use as Delivered Validation Codes Datatel Confidential 210 of 235
Core Use as Delivered Validation Codes Datatel Confidential 211 of 235
Core Use as Delivered Validation Codes Datatel Confidential 212 of 235
Core Use as Delivered Validation Codes Datatel Confidential 213 of 235
Core Use as Delivered Validation Codes Datatel Confidential 214 of 235
Core Use as Delivered Validation Codes Datatel Confidential 215 of 235
Core Use as Delivered Validation Codes Datatel Confidential 216 of 235
Core Use as Delivered Validation Codes Datatel Confidential 217 of 235
Core Use as Delivered Validation Codes Datatel Confidential 218 of 235
The following codes can be used as delivered.
CODE FILE CODE DESCRIPTION SCREEN
DOC.TYPE Datatel-delivered; do not modify DTYS
Will not change
CAMPUS.ORGS
Defer decisions until CO (Campus Orgs) Training
CORP.TYPES ORTY
Called Organization types on the screen.
12/6/04 - Marie may use to group types of organizations she works with in CL ORGP
Could use this (code file) or industry.class valcode to do this.
COUNTRIES AD Andorra CTRY
AE United Arab Emirates NAE
COUNTRIES DOES NOT COME AF Afghanistan
POPULATED IN COLLEAGUE. THESE AG Antigua and Barbuda
CODES NEED TO BE UPLOADED INTO AI Anguilla
THE SYSTEM. THIS CAN BE DONE AL Albania
USING THE EXPORT FUNCTIONALITY AM Armenia
AND THIS LIST, OR YOUR LEGACY LIST AN Netherlands Antilles
AO Angola
AQ Antarctica
AR Argentina
AS American Samoa
MIS Code AT Austria
AU Australia
AW Aruba
12/6/04 - Done and in test AZ Azerbaijan
BA Bosnia and Herzegovina
BB Barbados
BD Bangladesh
BE Belgium
BF Burkina Faso
Core Use as Delivered Code Files Datatel Confidential 219 of 235
BG Bulgaria
BH Bahrain
BI Burundi
BJ Benin
BM Bermuda
BN Brunei Darussalam
BO Bolivia
BR Brazil
BS Bahamas
BT Bhutan
BV Bouvet Island
BW Botswana
BY Belarus
BZ Belize
CA Canada
CC Cocos (Keeling) Islands
CF Central African Republic
CG Congo
CH Switzerland
CI Cote D'Ivoire
CK Cook Islands
CL Chile
CM Cameroon
CN China
CO Colombia
CR Costa Rica
CS Czechoslovakia (former)
CU Cuba
CV Cape Verde
CX Christmas Island
CY Cyprus
CZ Czech Republic
DE Germany
DJ Djibouti
DK Denmark
DM Dominica
DR Dominican Republic
Core Use as Delivered Code Files Datatel Confidential 220 of 235
DZ Algeria
EC Ecuador
EE Estonia
EG Egypt
EH Western Sahara
ER Eritrea
ES Spain
ET Ethiopia
FI Finland
FJ Fiji
FK Falkland Isls (Malvinas)
FM Micronesia
FO Faroe Islands
FR France
FX France, Metropolitan
GA Gabon
GB Great Britain (UK)
GD Grenada
GE Georgia
GF French Guiana
GH Ghana
GI Gibraltar
GL Greenland
GM Gambia
GN Guinea
GP Guadeloupe
GQ Equatorial Guinea
GR Greece
GS S. Georgia/S. Sandwich Is
GT Guatemala
GU Guam
GW Guinea-Bissau
GY Guyana
HK Hong Kong
HM Heard/McDonald Islands
HN Honduras
HR Croatia (Hrvatska)
Core Use as Delivered Code Files Datatel Confidential 221 of 235
HT Haiti
HU Hungary
ID Indonesia
IE Ireland
IL Israel
IN India
IO British Indian Ocean Terr
IQ Iraq
IR Iran
IS Iceland
IT Italy
JM Jamaica
JO Jordan
JP Japan
KE Kenya
KG Kyrgyzstan
KH Cambodia
KI Kiribati
KM Comoros
KN Saint Kitts and Nevis
KP Korea (North)
KR Korea (South)
KW Kuwait
KY Cayman Islands
KZ Kazakhstan
LA Laos
LB Lebanon
LC Saint Lucia
LI Liechtenstein
LK Sri Lanka
LR Liberia
LS Lesotho
LT Lithuania
LU Luxembourg
LV Latvia
LY Libya
MA Morocco
Core Use as Delivered Code Files Datatel Confidential 222 of 235
MC Monaco
MD Moldova
MG Madagascar
MH Marshall Islands
MK Macedonia
ML Mali
MM Myanmar
MN Mongolia
MO Macau
MP Northern Mariana Islands
MQ Martinique
MR Mauritania
MS Montserrat
MT Malta
MU Mauritius
MV Maldives
MW Malawi
MX Mexico
MY Malaysia
MZ Mozambique
NA Namibia
NC New Caledonia
NE Niger
NF Norfolk Island
NG Nigeria
NI Nicaragua
NL Netherlands
NO Norway
NP Nepal
NR Nauru
NT Neutral Zone
NU Niue
NZ New Zealand (Aotearoa)
OM Oman
PA Panama
PE Peru
PF French Polynesia
Core Use as Delivered Code Files Datatel Confidential 223 of 235
PG Papua New Guinea
PI Philippines
PK Pakistan
PL Poland
PM St. Pierre and Miquelon
PN Pitcairn
PR Puerto Rico
PT Portugal
PW Palau
PY Paraguay
QA Qatar
RE Reunion
RO Romania
RU Russian Federation
RW Rwanda
SA Saudi Arabia
SB Solomon Islands
SC Seychelles
SD Sudan
SE Sweden
SG Singapore
SH St. Helena
SI Slovenia
SJ Svalbard/Jan Mayen Isls
SK Slovak Republic
SL Sierra Leone
SM San Marino
SN Senegal
SO Somalia
SR Suriname
ST Sao Tome and Principe
SU USSR (former)
SV El Salvador
SY Syria
SZ Swaziland
TC Turks and Caicos Islands
TD Chad
Core Use as Delivered Code Files Datatel Confidential 224 of 235
TF French Southern Terrs.
TG Togo
TH Thailand
TJ Tajikistan
TK Tokelau
TM Turkmenistan
TN Tunisia
TO Tonga
TP East Timor
TR Turkey
TT Trinidad and Tobago
TV Tuvalu
TW Taiwan
TZ Tanzania
UA Ukraine
UG Uganda
UK United Kingdom
UM US Minor Outlying Islands
US United States
UY Uruguay
UZ Uzbekistan
VA Vatican City State
VC Saint Vincent/Grenadines
VE Venezuela
VG Virgin Islands (British)
VI Virgin Islands (U.S.)
VN Viet Nam
VU Vanuatu
WF Wallis and Futuna Islands
WS Samoa
YE Yemen
YT Mayotte
YU Yugoslavia
ZA South Africa
ZM Zambia
ZR Zaire
ZW Zimbabwe
Core Use as Delivered Code Files Datatel Confidential 225 of 235
STATES AK Alaska STPR
This code file does come AL Alabama NAE
populated by Datatel AR Arkansas ADR
AZ Arizona
CA California
CZ Canal Zone
CO Colorado
CT Connecticut
MIS Reporting DC District Of Columbia
DE Delaware
FL Florida
GA Georgia
12/6/04 - Done and in test GU Guam
HI Hawaii
IA Iowa
ID Idaho
IL Illinois
IN Indiana
KS Kansas
KY Kentucky
LA Louisiana
MA Massachusetts
MD Maryland
ME Maine
MI Michigan
MN Minnesota
MO Missouri
MS Mississippi
MT Montana
NC North Carolina
ND North Dakota
NE Nebraska
NH New Hampshire
NJ New Jersey
NM New Mexico
Core Use as Delivered Code Files Datatel Confidential 226 of 235
NV Nevada
NY New York
OH Ohio
OK Oklahoma
OR Oregon
PA Pennsylvania
PR Puerto Rico
RI Rhode Island
SC South Carolina
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VA Virginia
VI Virgin Islands
VT Vermont
WA Washington
WI Wisconsin
WV West Virginia
WY Wyoming
BC British Columbia
MB Manitoba
NB New Brunswick
NT Northwest Territories
NS Nova Scotia
ON Ontario
QC Quebec
SK Saskatchewan
YT Yukon
Core Use as Delivered Code Files Datatel Confidential 227 of 235
ISSUES LOG
NOTE: List any Issues which need to be addressed to continue the implementation process.
Issue Decision Assignee Date Due Date
Core Issues Log Datatel Confidential 228 of 235
Core Issues Log Datatel Confidential 229 of 235
ACTION ITEMS
NOTE: List any Action Items which are assigned along with the name of the person responsible for the Action Item.
Item Action Item Decision Assignee Date Due Date
1
2
3
4
5
6
7
8
9
10
Core Action Items Datatel Confidential 230 of 235
Core Action Items Datatel Confidential 231 of 235
Core Action Items Datatel Confidential 232 of 235
Core Action Items Datatel Confidential 233 of 235
MISCELLANEOUS ITEMS
NOTE: List any Miscellaneous Items related to the implementation of CORE.
Miscellaneous Item Discussion/Decision Assignee Date Due Date
Core Miscellaneous Items Datatel Confidential 234 of 235
Core Miscellaneous Items Datatel Confidential 235 of 235
Related docs
Other docs by uqh10688
