TRW_SEC_INFO

#	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_SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Display Sequence
6	TRW_SUMMARY_SW	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary. Y/N Table Edit
7	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
8	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
9	TRW_PV_LABEL_SW	Character(1)	VARCHAR2(1) NOT NULL	Grid Labels for Printable View Y/N Table Edit Default Value: N
10	TRW_TOT_ER_AMT	Signed Number(23,6)	DECIMAL(21,6) NOT NULL	Total Employer Amount
11	TRW_TOT_EE_AMT	Signed Number(23,6)	DECIMAL(21,6) NOT NULL	Total Employee Amount
12	TRW_TOT_CP_AMT	Signed Number(23,6)	DECIMAL(21,6) NOT NULL	Total Company Provided Amount
13	TRW_ITEM_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the item column label text.
14	TRW_ER_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the employer pays column label text.
15	TRW_EE_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the employee pays column label text.
16	TRW_CP_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the company provided column label text.
17	TRW_ERTOT_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the employer total column label text.
18	TRW_EETOT_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the employer/employee total column label text.
19	TRW_PCT_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the percent of total column label text.
20	TRW_SPLIT_COL_LBL	Character(30)	VARCHAR2(30) NOT NULL	Holds the contribution split column label text.
21	TRW_INCL_COMPROV	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary.
22	TRW_INCL_EMPLRPAID	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary.
23	TRW_INCL_EMPLYPAID	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary.
24	TRW_INCL_ITEMNAME	Character(1)	VARCHAR2(1) NOT NULL	Summary checkbox to indicate if the section is identified as summary.
25	TRW_INCL_ER_TOT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Employer Total column will be displayed in Total Rewards Statement.
26	TRW_INCL_ER_EE_TOT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Employer/Employee Total column will be displayed in Total Rewards Statement.
27	TRW_INCL_PCT_TOT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Percent of Total column will be displayed in Total Rewards Statement.
28	TRW_INCL_SPLIT	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether Contribution Split column will be displayed in Total Rewards Statement.