| HRS_ONL_FMSG_VW(SQL View) | Index Back | 
|---|---|
| User Configurable TextSelects the Pass Message TEXT_ID's | 
| SELECT A.TEXT_ID , A.DESCR254_MIXED FROM PS_HR_SSTEXT_MSGID A WHERE A.OBJECTOWNERID = 'HRAM' AND A.TEXT_ID LIKE 'HRAM_%_FAIL%' | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(18) | VARCHAR2(18) NOT NULL | Text ID | |
| 2 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |