SSR_CART_CRSE(SQL Table) |
Index Back |
|---|---|
CART Course detailsCART Course details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SSR_SYS_CODE |
Character(4) | VARCHAR2(4) NOT NULL | CART system code |
| 2 | SSR_CART_REQ_ID |
Number(12,0) | DECIMAL(12) NOT NULL | CART request id |
| 3 | SSR_REQUEST_DATE |
Date(10) | DATE NOT NULL | CART REQUEST DATE |
| 4 | SSR_CART_REF_NBR |
Character(9) | VARCHAR2(9) NOT NULL | CART reference nbr |
| 5 | SSR_CART_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | CART Empid |
| 6 | ACAD_PROG |
Character(5) | VARCHAR2(5) NOT NULL | Academic Program |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | COURSE_START_DT | Date(10) | DATE | Course Start Date |
| 9 | COURSE_END_DT | Date(10) | DATE | Course End Date |
| 10 | SAD_ATTEND_MODE | Character(1) | VARCHAR2(1) NOT NULL |
Mode of Attendance
1=Internal Mode of Attendance 2=External Mode of Attendance 3=Multi-modal Mode of Attendance 4=Completed Course through OUA 5=Submission of Original Work 6=Employer based 7=Completed Course except in OUA |
| 11 | SSR_CROSS_INST | Character(3) | VARCHAR2(3) NOT NULL | Cross Institution |
| 12 | SSR_YR_BASED_SUBJ | Character(3) | VARCHAR2(3) NOT NULL | Year Based Subject |
| 13 | SSR_MSTR_PHD | Character(3) | VARCHAR2(3) NOT NULL | Master/PHD |
| 14 | SSR_EFTS_TOT | Number(8,5) | DECIMAL(7,5) NOT NULL | Total EFTSL Value |
| 15 | SSR_ENRL_MTCH_RES | Character(3) | VARCHAR2(3) NOT NULL | Enrolment Match Result |