| LM_RSNCD_VW1(SQL View) | Index Back | 
|---|---|
| Reason Code viewReason code view | 
| SELECT LM_RSN_CD , LM_RSN_DESCR FROM PS_LM_RSNCD_TBL WHERE LM_RSNCD_TYPE = '02' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Identifies the user defined reason code for program and activity status changes. | |
| 2 | LM_RSN_DESCR | Character(50) | VARCHAR2(50) NOT NULL | Description |