EMPLIDPrompt Table: PEOPLE_SRCH
TEST_DTN=No Personal Data Impact
U=Caused Personal Data Update
Y=Caused Personal Data Creation
Default Value: N
SAD_CRS_CD(SQL Table) |
Index Back |
|---|---|
CRS ACI TableCRS_ACI contains bio/demo and additional data stored from the search tape. |
| # | 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 | 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 |
| 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 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 8 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 9 | SAD_ADDRESS3_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 3 |
| 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 | SAD_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 15 | SAD_SEX_LD | Character(1) | VARCHAR2(1) NOT NULL | Test Load Gender |
| 16 | PERM_STATE_CRS | Character(2) | VARCHAR2(2) NOT NULL | CRS Permanent State |
| 17 | SAD_SSN_LD | Character(9) | VARCHAR2(9) NOT NULL | Admissions Test Load SSN |
| 18 | US_CITIZEN_CRS | Character(1) | VARCHAR2(1) NOT NULL | US Citizen/Resident Alien |
| 19 | CAN_CITIZEN_CRS | Character(1) | VARCHAR2(1) NOT NULL | Canada Citizen/Landed Immgrant |
| 20 | UNDGRD_DEG_CD_CRS | Character(4) | VARCHAR2(4) NOT NULL | Undergraduate Information |
| 21 | UNDGRD_DEG_DT_CRS | Character(6) | VARCHAR2(6) NOT NULL | Undergraduate Degree Date |
| 22 | UNDGRD_SCH_ST_CRS | Character(2) | VARCHAR2(2) NOT NULL | School State (Numeric) |
| 23 | CMPLT_FLAG_CRS | Character(1) | VARCHAR2(1) NOT NULL | Complete Flag |
| 24 | AVG_LSAT_SCORE_CRS | Character(3) | VARCHAR2(3) NOT NULL | Average LSAT Score |
| 25 | VLD_LSAT_SCRS_CRS | Character(2) | VARCHAR2(2) NOT NULL | Number of Valid LSAT Scores |
| 26 | ACCO_TST_FLAG_CRS | Character(1) | VARCHAR2(1) NOT NULL | Accommodated Test Flag |
| 27 | DT_UPCMNG_LSAT_CRS | Character(6) | VARCHAR2(6) NOT NULL | Date of Upcoming LSAT |
| 28 | LSDAS_GPA_CRS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS GPA |
| 29 | SELF_RPRTD_GPA_CRS | Character(1) | VARCHAR2(1) NOT NULL | Self-Reported GPA |
| 30 | LAW_SCHL_CD_CRS | Character(4) | VARCHAR2(4) NOT NULL | Law School Code |
| 31 | RQUEST_RUN_NBR_CRS | Character(3) | VARCHAR2(3) NOT NULL | CRS Request Nbr Within the Run |
| 32 | RUN_NBR_CRS | Character(5) | VARCHAR2(5) NOT NULL | CRS Run Number |
| 33 | SAD_TELEPHONE_LD | Character(20) | VARCHAR2(20) NOT NULL | Telephone Number |
| 34 | SAD_ETHNICITY_LD | Character(2) | VARCHAR2(2) NOT NULL | Ethnicity |
| 35 | DEGREE_DT | Date(10) | DATE | Admissions degree date. |
| 36 | SAD_CRS_PERM_ST | Character(2) | VARCHAR2(2) NOT NULL | CRS Permanent State or Province |
| 37 | SAD_CRS_UGRD_ST | Character(2) | VARCHAR2(2) NOT NULL | CRS Udergraduate School State |
| 38 | SAD_CRS_MSTR_ID | Character(10) | VARCHAR2(10) NOT NULL | CRS Master ID for this request |
| 39 | SAD_CRS_RUN_DT | Character(8) | VARCHAR2(8) NOT NULL | CRS Run Date |
| 40 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 41 | SAD_CRS_CIT_FLG | Character(1) | VARCHAR2(1) NOT NULL | Citizen of country other than US or Canada |
| 42 | SAD_CRS_EMP_STS | Character(1) | VARCHAR2(1) NOT NULL | CRS Current Employment |
| 43 | SAD_CRS_EMP_YRS | Character(1) | VARCHAR2(1) NOT NULL | CRS Years of Full-time Employment |
| 44 | SAD_CRS_MIL_SVC | Character(1) | VARCHAR2(1) NOT NULL | CRS Military Service |
| 45 | SAD_CRS_CLS_RNK | Character(1) | VARCHAR2(1) NOT NULL | Class Rank |
| 46 | SAD_CRS_DEG_HI | Character(1) | VARCHAR2(1) NOT NULL | CRS Highest Degree Earned |
| 47 | SAD_CRS_PGM_TIM | Character(1) | VARCHAR2(1) NOT NULL | CRS Program Time |
| 48 | SAD_CRS_GEO_CHS | Character(1) | VARCHAR2(1) NOT NULL | CRS Geographic Characteristics |
| 49 | SAD_CRS_REL_AFF | Character(1) | VARCHAR2(1) NOT NULL | CRS Religious Affiliation |
| 50 | SAD_CRS_GLBT_ST | Character(1) | VARCHAR2(1) NOT NULL | GLBT Status |
| 51 | SAD_CRS_CRSEWRK1 | Character(2) | VARCHAR2(2) NOT NULL | Coursework 1 |
| 52 | SAD_CRS_CRSEWRK2 | Character(2) | VARCHAR2(2) NOT NULL | CRS Coursework 2 |
| 53 | SAD_CRS_ENR_YR | Character(2) | VARCHAR2(2) NOT NULL | CRS Expected enrollment year |
| 54 | SAD_CRS_REG_NBR | Character(5) | VARCHAR2(5) NOT NULL | CRS Forum Registration Number |
| 55 | SAD_LSAC_ACCT_NBR | Character(9) | VARCHAR2(9) NOT NULL | LSAC Account Number |