PSCUBDIMSTRINFO

index back

PeopleSoft Field Name Field Type Column Type Description
CUB_DIMENSIONID Character(30) VARCHAR2(30) NOT NULL Dimension Name (see PSCUBDIMENSION).
CUB_SEQNUM Number(10,0) DECIMAL(10) NOT NULL Sequence Number
SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
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