SAD_LAW_SUS(SQL Table) |
Index Back |
|---|---|
LSAC Test Suspension TableLSAC_SUSPN contains all records from the LSAT and LSDAS load process. LSAT edit will update fields. Those records which are 'clean' will be processed by the LSAT post program, loaded into the 'live' tables and then removed from the suspense table. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TEST_ID |
Character(11) | VARCHAR2(11) NOT NULL | Test ID |
| 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 | LAW_SCH_CD_LSAC | Character(4) | VARCHAR2(4) NOT NULL | LSAC Law School Code |
| 5 | TRANS_DT_LSAC | Character(10) | VARCHAR2(10) NOT NULL | LSAC Date Of Transmission |
| 6 | TIME_STMP_LSAC | Character(6) | VARCHAR2(6) NOT NULL | LSAC Time Stamp |
| 7 | SAD_SSN_LD | Character(9) | VARCHAR2(9) NOT NULL | Admissions Test Load SSN |
| 8 | SSN | Character(9) | VARCHAR2(9) NOT NULL | Social Security # |
| 9 | SAD_LAST_NAME_LD | Character(32) | VARCHAR2(32) NOT NULL | Admissions Last Name from Test Load |
| 10 | SAD_FIRST_NAME_LD | Character(30) | VARCHAR2(30) NOT NULL | Admissions First Name from Test Load |
| 11 | SAD_MID_INIT_LD | Character(1) | VARCHAR2(1) NOT NULL | Admissions Middle Initial from Test Load |
| 12 | NAME_PREFIX | Character(4) | VARCHAR2(4) NOT NULL |
Name Prefix
Prompt Table: NAME_PREFIX_TBL |
| 13 | PREV_LST_NAME_LSAC | Character(25) | VARCHAR2(25) NOT NULL | LSAC Previous Last Name |
| 14 | LAW_SCH_SSN_LSAC | Character(9) | VARCHAR2(9) NOT NULL | LSAC Law School SSN |
| 15 | LAW_LST_NM_LSAC | Character(25) | VARCHAR2(25) NOT NULL | LSAC Law School Last Name |
| 16 | LAW_FRST_NM_LSAC | Character(15) | VARCHAR2(15) NOT NULL | LSAC Law School First Name |
| 17 | LAW_MI_LSAC | Character(1) | VARCHAR2(1) NOT NULL | LSAC Law School Middle Initial |
| 18 | LSDAS_TRACKING_NBR | Character(15) | VARCHAR2(15) NOT NULL | Law School Tracking Number |
| 19 | SAD_BIRTHDATE_LD | Character(10) | VARCHAR2(10) NOT NULL | Admissions Birthdate from Test Load |
| 20 | BIRTHDATE | Date(10) | DATE | Date of Birth |
| 21 | AGE_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC Age |
| 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_ETHNICITY_LD | Character(2) | VARCHAR2(2) NOT NULL | Ethnicity |
| 25 | ETHNIC_GRP_CD | Character(8) | VARCHAR2(8) NOT NULL |
Ethnic group code
Prompt Table:
ETHNIC_GRP_TBL
|
| 26 | SAD_ADDRESS1_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 27 | SAD_ADDRESS2_LD | Character(55) | VARCHAR2(55) NOT NULL | Address 2 |
| 28 | SAD_CITY_LD | Character(40) | VARCHAR2(40) NOT NULL | Test Load City |
| 29 | SAD_STATE_LD | Character(60) | VARCHAR2(60) NOT NULL | Test Load State |
| 30 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_NAMES_TBL |
| 31 | FOR_ADD_LSAC | Character(40) | VARCHAR2(40) NOT NULL | LSAC Foreign Address |
| 32 | SAD_POSTAL_LD | Character(15) | VARCHAR2(15) NOT NULL | Test Load Postal Code |
| 33 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 34 | ST_PERM_RES_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC State of Permanent Residence |
| 35 | FUT_TST_DT_LSAC | Character(10) | VARCHAR2(10) NOT NULL | LSAC Future Test Date |
| 36 | VAL_3SCORE_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC Number of Valid 3-digit Scores |
| 37 | AVG3_SCORE_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS Average 3-digit Score |
| 38 | LSDAS_UPPER_BAND | Number(3,0) | SMALLINT NOT NULL | LSDAS Upper Band |
| 39 | LSDAS_LOWER_BAND | Number(3,0) | SMALLINT NOT NULL | LSDAS Lower Band |
| 40 | VAL_2SCORE_LSAC | Character(2) | VARCHAR2(2) NOT NULL | LSAC Number of Valid 2-digit Scores |
| 41 | AVG2_SCORE_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS Average 2-digit Score |
| 42 | DT_COMP_LSAC | Character(10) | VARCHAR2(10) NOT NULL | LSAC Date File Completed |
| 43 | SCORE_UPDT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Score Update
Y/N Table Edit Default Value: N |
| 44 | MIS_UPDT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Misconduct Update
Y/N Table Edit Default Value: N |
| 45 | PRIOR_UPDT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Prior Matriculation Update
Y/N Table Edit Default Value: N |
| 46 | MISCONDUCT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAC Misconduct Flag
Y/N Table Edit Default Value: N |
| 47 | LSDAS_TERM_CODE | Character(15) | VARCHAR2(15) NOT NULL | Term Code |
| 48 | TERM_YEAR | Number(4,0) | SMALLINT NOT NULL | Term Year |
| 49 | APP_STATUS_LSAC | Character(1) | VARCHAR2(1) NOT NULL | LSAC Applicant Status |
| 50 | SAD_EMAIL_LD | Character(70) | VARCHAR2(70) NOT NULL | EMail Address |
| 51 | SAD_LSAC_ACCT_NBR | Character(9) | VARCHAR2(9) NOT NULL | LSAC Account Number |
| 52 | ORG_ID_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Organization ID |
| 53 | ORG_NAME_LSDAS | Character(40) | VARCHAR2(40) NOT NULL | Organization Name |
| 54 | DEGREE_LSDAS | Character(1) | VARCHAR2(1) NOT NULL | LSDAS Degree |
| 55 | DEGREE_DT_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSAC Degree Date |
| 56 | SUBJ_AREA1_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS First Major |
| 57 | SUBJ_AREA2_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDAS Subject Area 2 |
| 58 | NO_OF_CREDITS_A | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of A |
| 59 | NO_OF_CREDITS_B | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits B |
| 60 | NO_OF_CREDITS_C | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of C |
| 61 | NO_OF_CREDITS_D | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of D |
| 62 | NO_OF_CREDITS_F | Character(5) | VARCHAR2(5) NOT NULL | LSDASTotal Credits of F |
| 63 | NO_OF_UNCNVR_CRDTS | Character(5) | VARCHAR2(5) NOT NULL | Number of Unconverted Credits |
| 64 | TOTAL_CRDTS_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total All Credits |
| 65 | CUMLT_CRDTS_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Cumulative Credits |
| 66 | CUMLT_ACROSS_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Cumulative Across GPA |
| 67 | SUMMARY_CRDT_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Summary Credits |
| 68 | DEGREE_GPA_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Degree GPA |
| 69 | NON_PUN_CR_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Non-Punitive Credits (Total) |
| 70 | PER_LSAT_LSDAS | Character(34) | VARCHAR2(34) NOT NULL | LSDAS % of Distribution of LSAT |
| 71 | PER_GPA_LSDAS | Character(28) | VARCHAR2(28) NOT NULL | LSDAS % of Distribution of GPA |
| 72 | AVG3_IND_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSDAS Average 3-digit Index |
| 73 | AVG2_IND_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSDAS Average 2-digit Index |
| 74 | TRANS_UPDT_LSDAS | Character(1) | VARCHAR2(1) NOT NULL |
LSDAS Transcript Update
Y/N Table Edit Default Value: N |
| 75 | LSDAS_LOR | Character(1) | VARCHAR2(1) NOT NULL | Recommendations on File |
| 76 | LSDAS_LOR_UNASSGND | Character(1) | VARCHAR2(1) NOT NULL | Unsigned Recommendations |
| 77 | REP_TYPE_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Report Type |
| 78 | FOREIGN_EDUCATED | Character(1) | VARCHAR2(1) NOT NULL | Foreign Educated |
| 79 | SAD_LAW_LOR_UPDATE | Character(1) | VARCHAR2(1) NOT NULL | LSDAS Letter of Recommendation Update |
| 80 | SAD_TEST_DT_LD | Character(10) | VARCHAR2(10) NOT NULL | Test Load Test Date |
| 81 | TEST_SELECT_LSAC | Character(1) | VARCHAR2(1) NOT NULL |
LSAT/LSDAS Test Score
L=LSAT Test Score S=LSDAS Test Score |
| 82 | TRANSACTN_CD_LSAC | Character(1) | VARCHAR2(1) NOT NULL | Transaction Code LSAC |