FT_SALCMP_IN_VW(SQL View) |
Index Back |
|---|
| SELECT C.FT_RUN_ID , C.FT_SALARYCOMP_GUID , C.FT_EFF_SEQUENCE , C.FT_SALARY_GUID , C.FT_REASON_CODE , SUM(C.FT_CHANGE_AMOUNT) , SUM(C.FT_CHANGE_PERCENT) FROM %Table(FT_SALARYCMP_IN) C GROUP BY C.FT_RUN_ID , C.FT_SALARYCOMP_GUID , C.FT_EFF_SEQUENCE , C.FT_SALARY_GUID , C.FT_REASON_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FT_RUN_ID | Number(18,0) | DECIMAL(18) NOT NULL | LEGAL_ENTITY_ID |
| 2 | FT_SALARYCOMP_GUID | Character(36) | VARCHAR2(36) NOT NULL | Salary Component GUID |
| 3 | FT_EFF_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Effective Sequence |
| 4 | FT_SALARY_GUID | Character(36) | VARCHAR2(36) NOT NULL | Salary GUID |
| 5 | FT_REASON_CODE | Character(30) | VARCHAR2(30) NOT NULL | Reason Code |
| 6 | FT_CHANGE_AMOUNT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | CHANGE_AMOUNT |
| 7 | FT_CHANGE_PERCENT | Number(19,6) | DECIMAL(18,6) NOT NULL | CHANGE_PERCENTAGE |