SYNCIDCD=Not Imported -- Customer Data
DP=Duplicate
E1=Failed Edit Checks
E2=Not Imported -- Errors Found
IM=Imported
RSF_IMP_RSLT_VW(SQL View) |
Index Back |
|---|---|
Used in Imports Config Search |
| SELECT R.SYNCID , V.LEAD_IMP_STATUS , V.LAST_IMPORTED_DTTM , V.TOTAL_ROW_COUNT , V.ROWS_PROCESSED , V.ROWS_IN_ERROR , V.ROWS_DUPLICATE FROM PS_RB_IMP_RUN R , PS_RSF_LE_IMP_STS V WHERE R.OPRID = V.OPRID AND R.DTTM_IMPORTED = V.DTTM_IMPORTED AND R.SYNCID <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SYNCID |
Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 2 | LEAD_IMP_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
Status of the Lead Import
CD=Not Imported -- Customer Data DP=Duplicate E1=Failed Edit Checks E2=Not Imported -- Errors Found IM=Imported |
| 3 | LAST_IMPORTED_DTTM | DateTime(26) | TIMESTAMP | Last Import Attempt made on this date and time |
| 4 | TOTAL_ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Total Row Count |
| 5 | ROWS_PROCESSED | Number(8,0) | INTEGER NOT NULL | Number of rows processed |
| 6 | ROWS_IN_ERROR | Number(8,0) | INTEGER NOT NULL | Number of rows in error |
| 7 | ROWS_DUPLICATE | Number(9,0) | DECIMAL(9) NOT NULL | Rows in Duplicate Status |