OBJECTOWNERIDQRY_SEC_PD_NAME(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.OBJECTOWNERID ,B.XLATLONGNAME FROM PS_QRYSEC_MAIN_TBL A ,PSXLATITEM B WHERE B.FIELDNAME='OBJECTOWNERID' AND B.EFF_STATUS='A' AND B.EFFDT=( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE C.FIELDNAME=B.FIELDNAME AND C.FIELDVALUE=B.FIELDVALUE AND C.EFFDT<=%CurrentDateIn AND C.EFF_STATUS='A') AND A.OBJECTOWNERID= B.FIELDVALUE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OBJECTOWNERID |
Character(4) | VARCHAR2(4) NOT NULL | Object owner identifier |
| 2 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |