| # |
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
|
| 3 |
SAD_LAST_NAME_LD |
Character(32) |
VARCHAR2(32) NOT NULL |
Admissions Last Name from Test Load
|
| 4 |
SAD_FIRST_NAME_LD |
Character(30) |
VARCHAR2(30) NOT NULL |
Admissions First Name from Test Load
|
| 5 |
SAD_MID_INIT_LD |
Character(1) |
VARCHAR2(1) NOT NULL |
Admissions Middle Initial from Test Load
|
| 6 |
SAD_SSN_LD |
Character(9) |
VARCHAR2(9) NOT NULL |
Admissions Test Load SSN
|
| 7 |
SAD_BIRTHDATE_LD |
Character(10) |
VARCHAR2(10) NOT NULL |
Admissions Birthdate from Test Load
|
| 8 |
SAD_SEX_LD |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Load Gender
|
| 9 |
SAD_ADDRESS1_LD |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 10 |
SAD_CITY_LD |
Character(40) |
VARCHAR2(40) NOT NULL |
Test Load City
|
| 11 |
SAD_STATE_LD |
Character(60) |
VARCHAR2(60) NOT NULL |
Test Load State
|
| 12 |
SAD_POSTAL_LD |
Character(15) |
VARCHAR2(15) NOT NULL |
Test Load Postal Code
|
| 13 |
SAD_COUNTRY_LD |
Character(30) |
VARCHAR2(30) NOT NULL |
Test Load Country
|
| 14 |
RESIDENCE_CODE_SAT |
Character(5) |
VARCHAR2(5) NOT NULL |
SAT Residence Code
|
| 15 |
SAD_TELEPHONE_LD |
Character(20) |
VARCHAR2(20) NOT NULL |
Telephone Number
|
| 16 |
SCHOOL_CD_SAT |
Character(6) |
VARCHAR2(6) NOT NULL |
SAT College Code
|
| 17 |
HS_CODE_SAT |
Character(6) |
VARCHAR2(6) NOT NULL |
High School Code
|
| 18 |
HS_NAME_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
SAT High School Name
|
| 19 |
HS_ADD1_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
High School Address 1
|
| 20 |
HS_ADD2_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
High School Address 2
|
| 21 |
HS_ADD3_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
High School Address 3
|
| 22 |
HS_PHONE_NBR_SAT |
Character(12) |
VARCHAR2(12) NOT NULL |
SAT High School Telephone Number
|
| 23 |
HS_TYPE_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT High School Type
A=Public
B=Independent Nonreligious
C=Independent Religious
|
| 24 |
HS_SNR_CLS_SZ_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT High School Senior Class Size
A=Fewer than 100
B=100 - 249
C=250 - 499
D=500 - 749
E=750 - 999
F=1000 or more
|
| 25 |
HS_PCT_SENIORS_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT High School Percent of Seniors Going to College
A=90% or more
B=80% - 89%
C=70% - 79%
D=60% - 69%
E=50% - 59%
F=40% - 49%
G=30% - 39%
H=20% - 29%
I=10% - 19%
J=Less than 10%
|
| 26 |
HS_LOCATION_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Location of High School
A=Large City
B=Medium-size City
C=Small City or Town
D=Suburban
E=Rural
|
| 27 |
HS_NBR_AP_CRS_SAT |
Number(2,0) |
SMALLINT NOT NULL |
SAT High School Number of AP Courses Offered
|
| 28 |
HS_HNRS_CRSES_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT High School Honors Courses Offered
A=Yes
B=No
|
| 29 |
HS_UNITS_GRAD_SAT |
Number(4,0) |
SMALLINT NOT NULL |
SAT High School Units to Graduate
|
| 30 |
HS_GRAD_DT_SAT |
Character(4) |
VARCHAR2(4) NOT NULL |
SAT High School Graduation Date
|
| 31 |
HS_GRAD_DT |
Date(10) |
DATE |
Highschool graduation date
|
| 32 |
SAD_TEST_DT_LD |
Character(10) |
VARCHAR2(10) NOT NULL |
Test Load Test Date
|
| 33 |
GPA_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Grade Point Average
|
| 34 |
MAJOR_FIRSTCH_SAT |
Character(3) |
VARCHAR2(3) NOT NULL |
SAT First Choice of Major
|
| 35 |
MAJOR_OTHER_SAT |
Character(3) |
VARCHAR2(3) NOT NULL |
SAT Other Major 1
|
| 36 |
RANK_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Class Rank
|
| 37 |
SAD_ETHNICITY_LD |
Character(2) |
VARCHAR2(2) NOT NULL |
Ethnicity
|
| 38 |
FIRST_LANGUAGE_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
First Language
|
| 39 |
FINANCIAL_AID_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Financial Aid
Y/N Table Edit
Default Value: N
|
| 40 |
SAD_CITIZEN_LD |
Character(3) |
VARCHAR2(3) NOT NULL |
Test Load Citizenship
|
| 41 |
PARTICIPATION_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Participation in Community/School Activities Flag
|
| 42 |
SDQ_ACT_DT_SAT |
Character(4) |
VARCHAR2(4) NOT NULL |
SAT Student Descriptive Questionnaire Activity Date
|
| 43 |
SPORTS_PARTIC_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Participated in Sports
Y/N Table Edit
Default Value: N
|
| 44 |
SPORT1_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Sport 1
|
| 45 |
SPORT2_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Sport 2
|
| 46 |
SPORT3_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Sport 3
|
| 47 |
SPORT4_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Sport 4
|
| 48 |
SPORT5_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Sport 5
|
| 49 |
SPORT6_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Sport 6
|
| 50 |
TYPE_PREF1_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT 4-Year College or University
Y/N Table Edit
Default Value: N
|
| 51 |
TYPE_PREF2_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT 2-Year Community or Junior College
Y/N Table Edit
Default Value: N
|
| 52 |
TYPE_PREF3_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Vocational or Technical School
Y/N Table Edit
Default Value: N
|
| 53 |
TYPE_PREF4_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Undecided 2-Year or 4-Year School
Y/N Table Edit
Default Value: N
|
| 54 |
PUB_PRIV_PREF1_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Public University or College
Y/N Table Edit
Default Value: N
|
| 55 |
PUB_PRIV_PREF2_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Private University or College (not religiously affiliated)
Y/N Table Edit
Default Value: N
|
| 56 |
PUB_PRIV_PREF3_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Private University or College (religiously affiliated)
Y/N Table Edit
Default Value: N
|
| 57 |
PUB_PRIV_PREF4_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Undecided Public/Private Institution
Y/N Table Edit
Default Value: N
|
| 58 |
SIZE_PREF1_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Size of Institution Preference - Fewer than 1000
Y/N Table Edit
Default Value: N
|
| 59 |
SIZE_PREF2_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Size of Institution Preference - About 1000 to 5000 Students
Y/N Table Edit
Default Value: N
|
| 60 |
SIZE_PREF3_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Size of Institution Preference - About 5000 to 10,000 Students
Y/N Table Edit
Default Value: N
|
| 61 |
SIZE_PREF4_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Size of Institution Preference - About 10,000 to 20,000 Students
Y/N Table Edit
Default Value: N
|
| 62 |
SIZE_PREF5_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Size of Institution Preference - More Than 20,000 Students
Y/N Table Edit
Default Value: N
|
| 63 |
SIZE_PREF6_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Size of Institution Preference - Undecided
Y/N Table Edit
Default Value: N
|
| 64 |
SETTING_PREF1_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Setting - Large City or Metropolitan Area
Y/N Table Edit
Default Value: N
|
| 65 |
SETTING_PREF2_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Setting - Medium-size City
Y/N Table Edit
Default Value: N
|
| 66 |
SETTING_PREF3_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Setting - Small City or Town
Y/N Table Edit
Default Value: N
|
| 67 |
SETTING_PREF4_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Setting - Suburban Community
Y/N Table Edit
Default Value: N
|
| 68 |
SETTING_PREF5_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Setting - Rural
Y/N Table Edit
Default Value: N
|
| 69 |
SETTING_PREF6_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Setting - Undecided
Y/N Table Edit
Default Value: N
|
| 70 |
LOC_PREF1_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Location Preference - Close to Home
Y/N Table Edit
Default Value: N
|
| 71 |
LOC_PREF2_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Location Preference - In My Home State
Y/N Table Edit
Default Value: N
|
| 72 |
LOC_PREF3_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Location Preference - In States Bordering Mine
Y/N Table Edit
Default Value: N
|
| 73 |
LOC_PREF4_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Location Preference - Beyond States Bordering Mine
Y/N Table Edit
Default Value: N
|
| 74 |
LOC_PREF5_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Location Preference - Outside the U.S.
Y/N Table Edit
Default Value: N
|
| 75 |
LOC_PREF6_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Location Preference - Undecided
Y/N Table Edit
Default Value: N
|
| 76 |
COL_TYPE_PREF1_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT College Type Preference - All Women or All Men
Y/N Table Edit
Default Value: N
|
| 77 |
COL_TYPE_PREF2_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT College Type Preference - Coeducational
Y/N Table Edit
Default Value: N
|
| 78 |
COL_TYPE_PREF3_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT College Type Preference - Undecided
Y/N Table Edit
Default Value: N
|
| 79 |
DEG_GOAL_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Degree Goal
|
| 80 |
CERT_MAJOR_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Certainty of First Choice Major
|
| 81 |
OTH_MAJ2_SAT |
Character(3) |
VARCHAR2(3) NOT NULL |
SAT Other Major 2
|
| 82 |
OTH_MAJ3_SAT |
Character(3) |
VARCHAR2(3) NOT NULL |
SAT Other Major 3
|
| 83 |
OTH_MAJ4_SAT |
Character(3) |
VARCHAR2(3) NOT NULL |
SAT Other Major 4
|
| 84 |
PTJOB_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Part-time Job
|
| 85 |
HOUSING_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Housing Plans
|
| 86 |
BEST_LANG_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Best Language
|
| 87 |
RELIGION_SAT |
Character(2) |
VARCHAR2(2) NOT NULL |
SAT Religion
|
| 88 |
COL_CD1_SAT |
Character(5) |
VARCHAR2(5) NOT NULL |
SAT College Code 1
|
| 89 |
COL_NAME1_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
SAT College Name 1
|
| 90 |
COL_CD2_SAT |
Character(5) |
VARCHAR2(5) NOT NULL |
SAT College Code 2
|
| 91 |
COL_NAME2_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
SAT College Name 2
|
| 92 |
COL_CD3_SAT |
Character(5) |
VARCHAR2(5) NOT NULL |
SAT College Code 3
|
| 93 |
COL_NAME3_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
SAT College Name 3
|
| 94 |
COL_CD4_SAT |
Character(5) |
VARCHAR2(5) NOT NULL |
SAT College Code 4
|
| 95 |
COL_NAME4_SAT |
Character(30) |
VARCHAR2(30) NOT NULL |
SAT College Name 4
|
| 96 |
REC_NUM_SAT |
Character(2) |
VARCHAR2(2) NOT NULL |
SAT Record Number
|
| 97 |
SS_PER_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
SAT Student Search Permission
|
| 98 |
DT_REPORT_SAT |
Character(6) |
VARCHAR2(6) NOT NULL |
SAT Date of Report
|
| 99 |
TEST_SELECT_SAT |
Character(1) |
VARCHAR2(1) NOT NULL |
School Tape Type
C=College Tape
S=Secondary School Tape
Default Value: C
|
| 100 |
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
|
| 101 |
SAD_EMAIL_LD |
Character(70) |
VARCHAR2(70) NOT NULL |
EMail Address
|