LM_PERSON_IDLM_CM_PURP_TYPEPrompt Table: LM_CM_PURP_TYPE
N=No
Y=Yes
LM_EM_ADDR_VW(SQL View) |
Index Back |
|---|---|
Learner Email addresses |
| SELECT L.LM_PERSON_ID , P.OPRID , L.LM_CM_PURP_TYPE , C.LM_CM_PURP_SDESCR , L.LM_EMAIL_ADDR , L.LM_PRIMARY FROM PS_LM_PERSON_EMAIL L , PS_LM_PERSON_OPRID P , PS_LM_CM_PURP_TYPE C WHERE L.LM_PERSON_ID = P.LM_PERSON_ID AND C.LM_CM_PURP_TYPE = L.LM_CM_PURP_TYPE |
| # | 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 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | LM_CM_PURP_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Contact Method Purpose Type
Prompt Table: LM_CM_PURP_TYPE |
| 4 | LM_CM_PURP_SDESCR | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 5 | LM_EMAIL_ADDR | Character(70) | VARCHAR2(70) NOT NULL | Email address |
| 6 | LM_PRIMARY | Character(1) | VARCHAR2(1) NOT NULL |
Primary Contact Method
N=No Y=Yes |