SSR_ACM_TREEWKV(SQL View) |
Index Back |
|---|---|
Derived Record Act Block SelDerived Record for Activity Block Selections |
| SELECT ' ' , ' ' , ' ' , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , ' ' , ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 0 , 0 , ' ' , ' ' FROM PS_SSR_DUMMY_REC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_EXPAND_COLLAPS | Character(1) | VARCHAR2(1) NOT NULL | Expand / Collapse |
| 2 | SSR_DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This field is used for holding the 80 character description used in the xml file for post enrollment requisite check reports. |
| 3 | BACK_PB | Character(1) | VARCHAR2(1) NOT NULL | Back |
| 4 | PAGE_NUM | Number(4,0) | SMALLINT NOT NULL | Page # |
| 5 | PAGEID | Character(18) | VARCHAR2(18) NOT NULL | Page ID for discounts and perks category pages. |
| 6 | FORWARD_SW | Character(1) | VARCHAR2(1) NOT NULL | Forward |
| 7 | SSR_ACTIVITY_ID | Character(11) | VARCHAR2(11) NOT NULL | Academic Activity ID |
| 8 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 9 | SESSION_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session 10W=10 Week 12W=Twelve Week 4W1=Four Week - First 4W2=Four Week - Second 4W3=Four Week - Third 4W4=Four Week - Fourth 6W1=Six Week - First 6W2=Six Week - Second 8W1=Eight Week - First 8W2=Eight Week - Second A11=Medical Period 1, 4 Weeks A12=Medical Period 1, 8 Weeks A13=Medical Pd 1, 12 Weeks A21=Medical Period 2, 4 Weeks A22=Medical Period 2, 8 Weeks A23=Medical Period 2, 12 Week FYR=Full Year MIN=Mini Session OEE=Open Entry/Open Exit SM1=Semester 1 SM2=Semester 2 |
| 10 | CLASS_SECTION | Character(4) | VARCHAR2(4) NOT NULL | Class Section |
| 11 | ASSOCIATED_CLASS | Number(4,0) | SMALLINT NOT NULL | Class Association |
| 12 | CLASS_NBR | Number(5,0) | INTEGER NOT NULL | Class Nbr |
| 13 | SSR_CW_REQUIRED | Character(1) | VARCHAR2(1) NOT NULL | Mandatory |
| 14 | SSR_AC_DEFAULT | Character(1) | VARCHAR2(1) NOT NULL | Default Mark |
| 15 | SSR_ACT_ID_ROOT | Character(11) | VARCHAR2(11) NOT NULL | Course Root Activity ID |
| 16 | SSR_ACO_TREE_LVL | Number(3,0) | SMALLINT NOT NULL | Level 1 Row |
| 17 | SSR_SEQ_NBR7 | Number(7,0) | INTEGER NOT NULL | Sequence Number |
| 18 | SSR_CW_XTRA_CR | Character(1) | VARCHAR2(1) NOT NULL | Extra Credit |
| 19 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 20 | SSR_ACM_IND_CONT | Character(1) | VARCHAR2(1) NOT NULL | Individualized Content |
| 21 | SSR_PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Academic Period ID |
| 22 | SSR_SUP_RESIT | Character(1) | VARCHAR2(1) NOT NULL | This field indicates if resits are allowed. |
| 23 | SSR_AC_REQ_COND | Number(3,0) | SMALLINT NOT NULL | Select |
| 24 | SSR_AC_CONNECTOR | Character(1) | VARCHAR2(1) NOT NULL |
Connector
(=Open Parenthesis )=Close Parenthesis A=And O=Or |
| 25 | SSR_CW_CONF_REQ | Character(1) | VARCHAR2(1) NOT NULL | Confirmation Required |
| 26 | SSR_AC_CONTENT_TP | Character(20) | VARCHAR2(20) NOT NULL | Academic Content Type |
| 27 | SSR_AC_ITEM_ID | Character(10) | VARCHAR2(10) NOT NULL | Content Item ID |
| 28 | PAGE_NUM_THRU | Number(4,0) | SMALLINT NOT NULL | Thru Page Number |
| 29 | SSR_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL | Display in Self Service |
| 30 | SSR_IAM_OR_CONNECT | Character(1) | VARCHAR2(1) NOT NULL | OR Connector |
| 31 | SSR_PAGE_NUM_FROM | Number(4,0) | SMALLINT NOT NULL | Page From |
| 32 | SSR_PAGE_SCROLL_TO | Number(4,0) | SMALLINT NOT NULL | Scroll To |
| 33 | SSR_COMPONENT | Character(3) | VARCHAR2(3) NOT NULL |
Course Component.
CLN=Clinical CON=Continuance DIS=Discussion FLD=Field Studies IND=Independent Study LAB=Laboratory LEC=Lecture PRA=Practicum RSC=Research SEM=Seminar SUP=Supervision THE=Thesis Research TUT=Tutorial |
| 34 | SSR_AC_CONTENT_ID | Character(13) | VARCHAR2(13) NOT NULL | Activity Registry ID |
| 35 | SSR_CW_ASMT_CD | Character(4) | VARCHAR2(4) NOT NULL | Content Code |
| 36 | SSR_ACR_SHORT_LBL | Character(8) | VARCHAR2(8) NOT NULL | Content Code |
| 37 | ASSESSED | Character(1) | VARCHAR2(1) NOT NULL | Assessed |
| 38 | SSR_ACTIVTY_ID_PAR | Character(11) | VARCHAR2(11) NOT NULL | Parent Activity ID |
| 39 | SSR_ACT_CLSINFONLY | Character(1) | VARCHAR2(1) NOT NULL | Class Info Only |
| 40 | SSR_GRIDCOLUMN_SEQ | Number(5,0) | INTEGER NOT NULL | Grid Sequence Number |
| 41 | SSR_GRIDCOLUMN_LOC | Number(5,0) | INTEGER NOT NULL | Grid Location |
| 42 | SSR_EXAMPRD_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Exam Period Type
REG=Regular Period RES=Resit Period |
| 43 | SSR_DESCRLONG | Long Character | CLOB | Description |