CP_CONSTRT_COND (SQL Table)	Index Back
CP Constraint Condition Record CP Constraint Condition Record

CP_CONSTRT_COND

(SQL Table)

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

2 CP_CONSTRAINT Character(10) VARCHAR2(10) NOT NULL Constraint Field

3 CP_SEQ Number(3,0) SMALLINT NOT NULL Sequence Field
Default Value: 1

4 CP_CONDITION_EXPR Character(18) VARCHAR2(18) NOT NULL Condition Expression ID Field
Prompt Table: CP_EXPR

5 CP_MESSAGE_ID Character(18) VARCHAR2(18) NOT NULL Message ID Field
Prompt Table: CP_MESSAGE

6 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_CONSTRAINT	Character(10)	VARCHAR2(10) NOT NULL	Constraint Field
3	CP_SEQ	Number(3,0)	SMALLINT NOT NULL	Sequence Field Default Value: 1
4	CP_CONDITION_EXPR	Character(18)	VARCHAR2(18) NOT NULL	Condition Expression ID Field Prompt Table: CP_EXPR
5	CP_MESSAGE_ID	Character(18)	VARCHAR2(18) NOT NULL	Message ID Field Prompt Table: CP_MESSAGE
6	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.