FIXEDEXPR_TAO

index back

Qry Upgrd Tmp Activity Object


PeopleSoft Field Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
EXPNUM Number(3,0) SMALLINT NOT NULL Expression Number
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
LENGTH Number(5,0) INTEGER NOT NULL Length
DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
USECOUNT Number(3,0) SMALLINT NOT NULL Use Count
UPDATECOMPLT Number(3,0) SMALLINT NOT NULL Update Complete Flag
EXPRESSIONTEXT Long Character CLOB Expression Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19