SSR_BC_GEN_OPTS

(SQL Table)
Index Back

Browse Catalog General Options

Browse 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