CP_INTRN_KEY_VW

(SQL View)
 Index Back

CP Internal Variable Key Info

CP Internal Variable Key Info

SELECT setid , fieldname_cp , cp_syskeynum , table_field , var_intl_cd , cp_keyvalue , lastupddttm FROM PS_CP_INTRN_KEY

  • Parent record: CP_INTRN_VAR

    • # 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_SYSKEYNUM Number(3,0) SMALLINT NOT NULL System Key Number Field

    Default Value: 1

    4 TABLE_FIELD Character(20) VARCHAR2(20) NOT NULL System Field Name

    Prompt Table: CP_SYSRECFLD_VW

    5 VAR_INTL_CD Character(2) VARCHAR2(2) NOT NULL International Variable Type
    01=Option
    02=Secondary
    03=Global
    04=Matrix
    05=Internal
    06=Multiple Option
    07=Value List
    08=External Program
    09=Character
    10=Number
    11=Literal
    12=Boolean
    14=Constant
    15=Expression
    16=Message
    6 CP_KEYVALUE Character(18) VARCHAR2(18) NOT NULL Key Variable Value Field

    Prompt Table: %EDITTABLE10

    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.