TRW_STMT_IDEMPLIDTRW_STMT_RCDTRW_SECTION_IDTRW_RW_ITEM_IDTRW_EE_ST_SC_VW(SQL View) |
Index Back |
|---|---|
TRW EE Stmt Section Sum RecordThis table is the total rewards employee statement section summary table that summarizes totals for reward items associated to the section. |
| SELECT TRW_STMT_ID , EMPLID , TRW_STMT_RCD , TRW_SECTION_ID , TRW_RW_ITEM_ID , TRW_TOT_EE_AMT , TRW_TOT_ER_AMT , TRW_TOT_CP_AMT , TRW_UNITS , CURRENCY_CD FROM PS_TRW_EE_STMT_SEC |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRW_STMT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Reward Statement ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | TRW_STMT_RCD |
Number(3,0) | SMALLINT NOT NULL | Statement Record |
| 4 | TRW_SECTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Section ID for sections in total rewards template.setup |
| 5 | TRW_RW_ITEM_ID |
Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - reward item ID |
| 6 | TRW_TOT_EE_AMT | Signed Number(23,6) | DECIMAL(21,6) NOT NULL | Total Employee Amount |
| 7 | TRW_TOT_ER_AMT | Signed Number(23,6) | DECIMAL(21,6) NOT NULL | Total Employer Amount |
| 8 | TRW_TOT_CP_AMT | Signed Number(23,6) | DECIMAL(21,6) NOT NULL | Total Company Provided Amount |
| 9 | TRW_UNITS | Number(8,0) | INTEGER NOT NULL | TRW Units |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |