TRW_STMT_IDEMPLIDTRW_STMT_RCDTRW_SECTION_IDTRW_RW_ITEM_IDDefault Value: %date
TRW_PRV_SUM_VW(SQL View) |
Index Back |
|---|---|
TRW Summary SectionThis view gets the total rewards summary section for the Preview Fluid Statement link. |
| SELECT DISTINCT 'DUMMY' , 'DUMMY' , 0 , SECT.TRW_SECTION_ID , SECT.TRW_SECTION_ID , 9999.999999 , 9999.999999 , 9999.999999 , 0 , 'USD' , TMPL.TEMPLATE_ID , TMPL.EFFDT , SECT.TRW_SEQ_NUM , ITEM.TRW_SEQ_NUM FROM PS_TRW_TEMPLATE TMPL , PS_TRW_TEMPL_SECT SECT , PS_TRW_TEMPL_ITEM ITEM WHERE TMPL.TEMPLATE_ID = SECT.TEMPLATE_ID AND TMPL.EFFDT = SECT.EFFDT AND SECT.TEMPLATE_ID = ITEM.TEMPLATE_ID AND SECT.EFFDT = ITEM.EFFDT AND SECT.TRW_SECTION_ID = ITEM.TRW_SECTION_ID |
| # | 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 |
| 11 | TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Template ID |
| 12 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 13 | TRW_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Display Sequence |
| 14 | TRW_SEQ | Number(3,0) | SMALLINT NOT NULL | Sequence Number |