PSCUBCONNECTID

(SQL Table)
 Index Back

Cube connection definitions.

Hyperion Essbase connection information.

  • Related Language Record: PSCUBCONNLANG

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

    Default Value: R

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

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

    9 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
    10 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.
    11 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.
    12 DESCRLONG Long Character CLOB Long Description