SSR_CRS_GRP_HDR(SQL Table) | 
Index Back | 
|---|---|
Course Group HeaderUse this table to define and describe Course Groups. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL | 
Academic Institution
 Prompt Table: INSTITUTION_TBL  | 
|
| 2 | Character(9) | VARCHAR2(9) NOT NULL | Course Group ID | |
| 3 | Date(10) | DATE NOT NULL | 
Effective Date
 Default Value: %date  | 
|
| 4 | END_EFFDT | Date(10) | DATE | End Effdt | 
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL | 
Effective Status
 A=Active I=Inactive Default Value: A  | 
| 6 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 | 
| 7 | SSR_AUTO_PROCESS | Character(1) | VARCHAR2(1) NOT NULL | 
If Y, will be picked up by the PE Block Enrollment process.
 Y/N Table Edit Default Value: Y  | 
| 8 | SSR_FLTR_SBJ | Character(1) | VARCHAR2(1) NOT NULL | 
Subject
 Y/N Table Edit Default Value: N  | 
| 9 | SSR_FLTR_CAR | Character(1) | VARCHAR2(1) NOT NULL | 
Career
 Y/N Table Edit Default Value: N  | 
| 10 | SSR_FLTR_CMP | Character(1) | VARCHAR2(1) NOT NULL | 
Campus
 Y/N Table Edit Default Value: N  | 
| 11 | SSR_FLTR_ORG | Character(1) | VARCHAR2(1) NOT NULL | 
Academic Organization
 Y/N Table Edit Default Value: N  | 
| 12 | SSR_FLTR_AGR | Character(1) | VARCHAR2(1) NOT NULL | 
Academic Group
 Y/N Table Edit Default Value: N  | 
| 13 | SSR_FLTR_CAF | Character(1) | VARCHAR2(1) NOT NULL | 
Academic Item Attribute
 Y/N Table Edit Default Value: N  | 
| 14 | DESCRLONG | Long Character | CLOB | Long Description | 
| 15 | SAA_WHERE_CLAUSE | Long Character | CLOB | This field contains the where clause used in different processes in academic advisement. | 
| 16 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By | 
| 17 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created | 
| 18 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By | 
| 19 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |