TEXT_IDLANGUAGE_CDHRS_ONL_MSG_LN(SQL View) |
Index Back |
|---|---|
Related Language RecordRelated Language Record for HRS_ONL_EMSG_VW, HRS_ONL_PMSG_VW and HRS_ONL_FMSG_VW |
| SELECT A.TEXT_ID , A.LANGUAGE_CD , A.DESCR254_MIXED FROM PS_HR_SSTEXT_MLNG A WHERE A.OBJECTOWNERID = 'HRAM' AND ( A.TEXT_ID LIKE 'HRAM_%_EMSG%' OR A.TEXT_ID LIKE 'HRAM_%_PASS%' OR A.TEXT_ID LIKE 'HRAM_%_FAIL%') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEXT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Text ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |