SAD_TFL_SUS

(SQL Table)
 Index Back

TOEFL Test Suspense

TOEFL Test Suspense

# 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 CI_CODE_TOEFL Character(4) VARCHAR2(4) NOT NULL Institution Code
5 ORG_ID_TOEFL Character(2) VARCHAR2(2) NOT NULL TOEFL Department Code
6 REG_NBR_TOEFL Character(16) VARCHAR2(16) NOT NULL Registration Number
7 SAD_LAST_NAME_LD Character(32) VARCHAR2(32) NOT NULL Admissions Last Name from Test Load
8 SAD_FIRST_NAME_LD Character(30) VARCHAR2(30) NOT NULL Admissions First Name from Test Load
9 SAD_MID_NAME_LD Character(30) VARCHAR2(30) NOT NULL Middle Name
10 SAD_MID_INIT_LD Character(1) VARCHAR2(1) NOT NULL Admissions Middle Initial from Test Load
11 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix

Prompt Table: NAME_PREFIX_TBL

12 SAD_ADDRESS1_LD Character(55) VARCHAR2(55) NOT NULL Address 1
13 SAD_ADDRESS2_LD Character(55) VARCHAR2(55) NOT NULL Address 2
14 SAD_ADDRESS3_LD Character(55) VARCHAR2(55) NOT NULL Address 3
15 SAD_ADDRESS4_LD Character(55) VARCHAR2(55) NOT NULL Address 4
16 SAD_CITY_LD Character(40) VARCHAR2(40) NOT NULL Test Load City
17 SAD_STATE_LD Character(60) VARCHAR2(60) NOT NULL Test Load State
18 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_NAMES_TBL

19 SAD_COUNTRY_LD Character(30) VARCHAR2(30) NOT NULL Test Load Country
20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

21 SAD_CNTRY_NAME_LD Character(40) VARCHAR2(40) NOT NULL TOEFL Country Name
22 SAD_POSTAL_LD Character(15) VARCHAR2(15) NOT NULL Test Load Postal Code
23 SAD_NTV_CNTRY_LD Character(3) VARCHAR2(3) NOT NULL Native Country Code
24 COUNTRY_TOEFL Character(40) VARCHAR2(40) NOT NULL TOEFL Native Country
25 SAD_NTV_LANG_LD Character(3) VARCHAR2(3) NOT NULL Native Language Code
26 LANG_TOEFL Character(40) VARCHAR2(40) NOT NULL TOEFL Native Language
27 SAD_BIRTHDATE_LD Character(10) VARCHAR2(10) NOT NULL Admissions Birthdate from Test Load
28 BIRTHDATE Date(10) DATE Date of Birth
29 SAD_SEX_LD Character(1) VARCHAR2(1) NOT NULL Test Load Gender
30 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
31 SAD_TEST_DT_LD Character(10) VARCHAR2(10) NOT NULL Test Load Test Date
32 TEST_DT Date(10) DATE NOT NULL Test Date

Default Value: %date

33 CENTER_TOEFL Character(5) VARCHAR2(5) NOT NULL TOEFL Center
34 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
35 NON_STNDRD_IND_TOF Character(1) VARCHAR2(1) NOT NULL TOEFL Non-Standard Indicator
L=No Listening Score
X=Extra Time
36 SAD_SPK_IND_LD Character(1) VARCHAR2(1) NOT NULL TOEFL Speaking Indicator
37 TRNCTD_IND_TOEFL Character(1) VARCHAR2(1) NOT NULL TOEFL Truncated Scale Indicator
38 REASON_TOEFL Character(1) VARCHAR2(1) NOT NULL TOEFL Reason Taken
39 DEGREE_TOEFL Character(1) VARCHAR2(1) NOT NULL TOEFL Degree
40 SAD_TST_SCR_COMP1 Character(3) VARCHAR2(3) NOT NULL Test Component 1 Score
41 SAD_SCORE_COMP1 Number(7,2) DECIMAL(6,2) NOT NULL Score
42 SAD_TST_COMP1 Character(5) VARCHAR2(5) NOT NULL Test Component 1

