| # |
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 |
CRSE_ENRL_BLOCK |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Enrollment Block
|
| 3 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Default Value: OPR_DEF_TBL_CS.STRM
Prompt Table:
TERM_VAL_TBL
|
| 4 |
CLASS_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Nbr
Prompt Table:
%EDITTABLE
|
| 5 |
ENRL_REQ_ACTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Enrollment Request Action
A=Add Grade
C=Change Grade
D=Drop
E=Enroll
M=Normal Maintenance
P=Change Wait List Position
R=Remove Grade
S=Swap Courses
W=Drop to Wait List
Default Value: CRSE_BLOCK_HDR.ENRL_REQ_ACTION
|
| 6 |
ENRL_ACTION_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Enrollment Action Reason
Default Value: CRSE_BLOCK_HDR.ENRL_ACTION_REASON
Prompt Table:
ENRL_RSN_TBL
|
| 7 |
ENRL_ACTION_DT |
Date(10) |
DATE |
Enrollment Action Date
Default Value: CRSE_BLOCK_HDR.ENRL_ACTION_DT
|
| 8 |
UNT_TAKEN |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Units Taken
|
| 9 |
CRSE_COUNT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Course Count
|
| 10 |
REPEAT_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Repeat Code
NTEA=No Taking Exam/Assessment
Prompt Table:
REPEAT_CODE_TBL
|
| 11 |
CRSE_GRADE_INPUT |
Character(3) |
VARCHAR2(3) NOT NULL |
Grade Input
A=A
Prompt Table:
GRADE_TBL2_VW
|
| 12 |
GRADING_BASIS_ENRL |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
Prompt Table:
%EDITTABLE10
|
| 13 |
CLASS_NBR_CHG_TO |
Number(5,0) |
INTEGER NOT NULL |
Change to Class Nbr
Prompt Table:
%EDITTABLE4
|
| 14 |
DROP_CLASS_IF_ENRL |
Number(5,0) |
INTEGER NOT NULL |
Drop This Class if Enrolled
Prompt Table:
CLASS_TBL_VW
|
| 15 |
RELATE_CLASS_NBR_1 |
Number(5,0) |
INTEGER NOT NULL |
Related Class Number 1
Prompt Table:
CLASS_TBL_RE_VW
|
| 16 |
RELATE_CLASS_NBR_2 |
Number(5,0) |
INTEGER NOT NULL |
Related Class Number 2
Prompt Table:
CLASS_TBL_RE_VW
|
| 17 |
OVRD_CLASS_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by SR Enrollments and Class Permissions.
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_CLASS_LIMIT
|
| 18 |
OVRD_GRADING_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Grading Basis
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_GRADING_BASIS
|
| 19 |
OVRD_CLASS_UNITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Class Units
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_CLASS_UNITS
|
| 20 |
OVRD_UNIT_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Unit Load
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_UNIT_LOAD
|
| 21 |
OVRD_CLASS_LINKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Class Links
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_CLASS_LINKS
|
| 22 |
OVRD_CLASS_PRMSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Class Permission
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_CLASS_PRMSN
|
| 23 |
OVRD_REQUISITES |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Requisites
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_REQUISITES
|
| 24 |
OVRD_TIME_CNFLCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Time Conflict
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_TIME_CNFLCT
|
| 25 |
OVRD_CAREER |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Career
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_CAREER
|
| 26 |
WAIT_LIST_OKAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Wait List Okay
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.WAIT_LIST_OKAY
|
| 27 |
OVRD_ENRL_ACTN_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Action Date
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_ENRL_ACTN_DT
|
| 28 |
OVRD_RQMNT_DESIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ovrd Requirement Designation
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_RQMNT_DESIG
|
| 29 |
OVRD_SRVC_INDIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Service Indicator
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_SRVC_INDIC
|
| 30 |
OVRD_APPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Appointment
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.OVRD_APPT
|
| 31 |
INSTRUCTOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table:
%EDITTABLE3
|
| 32 |
RQMNT_DESIGNTN |
Character(4) |
VARCHAR2(4) NOT NULL |
This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
Prompt Table:
RQMNT_DESIG_TBL
|
| 33 |
RQMNT_DESIGNTN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requirement Designation Option
N=No
Y=Yes
|
| 34 |
RQMNT_DESIGNTN_GRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Requirement Designation Grade
N=Not Satisfied
S=Satisfied
|
| 35 |
TSCRPT_NOTE_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Transcript Note ID
Prompt Table:
TSCRPT_NOTE_TBL
|
| 36 |
SSR_DYND_LDRP_OVRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Dynamic Dates
Y/N Table Edit
Default Value: CRSE_BLOCK_HDR.SSR_DYND_LDRP_OVRD
|