CP_TEMP_DETL (SQL Table)	Index Back
CP Template Detail CP Template Detail Record

CP_TEMP_DETL

(SQL Table)

CP Template Detail

CP Template Detail Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW

2 CP_TEMPLATE_ID Character(10) VARCHAR2(10) NOT NULL Template ID Field

3 CP_TMPL_SEQ Number(4,0) SMALLINT NOT NULL Template Sequence Field
Default Value: 1

4 FROM_POSITION Number(4,0) SMALLINT NOT NULL Template Field From Position

5 TO_POSITION Number(4,0) SMALLINT NOT NULL Template Field To Position

6 POSITION_DESC Character(30) VARCHAR2(30) NOT NULL Template Position Description

7 VAR_INTL_CD Character(2) VARCHAR2(2) NOT NULL International Variable Type
01=Option
02=Secondary
03=Global
04=Matrix
05=Internal
06=Multiple Option
07=Value List
08=External Program
09=Character
10=Number
11=Literal
12=Boolean
14=Constant
15=Expression
16=Message
Prompt Table: CP_VAR_TMP_VW

8 POSITION_VALUE Character(18) VARCHAR2(18) NOT NULL Template Position Value
Prompt Table: %EDITTABLE

9 CP_USER_CD Character(10) VARCHAR2(10) NOT NULL Value List Field
Prompt Table: CP_USERCD_VW2

10 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Prompt Table: SP_SETID_NONVW
2	CP_TEMPLATE_ID	Character(10)	VARCHAR2(10) NOT NULL	Template ID Field
3	CP_TMPL_SEQ	Number(4,0)	SMALLINT NOT NULL	Template Sequence Field Default Value: 1
4	FROM_POSITION	Number(4,0)	SMALLINT NOT NULL	Template Field From Position
5	TO_POSITION	Number(4,0)	SMALLINT NOT NULL	Template Field To Position
6	POSITION_DESC	Character(30)	VARCHAR2(30) NOT NULL	Template Position Description
7	VAR_INTL_CD	Character(2)	VARCHAR2(2) NOT NULL	International Variable Type 01=Option 02=Secondary 03=Global 04=Matrix 05=Internal 06=Multiple Option 07=Value List 08=External Program 09=Character 10=Number 11=Literal 12=Boolean 14=Constant 15=Expression 16=Message Prompt Table: CP_VAR_TMP_VW
8	POSITION_VALUE	Character(18)	VARCHAR2(18) NOT NULL	Template Position Value Prompt Table: %EDITTABLE
9	CP_USER_CD	Character(10)	VARCHAR2(10) NOT NULL	Value List Field Prompt Table: CP_USERCD_VW2
10	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.