CP_INT_VAR_VW (SQL View)	Index Back
Internal Variable for Matrix This view is used to automatically populate the Matrix Header Panel with the Variable Type, Variable Length, and Decimal Places SELECT Distinct SETID, FIELDNAME_CP, CP_FLDTYPE, CP_SYSLENGTH, CP_SYSDECIMAL FROM PS_CP_INTRN_VAR

CP_INT_VAR_VW

(SQL View)

Internal Variable for Matrix

This view is used to automatically populate the Matrix Header Panel with the Variable Type, Variable Length, and Decimal Places SELECT Distinct SETID, FIELDNAME_CP, CP_FLDTYPE, CP_SYSLENGTH, CP_SYSDECIMAL FROM PS_CP_INTRN_VAR

SELECT SETID , FIELDNAME_CP , CP_VARIABLE_DESCR FROM PS_CP_INTRN_VAR

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

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