PSCUBRUNPARM

index back

Cube Query Prompt Fields


  • Parent record: PSCUBRUNCNTL
  • PeopleSoft Field Name Field Type Column Type Description
    OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    CUB_OUTLINEID Character(30) VARCHAR2(30) NOT NULL Outline Name (see PSCUBOUTLINE).
    QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    CUB_FIELDTYPE Character(20) VARCHAR2(20) NOT NULL Field Type
    CUB_FNUMBER Signed Number(23,3) DECIMAL(21,3) NOT NULL Numeric Field
    CUB_FCHAR Character(254) VARCHAR2(254) NOT NULL Character Data
    CUB_FDATE Date(10) DATE Date Field
    CUB_FDATETIME DateTime(26) TIMESTAMP Datetime Field
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19