EMPLIDPrompt Table: PEOPLE_SRCH
TEST_DTPrompt Table: SAD_ADA_CD
CRSE_SESSN_NBRSESSN_STATS_AADSASCOLG_CODE_AADSASTERM_TYPE_AADSASSAD_START_YRSAD_AADSAS_TERMSAD_ADA_CD_CS(SQL Table) |
Index Back |
|---|---|
AADSAS ACI Course SessionThis contains all the course session information. |
| # | 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 | COLG_CODE_AADSAS |
Character(6) | VARCHAR2(6) NOT NULL | College Code |
| 6 | FROM_DT_AADSAS | Character(6) | VARCHAR2(6) NOT NULL | AADSAS Begin Date |
| 7 | TO_DT_AADSAS | Character(6) | VARCHAR2(6) NOT NULL | AADSAS End Date |
| 8 | TERM_TYPE_AADSAS |
Character(10) | VARCHAR2(10) NOT NULL | AADSAS Term Type |
| 9 | COL_NAME_AADSAS | Long Character(255) | VARCHAR2(255) | College Name |
| 10 | SAD_START_YR |
Character(4) | VARCHAR2(4) NOT NULL | AADSAS Start Year |
| 11 | SAD_AADSAS_TERM |
Character(10) | VARCHAR2(10) NOT NULL | AADSAS Term |
| 12 | SAD_CAL_CR_HRS | Character(8) | VARCHAR2(8) NOT NULL | Overall Hours |
| 13 | SAD_CAL_QUAL_PNTS | Character(8) | VARCHAR2(8) NOT NULL | Calculated Quality Points Value - Overall |
| 14 | SAD_CAL_GPA_VAL | Character(5) | VARCHAR2(5) NOT NULL | GPA |
| 15 | SAD_CAL_QL_PNTS_WH | Character(8) | VARCHAR2(8) NOT NULL | Calculated Quality Points Value without +/- - Overall |
| 16 | SAD_CAL_GPA_WHOLE | Character(5) | VARCHAR2(5) NOT NULL | Overall GPA |