LM_PERSON_VW2(SQL View) |
Index Back |
|---|---|
PeopleContains all People |
| SELECT A.LM_PERSON_ID , B.LM_ACTIVE , C.LM_LANG_CD , C.LM_SEX , A.LM_BIRTHDATE , A.LM_COMM_METHOD , A.LM_SOURCE_IND , A.LM_EXT_PERSON_FLG , B.LM_LE_ID FROM PS_LM_PERSON A , PS_LM_CURR_JOB_VW B , PS_LM_PERSON_EFFDT C WHERE B.LM_PERSON_ID = A.LM_PERSON_ID AND C.LM_PERSON_ID = A.LM_PERSON_ID AND %CurrentDateIn BETWEEN B.EFFDT AND B.LM_END_EFFDT AND %CurrentDateIn BETWEEN C.EFFDT AND C.LM_END_EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  LM_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | ELM Person ID |
| 2 | LM_ACTIVE | Character(1) | VARCHAR2(1) NOT NULL |
Active
N=Inactive Y=Active |
| 3 | LM_LANG_CD | Character(3) | VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French DAN=Danish DUT=Dutch ENG=English ESP=Spanish FRA=French GER=German GRK=Greek INE=International English ITA=Italian JPN=Japanese KOR=Korean POR=Portuguese SVE=Swedish THA=Thai ZHS=Simplified Chinese ZHT=Traditional Chinese |
| 4 | LM_SEX | Character(1) | VARCHAR2(1) NOT NULL |
Sex
F=Female M=Male U=Unknown |
| 5 | LM_BIRTHDATE | Date(10) | DATE | Birthdate |
| 6 | LM_COMM_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Preferred Communication Method
EMAL=Email MAIL=Postal Mail PHON=Telephone |
| 7 | LM_SOURCE_IND | Character(4) | VARCHAR2(4) NOT NULL |
Source Indicator
EXT=External HR89=HRMS 89 HRMS=HRMS LELM=Enterprise Learning |
| 8 | LM_EXT_PERSON_FLG | Character(1) | VARCHAR2(1) NOT NULL | External Person Flag |
| 9 | LM_LE_ID | Number(10,0) | DECIMAL(10) NOT NULL | Learning Environment ID - System Generated number |