PSCUBCONNECTID

index back

Cube connection definitions.

Hyperion Essbase connection information.

  • Related language record: PSCUBCONNLANG
  • PeopleSoft Field Name Field Type Column Type Description
    CUB_CONNECTID Character(30) VARCHAR2(30) NOT NULL Essbase Connection ID
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    ANALYSIS_DB_SERVER Character(30) VARCHAR2(30) NOT NULL Database Server
    ESS_USER_ACCESS Character(1) VARCHAR2(1) NOT NULL User Access
    C=Calculate
    D=Design
    N=None
    R=Read-Only
    W=Read-Write

    Default: R

    ANL_DB_LOGON_ID Character(30) VARCHAR2(30) NOT NULL User Name
    CUB_ESSPWD Character(88) VARCHAR2(88) NOT NULL Essbase Password
    UNICODE_ENABLED Number(1,0) SMALLINT NOT NULL Unicode Enabled

    1/0 Table Edit (1=True, 0=False)

    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    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.
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20