SAD_TFL_CD(SQL Table) |
Index Back |
|---|---|
TOEFL Candidate InfoTOEFL Candidate Information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
| 2 | TEST_DT |
Date(10) | DATE NOT NULL |
Test Date
Default Value: %date |
| 3 | CI_CODE_TOEFL | Character(4) | VARCHAR2(4) NOT NULL | Institution Code |
| 4 | ORG_ID_TOEFL | Character(2) | VARCHAR2(2) NOT NULL | TOEFL Department Code |
| 5 | REG_NBR_TOEFL | Character(16) | VARCHAR2(16) NOT NULL | Registration Number |
| 6 | COUNTRY_TOEFL | Character(40) | VARCHAR2(40) NOT NULL | TOEFL Native Country |
| 7 | SAD_COUNTRY_LD | Character(30) | VARCHAR2(30) NOT NULL | Test Load Country |
| 8 | LANG_TOEFL | Character(40) | VARCHAR2(40) NOT NULL | TOEFL Native Language |
| 9 | SAD_LAST_NAME_LD | Character(32) | VARCHAR2(32) NOT NULL | Admissions Last Name from Test Load |
| 10 | SAD_FIRST_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Admissions First Name from Test Load |
| 11 | SAD_MID_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Middle Name |
| 12 | SAD_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 13 | SAD_SEX_LD | Character(1) | VARCHAR2(1) NOT NULL | Test Load Gender |
| 14 | REASON_TOEFL | Character(1) | VARCHAR2(1) NOT NULL | TOEFL Reason Taken |
| 15 | DEGREE_TOEFL | Character(1) | VARCHAR2(1) NOT NULL | TOEFL Degree |
| 16 | NO_TAKEN_TOEFL | Character(1) | VARCHAR2(1) NOT NULL | Number of Times Taken |
| 17 | INTP_TOEFL | Character(4) | VARCHAR2(4) NOT NULL | Interpretive Info Year |
| 18 | CENTER_TOEFL | Character(5) | VARCHAR2(5) NOT NULL | TOEFL Center |
| 19 | TEST_TYPE_TOEFL | Character(1) | VARCHAR2(1) NOT NULL |
TOEFL- Test Type
C=Computer Based Test I=Internet Based Test P=Paper & Pencil Test P=Paper & Pencil Test P=Paper Based Test S=Test of Spoken English |
| 20 | NON_STNDRD_IND_TOF | Character(1) | VARCHAR2(1) NOT NULL |
TOEFL Non-Standard Indicator
L=No Listening Score X=Extra Time |
| 21 | TRNCTD_IND_TOEFL | Character(1) | VARCHAR2(1) NOT NULL | TOEFL Truncated Scale Indicator |
| 22 | SAD_TEST_DT_LD | Character(10) | VARCHAR2(10) NOT NULL | Test Load Test Date |
| 23 | TOPIC_TOEFL | Character(1) | VARCHAR2(1) NOT NULL | No Response/Off Topic |
| 24 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 25 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 26 | SAD_ADDRESS3_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 27 | SAD_ADDRESS4_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 28 | SAD_CITY_LD | Character(40) | VARCHAR2(40) NOT NULL | Test Load City |
| 29 | SAD_STATE_LD | Character(60) | VARCHAR2(60) NOT NULL | Test Load State |
| 30 | SAD_POSTAL_LD | Character(15) | VARCHAR2(15) NOT NULL | Test Load Postal Code |
| 31 | SAD_CNTRY_NAME_LD | Character(40) | VARCHAR2(40) NOT NULL | TOEFL Country Name |
| 32 | SAD_NTV_CNTRY_LD | Character(3) | VARCHAR2(3) NOT NULL | Native Country Code |
| 33 | SAD_NTV_LANG_LD | Character(3) | VARCHAR2(3) NOT NULL | Native Language Code |
| 34 | SAD_SPK_IND_LD | Character(1) | VARCHAR2(1) NOT NULL | TOEFL Speaking Indicator |
| 35 | CAUSE_CREATION | Character(1) | VARCHAR2(1) NOT NULL |
Personal Data Impacts
N=No Personal Data Impact U=Caused Personal Data Update Y=Caused Personal Data Creation Default Value: N |
| 36 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 37 | SAD_TOEFL_EMAIL | Character(75) | VARCHAR2(75) NOT NULL | TOEFL Email |
| 38 | SAD_TFL_CTR_CD | Character(15) | VARCHAR2(15) NOT NULL | Test Center Code |
| 39 | SAD_TFL_CTR_CNTRY | Character(36) | VARCHAR2(36) NOT NULL | Test Center Country |