LM_ENRL_RSN_VW(SQL View) |
Index Back |
|---|---|
Enrollment ReasonsEnrollment Drop Reason |
| SELECT LM_ENRLMT_ID ,CASE WHEN A.LM_RSN_CD = '0' THEN C.MESSAGE_TEXT ELSE Coalesce(LM_RSN_DESCR ,C.MESSAGE_TEXT) END FROM PS_LM_CLS_RST_RSN A LEFT OUTER JOIN PS_LM_RSNCD_ACT_VW B ON A.LM_RSN_CD = B.LM_RSN_CD , PSMSGCATDEFN C WHERE C.MESSAGE_SET_NBR = 158 AND C.MESSAGE_NBR = 2601 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | LM_ENRLMT_ID | Number(10,0) | DECIMAL(10) NOT NULL | Enrollment ID |
| 2 | LM_RSN_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |