CP_INTRN_VAR (SQL Table)	Index Back
CP Internal Varaibles CP Internal Varaibles

CP_INTRN_VAR

(SQL Table)

CP Internal Varaibles

Related Language Record: CP_INTRNVAR_LNG

Parent Record Of CP_INTRN_KEY CP_INTRN_KEY_VW

# 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 FIELDNAME_CP Character(18) VARCHAR2(18) NOT NULL CP Variable Name Field

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

4 CP_INTRN_TYPE Character(1) VARCHAR2(1) NOT NULL Internal Variable Type Field
0=Standard
1=Custom
Default Value: 0

5 CP_SQL Long Character CLOB SQL Field

6 TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
Prompt Table: CP_SYSREC_VW

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

8 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	FIELDNAME_CP	Character(18)	VARCHAR2(18) NOT NULL	CP Variable Name Field
3	CP_VARIABLE_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Variable Description Field
4	CP_INTRN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Internal Variable Type Field 0=Standard 1=Custom Default Value: 0
5	CP_SQL	Long Character	CLOB	SQL Field
6	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name Prompt Table: CP_SYSREC_VW
7	TABLE_FIELD	Character(20)	VARCHAR2(20) NOT NULL	System Field Name Prompt Table: CP_SYSRECFLD_VW
8	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.