EMPLIDPrompt Table: PEOPLE_SRCH
TEST_DTN=No Personal Data Impact
U=Caused Personal Data Update
Y=Caused Personal Data Creation
Y/N Table Edit
Default Value: N
0=No Response
1=Male
2=Female
CRS_ACI(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 Y/N Table Edit Default Value: N |
| 4 | LAST_NAME_CRS | Character(25) | VARCHAR2(25) NOT NULL | Last Name |
| 5 | FIRST_NAME_CRS | Character(15) | VARCHAR2(15) NOT NULL | First Name |
| 6 | MIDDLE_INIT_CRS | Character(1) | VARCHAR2(1) NOT NULL | Middle Initial |
| 7 | ADDRESS1_CRS | Character(40) | VARCHAR2(40) NOT NULL | CRS Address Line 1 |
| 8 | ADDRESS2_CRS | Character(40) | VARCHAR2(40) NOT NULL | CRS Address Line 2 |
| 9 | ADDRESS3_CRS | Character(40) | VARCHAR2(40) NOT NULL | CRS Address line 3 |
| 10 | CITY_CRS | Character(20) | VARCHAR2(20) NOT NULL | CRS City |
| 11 | STATE_CRS | Character(2) | VARCHAR2(2) NOT NULL | CRS State |
| 12 | POSTAL_CRS | Character(9) | VARCHAR2(9) NOT NULL | CRS Postal Code |
| 13 | COUNTRY_CRS | Character(20) | VARCHAR2(20) NOT NULL | CRS Country |
| 14 | BIRTHDATE_CRS | Character(8) | VARCHAR2(8) NOT NULL | CRS Birthdate |
| 15 | SEX_CRS | Character(1) | VARCHAR2(1) NOT NULL |
CRS Gender
0=No Response 1=Male 2=Female |
| 16 | PERM_STATE_CRS | Character(2) | VARCHAR2(2) NOT NULL | CRS Permanent State |
| 17 | SSN_CRS | Character(9) | VARCHAR2(9) NOT NULL | CRS 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 | RCNT_LSAT_DT_CRS | Character(8) | VARCHAR2(8) NOT NULL | CRS Most Recent LSAT Test Dt |
| 25 | AVG_LSAT_SCORE_CRS | Character(3) | VARCHAR2(3) NOT NULL | Average LSAT Score |
| 26 | VLD_LSAT_SCRS_CRS | Character(2) | VARCHAR2(2) NOT NULL | Number of Valid LSAT Scores |
| 27 | ACCO_TST_FLAG_CRS | Character(1) | VARCHAR2(1) NOT NULL | Accommodated Test Flag |
| 28 | DT_UPCMNG_LSAT_CRS | Character(6) | VARCHAR2(6) NOT NULL | Date of Upcoming LSAT |
| 29 | LSDAS_GPA_CRS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS GPA |
| 30 | SELF_RPRTD_GPA_CRS | Character(1) | VARCHAR2(1) NOT NULL | Self-Reported GPA |
| 31 | LAW_SCHL_CD_CRS | Character(4) | VARCHAR2(4) NOT NULL | Law School Code |
| 32 | RQUEST_RUN_NBR_CRS | Character(3) | VARCHAR2(3) NOT NULL | CRS Request Nbr Within the Run |
| 33 | RUN_NBR_CRS | Character(5) | VARCHAR2(5) NOT NULL | CRS Run Number |
| 34 | TELEPHONE_CRS | Character(12) | VARCHAR2(12) NOT NULL | CRS Telephone Number |