EOCM_DS_LOGH_VW

(SQL View)
 Index Back

SELECT A.SETID , A.EOCM_CATALOG_ID , C.EOCM_ACCESS_ID , C.EOCM_DATA_SRC_ID , C.SEQNUM , C.ATTACHSYSFILENAME , C.ATTACHUSERFILE , C.EOCM_IMPORT_FLAG , C.EOCM_LOAD_FLAG , C.EOCM_ERROR_FLAG , C.EOCM_IMPORT_STATUS , C.EOCM_TOT_IMP_ROWS , C.EOCM_SUCCESS_ROWS , C.EOCM_ERROR_ROWS , C.EOCM_TP_VER_ID , C.LASTUPDDTTM , C.LASTUPDOPRID , B.EOCM_MAP_OBJ FROM PS_EOCM_CATALOG A , PS_EOCM_MAP_MST B , PS_EOEW_MAP_DFN D , PS_EOCM_DS_LOG C WHERE A.SETID = B.SETID AND A.EOCM_CATALOG_ID = B.EOCM_CATALOG_ID AND A.EOCM_MAP_OBJ = B.EOCM_MAP_OBJ AND B.EOEW_MAP_OBJ = D.EOEW_MAP_OBJ AND A.SETID = C.SETID AND A.eocm_catalog_id = C.eocm_catalog_id AND D.EOEW_SRC_OBJ = C.EOCM_DATA_SRC_ID AND C.EOCM_FILE_SOURCE = 'Q'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID
3 EOCM_ACCESS_ID Number(15,0) DECIMAL(15) NOT NULL Field for storing the Partner ID
4 EOCM_DATA_SRC_ID Character(10) VARCHAR2(10) NOT NULL Catalog Source ID
5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
6 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
7 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
8 EOCM_IMPORT_FLAG Character(1) VARCHAR2(1) NOT NULL This field indicated whether the Data File has been imported to the source table
9 EOCM_LOAD_FLAG Character(1) VARCHAR2(1) NOT NULL This flag indicates whether the catalog source is loaded to target or not
10 EOCM_ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
11 EOCM_IMPORT_STATUS Character(1) VARCHAR2(1) NOT NULL Data Source Import Status
1=Uploaded
2=Import in Process
3=Import Successful
4=Error in Import
5=Deleted
6=Attached
7=Loaded
8=Import Cancelled
9=Import not Successful
12 EOCM_TOT_IMP_ROWS Number(15,0) DECIMAL(15) NOT NULL Total imported rows
13 EOCM_SUCCESS_ROWS Number(15,0) DECIMAL(15) NOT NULL successful imported rows counter
14 EOCM_ERROR_ROWS Number(15,0) DECIMAL(15) NOT NULL error rows counter
15 EOCM_TP_VER_ID Number(3,0) SMALLINT NOT NULL trading partner version id
16 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
17 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
18 EOCM_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Catalog Management Map Object