PSCUBOUTQRYINF

index back

Cube Query Prompt Fields


PeopleSoft Field Name Field Type Column Type Description
CUB_OUTLINEID Character(30) VARCHAR2(30) NOT NULL Outline Name (see PSCUBOUTLINE).
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
BNDNUM Number(3,0) SMALLINT NOT NULL Bind Number
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