EO_BIOWNRID_VW

(SQL View)
Index Back

Comp Interfaces OwnerID View

View distinct Valid Ownerids for Component Interfaces

SELECT DISTINCT OBJECTOWNERID , XLATLONGNAME , XLATSHORTNAME FROM PSIODEFN , XLATTABLE_VW WHERE XLATTABLE_VW.FIELDNAME = 'OBJECTOWNERID' AND PSIODEFN.OBJECTOWNERID = XLATTABLE_VW.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
3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name