2011-2012 PharmCAS Data Dictionary - AACP

Document Sample
2011-2012 PharmCAS Data Dictionary - AACP Powered By Docstoc
					Printed on 7/18/2011                               PharmCAS Data Dictionary of e-File Output per Weekly Mailing                      Page 1 of 64




Introduction to the PharmCAS 2010-2011 Data Dictionary
version: Initial Release - 29 Apr 11

This is the PharmCAS Data Dictionary for the 2011-2012 application cycle. This file will only hold data for the current mailing of
applicants; i.e., it will not be cumulative.

All data structure additions or changes from the previous 2010-2011 cycle are hightlighted in RED.
All data structure deletions from the previous 2010-2011 cycle are hightlighted in BLUE.

Various fields on the folders and folder inserts contain question numbers in the printed form only. These numbers have been
added to the Main Table as a new column to help with cross-referencing electronic and paper information.




Main Tables
Main: Applicant's name, address, and other personal information.
Tests: User reported Tests (PCAT, TOEFL, and TSE)
PCAT: Official PCAT scores provided by the testing service.
TOEFL: Official TOEFL scores provided by the testing service.
TSE: Official TSE scores as provided by the testing service.
Colleges: Institutions Attended section (One to many)
Complete: List of Completed Coursework (One to many)
Planned: List of Planned/In Progress Coursework (One to many)
ExtraCur: Extracurricular, Volunteer, Community Service, Leadership, Dentistry Job Shadowing section
WorkExp: Work Experience section.
Honors: Awards, Honors, Scholarships section
Publications: Publications
Campus: Applicant Campus selection.
GPAYear: GPA based on academic year
GPA: Applicant GPA information.
GPACrs: Calculated GPA for individual Subject Course at any academic level.
Degree: Applicant Degree information.
Certifications: Professional licenses and certifications information.
RefProf: Applicant Reference information.
RefData: Applicant Reference information in detail.




                                                                              Intro
Printed on 7/18/2011                            PharmCAS Data Dictionary of e-File Output per Weekly Mailing     Page 2 of 64



Referenced lookup tables:
lk_campus
lk_classification
lk_country
lk_course_type
lk_crs_level_status
lk_decision
lk_degree
lk_edu
lk_evaluate
lk_grade
lk_howwell
lk_level
lk_major
lk_month
lk_nummonths
lk_numyears
lk_previous_school
lk_prof
lk_recommend
lk_relation
lk_sess_level_status
lk_setting
lk_state
lk_subject
lk_visa
lk_year


Change Log:

Initial Release (Changes from 2010-2011 Cycle):
Main table: Updated wording to question. Formal text regarding "conduct violations" has been removed for 2012.
Main table: Added new field "TIIRESULTS" for future use with vendor.
Updated lk_country lookup table with current US State Dept standard.




                                                                           Intro
Printed on 7/18/2011                                PharmCAS Data Dictionary of e-File Output per Weekly Mailing                              Page 3 of 64



Main: Profile Information, Personal Information, Contact Information, Ethnicity Inforamtion and Personal Statement

   Field Name            Type      Width                                 Data Recorded                                         Lookup Table
MAILNUM                Numeric        11 Mailing number
REVISED                Character       3 Indicates whether the applicant info is revised in the current mailing (i.e. has
                                         been modified since the last mailing) Revised - Yes, New - No
APPLICANT              Numeric        11 Applicant's PhamCAS ID
DATE_RECVD             Date           10 Date application received
SALUTATION             Character       4 Salutation or Title (e.g. Mr., Mrs., Dr.)
LASTNAME               Character      30 Applicant's last name
FIRSTNAME              Character      30 Applicant's first name
MIDNAME                Character      20 Applicant's middle name
SUFFIX                 Character       3 Suffix (Jr, IV, etc)
EMAIL                  Character      40 E-mail
ALTLSTNAME             Character      30 Prior / Alternate Last Name
ALTFSTNAME             Character      20 Prior / Alternate First Name
PREFERRED              Character      20 Preferred Address (Current or Permanent)
CURMAILTIL             Character      10 Current Mailing Address Until
CURSTREET1             Character      30 Current Street Address Line 1
CURSTREET2             Character      30 Current Street Address Line 2
CURSTREET3             Character      30 Current Street Address Line 3
CURCITY                Character      25 Current City
CURSTATE               Character       2 Current State/Province                                                             lk_state
CURSTTNAME             Character      60 Current State/Province Full Name                                                   lk_state
CURCOUNTY              Character      25 Current County/Region/District
CURZIP                 Character      10 Current ZIP/Postal code
CURCOUNTRY             Character       3 Current Country or Territory                                                       lk_country
CURCTRYNAM             Character      60 Current Country or Territory Full Name                                             lk_country
DAYPHONE               Character      20 Daytime phone
DAYEXTENTN             Character       6 Daytime phone extension
EVNPHONE               Character      20 Evening phone
CELLPHONE              Character      25 Cell Phone Number
FAX                    Character      20 Fax
PRMSTREET1             Character      30 Permanent address - Street Address Line 1
PRMSTREET2             Character      30 Permanent address - Street Address Line 2
PRMSTREET3             Character      30 Permanent address - Street Address Line 3
PRMCITY                Character      25 Permanent address - City


                                                                               Main
Printed on 7/18/2011                                PharmCAS Data Dictionary of e-File Output per Weekly Mailing                       Page 4 of 64



Main: Profile Information, Personal Information, Contact Information, Ethnicity Inforamtion and Personal Statement

   Field Name            Type      Width                                 Data Recorded                                  Lookup Table
PRMSTATE               Character       2   Permanent address - State/Province                                        lk_state
PRMSTTNAME             Character      60   Permanent address - State/Province Full Name                              lk_state
PRMCOUNTY              Character      25   Permanent address - County/Region/District
PRMZIP                 Character      10   Permanent address - ZIP/Postal code
PRMCOUNTRY             Character       3   Permanent address - Country or Territory                                  lk_country
PRMCTRYNAM             Character      60   Permanent address - Country or Territory Full Name                        lk_country
PRMPHONE               Character      20   Permanent address - Phone
PRMEXTENTN             Character       6   Permanent address - Phone extension
PREFPHONE              Character       3   Preferred Phone Number Code
PREFPHNNAM             Character      20   Preferred Phone Number Full Name(1-Current Day,2-Current Evening,3-Cell
                                           and 4-permanent)
STATERESID             Character       2   Permanent / Legal State of Residency                                      lk_state
STTRESNAME             Character      60   Permanent / Legal State of Residency Full Name                            lk_state
NUMYEARS               Character       2   Number of Years Residing in State
PREVRESID              Character       2   Previous State of Residency                                               lk_state
PRVRESNAME             Character      60   Previous State of Residency Full Name                                     lk_state
CTZNSTATUS             Character       1   Citizenship/Residency Status (1, 2, 3, 4)
STATUSNAME             Character      30   Citizenship/Residency Status Full Name (1-US Citizen, 2-US Permanent
                                           Resident, 3-Foreign Citizen, 4-Other Eligible Non-Citizen)
CTZCOUNTRY             Character       3   Country of Citizenship                                                    lk_country
CTZCTRYNAM             Character      60   Country of Citizenship Full Name                                          lk_country
VISATYPE               Character       2   Type of Visa (if foreign citizen only)                                    lk_visa
VISANAME               Character      50   Type of Visa Full Name (if foreign citizen only)                          lk_visa
ENGLPRIME              Character       3   Is English your first (primary) language (Yes/No)
BTHCITY                Character      25   City where applicant was born
BTHSTATE               Character       2   State where applicant was born                                            lk_state
BTHSTTNAME             Character      60   State where applicant was born Full Name                                  lk_state
BTHCNTRY               Character       3   Country where applicant was born                                          lk_country
CNTRYNAME              Character      60   Name of the country where applicant was born                              lk_country
DOB                    Date           10   Birthday (Month/Day/Year)
GENDER                 Character      20   Male,Female, Decline to State
ETHNO_HIS              Character       3   Ethnicity: No, Spanish/Hispanic/Latino/Latina
ETHHISPAN              Character       3   Ethnicity: Yes, Spanish/Hispanic/Latino/Latina
ETHALASK               Character       3   Race: American Indian or Alaska Native


                                                                               Main
