LM_ENRL_ADM1_VW

(SQL View)
Index Back

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