CP_MULTOP_DETL (SQL Table)	Index Back
CP Multiple Option Detail CP Multiple Option Detail

CP_MULTOP_DETL

(SQL Table)

CP Multiple Option Detail

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

2 CP_MULT_TABLE Character(18) VARCHAR2(18) NOT NULL Multiple Option FIeld

3 CP_OPTION_NAME Character(18) VARCHAR2(18) NOT NULL Option Variable Name Field
Prompt Table: CP_OPT_VAR_VW

4 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.
2	CP_MULT_TABLE	Character(18)	VARCHAR2(18) NOT NULL	Multiple Option FIeld
3	CP_OPTION_NAME	Character(18)	VARCHAR2(18) NOT NULL	Option Variable Name Field Prompt Table: CP_OPT_VAR_VW
4	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.