ENRL_REQ_HEADER

(SQL Table)
Index Back

Enrollment Request Header

The Enrollment Request Header table contains general information pertaining to an Enrollment Request.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID

Default Value: 0

Prompt Table: ENRL_REQ2_SRCH

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 ENRL_REQ_PROC_ST Character(1) VARCHAR2(1) NOT NULL Enrollment Req Process Status
E=Errors Found
M=Success/Messages
P=Pending
S=Success

Default Value: P

4 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

Default Value: E

5 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
6 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.