SSR_PERIOD_TYPEACYR=Academic Year
EXAM=Exam Period
FAYR=Financial Aid Year
SPLN=Student Planning
Default Value: EXAM
Prompt Table: SCC_ENTITY_PT
Y/N Table Edit
Default Value: N
SSR_PERIOD_ENT(SQL Table) |
Index Back |
|---|---|
Campus Period Type EntityThis table holds the associated entities for the campus period types. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_PERIOD_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Period Type
ACYR=Academic Year EXAM=Exam Period FAYR=Financial Aid Year SPLN=Student Planning Default Value: EXAM |
| 2 | SCC_CAF_ENTITY_ID | Character(40) | VARCHAR2(40) NOT NULL |
CAF Entity ID
Prompt Table: SCC_ENTITY_PT |
| 3 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |
| 4 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 5 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 6 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 7 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |