SSR_BC_GEN_OPTS(SQL Table) |
Index Back |
---|---|
Browse Catalog General OptionsBrowse Catalog General Options |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SSR_RV_SFF_MAXCRS | Number(5,0) | INTEGER NOT NULL | Maximum Courses to Display |
2 | SSR_RV_NSFF_MAXCRS | Number(5,0) | INTEGER NOT NULL | Maximum Courses to Display |
3 | SSR_FV_SFF_MAXCRS | Number(5,0) | INTEGER NOT NULL | Maximum Courses to Display |
4 | SSR_FV_NSFF_MAXCRS | Number(5,0) | INTEGER NOT NULL | Maximum Courses to Display |
5 | SSR_CLSCFG_ATTRVAL | Character(1) | VARCHAR2(1) NOT NULL |
Course Attribute Value
Y/N Table Edit Default Value: Y |
6 | SSR_CLSCFG_TOPIC | Character(1) | VARCHAR2(1) NOT NULL |
Course Topic
Y/N Table Edit Default Value: Y |
7 | SSR_CS_TRKENRLCHG | Character(1) | VARCHAR2(1) NOT NULL |
track enrollment changes to course / class
Y/N Table Edit Default Value: Y |
8 | SSR_CS_TRKADMNCHG | Character(1) | VARCHAR2(1) NOT NULL |
track administrative changes to course / class
Y/N Table Edit Default Value: Y |
9 | SSR_CS_DEFLT_OPEN | Character(1) | VARCHAR2(1) NOT NULL |
Default to Open Classes
Y/N Table Edit Default Value: Y |
10 | SSR_CLSRCH_MAXCRS | Number(5,0) | INTEGER NOT NULL |
Maximum Courses to Display
Default Value: 50 |
11 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Default Value: 14770 Prompt Table: PSMSGSETDEFN |
12 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Default Value: 957 Prompt Table: PSMSGCATDEFN |
13 | SSR_INCL_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Inclusion Active Flag
Y/N Table Edit Default Value: Y |
14 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
15 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
16 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
17 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |