OUAC_J1_K1_EC(SQL Table) |
Index Back |
|---|---|
OUAC LSAT SummarySACE98-A NEW - OUACJ1/K1 Transactions SACE98-D MOD - Added Prompt to Ethnicity LSAC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ECTRANSID |
Character(15) | VARCHAR2(15) NOT NULL | Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders) |
| 2 | ECQUEUEINSTANCE |
Number(9,0) | DECIMAL(9) NOT NULL | Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. |
| 3 | ECTRANSINOUTSW |
Character(1) | VARCHAR2(1) NOT NULL |
Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound O=Outbound |
| 4 | OUAC_TRAN_ID |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Transaction Identifier |
| 5 | OUAC_REF_NBR |
Character(11) | VARCHAR2(11) NOT NULL | OUAC Reference Number |
| 6 | OUAC_DIST_NBR |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Distribution Number |
| 7 | OUAC_APPL_NBR |
Character(2) | VARCHAR2(2) NOT NULL | OUAC Application Number |
| 8 | OUAC_RPT_LSAT_CODE | Character(9) | VARCHAR2(9) NOT NULL | Applicant Reported LSAT Code |
| 9 | OUAC_RPT_LSAT_SCOR | Number(3,0) | SMALLINT NOT NULL | Applicant Reported LSAT Score |
| 10 | OUAC_RPT_LSAT_DATE | Character(6) | VARCHAR2(6) NOT NULL | Applicant Reported Test Date |
| 11 | OUAC_PLAN_LSAT | Character(1) | VARCHAR2(1) NOT NULL | Plan to Write LSAT |
| 12 | OUAC_LSAT_FUTURE1 | Character(1) | VARCHAR2(1) NOT NULL | LSAT Future Test 1 |
| 13 | OUAC_LSAT_FUTURE2 | Character(1) | VARCHAR2(1) NOT NULL | LSAT Future Test 2 |
| 14 | OUAC_LSAT_FUTURE3 | Character(1) | VARCHAR2(1) NOT NULL | LSAT Future Test 3 |
| 15 | OUAC_ACT_LSAT_CODE | Character(9) | VARCHAR2(9) NOT NULL | LSAT Actual Access Code |
| 16 | ETHNICITY_LSAC | Character(2) | VARCHAR2(2) NOT NULL |
LAW Ethnicity
00=Not Authourized to Release 01=American Indian/Alaskan Native 02=Black/Afro-American 03=White Caucasian 04=Chicano-Mexican Ameican 05=Hispanic 06=Oriental/Asian American 07=Puerto Rican 08=Other 09=Canadian Aboriginal 99=Not Reported |
| 17 | MISCONDUCT_LSAC | Character(1) | VARCHAR2(1) NOT NULL | LSAC Misconduct Flag |
| 18 | OUAC_LSAT_TRAN_FLG | Character(1) | VARCHAR2(1) NOT NULL | OUAC LSAT Transaction Flag |
| 19 | OUAC_LSAT_AVG_SCOR | Number(3,0) | SMALLINT NOT NULL | LSAT Average Score |
| 20 | OUAC_LSAT_HIGH_SCR | Number(3,0) | SMALLINT NOT NULL | LSAT Highest Score |
| 21 | OUAC_LSAT_NBR_WRIT | Number(2,0) | SMALLINT NOT NULL | LSAT Number Times Written |
| 22 | OUAC_POS_92_95 | Character(4) | VARCHAR2(4) NOT NULL | OUAC Transaction Pos. 92-95 |
| 23 | OUAC_LSAT_BAND_UPR | Character(3) | VARCHAR2(3) NOT NULL | LSAT Score Band - Upper |
| 24 | OUAC_LSAT_BAND_LOW | Character(3) | VARCHAR2(3) NOT NULL | LSAT Score Band - Lower |
| 25 | TEST_DT | Date(10) | DATE | Test Date |
| 26 | DATE_LOADED | Date(10) | DATE | Date Loaded |