FT_RPT_HDR_VW(SQL View) |
Index Back |
|---|---|
Transformation Error ReportsView used with Transformation Error Reports |
| SELECT RPT.FT_PARENT_INSTANCE , RPT.PROCESS_INSTANCE , OMAP.FT_XTRCT_PROCESS , RPT.FT_OBJECT_IDENT , RPT.FT_TOTAL_ROWS , RPT.FT_ERROR_ROWS , RPT.FT_FILE_STATUS FROM PS_FT_RPT_HDR RPT , PS_FT_OBJECT_MAP OMAP WHERE OMAP.FT_OBJECT_IDENT = RPT.FT_OBJECT_IDENT ORDER BY RPT.FT_PARENT_INSTANCE , RPT.PROCESS_INSTANCE , OMAP.FT_XTRCT_PROCESS , RPT.FT_OBJECT_IDENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  FT_PARENT_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Parent Process Instance |
| 2 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | FT_XTRCT_PROCESS |
Character(2) | VARCHAR2(2) NOT NULL |
Process
01=Location 02=HR Business Unit 03=Department 04=Job Grade 05=Job Code 06=Position 07=Person/Job 08=Department Tree 09=Related Language 10=Job Grade Rate 11=Salary 12=Bonus |
| 4 | FT_OBJECT_IDENT |
Character(4) | VARCHAR2(4) NOT NULL | A unique value to identify each objects. Use the following ranges, 0000-0999 outbound 1000-1999 inbound |
| 5 | FT_TOTAL_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Total Number of Rows Processed |
| 6 | FT_ERROR_ROWS | Number(15,0) | DECIMAL(15) NOT NULL | Total Number of Rows in Error |
| 7 | 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 |