Printed on 7/18/2011                                 PharmCAS Data Dictionary of e-File Output per Weekly Mailing                              Page 5 of 64



Main: Profile Information, Personal Information, Contact Information, Ethnicity Inforamtion and Personal Statement

   Field Name            Type      Width                                  Data Recorded                                      Lookup Table
ETHASIAN               Character       3   Race: Asian
ETHASIANIN             Character       3   Race: Asian Indian
ETHCHINESE             Character       3   Race: Chinese
ETHFILIPIN             Character       3   Race: Filipino
ETHJAPAN               Character       3   Race: Japanese
ETHKOREAN              Character       3   Race: Korean
ETHOTHERAS             Character       3   Race: Other Asian
ETHASDESC              Character      40   Race: If other, please specify
ETHPAKIST              Character       3   Race: Pakistani
ETHVIETNAM             Character       3   Race: Vietnamese
ETHBLACK               Character       3   Race: Black or African-American
ETHPISLAND             Character       3   Race: Native Hawaiian or Other Pacific Islander
ETHGUAM                Character       3   Race: Guamanian or Chamorro
ETHHAWAII              Character       3   Race: Native Hawaiian
ETHOTHERPI             Character       3   Race: Other Pacific Islander
ETHPIDESC              Character      40   Race: If other, please specify
ETHSAMOAN              Character       3   Race: Samoan
ETHWHITE               Character       3   Race: White
MILITEXP               Character       3   Do you have military experience? (Yes/No/N/A)
PREVENROLL             Character       3   Have you previously enrolled in a pharmacy degree program? (Yes/No)
PREVCOLCDE             Character       3   If Yes, specify college or school of pharmacy (Code)                           lk_previous_school
PREVCOLNME             Character      50   If Yes, specify college or school of pharmacy (Full Name)                      lk_previous_school
PREVELIGBL             Character       3   Are you eligible to return to the pharmacy degree program? (Yes/No)
DISCIPLINE             Character       3   Were you ever the recipient of any action (e.g. dismissal, disqualification,
                                           suspension, probation etc.) by any college or university for unacceptable
                                           academic performance? (Yes/No)
CONVICTED              Character       3   Have you ever been convicted of a felony? (Yes/No)
RELATION1              Character      10   Parental Relationship 1 (Father, Mother, Guardian)
LIVING1                Character      10   Living or Deceased 1 (Living, Deceased, Unknown)
OCCUPATN1              Character      30   Parent / Guardian Occupation 1
STTRESID1              Character       2   Parent / Guardian Legal State of Residency                                     lk_state
STTRESNAM1             Character      60   Parent / Guardian Legal State of Residency Full Name                           lk_state
EDUCATN1               Character       2   Parent / Guardian Highest Level of Education                                   lk_edu
EDUNAME1               Character      50   Parent / Guardian Highest Level of Education Full Name                         lk_edu


                                                                                Main
Printed on 7/18/2011                               PharmCAS Data Dictionary of e-File Output per Weekly Mailing                         Page 6 of 64



Main: Profile Information, Personal Information, Contact Information, Ethnicity Inforamtion and Personal Statement

   Field Name            Type      Width                                Data Recorded                                    Lookup Table
RELATION2              Character      10 Parental Relationship 2 (Father, Mother, Guardian)
LIVING2                Character      10 Living or Deceased 2 (Living, Deceased, Unknown)
OCCUPATN2              Character      30 Parent / Guardian Occupation 2
STTRESID2              Character       2 Parent / Guardian Legal State of Residency                                   lk_state
STTRESNAM2             Character      60 Parent / Guardian Legal State of Residency Full Name                         lk_state
EDUCATN2               Character       2 Parent / Guardian Highest Level of Education                                 lk_edu
EDUNAME2               Character      50 Parent / Guardian Highest Level of Education Full Name                       lk_edu
HSNAME                 Character      30 Name of High School
HSGRADMON              Character       2 Month of Graduation (or Completion of GED) (01 - 12)                         lk_month
HSGRADYEAR             Character       4 Year of Graduation (or Completion of GED) (e.g. 2002)                        lk_year
HSCITY                 Character      25 City where High School is located
HSSTATE                Character       2 State where High School is located                                           lk_state
HSSTTNAME              Character      60 State where High School is located Full Name                                 lk_state
PREVAPPIED             Character       3 Have you previously applied through PharmCAS? (Yes/No)
EARLYDECID             Character       3 Do you want to be considered an Early Decision Applicant? (Yes/No)
RELAUTHORZ             Character       3 Advisor Release (Yes/No)
RELSCHOOLS             Character       3 Certification and Verification statement (Yes/No)
DISEXPLAIN             Memo              Explanation - If you answered "Yes" to disciplinary action
CONEXPLAIN             Memo              Explanation - If you answered "Yes" to convicted of a felony
PERSSTMT               Memo              Personal Statement
TIIRESULTS             Character       3 "Turn it In" results - (0-100)
REVISIONS              Memo              Dated list of revised application sections since the last mailing (if any)




                                                                              Main
Printed on 7/18/2011                           PharmCAS Data Dictionary of e-File Output per Weekly Mailing           Page 7 of 7



Tests: User reported Tests (PCAT, TOEFL, and TSE)

  Field Name           Type    Width                                     Data recorded
APPLICANT          Numeric         11 Applicant's PhamCAS ID
TESTTYPE           Character        5 Type of Test (PCAT/TOEFL/TSE)
                   Character        1 TOEFL Type if entering TOEFL score (Internet = I, Computer = C, Paper = P, or
TOEFLT                                TSE, TSE/TWE = S)
TESTDATMON Character                2 Month of Test (01 - 12)
TESTDATYR  Character                4 Year of Test (e.g. 2002)




                                                                         Tests
Printed on 7/18/2011   PharmCAS Data Dictionary of e-File Output per Weekly Mailing   Page 8 of 8




        Lookup Table




lk_month
lk_year




                                                 Tests
Printed on 7/18/2011                                 PharmCAS Data Dictionary of e-File Output per Weekly Mailing                  Page 9 of 64



PCAT: Official PCAT scores provided by the testing service.

  Field Name             Type      Width                          Data recorded                                     Lookup Table
APPLICANT              Numeric         11   Applicant's PhamCAS ID
TESTDATMON             Character        2   Month of Test (01 - 12)                                           lk_month
TESTDATYR              Character        4   Year of Test (e.g. 2002)                                          lk_year
VERBAL                 Character        3   Verbal Ability Score
VERBALPCT1             Character        2   Verbal Ability Percentile - 2003 scale
VERBALPCT2             Character        2   Verbal Ability Percentile - 1992 scale
BIOLOGY                Character        3   Biology Score
BIOPERC1               Character        2   Biology Percentile - 2003 scale
BIOPERC2               Character        2   Biology Percentile - 1992 scale
READING                Character        3   Reading Comprehension Score
READPERC1              Character        2   Reading Comprehension Percentile - 2003 scale
READPERC2              Character        2   Reading Comprehension Percentile - 1992 scale
QUANTABIL              Character        3   Quantitative Ability Score
QUANTPERC1             Character        2   Quantitative Ability Percentile - 2003 scale
QUANTPERC2             Character        2   Quantitative Ability Percentile - 1992 scale
CHEMISTRY              Character        3   Chemistry Score
CHEMPERC1              Character        2   Chemistry Percentile - 2003 scale
CHEMPERC2              Character        2   Chemistry Percentile - 1992 scale
COMPOSITE              Character        3   Composite Score
COMPPERC1              Character        2   Composite Percentile - 2003 scale
COMPPERC2              Character        2   Composite Percentile - 1992 scale
WRITCONVS              Character        2   Writing - Conventions of Language Score
WRITPROBS              Character        3   Writing - Problem Solving Score
WRITCONVM              Character        4   Writing -Conventions of Language Mean Score
WRITPROBM              Character        4   Writing - Problem Solving Mean Score




                                                                               PCAT
