SETIDPrompt Table: SETID_TBL
EOCM_ACCESS_IDPrompt Table: EOCM_TRDPARTNER
EOCM_DATA_SRC_IDSEQNUMERROR_COUNTEOCM_DS_ERR_VW(SQL View) |
Index Back |
|---|---|
Data Source LogThis record stores all the log information with the uploading of Data Source Files |
| SELECT A.SETID , A.EOCM_ACCESS_ID , A.EOCM_DATA_SRC_ID , A.SEQNUM , A.ERROR_COUNT , B.EOCM_ERROR_ROWS , A.EOCM_LINE_NUM , A.EOCM_FIELD_NAME , A.MESSAGE_NBR , A.MESSAGE_SET_NBR , A.EOCM_ERROR_VALUE , A.EOCM_ORIG_VALUE FROM PS_EOCM_DS_ERROR A , PS_EOCM_DS_LOG B WHERE A.SETID = B.SETID AND A.EOCM_ACCESS_ID = B.EOCM_ACCESS_ID AND A.EOCM_DATA_SRC_ID = B.EOCM_DATA_SRC_ID AND A.SEQNUM = B.SEQNUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SETID_TBL |
| 2 | EOCM_ACCESS_ID |
Number(15,0) | DECIMAL(15) NOT NULL |
Field for storing the Partner ID
Prompt Table: EOCM_TRDPARTNER |
| 3 | EOCM_DATA_SRC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Catalog Source ID |
| 4 | SEQNUM |
Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | ERROR_COUNT |
Number(9,0) | DECIMAL(9) NOT NULL | Error Count |
| 6 | EOCM_ERROR_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | error rows counter |
| 7 | EOCM_LINE_NUM | Number(10,0) | DECIMAL(10) NOT NULL | Line Number |
| 8 | EOCM_FIELD_NAME | Character(32) | VARCHAR2(32) NOT NULL | store the last field for new prods |
| 9 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL | Message Number. This field refers to the Message Number in the Message Catalog. |
| 10 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL | Message Set Number. This field refers to the Message Set Number in the Message Catalog. |
| 11 | EOCM_ERROR_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Current Value |
| 12 | EOCM_ORIG_VALUE | Character(254) | VARCHAR2(254) NOT NULL | Current Value |