TRW_TMPL_SCT_VW(SQL View) |
Index Back |
|---|---|
Template Sections ViewUsed by My Total Rewards to load section information. |
| SELECT STMT.TRW_STMT_ID , TMPL.TEMPLATE_ID , SECT.TRW_SECTION_ID , EESC.EMPLID , EESC.TRW_STMT_RCD , STMT.THRUDATE , TMPL.TRW_PRINTABLE_SW , SECT.TRW_SUMMARY_SW , SECT.TRW_CHART_SW , SECT.TRW_CHART_TYPE , SECT.TRW_SEQ_NUM , SECT.TRW_PV_LABEL_SW , SECT.TRW_INCL_COMPROV , SECT.TRW_INCL_EMPLRPAID , SECT.TRW_INCL_EMPLYPAID , SECT.TRW_INCL_ITEMNAME , SECT.TRW_INCL_ER_TOT , SECT.TRW_INCL_ER_EE_TOT , SECT.TRW_INCL_PCT_TOT , SECT.TRW_INCL_SPLIT FROM PS_TRW_STMT_TBL STMT , PS_TRW_TEMPLATE TMPL , PS_TRW_TEMPL_SECT SECT , PS_TRW_EE_STMT_SEC EESC WHERE TMPL.TEMPLATE_ID = SECT.TEMPLATE_ID AND STMT.TRW_STMT_ID = EESC.TRW_STMT_ID AND SECT.TRW_SECTION_ID = EESC.TRW_SECTION_ID AND TMPL.EFFDT = SECT.EFFDT AND TMPL.EFF_STATUS = 'A' AND TMPL.EFFDT = ( SELECT MAX(ED.EFFDT) FROM PS_TRW_TEMPLATE ED WHERE ED.TEMPLATE_ID = TMPL.TEMPLATE_ID AND ED.EFFDT <= STMT.THRUDATE ) AND EESC.TRW_RW_ITEM_ID = ( SELECT MIN(RW.TRW_RW_ITEM_ID) FROM PS_TRW_EE_STMT_SEC RW WHERE RW.TRW_STMT_ID = STMT.TRW_STMT_ID AND RW.EMPLID = EESC.EMPLID AND RW.TRW_STMT_RCD = EESC.TRW_STMT_RCD AND RW.TRW_SECTION_ID = EESC.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 | TEMPLATE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Template ID |
| 3 | TRW_SECTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Section ID for sections in total rewards template.setup |
| 4 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | TRW_STMT_RCD |
Number(3,0) | SMALLINT NOT NULL | Statement Record |
| 6 | THRUDATE | Date(10) | DATE | End Date |
| 7 | TRW_PRINTABLE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Display Expanded View Only
Y/N Table Edit Default Value: N |
| 8 | TRW_SUMMARY_SW | Character(1) | VARCHAR2(1) NOT NULL |
Summary checkbox to indicate if the section is identified as summary.
Y/N Table Edit Default Value: N |
| 9 | TRW_CHART_SW | Character(1) | VARCHAR2(1) NOT NULL |
An indicator to indicate whether a chart is displayed or not.
Y/N Table Edit Default Value: N |
| 10 | TRW_CHART_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Identifies the chart type to use in Total Rewards Statements. It is a subset of chart types from tools field PTPPB_CHART_TYPE.
0=2 Dimensional Bar 6=2 Dimensional Pie 7=3 Dimensional Bar 9=3 Dimensional Pie Default Value: 6 |
| 11 | TRW_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Display Sequence |
| 12 | TRW_PV_LABEL_SW | Character(1) | VARCHAR2(1) NOT NULL | Grid Labels for Printable View |
| 13 | TRW_INCL_COMPROV | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 14 | TRW_INCL_EMPLRPAID | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 15 | TRW_INCL_EMPLYPAID | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 16 | TRW_INCL_ITEMNAME | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 17 | TRW_INCL_ER_TOT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Employer Total column will be displayed in Total Rewards Statement. |
| 18 | TRW_INCL_ER_EE_TOT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Employer/Employee Total column will be displayed in Total Rewards Statement. |
| 19 | TRW_INCL_PCT_TOT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Percent of Total column will be displayed in Total Rewards Statement. |
| 20 | TRW_INCL_SPLIT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Contribution Split column will be displayed in Total Rewards Statement. |