Printed on 7/18/2011                                  PharmCAS Data Dictionary of e-File Output per Weekly Mailing                       Page 10 of 64



TOEFL: Official TOEFL scores provided by the testing service.

  Field Name             Type      Width                             Data recorded                                        Lookup Table
APPLICANT              Numeric         11    Applicant's PhamCAS ID
TESTDATMON             Character        2    Month of Test (01 - 12)                                                 lk_month
TESTDATYR              Character        4    Year of Test (e.g. 2002)                                                lk_year
TESTTYPE               Character        1    Test Score Type (Internet = I, Computer = C, Paper = P, TSE,
                                             TSE/TWE = S)
SCORE                  Character           6 Official TOEFL Score




                                                                               TOEFL
Printed on 7/18/2011                             PharmCAS Data Dictionary of e-File Output per Weekly Mailing      Page 11 of 64



TSE: Official TSE scores as provided by the testing service.

 Field Name            Type    Width                   Data recorded                                Lookup Table
APPLICANT          Numeric         11   Applicant's PhamCAS ID
TESTDATMON         Character        2   Month of Test (01 - 12)                             lk_month
TESTDATYR          Character        4   Year of Test (e.g. 2002)                            lk_year
SCORE              Character        6   Official TSE Score




                                                                            TSE
Printed on 7/18/2011                                PharmCAS Data Dictionary of e-File Output per Weekly Mailing                          Page 12 of 64



Colleges: Institutions Attended section (One to many)

  Field Name             Type      Width                                  Data recorded                                    Lookup Table
APPLICANT              Numeric         11   Applicant's PhamCAS ID
PRIMARY                Logical          3   Applicant designated primary college/institution attended (Yes/No)
COLLCODE               Character        5   College Code (for Internal Liaison Intl use)
IPEDCODE               Character        6   IPED Code of College or University (IPED in name ONLY - this is a Liaison
                                            Intl generated code)
COLLNAME               Character      200   Name of College or University
NONUS                  Character       40   Enter name of non-U.S./non-Canadian institution if applicable
COUNTRY                Character        3   Country of Institution                                                      lk_country
COUNTRYNAM             Character       60   Country of Institution Full Name                                            lk_country
STARTMONTH             Character        2   Attendance Date From: Month (01-12)                                         lk_month
STARTYEAR              Character        4   Attendance Date From: Year (e.g. 2000)                                      lk_year
ENDMONTH               Character        2   Attendance Date To: Month (01-12)                                           lk_month
ENDYEAR                Character        4   Attendance Date To: Year (e.g. 2000)                                        lk_year
DEGRCODE1              Character        2   Degree Code for First Degree                                                lk_degree
DEGRNAME1              Character       50   Degree Name for First Degree                                                lk_degree
DEGRSTAT1              Character       20   Status of the First Degree
MAJORCODE1             Character        3   Major Code for First Major of First Degree                                  lk_major
MAJORNAME1             Character       50   Major Name for First Major of First Degree                                  lk_major
MAJORCODE2             Character        3   Major Code for Second Major of First Degree                                 lk_major
MAJORNAME2             Character       50   Major Name for Second Major of First Degree                                 lk_major
DEGRMONTH1             Character        2   Date First Degree Earned or Anticipated: Month (01-12)                      lk_month
DEGRYEAR1              Character        4   Date First Degree Earned or Anticipated: Year (e.g. 2000)                   lk_year
DEGRCODE2              Character        2   Degree Code for Second Degree                                               lk_degree
DEGRNAME2              Character       50   Degree Name for Second Degree                                               lk_degree
DEGRSTAT2              Character       20   Status of the Second Degree
MAJORCODE3             Character        3   Major Code for Second Degree                                                lk_major
MAJORNAME3             Character       50   Major Name for Second Degree                                                lk_major
DEGRMONTH2             Character        2   Date Second Degree Earned or Anticipated: Month (01-12)
DEGRYEAR2              Character        4   Date Second Degree Earned or Anticipated: Year (e.g. 2000)
STATE                  Character        2   State or Province of the College or University                              lk_state
TRNCOMMENT             Character      150   Commentary that appears on the transcript (If any)
TRNDATEREC             Character       10   Transcript Date Received (Month/Day/Year)




                                                                             Colleges
Printed on 7/18/2011                                PharmCAS Data Dictionary of e-File Output per Weekly Mailing                                 Page 13 of 64



Complete: List of Completed Coursework (One to many)

Field Name             Type        Width   Data recorded                                                                  Lookup Table
APPLICANT              Numeric          11 Applicant's PhamCAS ID
IPEDCODE               Character         6 IPED Code of College or University (IPED in name ONLY - this is a Liaison
                                           Intl generated code)
COLLNAME               Character       200 Name of College or University
CRSCODE                Character        10 Internal Course Record number
ACASTATUS              Character        30 Session Level Academic Status                                                  lk_sess_level_status
TERM                   Character         8 Term (Winter, Spring, Summer, Summer 1, Summer 2, Fall, Interim)
TERMTYPE               Character        10 Type of Term (Quarter, Semester, Trimester, Unit)
YEAR                   Character         4 Year the course began (1950 - 2010)                                            lk_year
CRSTITLE               Character        40 Course Title
CRSPREFIX              Character        25 Course Prefix and Number (e.g. Chem 101)
CRSLVLABR              Character         6 Course Level Status                                                            lk_crs_level_status
CRSLVLFULL             Character        30 Course Level Status - Full description                                         lk_crs_level_status
GRADE                  Character         6 Grade as it appears on the transcript                                          lk_grade
PHGRADE                Character         4 Grade using PharmCAS conversion table
PHWEIGHT               Character         3 Numeric value of PharmCAS Grade (0.0 - 4.0)
CREDITS                Character         5 Number of Credit Hours
VERIFYGRD              Character         6 Verified Grade from Transcript (This field is normally empty. It will only
                                           contain a value when the Grade provided by the applicant does not match
                                           the Grade recorded on the official transcript.)
VERIFYCRD              Character         5 Verified Credit Hours from Transcript (This field is normally empty. It will
                                           only contain a value when the Credit Hours provided by the applicant does
                                           not match the Credit Hours recorded on the official transcript.)
SUBJECTCOD             Character         3 Code for Course Subject                                                        lk_subject
SUBJECTNAM             Character        30 Full Name of Course Subject                                                    lk_subject
CRSTYPE                Character         3 Course Type                                                                    lk_course_type
CRSTYPENAM             Character        30 Course Type Full Name                                                          lk_course_type
SPECCLASS              Character         2 Special Classification Code                                                    lk_classification
SPECCLNAM              Character        50 Special Classification Full Name                                               lk_classification
APTEST                 Character         4 Test Score




                                                                            Complete
Printed on 7/18/2011                               PharmCAS Data Dictionary of e-File Output per Weekly Mailing                             Page 14 of 64



Planned: List of Planned/In Progress Coursework (One to many)

  Field Name             Type      Width                                Data recorded                                        Lookup Table
