LM_MASS_RQST_VW

(SQL View)

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

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

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

7 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	LM_REQUESTOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Requestor
2	LM_SEQ_NBR	Number(10,0)	DECIMAL(10) NOT NULL	Sequence number to increment for the mass req record
3	FIRST_NAME	Character(30)	VARCHAR2(30) NOT NULL	First Name field
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name Field
5	LM_PROCESS_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Fr Mass Enrollment ER=Error PE=Pending PO=Processed PR=Processing SU=Successful
6	LM_PROCESSED_DT	Date(10)	DATE	Fr Mass Enrollment _ Processed Date
7	LM_MASS_RQST_NAME	Character(50)	VARCHAR2(50) NOT NULL	Used for Mass Enrollments - Requestor Name