CP_OPT_VAR (SQL Table)	Index Back
CP Option Variable Table CP Option Variable Table

CP_OPT_VAR

(SQL Table)

CP Option Variable Table

Related Language Record: CP_VAR_LNG

# 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.
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CP_VARIABLE Character(18) VARCHAR2(18) NOT NULL Variable Field

3 CP_VARIABLE_DESCR Character(30) VARCHAR2(30) NOT NULL Variable Description Field

4 CP_VALUE_TYPE Character(1) VARCHAR2(1) NOT NULL Value Type Field
C=Character
N=Number

5 CP_VARIABLE_LEN Number(2,0) SMALLINT NOT NULL Variable Length Field

6 CP_VARIABLE_DECI Number(1,0) SMALLINT NOT NULL Variable Decimal Field

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	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	CP_VARIABLE	Character(18)	VARCHAR2(18) NOT NULL	Variable Field
3	CP_VARIABLE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Variable Description Field
4	CP_VALUE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Value Type Field C=Character N=Number
5	CP_VARIABLE_LEN	Number(2,0)	SMALLINT NOT NULL	Variable Length Field
6	CP_VARIABLE_DECI	Number(1,0)	SMALLINT NOT NULL	Variable Decimal Field
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.