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 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
2 | SSR_CRS_GRP_ID | Character(9) | VARCHAR2(9) NOT NULL | Course Group ID |
3 | EFFDT | 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 |