PSPTPACKAGEDEFV

index back

Application Package Defn


SELECT PACKAGEID , PACKAGEROOT , PACKAGELEVEL , PACKAGEREF , LASTUPDOPRID , LASTUPDDTTM , OBJECTOWNERID , VERSION FROM PSPACKAGEDEFN WHERE QUALIFYPATH = '.'

PeopleSoft Field NameField TypeColumn TypeDescription
PACKAGEIDCharacter(30)VARCHAR2(30) NOT NULLPackage Name (see PSDIAGREG).
PACKAGEROOTCharacter(30)VARCHAR2(30) NOT NULLRoot Package ID
PACKAGELEVELNumber(2,0)SMALLINT NOT NULLPackage Level
PACKAGEREFCharacter(30)VARCHAR2(30) NOT NULLPackage ID Reference
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19