APPLICANT              Numeric         11 Applicant's PhamCAS ID
                       Character        6 IPED Code of College or University (IPED in name ONLY - this is a Liaison
IPEDCODE                                  Intl generated code)
COLLNAME               Character      200 Name of College or University
CRSCODE                Character       10 Internal Course Record number
ACASTATUS              Character       30 Academic Status
TERM                   Character        8 Term (Winter, Spring, Summer, Summer 1, Summer 2, Fall, Interim)
TERMTYPE               Character       10 Type of Term (Quarter, Semester, Trimester, Unit)
YEAR                   Character        4 Year the course began (1950 - 2010)                                         lk_year
CRSTITLE               Character       40 Course Title
CRSPREFIX              Character       25 Course Prefix and Number (e.g. Chem 101)
CRSLVLABR              Character        6 Course Level Status                                                         lk_crs_level_status
CRSLVLFULL             Character       30 Course Level Status - Full description                                      lk_crs_level_status
CREDITS                Character        5 Number of Credit Hours
SUBJECTCOD             Character        3 Code for Course Subject                                                     lk_subject
SUBJECTNAM             Character       30 Full Name of Course Subject                                                 lk_subject
SPECCLASS              Character        2 Special Classification Code                                                 lk_classification
SPECCLNAM              Character       50 Special Classification Full Name                                            lk_classification




                                                                            Planned
Printed on 7/18/2011                                 PharmCAS Data Dictionary of e-File Output per Weekly Mailing                          Page 15 of 64



ExtraCur: Extracurricular, Volunteer, Community Service, Leadership, Dentistry Job Shadowing section

  Field Name             Type      Width                                       Data recorded                                Lookup Table
APPLICANT              Numeric         11   Applicant's PhamCAS ID
NAME                   Character       40   Name of Organization
POSITION               Character      175   Position Title / Brief Description
PHARMREL               Character        3   Is the extracurricular activity related to pharmacy or health care? (Yes/No)
HEALTHPROF             Character        3   Is the extracurricular activity related to pharmacy or health care?             lk_prof
HLTHPROFNM             Character       50   Is the extracurricular activity related to pharmacy or health care? FULL NAME   lk_prof
PRIMSET                Character        3   Select the primary setting for pharmacy or health care experience               lk_setting
PRIMSETNAM             Character       50   Select the primary setting for pharmacy or health care experience FULL NAME     lk_setting
TOTALHOURS             Character        5   Total Number of Hours Over Span of Experience (0-99999)
AVGHOURS               Character        3   Average Weekly Hours (0 - 999)
STARTMONTH             Character        2   Month of the Start Date (01-12)
STARTYEAR              Character        4   Year of the Start Date (e.g. 2000)
ENDMONTH               Character        2   Month of the End Date (01-12) (Future dates are allowed)
ENDYEAR                Character        4   Year of the End Date (e.g. 2000) (Future dates are allowed)




                                                                              ExtraCur
Printed on 7/18/2011                                   PharmCAS Data Dictionary of e-File Output per Weekly Mailing                            Page 16 of 64



WorkExp: Work Experience section.

  Field Name             Type      Width                                   Data recorded                                        Lookup Table
APPLICANT              Numeric         11    Applicant's PhamCAS ID
NAME                   Character       40    Name of Employer
POSITION               Character      175    Position Title / Brief Description
AVGHOURS               Character        5    Average Weekly Hours (0 - 999)
STARTMONTH             Character        2    Month of the Start Date (01-12)                                          lk_month
STARTYEAR              Character        4    Year of the Start Date (e.g. 2000)                                       lk_year
ENDMONTH               Character        2    Month of the End Date (01-12) (Future dates are allowed) (Blank if       lk_month
                                             reflecting "To Present")
ENDYEAR                Character           4 Year of the End Date (e.g. 2000) (Future dates are allowed) (Blank if    lk_year
                                             reflecting "To Present")




                                                                               WorkExp
Printed on 7/18/2011                                PharmCAS Data Dictionary of e-File Output per Weekly Mailing                      Page 17 of 64



Honors: Awards, Honors, Scholarships section

  Field Name             Type      Width                                  Data recorded                                Lookup Table
APPLICANT              Numeric         11   Applicant's PhamCAS ID
NAME                   Character       50   Name of Honor, Award or Merit-Based Scholarship
ORGANIZATN             Character       40   Organization
RECVDMONTH             Character        2   Month of the Date Received or Awarded (01-12)                          lk_month
RECVDYEAR              Character        4   Year of the Date Received or Awarded (e.g. 2000)                       lk_year




                                                                             Honors
Printed on 7/18/2011                                  PharmCAS Data Dictionary of e-File Output per Weekly Mailing                   Page 18 of 64



Publications: Publications

  Field Name             Type      Width                                   Data recorded                                    Lookup
APPLICANT              Character       11   Applicant's PhamCAS ID
PUBNAME                Character       50   Organization or Publication Name.
PUBFNAME               Character       50   Contact's First Name
PUBLNAME               Character       50   Contact's Last Name
PUBTITLE               Character       50   Contact's Title
PUBPHONE               Character       20   Contact's phone number
EXPLEVEL               Character        2   Year / Level (applicant cannot see this)                                 lk_level
EXPLVLDESC             Character       28   Year / Level                                                             lk_level
PUBMONTH               Character        2   Publication Date: Month                                                  lk_month
PUBYEAR                Character        4   Publication Date: Year                                                   lk_year
DESCRIPT               Memo          1500   Publication Description




                                                                             Publications
Printed on 7/18/2011                             PharmCAS Data Dictionary of e-File Output per Weekly Mailing              Page 19 of 64



Campus: Applicant Campus selection.

   Field Name            Type      Width                    Data recorded                                   Lookup Table
APPLICANT              Numeric         11 Applicant's PhamCAS ID
CAMPUSCODE             Character        2 Code of Campus (Internal Use Code)                        lk_campus
CAMPUSNAME             Character       50 Name of Campus                                            lk_campus




                                                                          Campus
Printed on 7/18/2011                            PharmCAS Data Dictionary of e-File Output per Weekly Mailing                     Page 20 of 64



GPA: Applicant GPA information.

 Field Name            Type    Width                                 Data recorded                                Lookup Table
APPLICANT          Numeric         11 Applicant's PharmCAS ID
                   Character        6 IPED Code of College or University (IPED in name ONLY - this is a Liaison
IPEDCODE                              Intl generated code)
COLLNAME           Character      200 Name of College or University
HRSOVERALL         Character        8 Calculated Credit Hours Value - Overall
QPOVERALL          Character        8 Calculated Quality Points Value - Overall
GPAOVERALL         Character        5 Calculated GPA Value - Overall




                                                                           GPA
Printed on 7/18/2011                          PharmCAS Data Dictionary of e-File Output per Weekly Mailing              Page 21 of 64



GPAYear : GPA based on academic year

Field Name              Type          Width                                  Data Recorded                   Lookup Table
APPLICANT        Numeric                      11   Applicant's PharmCAS ID
YEAR             Character                     2   Year (FR, SO, JR, SR, Z1, GR, PR, PB, Z2)
QPSCI            Character                     8   Quality Points - Science
HRSSCI           Character                     8   Science Hours
GPASCI           Character                     5   Science GPA
QPNSCI           Character                     8   Quality Points - Non-Science
HRSNSCI          Character                     8   Non-Science Hours
GPANSCI          Character                     5   Non-Science GPA
QPMTH            Character                     8   Quality Points - Math
HRSMTH           Character                     8   Math Hours
GPAMTH           Character                     5   Math GPA
QPTOT            Character                     8   Quality Points - Overall
HRSTOT           Character                     8   Overall Hours
GPATOT           Character                     5   Overall GPA


Legend
Z1 = Total UnderGrad+Post-Bac
Z2 = Total UnderGrad +Grad+Prof



