| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PEOPLE_SRCH
|
| 2 |
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
|
| 3 |
INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 4 |
STRM |
Character(4) |
VARCHAR2(4) NOT NULL |
Term
Prompt Table:
TERM_TBL
|
| 5 |
CLASS_NBR |
Number(5,0) |
INTEGER NOT NULL |
Class Nbr
Prompt Table:
CLASS_TBL_VW
|
| 6 |
CRSE_CAREER |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Career
Default Value: CLASS_TBL_VW.ACAD_CAREER
|
| 7 |
SESSION_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Session
1=Regular Academic Session
10W=10 Week
12W=Twelve Week
4W1=Four Week - First
4W2=Four Week - Second
4W3=Four Week - Third
4W4=Four Week - Fourth
6W1=Six Week - First
6W2=Six Week - Second
8W1=Eight Week - First
8W2=Eight Week - Second
A11=Medical Period 1, 4 Weeks
A12=Medical Period 1, 8 Weeks
A13=Medical Pd 1, 12 Weeks
A21=Medical Period 2, 4 Weeks
A22=Medical Period 2, 8 Weeks
A23=Medical Period 2, 12 Week
FYR=Full Year
MIN=Mini Session
OEE=Open Entry/Open Exit
SM1=Semester 1
SM2=Semester 2
Default Value: CLASS_TBL_VW.SESSION_CODE
|
| 8 |
SESSN_ENRL_CNTL |
Character(3) |
VARCHAR2(3) NOT NULL |
Enrollment Control Session
|
| 9 |
STDNT_ENRL_STATUS |
Character(2) |
VARCHAR2(2) NOT NULL |
Student Enrollment Status
D=Dropped
E=Enrolled
W=Waiting
Default Value: E
|
| 10 |
ENRL_STATUS_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Enrollment Status Reason
ADRP=Administrative Drop
ALIM=Appointment Limit Exceeded
CANC=Dropped (class cancelled)
CREQ=Co-Requisite Enrollment
DROP=Dropped (was enrolled)
DRWL=Dropped (was wait listed)
ENRL=Enrolled
EWAT=Enrolled from Wait List
FULL=Section is Full
RCAP=Reserve Slots Full
RCMP=Related Component
SLIM=Session Limit Exceeded
TIME=Time Conflict Exsists
TIMR=Time Conflict Resolved
TLIM=Term Limit Exceeded
WDRW=Withdrawn from Class
Default Value: ENRL
|
| 11 |
ENRL_ACTION_LAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Last Enrollment Action
Prompt Table:
XL_ENRL_ACTN_VW
|
| 12 |
ENRL_ACTN_RSN_LAST |
Character(4) |
VARCHAR2(4) NOT NULL |
Last Enrl Action Reason
Prompt Table:
ENRL_RSN_TBL
|
| 13 |
ENRL_ACTN_PRC_LAST |
Character(2) |
VARCHAR2(2) NOT NULL |
Last Enrollment Action Process
C=Course Cancelled
E=Enrollment
G=Grade Post
R=Enrollment Request
Default Value: E
|
| 14 |
STATUS_DT |
Date(10) |
DATE NOT NULL |
Status Date
Default Value: %date
|
| 15 |
ENRL_ADD_DT |
Date(10) |
DATE |
Enrollment Add Date
Default Value: %date
|
| 16 |
ENRL_DROP_DT |
Date(10) |
DATE |
Enrollment Drop Date
|
| 17 |
UNT_TAKEN |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Units Taken
|
| 18 |
UNT_PRGRSS |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Units Taken-Academic Progress
|
| 19 |
UNT_PRGRSS_FA |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Units Taken-Fin Aid Progress
|
| 20 |
UNT_BILLING |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Billing Units
|
| 21 |
CRSE_COUNT |
Number(5,2) |
DECIMAL(4,2) NOT NULL |
Course Count
|
| 22 |
GRADING_BASIS_ENRL |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
Prompt Table:
%EDITTABLE
|
| 23 |
GRADING_BASIS_DT |
Date(10) |
DATE |
Grading Basis Date
Default Value: %date
|
| 24 |
OVRD_GRADING_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Grading Basis
Default Value: N
|
| 25 |
CRSE_GRADE_OFF |
Character(3) |
VARCHAR2(3) NOT NULL |
Official Grade
Prompt Table:
GRADE_TBL_VW
|
| 26 |
CRSE_GRADE_INPUT |
Character(3) |
VARCHAR2(3) NOT NULL |
Grade Input
A=A
Prompt Table:
GRADE_TBL_VW
|
| 27 |
GRADE_DT |
Date(10) |
DATE |
Grade Date
|
| 28 |
REPEAT_CODE |
Character(4) |
VARCHAR2(4) NOT NULL |
Repeat Code
NTEA=No Taking Exam/Assessment
Prompt Table:
REPEAT_CODE_TBL
|
| 29 |
REPEAT_DT |
Date(10) |
DATE |
Repeat Date
|
| 30 |
CLASS_PRMSN_NBR |
Number(6,0) |
INTEGER NOT NULL |
Class Permission Nbr
|
| 31 |
ASSOCIATED_CLASS |
Number(4,0) |
SMALLINT NOT NULL |
Associated Class
Default Value: CLASS_TBL_VW.ASSOCIATED_CLASS
|
| 32 |
STDNT_POSITIN |
Number(8,0) |
INTEGER NOT NULL |
Student Position
|
| 33 |
AUDIT_GRADE_BASIS |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Grading Basis
Y/N Table Edit
Default Value: GRADE_BASIS_VW.AUDIT_GRADE_BASIS
|
| 34 |
EARN_CREDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Earn Credit
Y/N Table Edit
|
| 35 |
INCLUDE_IN_GPA |
Character(1) |
VARCHAR2(1) NOT NULL |
Include in GPA
Y/N Table Edit
|
| 36 |
UNITS_ATTEMPTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Units Attempted
I=In Progress
N=No
Y=Yes
|
| 37 |
GRADE_POINTS |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Grade Points
|
| 38 |
GRADE_POINTS_FA |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Financial Aid Grade Points
|
| 39 |
GRD_PTS_PER_UNIT |
Number(10,3) |
DECIMAL(9,3) NOT NULL |
Grade Points Per Unit
|
| 40 |
MANDATORY_GRD_BAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Mandatory Grading Basis
Y/N Table Edit
Default Value: N
|
| 41 |
RSRV_CAP_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Reserve Capacity Sequence
|
| 42 |
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
|
| 43 |
RQMNT_DESIGNTN_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Requirement Designation Option
N=No
Y=Yes
|
| 44 |
RQMNT_DESIGNTN_GRD |
Character(1) |
VARCHAR2(1) NOT NULL |
Requirement Designation Grade
N=Not Satisfied
S=Satisfied
|
| 45 |
INSTRUCTOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table:
%EDITTABLE2
|
| 46 |
DROP_CLASS_IF_ENRL |
Number(5,0) |
INTEGER NOT NULL |
Drop This Class if Enrolled
Prompt Table:
CLASS_TBL_VW
|
| 47 |
ASSOCIATION_99 |
Character(1) |
VARCHAR2(1) NOT NULL |
Association 99
Y/N Table Edit
Default Value: N
|
| 48 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID
|
| 49 |
TSCRPT_NOTE_ID |
Character(4) |
VARCHAR2(4) NOT NULL |
Transcript Note ID
Prompt Table:
TSCRPT_NOTE_TBL
|
| 50 |
TSCRPT_NOTE_EXISTS |
Character(1) |
VARCHAR2(1) NOT NULL |
Transcript Note Exists Flag
Y/N Table Edit
Default Value: N
|
| 51 |
NOTIFY_STDNT_CHNG |
Character(2) |
VARCHAR2(2) NOT NULL |
Notify Student of Change
DP=Dropped/Class Canceled
WE=Enrolled From WaitList
WL=WaitList Status Change
|
| 52 |
REPEAT_CANDIDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Repeat Candidate Flag
Y/N Table Edit
Default Value: N
|
| 53 |
VALID_ATTEMPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Valid Attempted Grade
|
| 54 |
GRADE_CATEGORY |
Character(4) |
VARCHAR2(4) NOT NULL |
The default value of NONE is delivered with the system and should not be deleted.
TXFR=Transfer Pass (Sample)
|
| 55 |
SEL_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Tuition Group
|
| 56 |
DYN_CLASS_NBR |
Number(5,0) |
INTEGER NOT NULL |
Dynamic Class Nbr
|
| 57 |
UNT_EARNED |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Units Earned
|
| 58 |
LAST_UPD_DT_STMP |
Date(10) |
DATE |
Last Update Date Stamp
|
| 59 |
LAST_UPD_TM_STMP |
Time(15) |
TIMESTAMP |
Last Update Time Stamp
|
| 60 |
LAST_ENRL_DT_STMP |
Date(10) |
DATE |
Last Enrollment Date Stamp
|
| 61 |
LAST_ENRL_TM_STMP |
Time(15) |
TIMESTAMP |
Last Enrollment Time Stamp
|
| 62 |
LAST_DROP_DT_STMP |
Date(10) |
DATE |
Last Drop Date Stamp
|
| 63 |
LAST_DROP_TM_STMP |
Time(15) |
TIMESTAMP |
Last Drop Time Stamp
|
| 64 |
ENRL_REQ_SOURCE |
Character(2) |
VARCHAR2(2) NOT NULL |
Enrollment Request Source
CR=Class Roll
E=Enrollment Request
EN=Enrollment
FE=Fluid Cls Srch Enrl non-SFF
FF=Fluid Cls Srch Enrl SFF
FS=Fluid Self Service SFF
FX=Fluid Self Service non-SFF
IL=Grade Lapse
ME=Mass Enrollment
PB=Post Enrl Req Chk Batch
PD=Req Chk Drop Online
PO=Post Enrl Req Chk Online
PX=Req Chk Drop Batch
QE=Quick Enroll
SE=Self-Service Enrollment
SF=Student Financials Batch
SG=Self Service Grade Posting
TA=Test Administration (NLD)
WD=Term Withdrawal Engine
WL=Wait List Engine
|
| 65 |
LAST_UPD_ENREQ_SRC |
Character(2) |
VARCHAR2(2) NOT NULL |
Enrollment Request Source
CC=Class Cancellation
E=Enrollment Request
EN=Enrollment
FA=FA Progress Unit Update
GP=Grade Posting
IL=Incomplete Lapse
ME=Mass Enrollment
PB=Post Enrl Req Chk Batch
PD=Req Chk Drop Online
PO=Post Enrl Req Chk Online
PX=Req Chk Drop Batch
QE=Quick Enroll
RC=Repeat Checking
SE=Self-Service Enrollment
SF=Student Financials Batch
WD=Term Withdrawal Engine
WL=Wait List Engine
|
| 66 |
GRADING_SCHEME_ENR |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
|
| 67 |
RELATE_CLASS_NBR_1 |
Number(5,0) |
INTEGER NOT NULL |
Related Class Number 1
|
| 68 |
RELATE_CLASS_NBR_2 |
Number(5,0) |
INTEGER NOT NULL |
Related Class Number 2
|
| 69 |
ACAD_PROG |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Program
Default Value: STDNT_CAR_TERM.ACAD_PROG_PRIMARY
Prompt Table:
SSR_ACPRG_AC_V3
|