EOEW_OBJOWN_VW

(SQL View)
 Index Back

Subject Area

Used to capture information about the Enterprise Warehouse Tools object owner.

SELECT A.EOEW_OBJ_OWNER , B.EOEW_OBJ_OWNER , B.EOEW_OWNDFLT_FLG FROM PS_EOEW_OBJ_OWNER A , PS_EOEW_OBJ_OWNER B WHERE A.EOEW_OBJ_OWNER = B.EOEW_OBJ_OWNER OR B.EOEW_OWNDFLT_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOEW_OBJ_OWNER Character(15) VARCHAR2(15) NOT NULL Subject Area
2 EOEW_OBJ2_OWNER Character(15) VARCHAR2(15) NOT NULL Object Owner
3 EOEW_OWNDFLT_FLG Character(1) VARCHAR2(1) NOT NULL Default Subject Area

Y/N Table Edit

Default Value: N