TEST_IDPrompt Table: SA_TEST_TBL
TEST_REC_NBRPrompt Table: PEOPLE_SRCH
Prompt Table: NAME_PREFIX_TBL
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
Prompt Table: STATE_NAMES_TBL
Prompt Table: COUNTRY_TBL
SAD_GMT_SUS(SQL Table) |
Index Back |
|---|---|
GMAT Suspense FileSAD_GMT_SUS contains all records from the GMAT load process. Those records which are 'clean' will be processed by the GMAT post program, loaded into the 'live' tables and then removed from the suspense table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: SA_TEST_TBL |
| 2 | TEST_REC_NBR |
Number(9,0) | DECIMAL(9) NOT NULL | Test Type Record Nbr |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 4 | SAD_LAST_NAME_LD | Character(32) | VARCHAR2(32) NOT NULL | Admissions Last Name from Test Load |
| 5 | SAD_FIRST_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Admissions First Name from Test Load |
| 6 | SAD_MID_INIT_LD | Character(1) | VARCHAR2(1) NOT NULL | Admissions Middle Initial from Test Load |
| 7 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 8 | SAD_SEX_LD | Character(1) | VARCHAR2(1) NOT NULL | Test Load Gender |
| 9 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 10 | SAD_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 11 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 12 | SAD_SSN_LD | Character(9) | VARCHAR2(9) NOT NULL | Admissions Test Load SSN |
| 13 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 14 | SAD_TELEPHONE_LD | Character(20) | VARCHAR2(20) NOT NULL | Telephone Number |
| 15 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 16 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 17 | SAD_CITY_LD | Character(40) | VARCHAR2(40) NOT NULL | Test Load City |
| 18 | SAD_STATE_LD | Character(60) | VARCHAR2(60) NOT NULL | Test Load State |
| 19 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 20 | SAD_POSTAL_LD | Character(15) | VARCHAR2(15) NOT NULL | Test Load Postal Code |
| 21 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 22 | REG_NBR_GMAT | Character(16) | VARCHAR2(16) NOT NULL | GMAT Registration Number |
| 23 | GRAD_DT_GMAT | Character(6) | VARCHAR2(6) NOT NULL | GMAT Graduation Date |
| 24 | GRAD_DT | Date(10) | DATE | Graduation Date |
| 25 | ED_LEVEL_GMAT | Character(2) | VARCHAR2(2) NOT NULL | GMAT Education Level |
| 26 | U_GRAD_GPA_GMAT | Character(2) | VARCHAR2(2) NOT NULL | GMAT Undergraduate GPA |
| 27 | U_MAJOR_CODE_GMAT | Character(2) | VARCHAR2(2) NOT NULL | GMAT Undergraduate Major Code |
| 28 | SAD_CITIZEN_LD | Character(3) | VARCHAR2(3) NOT NULL | Test Load Citizenship |
| 29 | ATND_INST_CD_GMAT | Character(4) | VARCHAR2(4) NOT NULL | GMAT Attending Institution Code |
| 30 | ITND_GRD_STDY_GMAT | Character(2) | VARCHAR2(2) NOT NULL | GMAT Intended Graduate Study |
| 31 | SAD_COUNTRY_LD | Character(30) | VARCHAR2(30) NOT NULL | Test Load Country |
| 32 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 33 | DSN_INST_CODE_GMAT | Character(9) | VARCHAR2(9) NOT NULL | GMAT Designated Institution Code |
| 34 | TAPEDATE_GMAT | Character(8) | VARCHAR2(8) NOT NULL | GMAT Tape Created Date |
| 35 | TAPE_DT | Date(10) | DATE | Date Tape Created |
| 36 | SAD_MID_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 37 | SAD_GMAT_ID | Character(12) | VARCHAR2(12) NOT NULL | GMAT ID |