LM_MASS_OPR_VW

(SQL View)

SELECT D.OPRID , B.LM_SEQ_NBR , B.LM_REQUESTOR_ID , D.FIRST_NAME , D.LAST_NAME , B.LM_PROCESS_STATUS , B.LM_PROCESSED_DT , B.LM_MASS_RQST_NAME FROM PS_LM_OPRID_PER_VW A , PS_LM_ENRL_MASS_RQ B , PS_LM_PERS_DTL_VW C , PS_LM_OPRID_NME_VW D WHERE A.LM_PERSON_ID = B.LM_REQUESTOR_ID AND B.LM_REQUESTOR_ID = C.LM_PERSON_ID AND B.LM_PROCESS_STATUS IN ('PE' , 'PO') AND B.LM_ROW_ADDED_OPRID = D.OPRID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 LM_SEQ_NBR Number(10,0) DECIMAL(10) NOT NULL Sequence number to increment for the mass req record

3 LM_REQUESTOR_ID Number(15,0) DECIMAL(15) NOT NULL Requestor

4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name field

5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name Field

6 LM_PROCESS_STATUS Character(2) VARCHAR2(2) NOT NULL Fr Mass Enrollment
ER=Error
PE=Pending
PO=Processed
PR=Processing
SU=Successful

7 LM_PROCESSED_DT Date(10) DATE Fr Mass Enrollment _ Processed Date

8 LM_MASS_RQST_NAME Character(50) VARCHAR2(50) NOT NULL Used for Mass Enrollments - Requestor Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	LM_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence number to increment for the mass req record
3	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
4	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name field
5	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name Field
6	LM_PROCESS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Fr Mass Enrollment ER=Error PE=Pending PO=Processed PR=Processing SU=Successful
7	LM_PROCESSED_DT	Date(10)	DATE	Fr Mass Enrollment _ Processed Date
8	LM_MASS_RQST_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used for Mass Enrollments - Requestor Name