ENR_REQ_EMP_VW2 (SQL View)	Index Back
Enrollment Request Emplid View Block Enrollment Request Id Emplid View, used for searching Students only in Enrl Req Dtl Tbl.

ENR_REQ_EMP_VW2

(SQL View)

Enrollment Request Emplid View

Block Enrollment Request Id Emplid View, used for searching Students only in Enrl Req Dtl Tbl.

SELECT a.enrl_request_id , a.emplid , c.name , b.campus_id FROM PS_ENRL_REQ_DETAIL a , PS_SCC_PERS_SA_VW b , PS_SCC_CUR_NAME_VW c WHERE a.emplid = b.emplid AND a.emplid = c.emplid AND b.emplid = c.emplid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ENRL_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Enrollment Request ID

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PEOPLE_SRCH

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ENRL_REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Enrollment Request ID
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PEOPLE_SRCH
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	CAMPUS_ID	Character(16)	VARCHAR2(16) NOT NULL	Campus ID