SAD_LAW_CD(SQL Table) |
Index Back |
|---|---|
LSAC Test Suspension TableLSAC_ACI contains all records from the LSAT/LSDAS load process which were loaded into LSAC_SUSPN. This is a 'live' table containing the Bio/Demo and Additional Candidate Info data. |
| # | 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_TEST_DT_LD | Character(10) | VARCHAR2(10) NOT NULL | Test Load Test Date |
| 4 | TEST_SELECT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAT/LSDAS Test Score
L=LSAT Test Score S=LSDAS Test Score |
| 5 | SAD_LAST_NAME_LD | Character(32) | VARCHAR2(32) NOT NULL | Admissions Last Name from Test Load |
| 6 | SAD_FIRST_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Admissions First Name from Test Load |
| 7 | SAD_MID_INIT_LD | Character(1) | VARCHAR2(1) NOT NULL | Admissions Middle Initial from Test Load |
| 8 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 9 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 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_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 14 | SAD_SEX_LD | Character(1) | VARCHAR2(1) NOT NULL | Test Load Gender |
| 15 | SAD_SSN_LD | Character(9) | VARCHAR2(9) NOT NULL | Admissions Test Load SSN |
| 16 | SAD_ETHNICITY_LD | Character(2) | VARCHAR2(2) NOT NULL | Ethnicity |
| 17 | MISCONDUCT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Misconduct Flag
Y/N Table Edit Default Value: N |
| 18 | ADM_APPL_RUN | Character(1) | VARCHAR2(1) NOT NULL |
Posting Application Option
D=Duplicate Application N=Select For Applicatn Creation X=Do Not Use for Appl Creation Y=Created Application Default Value: N |
| 19 | ADM_APPL_NBR | Character(8) | VARCHAR2(8) NOT NULL | Application Nbr |
| 20 | ADM_APPL_DATE_RUN | Date(10) | DATE | Used as: - Run Date - Loaded Date - Effective Date |
| 21 | ORG_ID_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Organization ID |
| 22 | ORG_NAME_LSDAS | Character(40) | VARCHAR2(40) NOT NULL | Organization Name |
| 23 | DEGREE_LSDAS | Character(1) | VARCHAR2(1) NOT NULL | LSDAS Degree |
| 24 | DEGREE_DT_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSAC Degree Date |
| 25 | SUBJ_AREA1_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS First Major |
| 26 | SUBJ_AREA2_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS Subject Area 2 |
| 27 | NO_OF_CREDITS_A | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of A |
| 28 | NO_OF_CREDITS_B | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits B |
| 29 | NO_OF_CREDITS_C | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of C |
| 30 | NO_OF_CREDITS_D | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of D |
| 31 | NO_OF_CREDITS_F | Character(5) | VARCHAR2(5) NOT NULL | LSDASTotal Credits of F |
| 32 | NO_OF_UNCNVR_CRDTS | Character(5) | VARCHAR2(5) NOT NULL | Number of Unconverted Credits |
| 33 | TOTAL_CRDTS_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total All Credits |
| 34 | CUMLT_CRDTS_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Cumulative Credits |
| 35 | CUMLT_ACROSS_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Cumulative Across GPA |
| 36 | SUMMARY_CRDT_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Summary Credits |
| 37 | DEGREE_GPA_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Degree GPA |
| 38 | AVG3_SCORE_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS Average 3-digit Score |
| 39 | AVG3_IND_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSDAS Average 3-digit Index |
| 40 | AVG2_SCORE_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS Average 2-digit Score |
| 41 | AVG2_IND_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSDAS Average 2-digit Index |
| 42 | ACCREDITED_LSDAS | Character(1) | VARCHAR2(1) NOT NULL | LSDAS Undergrad Accredited |
| 43 | LSDAS_UPPER_BAND | Number(3,0) | SMALLINT NOT NULL | LSDAS Upper Band |
| 44 | LSDAS_LOWER_BAND | Number(3,0) | SMALLINT NOT NULL | LSDAS Lower Band |
| 45 | LSDAS_LOR | Character(1) | VARCHAR2(1) NOT NULL | Recommendations on File |
| 46 | LSDAS_LOR_UNASSGND | Character(1) | VARCHAR2(1) NOT NULL | Unsigned Recommendations |
| 47 | LSDAS_TRACKING_NBR | Character(15) | VARCHAR2(15) NOT NULL | Law School Tracking Number |
| 48 | FOREIGN_EDUCATED | Character(1) | VARCHAR2(1) NOT NULL | Foreign Educated |
| 49 | LSDAS_TERM_CODE | Character(15) | VARCHAR2(15) NOT NULL | Term Code |
| 50 | TERM_YEAR | Number(4,0) | SMALLINT NOT NULL | Term Year |
| 51 | NON_PUN_CR_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Non-Punitive Credits (Total) |
| 52 | VAL_3SCORE_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC Number of Valid 3-digit Scores |
| 53 | VAL_2SCORE_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC Number of Valid 2-digit Scores |
| 54 | LAW_SCH_CD_LSAC | Character(4) | VARCHAR2(4) NOT NULL | LSAC Law School Code |
| 55 | TRANS_DT_LSAC | Character(10) | VARCHAR2(10) NOT NULL | LSAC Date Of Transmission |
| 56 | TIME_STMP_LSAC | Character(6) | VARCHAR2(6) NOT NULL | LSAC Time Stamp |
| 57 | DT_COMP_LSAC | Character(10) | VARCHAR2(10) NOT NULL | LSAC Date File Completed |
| 58 | SCORE_UPDT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Score Update
Y/N Table Edit Default Value: N |
| 59 | TRANS_UPDT_LSDAS | Character(1) | VARCHAR2(1) NOT NULL |
LSDAS Transcript Update
Y/N Table Edit Default Value: N |
| 60 | MIS_UPDT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Misconduct Update
Y/N Table Edit Default Value: N |
| 61 | PRIOR_UPDT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Prior Matriculation Update
Y/N Table Edit Default Value: N |
| 62 | APP_STATUS_LSAC | Character(1) | VARCHAR2(1) NOT NULL | LSAC Applicant Status |
| 63 | PER_LSAT_LSDAS | Character(34) | VARCHAR2(34) NOT NULL | LSDAS % of Distribution of LSAT |
| 64 | PER_GPA_LSDAS | Character(28) | VARCHAR2(28) NOT NULL | LSDAS % of Distribution of GPA |
| 65 | FUT_TST_DT_LSAC | Character(10) | VARCHAR2(10) NOT NULL | LSAC Future Test Date |
| 66 | REP_TYPE_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Report Type |
| 67 | PREV_LST_NAME_LSAC | Character(25) | VARCHAR2(25) NOT NULL | LSAC Previous Last Name |
| 68 | LAW_SCH_SSN_LSAC | Character(9) | VARCHAR2(9) NOT NULL | LSAC Law School SSN |
| 69 | LAW_LST_NM_LSAC | Character(25) | VARCHAR2(25) NOT NULL | LSAC Law School Last Name |
| 70 | LAW_FRST_NM_LSAC | Character(15) | VARCHAR2(15) NOT NULL | LSAC Law School First Name |
| 71 | LAW_MI_LSAC | Character(1) | VARCHAR2(1) NOT NULL | LSAC Law School Middle Initial |
| 72 | AGE_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC Age |
| 73 | FOR_ADD_LSAC | Character(40) | VARCHAR2(40) NOT NULL | LSAC Foreign Address |
| 74 | ST_PERM_RES_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC State of Permanent Residence |
| 75 | 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 |
| 76 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 77 | SAD_LSAC_ACCT_NBR | Character(9) | VARCHAR2(9) NOT NULL | LSAC Account Number |