fields QPSCI, HRSSCI, GPASCI = all totals pertaining to Science
fields QPNSCI, HRSNSCI, GPANSCI = all totals pertaining to Non-Science
fields QPMTH, HRSMTH, GPAMTH = all totals pertaining to Math
fields QPTOT, HRSTOT, GPATOT = all cumulative totals




                                                                      GPAYear
Printed on 7/18/2011                            PharmCAS Data Dictionary of e-File Output per Weekly Mailing                                 Page 22 of 64



GPACrs: Calculated GPA for individual Subject Course at any academic level.

        Field Name              Type         Width                     Data recorded                           Lookup Table
APPLICANT                 Numeric                      11   Applicant's PharmCAS ID
SUBJECT                   Character                     3   Subject Code                               lk_subject             See Note #1.
SUBJECTNAM                Character                    30   Subject Name                               lk_subject             See Note #1.
HRSGRADE                  Character                     8   Grade Hours
HRS2                      Character                     8   Hours with grade < 2.0
HRSCR                     Character                     8   Credited Hours
HRSTOTAL                  Character                     8   Total Hours
QP                        Character                     8   Quality Points
GPA                       Character                     5   Calculated GPA


Note #1: Only the following subjects are used for Subject Course GPAs:

Biochemistry
Biology & Other Life Sciences
Organic Chemistry
Inorganic Chemistry
Physics
Other Science
Math
Microbiology
Social/Behavioral Science




                                                                         GPACrs
Printed on 7/18/2011                         PharmCAS Data Dictionary of e-File Output per Weekly Mailing                   Page 23 of 64



Degree: Applicant Degree information.

  Field Name                 Type   Width                             Data recorded                          Lookup Table
APPLICANT              Numeric          11 Applicant's PharmCAS ID
IPEDCODE               Character         6 IPED Code of College or University (IPED in name ONLY - this is
                                           a Liaison Intl generated code)
COLLNAME               Character       200 Name of College or University
STATE                  Character         2 State or Province of the College or University                    lk_state
VERIFIED               Character         3 Degree Verified (Yes/No)




                                                                      Degree
Printed on 7/18/2011                                 PharmCAS Data Dictionary of e-File Output per Weekly Mailing   Page 24 of 64



Certifications: Professional licenses and certifications information.

   Field Name            Type      Width                 Data recorded                            Lookup Table
APPLICANT              Numeric        11   Applicant's PharmCAS ID
LICTYPE                Character      30   Type of License or Certificate
ISSORG                 Character      30   Issuing Organization
STARTMONTH             Character       2   Attendance Date From: Month (01-12)                lk_month
STARTYEAR              Character       4   Attendance Date From: Year (e.g. 2000)             lk_year
ENDMONTH               Character       2   Attendance Date To: Month (01-12)                  lk_month
ENDYEAR                Character       4   Attendance Date To: Year (e.g. 2000)               lk_year




                                                                           Certifications
Printed on 7/18/2011                          PharmCAS Data Dictionary of e-File Output per Weekly Mailing                  Page 25 of 64



RefProf: Applicant Reference information.

  Field Name                 Type   Width                              Data recorded                         Lookup Table
APPLICANT              Numeric          11   Applicant's PharmCAS ID
REF_ID                 Numeric           6   Reference's ID
WAIVER                 Character         3   Waiver status (YES/NO)
TYPE                   Character        10   Reference type
RECD_DATE              Date             10   Reference received date
TITLE                  Character         5   Title
FIRSTNAME              Character        40   First Name
LASTNAME               Character        40   Last Name
MDLNAME                Character        40   Middle Name
SUFFIX                 Character         3   Suffix
EMAIL                  Character        60   Email
PHONE                  Character        20   Phone
OCCUPATION             Character        50   Occupation
STREET_1               Character        50   Reference's address - Street 1
STREET_2               Character        50   Reference's address - Street 2
CITY                   Character        40   Reference's address - City
STCODE                 Character         2   Reference's address - State                                     lk_state
STNAME                 Character        60   Reference's address - State Full Name                           lk_state
ZIP                    Character        10   Reference's address - ZIP Code
CNTRYCODE              Character         3   Reference's address - Country Code                              lk_country
CNTRYNAME              Character        60   Reference's address - Country Full Name                         lk_country




                                                                       RefProf
Printed on 7/18/2011                         PharmCAS Data Dictionary of e-File Output per Weekly Mailing                          Page 26 of 64



RefData: Applicant Reference information in detail.

Field Name             Type        Width        Data recorded                                                       Lookup Table
APPLICANT              Numeric             11   Applicant's PharmCAS ID
REF_ID                 Numeric              6   Reference's ID
AFFILIATED             Character           60   With what organization or institution are you affiliation
RELATECODE             Character            2   Select the role that best describes your primary relationship with  lk_relate
                                                the applicant.
RELATION               Character           60   Select the role that best describes your primary relationship with  lk_relate
                                                the applicant - Full Name.
POSTITLE               Character           60   If you selected Supervisor, Employer, or Co-worker above, please
                                                indicate the applicant's position title.
PHARMSCH               Character           60   Pharm institution from which you graduated
RELATE_OTH             Character           60   If you selected Other above, briefly describe.
STATELICNS             Character            2   State in which you are licensed to practice pharmacy, if applicable lk_state

STATELICNM             Character           60 State in which you are licensed to practice pharmacy, if applicable - lk_state
                                              Full Name
MONTHS                 Character            2 How long have you known the applicant - Months                        lk_nummonths
YEARS                  Character            2 How long have you known the applicant - Years                         lk_numyears
HOWWELL                Character            1 How well do you know this applicant - Code                            lk_howwell
HOWWELLNAM             Character           15 How well do you know this applicant - Description                     lk_howwell
ORALCOM_R              Character            1 Oral Communication - Code                                             lk_evaluate
ORALCOM_D              Character           20 Oral Communication - Description                                      lk_evaluate
WRITCOM_R              Character            1 Written Communication - Code                                          lk_evaluate
WRITCOM_D              Character           20 Written Communication - Description                                   lk_evaluate
INTABIL_R              Character            1 Intellectual Ability - Code                                           lk_evaluate
INTABIL_D              Character           20 Intellectual Ability - Description                                    lk_evaluate
LEADERS_R              Character            1 Leadership - Code                                                     lk_evaluate
LEADERS_D              Character           20 Leadership - Description                                              lk_evaluate
ETHICS_R               Character            1 Ethics - Code                                                         lk_evaluate
ETHICS_D               Character           20 Ethics - Description                                                  lk_evaluate
EMPATHY_R              Character            1 Empathy - Code                                                        lk_evaluate
EMPATHY_D              Character           20 Empathy - Description                                                 lk_evaluate
RELIABLT_R             Character            1 Reliability - Code                                                    lk_evaluate
RELIABLT_D             Character           20 Reliability - Description                                             lk_evaluate
JUDGMNT_R              Character            1 Judgment - Code                                                       lk_evaluate


                                                                      RefData
Printed on 7/18/2011                PharmCAS Data Dictionary of e-File Output per Weekly Mailing                              Page 27 of 64



JUDGMNT_D              Character   20   Judgment - Description                                                 lk_evaluate
INTERPRS_R             Character    1   Interpersonal Relations - Code                                         lk_evaluate
INTERPRS_D             Character   20   Interpersonal Relations - Description                                  lk_evaluate
ADAPT_R                Character    1   Adaptability - Code                                                    lk_evaluate
ADAPT_D                Character   20   Adaptability - Description                                             lk_evaluate
APPEAR_R               Character    1   Professional Appearance - Code                                         lk_evaluate
APPEAR_D               Character   20   Professional Appearance - Description                                  lk_evaluate
RECOMM_R               Character    1   Recommendation concerning admission - Code                             lk_recommend
RECOMM_D               Character   60   Recommendation concerning admission - Description                      lk_recommend
COMMENT                Memo             Comments
ADD_COMM               Memo             Additional Comments
CRSLIST                Memo             If Professor or Teaching Assistant, list all courses with applicant.




                                                               RefData
Code   Campus Description   Parent (School) Code
1      Gainesville (main)   11
2      Jacksonville         11
3      Orlando              11
4      St. Petersburg       11
5      Omaha (main)         09
6      Web-Based Pathway    09




                                         lk_campus
Code   Description                           Abbreviation
1      Not Applicable                        N/A
2      Repeated                              Repeated
3      Incomplete                            Incomplete
4      Distance Learning                     Dist. Learn.
5      Honors                                Honors
6      Study Abroad                          Study Abroad
7      Advanced Placement                    Adv. Place.
8      CLEP                                  CLEP
9      International Baccalaureate           Inter. Bac.
10     Regent's Exam                         Regent Exam
11     Institutional/Departmental Exam       Inst./Dept
12     Academic Bankruptcy                   Aca. Bank.
13     Freshman Forgiveness                  Fresh. For.
14     College in High School                College/HS
15     Online                                Online




                                         lk_classification
Country Name               Abbrev.      Notes:
Afghanistan                AF           http://www.state.gov/s/inr/rls/4250.htm
Albania                    AL
Algeria                    AG
Andorra                    AN
Angola                     AO
Antigua and Barbuda        AC
Argentina                  AR
Armenia                    AM
Australia                  AS
Austria                    AU
Azerbaijan                 AJ
Bahamas, The               BF
Bahrain                    BA
Bangladesh                 BG
Barbados                   BB
Belarus                    BO
Belgium                    BE
Belize                     BH
Benin                      BN
Bhutan                     BT
Bolivia                    BL
Bosnia and Herzegovina     BK
Botswana                   BC
Brazil                     BR
Brunei                     BX
Bulgaria                   BU
Burkina Faso               UV
Burma                      BM
Burundi                    BY
Cambodia                   CB
Cameroon                   CM
Canada                     CA
Cape Verde                 CV
Central African Republic   CT
Chad                       CD
Chile                      CI
China                      CH
Colombia                   CO
Comoros                    CN
Congo (Brazzaville)        CF
Congo (Kinshasa)           CG
Costa Rica                 CS
Côte d'Ivoire              IV
Croatia                    HR
Cuba                       CU
Cyprus                     CY
Czech Republic             EZ
Denmark                    DA
Djibouti                   DJ
Dominica                   DO
Dominican Republic         DR


                           lk_country
Ecuador             EC
Egypt               EG
El Salvador         ES
Equatorial Guinea   EK
Eritrea             ER
Estonia             EN
Ethiopia            ET
Fiji                FJ
Finland             FI
France              FR
Gabon               GB
Gambia, The         GA
Georgia             GG
Germany             GM
Ghana               GH
Greece              GR
Grenada             GJ
Guatemala           GT
Guinea              GV
Guinea-Bissau       PU
Guyana              GY
Haiti               HA
Holy See            VT
Honduras            HO
Hungary             HU
Iceland             IC
India               IN
Indonesia           ID
Iran                IR
Iraq                IZ
Ireland             EI
Israel              IS
Italy               IT
Jamaica             JM
Japan               JA
Jordan              JO
Kazakhstan          KZ
Kenya               KE
Kiribati            KR
Korea, North        KN
Korea, South        KS
Kosovo              KV           ADD
Kuwait              KU
Kyrgyzstan          KG
Laos                LA
Latvia              LG
Lebanon             LE
Lesotho             LT
Liberia             LI
Libya               LY
Liechtenstein       LS
Lithuania           LH


                    lk_country
Luxembourg              LU
Macedonia               MK
Madagascar              MA
Malawi                  MI
Malaysia                MY
Maldives                MV
Mali                    ML
Malta                   MT
Marshall Islands        RM
Mauritania              MR
Mauritius               MP
Mexico                  MX
Micronesia,             FM
Federated States of
Moldova                 MD
Monaco                  MN
Mongolia                MG
Montenegro              MJ
Morocco                 MO
Mozambique              MZ
Namibia                 WA
Nauru                   NR
Nepal                   NP
Netherlands             NL
New Zealand             NZ
Nicaragua               NU
Niger                   NG
Nigeria                 NI
Norway                  NO
Oman                    MU
Pakistan                PK
Palau                   PS
Panama                  PM
Papua New Guinea        PP
Paraguay                PA
Peru                    PE
Philippines             RP
Poland                  PL
Portugal                PO
Qatar                   QA
Romania                 RO
Russia                  RS
Rwanda                  RW
Saint Kitts and Nevis   SC
Saint Lucia             ST
Saint Vincent and       VC
the Grenadines
Samoa                   WS
San Marino              SM
Sao Tome and Principe   TP
Saudi Arabia            SA
Senegal                 SG


                        lk_country
Serbia                 RI
Seychelles             SE
Sierra Leone           SL
Singapore              SN
Slovakia               LO
Slovenia               SI
Solomon Islands        BP
Somalia                SO
South Africa           SF
Spain                  SP
Sri Lanka              CE
Sudan                  SU
Suriname               NS
Swaziland              WZ
Sweden                 SW
Switzerland            SZ
Syria                  SY
Tajikistan             TI
Tanzania               TZ
Thailand               TH
Timor-Leste            TT           (formally East Timor)
Togo                   TO
Tonga                  TN
Trinidad and Tobago    TD
Tunisia                TS
Turkey                 TU
Turkmenistan           TX
Tuvalu                 TV
Uganda                 UG
Ukraine                UP
United Arab Emirates   AE
United Kingdom         UK
United States          US
Uruguay                UY
Uzbekistan             UZ
Vanuatu                NH
Venezuela              VE
Vietnam                VM
Yemen                  YM
Zambia                 ZA
Zimbabwe               ZI
NOT LISTED             99
Taiwan                 TW




                       lk_country
v/s/inr/rls/4250.htm




                       lk_country
Code   Description
212    Lab Only
213    Lecture Only
214    Lab and Lecture Combined




                                  lk_course_type
Code   Description              Abbreviation
119    Lower-division (Fr/So)   Fr/So
120    Upper-division (Jr/Sr)   Jr/Sr
121    Graduate                 Grad
122    Technical/Vocational     TecVo
123    Remedial                 Remed
124    Professional             Prof




                                           lk_crs_level_status
Code   Description
1      Withdrew
2      Denied
3      Wait List
4      Regular
5      Offer Made
6      Offer Accepted
7      Declined offer
8      Deferred
9      Rescinded
10     Matriculated
11     Received/Under Review




                               lk_decision
Code   Description
1      ASSOCIATE ARTS
2      ASSOCIATE SCIENCE
3      BACHELOR ARTS
4      OTHER BACHELOR
5      BACHELOR SCIENCE
6      CERTIFICATE
7      DOCTOR OF CHIROPRACTIC
8      DOCTOR OF OSTEOPATHIC MED
9      OTHER DOCTORAL (NOT Ph.D)
10     DOCTOR OF DENTISTRY
11     DOCTOR OF VETERINARY MED
12     JURIS DOCTORATE
13     MASTER ARTS
14     DOCTOR OF MEDICINE
15     OTHER MASTER
16     MASTER SCIENCE
17     NO DEGREE
18     PH.D.




                                   lk_degree
Code   Education Description
1      No degree, certificate or diploma
2      High school degree or equivalent
3      Trade certificate or diploma
4      Some college
5      Associates degree
6      Bachelors degree
7      Professional degree
8      Masters degree
9      Earned doctoral degree
10     Unknown / Other




                                           lk_edu
