LM_ENRL_ADM1_VW (SQL View)	Index Back
Enrollment Admin View

LM_ENRL_ADM1_VW

(SQL View)

Enrollment Admin View

SELECT DISTINCT A.LM_PERSON_ID ,A.EFFDT ,CASE WHEN A.LM_ACTIVE = 'Y' THEN 'A' ELSE 'I' END , B.LAST_NAME_SRCh , B.FIRST_NAME_SRCH , B.NAME , B.LM_NAME_DISPLAY FROM PS_LM_PERSON_JOB A , PS_LM_PERSON_NAME B WHERE A.LM_PERSON_ID = b.lm_person_id AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND ((B.LM_NAME_TYPE = 'PRF') OR (B.LM_NAME_TYPE = 'PRI' AND NOT EXISTS ( SELECT LM_NAME_TYPE FROM PS_LM_PERSON_NAME WHERE LM_PERSON_ID = B.LM_PERSON_ID AND LM_NAME_TYPE = 'PRF' AND %CurrentDateIn BETWEEN EFFDT AND LM_END_EFFDT))) AND A.LM_EFFSEQ = ( SELECT MAX(LM_EFFSEQ) FROM PS_LM_PERSON_JOB A1 WHERE A1.LM_PERSON_ID = A.LM_PERSON_ID AND A1.LM_EMPL_RCD = A.LM_EMPL_RCD AND A1.EFFDT = A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ENRLMT_ADMIN_ID Number(15,0) DECIMAL(15) NOT NULL Administrator
Prompt Table: LM_PERSON_VW
Set Control Field: PERSON_ID

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

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

7 LM_NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Name Display field

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ENRLMT_ADMIN_ID	Number(15,0)	DECIMAL(15) NOT NULL	Administrator Prompt Table: LM_PERSON_VW Set Control Field: PERSON_ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
4	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name
6	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
7	LM_NAME_DISPLAY	Character(50)	VARCHAR2(50) NOT NULL	Name Display field