Report Title Graduate GMAT Test Score Processing by cqp17691

VIEWS: 23 PAGES: 3

									Report Title:    Graduate GMAT Test Score Processing


Report Number:   P87DW439


Description:     This program reads a file of a file of GMAT Test scores that is
                 received by the Graduate School via Pearson Vue website and
                 uploaded to a production dataset. The original file is sent from the
                 Educational Testing Service (ETS) Pearson Vue. The uploaded file
                 generated by this process is in a format compatible with the ISIS
                 Master Test Score File.

                 Added a step which will do a name search matching on Last name,
                 First name (with & without middle initial), date of birth and last 4
                 digits of ssn. If there is no ssn in ISIS the record is written as is… If
                 all matches (including ssn) then the record is rewritten with the
                 entire ssn instead of ‘*****’###.

                 The uploaded data is copied to a generational dataset (three
                 versions) for access and retrieval by the School of Business.

                 This output file is merged with the Master File processed by the
                 P87WU900 Master Test File Update Program. The GMAT Verbal,
                 Quantitative, Total and analytical writing tests scores are processed.

                 If the record on the GMAT Test file does not contain a student
                 identification number, the students on the file are matched against
                 the ISIS database using the entire last name, sex and date of birth.
                 Because of incomplete ISIS information or anomalies in the
                 formatting of the last name fields on the ISIS or input file records, it
                 is possible an undiscovered match exists. All unmatched records
                 are written to the Unmatched Students Report for inclusion in all
                 subsequent processing of the P87WU900 Master Test File Update
                 Program or for review and manual processing if appropriate.

Use:             Inclusion of standardized GMAT scores in the ISIS System for
                 expected applicants is initiated by this process. When applications
                 are added to the database, scores are transferred from the Master
                 Test file to the student's ISIS G5 Test Score Screen.

                 This program runs automatically each workday without a
                 transmittal. Results are processed if data has been uploaded.


Special Forms:   None


                         Page 1 of 3                      Revised: 03/2/2006
                 P87DW439 Graduate GMAT Test Score Processing
                            Data File Information


Dataset Name Format:     PN0100.A143200.P87439.U.GMAT and
                         PN0100.A143200.P87439.D.GMAT

GMAT Test Score Update Upload File Layout (note this is as provided by ETS):


F I E L D             N A M E START LENGTH FORMAT/COMMENTS
Last Name                          1     32
First Name                        33     24
Initial                           57      1
Sex                               58      1
DOB                               59      6 MMDDYY
SSN                               65      9
Telephone                         74     10
Ext                               84      5
Address line 1                    89     32
Address line 2                   121     32
City                             153     30
State                            183      2
Zip                              185      9
Email                            194     55
Reg app #                        249     16
Admin date                       265      4
Verbal %                         269      2
Quan %                           271      2
Total score %                    273      2
Analytical writing %             275      2
Verbal converted                 277      2
Quan converted                   279      2
Total converted                  281      3
Analytical writing converted     284      3 WITH DECIMAL E.G. "6.0"
Irregularity code                287      1
Most recent previous admin date  288      4    MMYY
Most recent previous verbal %    292      2
Most recent previous Quan %      294      2
Most recent previous total score
%                                296      2
Most recent previous analytical
writing %                        298      2
Most recent previous verbal
converted                        300      2
Most recent previous Quan
converted                        302      2


                          Page 1 of 3                  Revised: 03/2/2006
              P87DW439 Graduate GMAT Test Score Processing
                         Data File Information
F I E L D             N A M E START LENGTH FORMAT/COMMENTS
Most recent previous total
converted                         304     3
Most recent previous analytical
writing converted                 307     3  WITH DECIMAL E.G. "6.0"
Most recent previous irregularity
code                              310     1
Second most recent admin date     311     4 MMYY
Second most recent verbal %       315     2
Second most recent Quan %         317     2
Second most recent total score %  319     2
Second most recent analytical
writing %                         321     2
Second most recent verbal
converted                         323     2
Second most recent Quan
converted                         325     2
Second most recent total
converted                         327     3
Second most recent analytical
writing converted                 330     3  WITH DECIMAL E.G. "6.0"
Second most recent irregularity
code                              333     1
Graduation date                   334     6            MMCCYY
Educational level                 340     2
Undergrad GPA                     342     2
Undergrad major code              344     2
Citizenship code                  346     3
Attending institution             349     4
Intended grad study               353     2
Country code                      355     3
Designated inst                   358     4
Date created                      362     8 MMDDCCYY
Filler                            370    31




                      Page 2 of 3               Revised: 03/2/2006

								
To top