| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SSR_ACTIVITY_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Academic Activity ID
|
| 2 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
|
| 3 |
SSR_PERIOD_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Academic Period ID
Prompt Table:
SSR_EXAM_PRD_VW
|
| 4 |
SSR_PRD_SCTN_NBR |
Number(6,0) |
INTEGER NOT NULL |
Period Section Number
|
| 5 |
SSR_ACM_INSTSTAT |
Character(3) |
VARCHAR2(3) NOT NULL |
Section Status
APR=Approved
SCH=Scheduled
TNT=Proposed/Tentative
UNS=Unscheduled
Default Value: UNS
|
| 6 |
SSR_ACM_ENRL_CAP |
Number(4,0) |
SMALLINT NOT NULL |
Room Capacity
|
| 7 |
SSR_ACM_ENRL_TOT |
Number(4,0) |
SMALLINT NOT NULL |
Room Capacity
|
| 8 |
SSR_CW_AUTO_ENROLL |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Enrollment
Y/N Table Edit
Default Value: N
|
| 9 |
SSR_CW_CONF_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmation Required
Y/N Table Edit
Default Value: N
|
| 10 |
SSR_AC_RSTCGRP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Restrict Enrollment to Group
Y/N Table Edit
|
| 11 |
STDNT_GROUP |
Character(4) |
VARCHAR2(4) NOT NULL |
Student Group
Prompt Table:
STDNT_GROUP_TBL
|
| 12 |
SSR_CW_EXAM_DUR_H |
Number(3,0) |
SMALLINT NOT NULL |
Exam Duration (hours : mins)
|
| 13 |
SSR_CW_EXAM_DUR_M |
Number(2,0) |
SMALLINT NOT NULL |
Exam Duration (mins)
|
| 14 |
SSR_ACM_REQ_ROOMS |
Number(3,0) |
SMALLINT NOT NULL |
Number of Required Rooms
Default Value: 1
|
| 15 |
FACILITY_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Facility ID
Prompt Table:
FACILITY_TBL
Set Control Field: INSTITUTION
|
| 16 |
FACILITY_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Facility Type
AUD=Auditorium
CBL=Cable TV
CMLB=Computer Lab
EXT=Exterior Space
ITV=Interactive TV Classroom
LAB=Laboratory
LCTR=Lecture Room
RSCH=Research Site
SMNR=Seminar Room
SPRT=Sporting Facility
|
| 17 |
ROOM_CAPACITY |
Number(4,0) |
SMALLINT NOT NULL |
Room Capacity
|
| 18 |
SSR_ACM_STU_CAP_RM |
Number(4,0) |
SMALLINT NOT NULL |
Room Capacity
|
| 19 |
EXAM_SEAT_SPACING |
Number(1,0) |
SMALLINT NOT NULL |
Exam Seat Spacing
|
| 20 |
SSR_ACM_TIMESLOT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Time Slotting
Y/N Table Edit
Default Value: N
|
| 21 |
SSR_ACM_STU_PRSLOT |
Number(3,0) |
SMALLINT NOT NULL |
Students Per Slot
|
| 22 |
SSR_ACM_SLOT_DUR_H |
Number(3,0) |
SMALLINT NOT NULL |
Slot Duration (hours)
|
| 23 |
SSR_ACM_SLOT_DUR_M |
Number(2,0) |
SMALLINT NOT NULL |
Slot Duration (mins)
|
| 24 |
CAMPUS_EVENT_NBR |
Character(9) |
VARCHAR2(9) NOT NULL |
Event ID
|
| 25 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 26 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 27 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 28 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|