PTIASPPKGTSTCVW

index back

SELECT O.PTIASPPKGGUID , O.PROJECTNAME , O.OBJECTTYPE , I.DESCR254 , O.OBJECTVALUE1 , O.OBJECTVALUE2 , O.OBJECTVALUE3 , O.OBJECTVALUE4 , O.PTIA_COUNTER FROM PS_PTIASPPKGTSTOBJ O , PS_PTIASPINTCODES I WHERE O.OBJECTTYPE=I.PTIASPINTVALUE AND I.PTIASPLOOKUPCODE = 'OBJTYPE'

PeopleSoft Field Name Field Type Column Type Description
PTIASPPKGGUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
PTIA_COUNTER Number(10,0) DECIMAL(10) NOT NULL PTIA Counter
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20