EOIU_RECFLD_VW

(SQL View)
 Index Back

Gets Rec Fields

Gets Rec Fields

SELECT A.EOIU_RECNAME , A.EOIU_FIELD_NAME , A.DESCRLONG FROM PS_EOIU_DBFLDS_VW A WHERE NOT EXISTS ( SELECT 'X' FROM PSKEYDEFN B WHERE B.RECNAME=A.EOIU_RECNAME AND B.FIELDNAME=A.EOIU_FIELD_NAME AND B.INDEXID = '_')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOIU_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
2 EOIU_FIELD_NAME Character(18) VARCHAR2(18) NOT NULL Field Name
3 DESCRLONG Long Character CLOB Long Description