CP_GBL_VAR

(SQL Table)
Index Back

CP Global Variable Table

CP Global Variable Table

  • Related Language Record: CP_GBL_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.