SAD_BPV_INDEX_IDSAD_BPV_MSGUUIDLANGUAGE_CDSAD_BPV_SBBVLNG(SQL View) |
Index Back |
|---|---|
Lang Rec Search Request (NLD) |
| SELECT SBB.SAD_BPV_INDEX_ID ,SBB.SAD_BPV_MSGUUID ,SBBL.LANGUAGE_CD ,SBB.DESCR50 FROM PS_SAD_BPV_SBB_NLD SBB , PS_SAD_BPV_SBB_LNG SBBL WHERE %Upper(SBB.SERVICENAME) = 'IDENTIFICATION' AND SBB.SAD_BPV_TRANS_DTTM = ( SELECT MAX(DTTM.SAD_BPV_TRANS_DTTM) FROM PS_SAD_BPV_SBB_NLD DTTM WHERE DTTM.OPRID = SBB.OPRID) AND SBB.SAD_BPV_INDEX_ID = SBBL.SAD_BPV_INDEX_ID AND SBB.SAD_BPV_MSGUUID = SBBL.SAD_BPV_MSGUUID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SAD_BPV_INDEX_ID |
Character(40) | VARCHAR2(40) NOT NULL | Transaction Index ID |
| 2 | SAD_BPV_MSGUUID |
Character(50) | VARCHAR2(50) NOT NULL | Message ID |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |