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 | Number(15,0) | DECIMAL(15) NOT NULL |
Administrator
Prompt Table:
LM_PERSON_VW
|
|
2 | 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 |