EORC_OBJOWNVW

(SQL View)
Index Back

SELECT FIELDVALUE , EFFDT , EFF_STATUS , XLATLONGNAME FROM PSXLATITEM WHERE FIELDNAME IN ( 'OBJECTOWNERID')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 RCM_DESCR Character(80) VARCHAR2(80) NOT NULL Description