CP_INTRN_KEY (SQL Table)	Index Back
CP Internal Variable Key Info CP Internal Variable Key Info

CP_INTRN_KEY

(SQL Table)

CP Internal Variable Key Info

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 FIELDNAME_CP Character(18) VARCHAR2(18) NOT NULL CP Variable Name Field

3 CP_SYSKEYNUM Number(3,0) SMALLINT NOT NULL System Key Number Field
Default Value: 1

4 TABLE_FIELD Character(20) VARCHAR2(20) NOT NULL System Field Name
Prompt Table: CP_SYSRECFLD_VW

5 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_INT_VW

6 CP_KEYVALUE Character(18) VARCHAR2(18) NOT NULL Key Variable Value Field
Prompt Table: %EDITTABLE10

7 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	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	FIELDNAME_CP	Character(18)	VARCHAR2(18) NOT NULL	CP Variable Name Field
3	CP_SYSKEYNUM	Number(3,0)	SMALLINT NOT NULL	System Key Number Field Default Value: 1
4	TABLE_FIELD	Character(20)	VARCHAR2(20) NOT NULL	System Field Name Prompt Table: CP_SYSRECFLD_VW
5	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_INT_VW
6	CP_KEYVALUE	Character(18)	VARCHAR2(18) NOT NULL	Key Variable Value Field Prompt Table: %EDITTABLE10
7	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.