TRW_TEMPL_SECT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Template ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	TRW_SECTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Section ID for sections in total rewards template.setup
4	TRW_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Display Sequence
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_PV_LABEL_SW	Character(1)	VARCHAR2(1) NOT NULL	Grid Labels for Printable View Y/N Table Edit Default Value: N
9	TRW_INCL_COMPROV	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary. Y/N Table Edit Default Value: N
10	TRW_INCL_EMPLRPAID	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary. Y/N Table Edit Default Value: N
11	TRW_INCL_EMPLYPAID	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary. Y/N Table Edit Default Value: N
12	TRW_INCL_ITEMNAME	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary. Y/N Table Edit Default Value: Y
13	TRW_INCL_ER_TOT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Employer Total column will be displayed in Total Rewards Statement. Default Value: N
14	TRW_INCL_ER_EE_TOT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Employer/Employee Total column will be displayed in Total Rewards Statement. Default Value: N
15	TRW_INCL_PCT_TOT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Percent of Total column will be displayed in Total Rewards Statement. Default Value: N
16	TRW_INCL_SPLIT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Contribution Split column will be displayed in Total Rewards Statement. Default Value: N
17	TRW_EMPCOMMUN_ONE	Long Character	CLOB	Track progress document - mgr comments at item level