Prompt Table: SA_TCMP_REL_TBL

43 SAD_TST_COMP1_PST Character(1) VARCHAR2(1) NOT NULL Post

Y/N Table Edit

Default Value: N

44 SAD_TST_COMP1_ERR Character(1) VARCHAR2(1) NOT NULL Error

Y/N Table Edit

Default Value: N

45 SAD_TST_SCR_COMP2 Character(3) VARCHAR2(3) NOT NULL Test Component 2 Score
46 SAD_SCORE_COMP2 Number(7,2) DECIMAL(6,2) NOT NULL Score
47 SAD_TST_COMP2 Character(5) VARCHAR2(5) NOT NULL Test Component 2

Prompt Table: SA_TCMP_REL_TBL

48 SAD_TST_COMP2_PST Character(1) VARCHAR2(1) NOT NULL Post

Y/N Table Edit

Default Value: N

49 SAD_TST_COMP2_ERR Character(1) VARCHAR2(1) NOT NULL Error

Y/N Table Edit

Default Value: N

50 SAD_TST_SCR_COMP3 Character(3) VARCHAR2(3) NOT NULL Test Component 3 Score
51 SAD_SCORE_COMP3 Number(7,2) DECIMAL(6,2) NOT NULL Score
52 SAD_TST_COMP3 Character(5) VARCHAR2(5) NOT NULL Test Component 3

Prompt Table: SA_TCMP_REL_TBL

53 SAD_TST_COMP3_PST Character(1) VARCHAR2(1) NOT NULL Post

Y/N Table Edit

Default Value: N

54 SAD_TST_COMP3_ERR Character(1) VARCHAR2(1) NOT NULL Error

Y/N Table Edit

Default Value: N

55 SAD_TST_SCR_COMP4 Character(3) VARCHAR2(3) NOT NULL Test Component 4 Score
56 SAD_SCORE_COMP4 Number(7,2) DECIMAL(6,2) NOT NULL Score
57 SAD_TST_COMP4 Character(5) VARCHAR2(5) NOT NULL Test Component 4

Prompt Table: SA_TCMP_REL_TBL

58 SAD_TST_COMP4_PST Character(1) VARCHAR2(1) NOT NULL Post

Y/N Table Edit

Default Value: N

59 SAD_TST_COMP4_ERR Character(1) VARCHAR2(1) NOT NULL Error

Y/N Table Edit

Default Value: N

60 SAD_TST_SCR_COMP5 Character(3) VARCHAR2(3) NOT NULL Test Component 5 Score
61 SAD_SCORE_COMP5 Number(7,2) DECIMAL(6,2) NOT NULL Score
62 SAD_TST_COMP5 Character(5) VARCHAR2(5) NOT NULL Test Component 5

Prompt Table: SA_TCMP_REL_TBL

63 SAD_TST_COMP5_PST Character(1) VARCHAR2(1) NOT NULL Post

Y/N Table Edit

Default Value: N

64 SAD_TST_COMP5_ERR Character(1) VARCHAR2(1) NOT NULL Error

Y/N Table Edit

Default Value: N

65 INTP_TOEFL Character(4) VARCHAR2(4) NOT NULL Interpretive Info Year
66 NO_TAKEN_TOEFL Character(1) VARCHAR2(1) NOT NULL Number of Times Taken
67 TOPIC_TOEFL Character(1) VARCHAR2(1) NOT NULL No Response/Off Topic
68 SAD_EMAIL_LD Character(70) VARCHAR2(70) NOT NULL EMail Address
69 SAD_TOEFL_EMAIL Character(75) VARCHAR2(75) NOT NULL TOEFL Email
70 SAD_TFL_CTR_CD Character(15) VARCHAR2(15) NOT NULL Test Center Code
71 SAD_TFL_CTR_CNTRY Character(36) VARCHAR2(36) NOT NULL Test Center Country