| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ENRL_REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Enrollment Request ID
|
| 2 |
ENRL_REQ_DETL_SEQ |
Number(6,0) |
INTEGER NOT NULL |
Enrollment Req Detail Sequence
|
| 3 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 4 |
ACAD_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
Prompt Table:
STDNT_CAREER
|
| 5 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 6 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
STDNT_CARTRM_VW
|
| 7 |
CLASS_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Nbr
Prompt Table:
%EDITTABLE
|
| 8 |
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
|
| 9 |
ENRL_ACTION_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Enrollment Action Reason
Prompt Table:
ENRL_RSN_TBL
|
| 10 |
ENRL_ACTION_DT |
Date(10) |
DATE |
Enrollment Action Date
|
| 11 |
UNT_TAKEN |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Units Taken
|
| 12 |
UNT_EARNED |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Units Earned
|
| 13 |
CRSE_COUNT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Course Count
|
| 14 |
REPEAT_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Repeat Code
NTEA=No Taking Exam/Assessment
Prompt Table:
REPEAT_CODE_TBL
|
| 15 |
CRSE_GRADE_INPUT |
Character(3) |
VARCHAR2(3) NOT NULL |
Grade Input
A=A
Prompt Table:
GRADE_TBL2_VW
|
| 16 |
GRADING_BASIS_ENRL |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
Prompt Table:
%EDITTABLE2
|
| 17 |
CLASS_PRMSN_NBR |
Number(6,0) |
INTEGER NOT NULL |
Class Permission Nbr
|
| 18 |
CLASS_NBR_CHG_TO |
Number(5,0) |
INTEGER NOT NULL |
Change to Class Nbr
Prompt Table:
%EDITTABLE4
|
| 19 |
DROP_CLASS_IF_ENRL |
Number(5,0) |
INTEGER NOT NULL |
Drop This Class if Enrolled
Prompt Table:
CLASS_TBL_S2_VW
|
| 20 |
CHG_TO_WL_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Change To Wait List Nbr
|
| 21 |
RELATE_CLASS_NBR_1 |
Number(5,0) |
INTEGER NOT NULL |
Related Class Number 1
Prompt Table:
CLASS_TBL_RE_V2
|
| 22 |
RELATE_CLASS_NBR_2 |
Number(5,0) |
INTEGER NOT NULL |
Related Class Number 2
Prompt Table:
CLASS_TBL_RE_V2
|
| 23 |
OVRD_CLASS_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by SR Enrollments and Class Permissions.
Y/N Table Edit
Default Value: OPR_DEF_TBL_CS.OVRD_CLASS_LIMIT
|
| 24 |
OVRD_GRADING_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Grading Basis
Y/N Table Edit
Default Value: N
|
| 25 |
OVRD_CLASS_UNITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Class Units
Y/N Table Edit
Default Value: N
|
| 26 |
OVRD_UNIT_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Unit Load
Y/N Table Edit
Default Value: OPR_DEF_TBL_CS.OVRD_UNIT_LOAD
|
| 27 |
OVRD_CLASS_LINKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Class Links
Y/N Table Edit
Default Value: N
|
| 28 |
OVRD_CLASS_PRMSN |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Class Permission
Y/N Table Edit
Default Value: OPR_DEF_TBL_CS.OVRD_CLASS_PRMSN
|
| 29 |
OVRD_REQUISITES |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Requisites
Y/N Table Edit
Default Value: OPR_DEF_TBL_CS.OVRD_REQUISITES
|
| 30 |
OVRD_TIME_CNFLCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Time Conflict
Y/N Table Edit
Default Value: OPR_DEF_TBL_CS.OVRD_TIME_CNFLCT
|
| 31 |
OVRD_CAREER |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Career
Y/N Table Edit
Default Value: N
|
| 32 |
WAIT_LIST_OKAY |
Character(1) |
VARCHAR2(1) NOT NULL |
Wait List Okay
Y/N Table Edit
Default Value: OPR_DEF_TBL_CS.WAIT_LIST_OKAY
|
| 33 |
OVRD_ENRL_ACTN_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Action Date
Y/N Table Edit
Default Value: N
|
| 34 |
OVRD_RQMNT_DESIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Ovrd Requirement Designation
Y/N Table Edit
Default Value: N
|
| 35 |
OVRD_SRVC_INDIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Service Indicator
Y/N Table Edit
Default Value: N
|
| 36 |
OVRD_APPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Appointment
Y/N Table Edit
Default Value: N
|
| 37 |
INSTRUCTOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table:
%EDITTABLE3
|
| 38 |
ENRL_REQ_DETL_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enrollment Req Detail Status
E=Errors found
M=Success/Messages
P=Pending
S=Success
X=Pending
Default Value: P
|
| 39 |
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
|
| 40 |
RQMNT_DESIGNTN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requirement Designation Option
N=No
Y=Yes
Default Value: N
|
| 41 |
RQMNT_DESIGNTN_GRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Requirement Designation Grade
N=Not Satisfied
S=Satisfied
|
| 42 |
TSCRPT_NOTE_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Transcript Note ID
Prompt Table:
TSCRPT_NOTE_TBL
|
| 43 |
TSCRPT_NOTE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transcript Note Exists Flag
Y/N Table Edit
Default Value: N
|
| 44 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 45 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 46 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 47 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Default Value: STDNT_CAR_TERM.ACAD_PROG_PRIMARY
Prompt Table:
SSR_ACPRG_AC_V3
|