SCD_TEMPL_SECT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCD_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID
2	SCD_VERSION_NBR	Number(5,0)	INTEGER NOT NULL	Version Number
3	SCD_SECTION_ID	Character(10)	VARCHAR2(10) NOT NULL	Section ID
4	SCD_SEQ_NBR	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 1
5	SCD_SECTION_NAME	Character(30)	VARCHAR2(30) NOT NULL	Section Name
6	SCD_SECTION_GROUP	Character(15)	VARCHAR2(15) NOT NULL	Section Type Prompt Table: SCD_SECT_GRPS
7	SCD_RATIN_MODEL_ID	Character(10)	VARCHAR2(10) NOT NULL	Rating Model ID Prompt Table: SCD_RATINMODELS
8	SCD_WEIGHT	Number(6,2)	DECIMAL(5,2) NOT NULL	Weight
9	SCD_SECTION_DESC	Character(254)	VARCHAR2(254) NOT NULL	Section Description
10	SCD_IDEAL_SCORE	Number(10,6)	DECIMAL(9,6) NOT NULL	Ideal Score
11	SCD_BENCHMRK_SCORE	Number(10,6)	DECIMAL(9,6) NOT NULL	Benchmark Score
12	CREATEDTTM	DateTime(26)	TIMESTAMP	DateTime of Query Creation
13	CREATED_BY	Character(30)	VARCHAR2(30) NOT NULL	Created By
14	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
15	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
16	SCD_INSTRUCTIONS	Long Character	CLOB	Instructions
17	SCD_SECT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	SCD Section Type C=Combo K=KPI S=Subjective Default Value: S