Code   Description
0      Not Observed
1      Poor
2      Below Average
3      Average
4      Good
5      Excellent




                       lk_evaluate
Code   Description
A+     A+
A      A
A-     A-
AB     AB
B+     B+
B      B
B-     B-
BC     BC
C+     C+
C      C
C-     C-
CD     CD
D+     D+
D      D
D-     D-
DE     DE
E      E
F      F
W      Withdrawn
WF     Withdrawn Failing
P      Pass - Pass/Fail
S      Satisfactory
CR     Credit
NP     No Pass - Pass/Fail
NS     Non-Satisfactory
U      Unsatisfactory
R      Repeated
AU     Audit
NG     No Grade
I      Incomplete




                             lk_grade
Code   Description
1      Very Well
2      Moderately
3      Minimally
4      Not at all




                     lk_howwell
Code   Description
1      College or University Year 1
2      College or University Year 2
3      College or University Year 3
4      College or University Year 4
5      College or University Year 5
CF     Bridge or College Foundation
GR     Graduate
HS     High School




                                      lk_level
Code   Description
1      ACCOUNTING
2      AEROSPACE ENG
3      AGRICULTURE
4      ANATOMY
5      ANESTHESIOLOGY
6      ANIMAL SCIENCE
7      ANTHROPOLOGY
8      ARCHITECTURE
9      ART
10     ART HISTORY
11     ASTRONOMY
12     BIOCHEMISTRY
13     BIOLOGY
14     BIOMATHEMATICS
15     BIOMEDICAL ENG
16     BIOPHYSICS
17     BIOTECHNOLOGY
18     BOTANY
19     BUSINESS
20     CHEM/BIO
21     CHEMICAL ENG
22     CHEMISTRY
23     CHIROPRACTIC
24     CIVIL ENGINEERING
25     CLASSICS
26     COMMUNICATIONS
27     COMPUTER SCIENCE
28     CRIMINOLOGY
29     CULINARY ARTS
30     DENTAL ASSIST
31     DENTISTRY
32     ECOLOGY
33     ECONOMICS
34     EDUCATION
35     ELECTRICAL ENG
36     ENGINEERING
37     ENGLISH
38     ENTOMOLOGY
39     ENVIRON STUDIES
40     EPIDEMIOLOGY
41     ETHNIC STUDIES
42     FOREIGN LANGUAGE
43     FORENSIC SCIENCE
44     FORESTRY
45     GENERAL STUDIES
46     GENETICS
47     GEOGRAPHY
48     GEOLOGY
49     GEOPHYSICS
50     HEALTH EDUCATION
51     HEALTH SCIENCE


                           lk_major
52    HISTORY
53    HOME ECONOMICS
54    HONORS PROGRAM
55    HOSPITAL ADMIN
56    HUMANITIES
57    INFORMATION TECHNOLOGY
58    INTERDISCIPLINARY STUDIES
59    INTERNATIONAL AFFAIRS/RELATIONS
60    JOURNALISM
61    KINESIOLOGY
62    LAW
63    LIBERAL ARTS
64    LIBRARY SCIENCE
65    LINGUISTICS
66    LITERATURE
67    MARINE SCI / BIOLOGY
68    MATHEMATICS
69    MECHANICAL ENG
70    MEDICAL ASSISTANT/TECH
71    MEDICAL TECH
72    MEDICINE
73    METEOROLOGY
74    MICROBIOLOGY
75    MILITARY SCIENCE
76    MUSIC
77    NEUROSCIENCE
78    NO ANSWER
79    NO MAJOR
80    NURSING
81    NUTRITION
82    OCCUPAT'L THER
83    OCEANOGRAPHY
84    OPTOMETRY
85    OSTEOPATHIC MED
86    OTHER
87    PATHOLOGY
122   PHARMACEUTICAL SCIENCES
88    PHARMACOLOGY
89    PHARMACY (NOT PRE-PHARMACY)
90    PHARMACY TECHNICIAN
91    PHILOSOPHY
92    PHYSICAL ED
93    PHYSICAL THERAPY
94    PHYSICIAN ASSIST
95    PHYSICS
96    PHYSIOLOGY
97    PODIATRY
98    POLITICAL SCIENCE
99    PRE-PHARMACY
100   PRE-PROFESSIONAL
101   PREMEDICAL
102   PSYCHOBIOLOGY


                                        lk_major
103   PSYCHOLOGY
104   PUBLIC ADMIN
105   PUBLIC HEALTH
106   RADIOLOGY
107   RELIGION
108   RESPIRATORY THER
109   SCIENCE
110   SCIENCE OTHER BIO
111   SOCIAL SCIENCE
112   SOCIAL WK/COUNSEL
113   SOCIOLOGY
114   SPEECH
115   SPEECH PATH
116   SPORTS MEDICINE
117   STATISTICS
118   THEATRE/CINEMA
119   THEOLOGY
120   VETERINARY
121   ZOOLOGY




                          lk_major
Code   Description
01     January
02     February
03     March
04     April
05     May
06     June
07     July
08     August
09     September
10     October
11     November
12     December




                     lk_month
Code   Description
1      1
2      2
3      3
4      4
5      5
6      6
7      7
8      8
9      9
10     10
11     11




                     lk_nummonths
Code   Description
1      1
2      2
3      3
4      4
5      5
6      6
7      7
8      8
9      9
10     10
11     11
12     12
13     13
14     14
15     15
16     16
17     17
18     18
19     19
20     20




                     lk_numyears
Code   Previous School Description
1      Non-U.S. Pharmacy Institution
2      Other U.S. Pharmacy Institution
3      Albany College of Pharmacy
4      Auburn University
5      Butler University
6      Campbell University
7      Cardiff University
8      Chiang Mai University
9      Chulalongkorn University
10     Creighton University
11     Dalhousie University
12     Drake University
13     Duquesne University
14     Ferris State University
15     Florida Agricultural and Mechanical University
16     Hampton University
17     Howard University
18     Idaho State University
19     Kuwait University
20     Lebanese American University
21     LECOM School of Pharmacy
22     Loma Linda University
23     Long Island University
24     Massachusetts College of Pharmacy - Boston
25     Massachusetts College of Pharmacy - Worcester
26     Medical University of South Carolina
27     Memorial University of Newfoundland
28     Mercer University
29     Midwestern University - Chicago
30     Midwestern University - Glendale
31     Nevada College of Pharmacy
32     North Dakota State University
33     Northeastern University
34     Nova Southeastern University
35     Ohio Northern University
36     Ohio State University
37     Oregon State University
38     Palm Beach Atlantic University
39     Philladelphia College of Pharmacy
40     Prince of Songkla University
41     Purdue University
42     Samford University
43     Shenandoah University
44     Silpakorn University
45     South Dakota State University
46     South University
47     Southwestern Oklahoma State University
48     St. John's University
49     St. Louis College of Pharmacy
50     State University of New Jersey - Rutgers
51     Temple University


                                            lk_previous_school
52    Texas Southern University
53    Texas Tech University Health Sciences Center
54    Ubon Ratchathani University
55    Universite Laval
56    Universiti Sains Malaysia
57    University at Buffalo
58    University of Alberta
59    University of Arizona
60    University of Arkansas for Medical Sciences
61    University of British Columbia
62    University of California - San Diego
63    University of California - San Francisco
64    University of Cincinnati - Medical Center
65    University of Colorado Health Sciences Center
66    University of Connecticut
67    University of Florida
68    University of Georgia
69    University of Houston
70    University of Illinois at Chicago
71    University of Iowa
72    University of Kansas
73    University of Kentucky
74    University of Louisiana at Monroe
75    University of Manitoba
76    University of Maryland
77    University of Michigan
78    University of Minnesota - Duluth
79    University of Minnesota - Minneapolis
80    University of Mississippi
81    University of Missouri - Kansas City
82    University of Montana
83    University of Montreal
84    University of Nebraska
85    University of New Mexico
86    University of North Carolina
87    University of Oklahoma
88    University of Pittsburgh
89    University of Puerto Rico
90    University of Rhode Island
91    University of Saskatchewan
92    University of South Carolina
93    University of Southern California
94    University of Tennessee
95    University of Texas at Austin
96    University of the Pacific
97    University of the Philippeans
98    University of Toledo
99    University of Toronto
100   University of Utah
101   University of Washington
102   University of Wisconsin - Madison
103   University of Wyoming


                                            lk_previous_school
