PSCUBOUTQRYINF

index back

Cube Query Prompt Fields


PeopleSoft Field NameField TypeColumn TypeDescription
CUB_OUTLINEIDCharacter(30)VARCHAR2(30) NOT NULLOutline Name (see PSCUBOUTLINE).
QRYNAMECharacter(30)VARCHAR2(30) NOT NULLQuery Name
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
BNDNUMNumber(3,0)SMALLINT NOT NULLBind Number
CUB_FIELDTYPECharacter(20)VARCHAR2(20) NOT NULLField Type
CUB_FNUMBERSigned Number(23,3)DECIMAL(21,3) NOT NULLNumeric Field
CUB_FCHARCharacter(254)VARCHAR2(254) NOT NULLCharacter Data
CUB_FDATEDate(10)DATEDate Field
CUB_FDATETIMEDateTime(26)TIMESTAMPDatetime Field
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19