OPRIDDTTM_IMPORTEDCD=Not Imported -- Customer Data
DP=Duplicate
E1=Failed Edit Checks
E2=Not Imported -- Errors Found
IM=Imported
RSF_LE_IMP_STS(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | DTTM_IMPORTED |
DateTime(26) | TIMESTAMP | Imported Date Time |
| 3 | ATTACHUSERFILE | Character(64) | VARCHAR2(64) NOT NULL | Attached File |
| 4 | RUNDATE | Date(10) | DATE | Process Scheduler Run Date |
| 5 | TOTAL_ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Total Row Count |
| 6 | ROWS_PROCESSED | Number(8,0) | INTEGER NOT NULL | Number of rows processed |
| 7 | ROWS_IN_ERROR | Number(8,0) | INTEGER NOT NULL | Number of rows in error |
| 8 | ROWS_DUPLICATE | Number(9,0) | DECIMAL(9) NOT NULL | Rows in Duplicate Status |
| 9 | 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 |
| 10 | NO_OF_HEADER_ROWS | Number(3,0) | SMALLINT NOT NULL | Number of Header Rows |
| 11 | LAST_IMPORTED_DTTM | DateTime(26) | TIMESTAMP | Last Import Attempt made on this date and time |