FT_RPT_HDR(SQL Table) |
Index Back |
|---|---|
Progress Report DataStores Progress Report Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Parent Process Instance | |
| 2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 3 | Character(4) | VARCHAR2(4) NOT NULL | A unique value to identify each objects. Use the following ranges, 0000-0999 outbound 1000-1999 inbound | |
| 4 | FT_TOTAL_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Total Number of Rows Processed |
| 5 | FT_ERROR_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Total Number of Rows in Error |
| 6 | FT_FILE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
File Load Status
C=Completed E=Error I=Initiated N=Not Scheduled P=Processing Q=Queued X=No Log Data Z=Completed with Errors |