EMPLIDPrompt Table: PEOPLE_SRCH
TEST_DTPrompt Table: SAD_ADA_CD
CRSE_SESSN_NBRSESSN_STATS_AADSASCRSE_NBRCOLG_CODE_AADSASSAD_ADA_CD_REC_NBRSAD_AADSAS_TERMTERM_TYPE_AADSASSAD_START_YRSAD_ADA_CD_CD(SQL Table) |
Index Back |
|---|---|
AADSAS ACI Course DetailThis contains all the course work detail information from the different sessions. |
| # | 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_ADA_CD |
| 3 | CRSE_SESSN_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Number |
| 4 | SESSN_STATS_AADSAS |
Character(30) | VARCHAR2(30) NOT NULL | AADSAS Session Status |
| 5 | CRSE_NBR |
Number(2,0) | SMALLINT NOT NULL | Course Number |
| 6 | CRSE_CODE_AADSAS | Character(4) | VARCHAR2(4) NOT NULL | AADSAS Course Code |
| 7 | CRSE_TYPE_AADSAS | Character(1) | VARCHAR2(1) NOT NULL | AADSAS Course Type |
| 8 | CRSE_GPA_AADSAS | Character(2) | VARCHAR2(2) NOT NULL | AADSAS GPA |
| 9 | CRSE_HRS_AADSAS | Character(3) | VARCHAR2(3) NOT NULL | AADSAS Hours |
| 10 | COLG_CODE_AADSAS |
Character(6) | VARCHAR2(6) NOT NULL | College Code |
| 11 | SAD_ADA_CD_REC_NBR |
Character(7) | VARCHAR2(7) NOT NULL | AADSAS Course Record Number |
| 12 | COL_NAME_AADSAS | Long Character(255) | VARCHAR2(255) | College Name |
| 13 | SAD_AADSAS_TERM |
Character(10) | VARCHAR2(10) NOT NULL | AADSAS Term |
| 14 | TERM_TYPE_AADSAS |
Character(10) | VARCHAR2(10) NOT NULL | AADSAS Term Type |
| 15 | SAD_START_YR |
Character(4) | VARCHAR2(4) NOT NULL | AADSAS Start Year |
| 16 | SAD_CRS_TITLE | Character(40) | VARCHAR2(40) NOT NULL | AADSAS Course Title |
| 17 | SAD_CRS_PREFIX_NBR | Character(25) | VARCHAR2(25) NOT NULL | AADSAS Prefix |
| 18 | SAD_CRS_LVL_ABR | Character(5) | VARCHAR2(5) NOT NULL | AADSAS Course Level |
| 19 | SAD_CRS_LVL | Character(30) | VARCHAR2(30) NOT NULL | AADSAS Course Level |
| 20 | SAD_CRS_GPA | Character(6) | VARCHAR2(6) NOT NULL | AADSAS Course GPA |
| 21 | SAD_AADSAS_CONV_GP | Character(4) | VARCHAR2(4) NOT NULL | AADSAS Grade |
| 22 | SAD_AADSAS_GRD_WGT | Character(3) | VARCHAR2(3) NOT NULL | AADSAS Grade Weightage |
| 23 | SAD_CREDIT_HRS | Character(5) | VARCHAR2(5) NOT NULL | AADSAS Credit Hours |
| 24 | SAD_VERIFY_GRD | Character(4) | VARCHAR2(4) NOT NULL | AADSAS Grade Verify |
| 25 | SAD_VERIFY_CREDIT | Character(3) | VARCHAR2(3) NOT NULL | AADSAS Credit Verify |
| 26 | SAD_CRS_SUB_CODE | Character(3) | VARCHAR2(3) NOT NULL | AADSAS Subject Code |
| 27 | SAD_CRS_SUB_DESCR | Character(30) | VARCHAR2(30) NOT NULL | AADSAS Subject Description |
| 28 | SAD_SPEC_CLASS_CD | Character(2) | VARCHAR2(2) NOT NULL | AADSAS Spec Class |
| 29 | SAD_SPEC_CLASS_NAM | Character(50) | VARCHAR2(50) NOT NULL | AADSAS Spec Class Name |
| 30 | SAD_AADSAS_AUDIT | Character(3) | VARCHAR2(3) NOT NULL | AADSAS Audit Status |