PROCESS_INSTANCEFT_XTRCT_PROCESS01=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
FT_RPT_PRCS_VW(SQL View) |
Index Back |
|---|---|
Process Group CountProcess Group Count |
| SELECT DISTINCT RPT.PROCESS_INSTANCE , OMAP.FT_XTRCT_PROCESS , COUNT(RPT.FT_OBJECT_IDENT) , COUNT( CASE WHEN RPT.FT_FILE_STATUS = 'C' THEN 1 ELSE NULL END ) FROM PS_FT_RPT_HDR RPT , PS_FT_OBJECT_MAP OMAP WHERE OMAP.FT_OBJECT_IDENT = RPT.FT_OBJECT_IDENT GROUP BY RPT.PROCESS_INSTANCE , OMAP.FT_XTRCT_PROCESS |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | 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 |
| 3 | FT_COUNT_1 | Number(10,0) | DECIMAL(10) NOT NULL | Count |
| 4 | FT_COUNT_2 | Number(10,0) | DECIMAL(10) NOT NULL | Count |