SAD_SSS_SUS(SQL Table) |
Index Back |
|---|---|
SSS Test Suspension TableSSS_SUSPN contains all records from the SSS (Student Search Service) load process. |
| # | 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 | CLG_BRDRGNL_CD_SSS | Character(1) | VARCHAR2(1) NOT NULL | SSS College Board Regional Code |
| 5 | SAD_SSS_CUST_ID | Character(6) | VARCHAR2(6) NOT NULL | SSS Customer ID |
| 6 | SAD_SSS_SRCH_YR | Character(2) | VARCHAR2(2) NOT NULL | SSS Search Year and Cycle |
| 7 | SAD_SSS_CYCLE | Character(1) | VARCHAR2(1) NOT NULL | Search Cycle |
| 8 | SAD_SSS_SRCH_FORM | Character(3) | VARCHAR2(3) NOT NULL | SSS Search Form Number |
| 9 | SAD_SSS_RUN_CODE | Character(3) | VARCHAR2(3) NOT NULL | Run Code |
| 10 | SAD_LAST_NAME_LD | Character(32) | VARCHAR2(32) NOT NULL | Admissions Last Name from Test Load |
| 11 | SAD_FIRST_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Admissions First Name from Test Load |
| 12 | SAD_MID_INIT_LD | Character(1) | VARCHAR2(1) NOT NULL | Admissions Middle Initial from Test Load |
| 13 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 14 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 15 | SAD_CITY_LD | Character(40) | VARCHAR2(40) NOT NULL | Test Load City |
| 16 | SAD_STATE_LD | Character(60) | VARCHAR2(60) NOT NULL | Test Load State |
| 17 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 18 | SAD_POSTAL_LD | Character(15) | VARCHAR2(15) NOT NULL | Test Load Postal Code |
| 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 | EPS_MRKT_CD_SSS | Character(4) | VARCHAR2(4) NOT NULL | SSS EPS Market Code |
| 22 | SAD_SEX_LD | Character(1) | VARCHAR2(1) NOT NULL | Test Load Gender |
| 23 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec |
| 24 | SAD_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 25 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 26 | SAD_SSN_LD | Character(9) | VARCHAR2(9) NOT NULL | Admissions Test Load SSN |
| 27 | HS_CODE_SSS | Character(6) | VARCHAR2(6) NOT NULL | High School Code |
| 28 | GRAD_YR_SSS | Character(2) | VARCHAR2(2) NOT NULL | SSS Graduation Year |
| 29 | PSTL_DLVRY_PNT_SSS | Character(2) | VARCHAR2(2) NOT NULL | Postal Delivery Point |
| 30 | PST_CRCTN_CHAR_SSS | Character(1) | VARCHAR2(1) NOT NULL | Postal Correction Character |
| 31 | SAD_ETHNICITY_LD | Character(2) | VARCHAR2(2) NOT NULL | Ethnicity |
| 32 | ETHNIC_GRP_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ethnic group code
Prompt Table:
ETHNIC_GRP_TBL
|
| 33 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 34 | SAD_COUNTY_LD | Character(6) | VARCHAR2(6) NOT NULL | County Code |
| 35 | PSAT_LSTD_MJR_SSS | Character(3) | VARCHAR2(3) NOT NULL | PSAT/NMSQT Search Listed Major |
| 36 | HS_CLUSTER_SSS | Character(2) | VARCHAR2(2) NOT NULL | SSS High School Cluster |
| 37 | EDUC_NBRHD_SSS | Character(2) | VARCHAR2(2) NOT NULL | SSS Educational Neighborhood |
| 38 | SAD_HS_CLUSTER_SSS | Character(2) | VARCHAR2(2) NOT NULL | New High School Cluster |
| 39 | SAD_EDUC_NBRHD_SSS | Character(2) | VARCHAR2(2) NOT NULL | New Educational Neighbourhood |
| 40 | TEST_DT | Date(10) | DATE NOT NULL | Test Date |
| 41 | SAD_TST_COMP1 | Character(5) | VARCHAR2(5) NOT NULL |
Test Component 1
Prompt Table: SA_TCMP_REL_TBL |
| 42 | SAD_SCORE_COMP1 | Number(7,2) | DECIMAL(6,2) NOT NULL | Score |
| 43 | SAD_PERCENT_COMP1 | Number(3,0) | SMALLINT NOT NULL | Percentile |
| 44 | SAD_TST_COMP1_PST | Character(1) | VARCHAR2(1) NOT NULL |
Post
Y/N Table Edit Default Value: N |
| 45 | SAD_TST_COMP2 | Character(5) | VARCHAR2(5) NOT NULL |
Test Component 2
Prompt Table: SA_TCMP_REL_TBL |
| 46 | SAD_SCORE_COMP2 | Number(7,2) | DECIMAL(6,2) NOT NULL | Score |
| 47 | SAD_PERCENT_COMP2 | Number(3,0) | SMALLINT NOT NULL | Percentile |
| 48 | SAD_TST_COMP2_PST | Character(1) | VARCHAR2(1) NOT NULL |
Post
Y/N Table Edit Default Value: N |
| 49 | TEST_ADMIN | Character(1) | VARCHAR2(1) NOT NULL |
Standard Test Administration
Y/N Table Edit Default Value: N |
| 50 | SAD_SSS_DAT_SRC_CD | Number(2,0) | SMALLINT NOT NULL | Student Data Source Code |
| 51 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 52 | SAD_ADDRESS3_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 53 | SAD_SSS_ORDERNBR | Character(10) | VARCHAR2(10) NOT NULL | Order Number |
| 54 | SAD_SSS_CBEXAM | Character(4) | VARCHAR2(4) NOT NULL | Most Recent CB Exam |
| 55 | SAD_SSS_LSTUPDT | Date(10) | DATE | Last Update Date |
| 56 | SAD_SSS_HOMESCHL | Character(1) | VARCHAR2(1) NOT NULL | Home Schooled |
| 57 | SAD_SSS_LOWSES | Character(2) | VARCHAR2(2) NOT NULL | Low SES |
| 58 | SAD_SSS_STDNT_ID | Character(32) | VARCHAR2(32) NOT NULL | Student ID |