EOCM_FLDS_VW

(SQL View)
Index Back

SELECT A.FIELDNAME , B.LONGNAME , A.EOCM_COMP_FLD , B.SETID , B.EOCM_CATALOG_ID , B.EOCM_ACCESS_ID , B.EOCM_TP_VER_ID , B.EOCM_REPORT_ID , C.FIELDTYPE FROM PS_EOCM_MAP_FIELDS A , PS_EOCM_SELECT_FLD B , PSDBFIELD C WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDNAME = C.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
3 EOCM_COMP_FLD Character(18) VARCHAR2(18) NOT NULL Compared Field
4 SETID Character(5) VARCHAR2(5) NOT NULL SetID
5 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
6 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
7 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id
8 EOCM_REPORT_ID Character(32) VARCHAR2(32) NOT NULL Report ID
9 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)