EMPLIDPrompt Table: PEOPLE_SRCH
TEST_DTPrompt Table: SAD_LAW_CD
SCHL_PERD_NBRSAD_LAW_CD_SCH(SQL Table) |
Index Back |
|---|---|
LSDAS School Inf FileThis contains all the school information from prior years before entering the law school and is loaded into this 'live' table. |
| # | 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
Prompt Table: SAD_LAW_CD |
| 3 | SCHL_PERD_NBR |
Number(2,0) | SMALLINT NOT NULL | School Attended Nbr |
| 4 | FROM_DT_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS From Year |
| 5 | TO_DT_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS To Year |
| 6 | ED_LEVEL_LSDAS | Character(1) | VARCHAR2(1) NOT NULL | LSDAS Education Level |
| 7 | GRADING_LVL_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Grading Level |
| 8 | SCHOOL_ABRV_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSDAS School Abbreviation |
| 9 | ORG_ID_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Organization ID |
| 10 | LCM_LSDAS | Character(3) | VARCHAR2(3) NOT NULL | LSDASUnacknowledged Transcript |
| 11 | NO_OF_CAND_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Number of Candidates |
| 12 | UNIT_TYPE_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Number of Semester Hours |
| 13 | GPA_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Grade Point Avg |
| 14 | CUMLT_GPA_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Cumulative GPA/College |
| 15 | CUMLT_PERC_LSDAS | Character(2) | VARCHAR2(2) NOT NULL | LSDAS Cumulative GPA Percentile Rank |
| 16 | GCM_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Unacknowledged Transcipt |
| 17 | ADJ_CMLT_GPA_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Adjusted Cumulative GPA |
| 18 | CUMLT_ACROSS_LSDAS | Character(4) | VARCHAR2(4) NOT NULL | LSDAS Cumulative Across GPA |
| 19 | NO_OF_CREDITS_A | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of A |
| 20 | NO_OF_CREDITS_B | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits B |
| 21 | NO_OF_CREDITS_C | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of C |
| 22 | NO_OF_CREDITS_D | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total Credits of D |
| 23 | NO_OF_CREDITS_F | Character(5) | VARCHAR2(5) NOT NULL | LSDASTotal Credits of F |
| 24 | NO_OF_UNCNVR_CRDTS | Character(5) | VARCHAR2(5) NOT NULL | Number of Unconverted Credits |
| 25 | TOTAL_CRDTS_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Total All Credits |
| 26 | DEGREE_DT_LSDAS | Character(7) | VARCHAR2(7) NOT NULL | LSAC Degree Date |
| 27 | DEGREE_LSDAS | Character(1) | VARCHAR2(1) NOT NULL | LSDAS Degree |
| 28 | NOTE_CODE1_LSDAS | Character(2) | VARCHAR2(2) NOT NULL | LSDAS Note Code 1 |
| 29 | NOTE_CODE2_LSDAS | Character(2) | VARCHAR2(2) NOT NULL | LSDAS Note Code 2 |
| 30 | CLASS_RANK_LSDAS | Character(9) | VARCHAR2(9) NOT NULL | LSDAS Class Rank |
| 31 | NON_PUN_HRS_LSDAS | Character(5) | VARCHAR2(5) NOT NULL | LSDAS Non-Punitive Semester Hours |