SSR_PERIOD_TBL(SQL Table) |
Index Back |
---|---|
Campus Period TableThis table holds the campus periods related data. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
2 | SSR_PERIOD_ID | Character(12) | VARCHAR2(12) NOT NULL | Academic Period ID |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | 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 |
5 | SSR_PRD_START_DT | Date(10) | DATE NOT NULL | Campus Period Start Date |
6 | SSR_PRD_START_TIME | Time(15) | TIMESTAMP | Campus Period Start Time |
7 | SSR_PRD_END_DT | Date(10) | DATE NOT NULL | Campus Period End Date |
8 | SSR_PRD_END_TIME | Time(15) | TIMESTAMP | Campus Period End Time |
9 | SSR_PRD_ENRL_CB | Character(1) | VARCHAR2(1) NOT NULL |
Enter Enrollment Attributes
Y/N Table Edit |
10 | SSR_LAST_SCTN_NBR | Number(5,0) | INTEGER NOT NULL | Last Sequence Nbr |
11 | SSR_MAX_EOC_PGM_DT | Date(10) | DATE | Max EOC Program Date |
12 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
13 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
14 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
15 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |