TEMPLATE_IDTRW_SECTION_IDY/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
0=2 Dimensional Bar
6=2 Dimensional Pie
7=3 Dimensional Bar
9=3 Dimensional Pie
Default Value: 6
TRW_PRV_STMT_VW(SQL View) |
Index Back |
|---|---|
Template Sections ViewUsed by fluid Total Rewards to load section information for Preview Statement. |
| SELECT TMPL.TEMPLATE_ID , SECT.TRW_SECTION_ID , TMPL.EFFDT , 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_TEMPLATE TMPL , PS_TRW_TEMPL_SECT SECT WHERE TMPL.TEMPLATE_ID = SECT.TEMPLATE_ID AND TMPL.EFFDT = SECT.EFFDT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TEMPLATE_ID |
Character(15) | VARCHAR2(15) NOT NULL | Template ID |
| 2 | TRW_SECTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Section ID for sections in total rewards template.setup |
| 3 | THRUDATE | Date(10) | DATE | End Date |
| 4 | TRW_PRINTABLE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Display Expanded View Only
Y/N Table Edit Default Value: N |
| 5 | 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 |
| 6 | 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 |
| 7 | 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 |
| 8 | TRW_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | Display Sequence |
| 9 | TRW_PV_LABEL_SW | Character(1) | VARCHAR2(1) NOT NULL | Grid Labels for Printable View |
| 10 | TRW_INCL_COMPROV | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 11 | TRW_INCL_EMPLRPAID | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 12 | TRW_INCL_EMPLYPAID | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 13 | TRW_INCL_ITEMNAME | Character(1) | VARCHAR2(1) NOT NULL | Summary checkbox to indicate if the section is identified as summary. |
| 14 | TRW_INCL_ER_TOT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Employer Total column will be displayed in Total Rewards Statement. |
| 15 | TRW_INCL_ER_EE_TOT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Employer/Employee Total column will be displayed in Total Rewards Statement. |
| 16 | TRW_INCL_PCT_TOT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Percent of Total column will be displayed in Total Rewards Statement. |
| 17 | TRW_INCL_SPLIT | Character(1) | VARCHAR2(1) NOT NULL | Indicates whether Contribution Split column will be displayed in Total Rewards Statement. |