104   Virginia Commonwealth University
105   Washington State University
106   Wayne State University
107   West Virginia University
108   Western University of Health Sciences
109   Wilkes University
110   Wingate University
111   Xavier University of Louisiana




                                              lk_previous_school
Code   Description
1      Alcohol/Drug Abuse Specialist
2      Audiologist
3      Biochemist
4      Biomathematician
5      Biomedical Engineer
6      Biophysicist
7      Biostatistatician
8      Chiropractor
9      Dentist
10     Dietitian/Nutritionist
11     Emergency Medical Technician
12     Epidemiologist
13     Health Care Administrator
14     Health Information Specialist
15     Hematologist
16     Hospital Administrator
17     Medicinal Chemist
18     Medical Laboratory Scientist
19     Medical Librarian
20     Medical Technologist
21     Nurse
22     Occupational Therapist
23     Ophthalmologist
24     Optometrist
25     Orthopedist
26     OTHER healthcare professional
27     Pharmacist
28     Pharmaceutical Scientist
29     Physical Therapist
30     Physican - Osteopathic
31     Physician - Allopathic
32     Physician Assistant
33     Podiatrist
34     Professor - Science
35     Psychologist
36     Psychiatrist
37     Psychometrist
38     Public Health Practitioner
39     Respiratory Therapist
40     Social Worker
41     Speech Pathologist
42     Support Staff or Manager
43     Therapist - Art, Music, Dance
44     Toxicologist
45     Veterinarian




                                       lk_prof
Code   Description
1      I highly recommend this applicant
2      I recommend this applicant
3      I recommend this applicant, but with some reservations
4      I am not able to recommend this applicant




                                          lk_recommend
Code   Description
1      Teaching Assistant
2      Supervisor
3      Professor (Science)
4      Professor (Math)
5      Professor (Liberal Arts)
6      Pre-Health Professions Advisor
7      Politician
8      Pharmacist
9      Health Care Professional
10     Friend
11     Family Member
12     Faculty Advisor
13     Employer
14     Co-Worker
15     Clergy
16     Other (e.g., brother & pharmacist)




                                            lk_relation
Code   Description
FR     Fr (Freshman)
SO     So (Sophomore)
JR     Jr (Junior)
SR     Sr (Senior)
GR     Gr (Graduate)
PR     Pr (Professional)
PB     PB (Post-BS/BA Undergraduate)




                                       lk_sess_level_status
Code   Description
1      Adult day care center
2      Alcohol/drug rehabilitation center
3      Ambulatory care center
4      Animal hospital or clinic
5      Armed services / military
6      Assisted living center
7      Camp
8      Club (pre-pharmacy)
9      Club (other)
10     College or university
11     Community health center
12     Consulting firm
13     Correctional institution
14     Extended / long term care
15     Government - Federal
16     Government - Local
17     Government - State
18     Health clinic
19     Health department
20     Health information center
21     Health insurance organization
22     Health maintenance organization
23     Home (care) health agency
24     Homeless shelter
25     Hospice
26     Hospital
27     Industrial plant
28     International health care organization
29     Law firm
30     Library
31     Life care facility
32     Managed care organization
33     Medical laboratories
34     Medical publisher
35     Mental health center
36     Non-profit organization
37     Nursing home
38     OTHER setting
39     Pharmaceutical industry
40     Pharmacy
41     Physical rehabilitation center
42     Poison control center
43     Preferred provider organization
44     Private practice
45     Psychiatric facility or institution
46     Public health organization/department
47     Regulatory organization
48     Research agency or organization
49     School - elementary
50     School - secondary
51     Social services


                                                lk_setting
52   Surgical care center
53   Women's health center




                             lk_setting
Code   State
ZZ     No State
AA     Armed Forces Americas
AB     Alberta
AE     Armed Forces Europe, Africa, Canada, Middle East
AK     Alaska
AL     Alabama
AP     Armed Forces Pacific
AR     Arkansas
AS     American Somoa
AZ     Arizona
BC     British Columbia
CA     California
CO     Colorado
CT     Connecticut
DC     District of Columbia
DE     Delaware
FL     Florida
FM     Federated States of Micronesia
GA     Georgia
GU     Guam
HI     Hawaii
IA     Iowa
ID     Idaho
IL     Illinois
IN     Indiana
KS     Kansas
KY     Kentucky
LA     Louisiana
MA     Massachusetts
MB     Manitoba
MD     Maryland
ME     Maine
MH     Marshall Islands
MI     Michigan
MN     Minnesota
MO     Missouri
MP     Northern Mariana Islands
MS     Mississippi
MT     Montana
NB     New Brunswick
NC     North Carolina
ND     North Dakota
NE     Nebraska
NF     Newfoundland
NH     New Hampshire
NJ     New Jersey
NM     New Mexico
NS     Nova Scotia
NT     Northwest Territories
NU     Nunavut
NV     Nevada


                                                 lk_state
NY   New York
OH   Ohio
OK   Oklahoma
ON   Ontario
OR   Oregon
PA   Pennsylvania
PE   Prince Edward Island
PR   Puerto Rico
PW   Palau
QC   Quebec
RI   Rhode Island
SC   South Carolina
SD   South Dakota
SK   Saskatchewan
TN   Tennessee
TX   Texas
UT   Utah
VA   Virginia
VI   Virgin Islands
VT   Vermont
WA   Washington
WI   Wisconsin
WV   West Virginia
WY   Wyoming
YT   Yukon Territory




                            lk_state
Code   Subject Description
1      Biochemistry
2      Biology & Other Life Sciences
4      Organic Chemistry
3      Inorganic Chemistry
6      Physics
5      Other Science
7      Math
14     Microbiology
8      English/Literature
10     General Non-Science
9      Social/Behavioral Science
11     Economics
12     Public Speaking
13     Computer Science




                                       lk_subject
Code   Description
1      F-1 Student
2      J-1 Student
3      J-1 Teacher, Researcher, or Trainee
4      H1-B Employee
5      B-1 Visitor
6      Visa Waiver WB
7      Visa Waiver WT
8      Refugee
9      None
10     Other




                                             lk_visa
Code   Description
2014   2014
2013   2013
2012   2012
2011   2011
2010   2010
2009   2009
2008   2008
2007   2007
2006   2006
2005   2005
2004   2004
2003   2003
2002   2002
2001   2001
2000   2000
1999   1999
1998   1998
1997   1997
1996   1996
1995   1995
1994   1994
1993   1993
1992   1992
1991   1991
1990   1990
1989   1989
1988   1988
1987   1987
1986   1986
1985   1985
1984   1984
1983   1983
1982   1982
1981   1981
1980   1980
1979   1979



                     lk_year
1978   1978
1977   1977
1976   1976
1975   1975
1974   1974
1973   1973
1972   1972
1971   1971
1970   1970
1969   1969
1968   1968
1967   1967
1966   1966
1965   1965
1964   1964
1963   1963
1962   1962
1961   1961
1960   1960
1959   1959
1958   1958
1957   1957
1956   1956
1955   1955
1954   1954
1953   1953
1952   1952
1951   1951
1950   1950




              lk_year

				
DOCUMENT INFO