Oracle jgaicc

avril 19, 2011

Co-Operative PeopleTools Table Reference – PSVERSION – Manager notification versions

Filed under: Uncategorized — jgaicc @ 11:41

PSVERSION

Return to Index

This table holds a version number for each type of cached object defined in the PeopleTools tables.  Each time an object is created, updated or deleted, both the global version number (OBJECTTYPENAME=SYS) and the version number that corresponds to the type of object are incremented.  The new object version number is written to the updated object.  However, if the object is deleted, a row will be written to the deleted object table (where the version number is usually a part of the unique key).  The version numbers are stored in the PeopleTools caches, and hence PeopleTools programs can determine whether the object definitions in the cache are up to date by comparing the version numbers.

PeopleSoft Field Name
Description

OBJECTTYPENAME

Object Type Name
Record Name
Deleted Objects Record Name
Object Type

ACM
PSACTIVITYDEFN
PSACTIVITYDEL
Activity

AEM
PSAEAPPLDEFN
PSAEAPPLDEL
Application Engine

AES
PSAESECTDEFN
PSAESECTDEL
Application Engine Section

ARCOM
PSARCHOBJDEFN
PSARCHOBJDEL
Archiving Object

APM
PSPACKAGEDEFN
PSPACKAGEDEL
Application Package

BCM
PSBCDEFN
PSBCDEL
Component Interface

BPM
PSBUSPROCDEFN
PSBUSPROCDEL
Business Process

CLM
PSCLASSDEFN
PSCLASSDEL
Permission List

FILEM
PSFILEDEFN
PSFILEDEL
Files

FLM
PSFLDDEFN
PSFLDDEL
File Layout

FRM
PSFILEREDEFN
PSFILEREDEFNDELL

GTM
PSGATEWAY
PSGATEWAYDEL
Integration Broker Gateway

JPUP

PSJPUPDEFN

PSJPUPDEL

MSDM

PSMSGDEFN

PSMSGDEL
Application Messaging

OPRM
PSOPERATION
PSOEPRATIONDEL
Integration Broker Service

PCM
PSPCMPROG
PSPCMPROGDEL
PeopleCode Program

PDM
PSPNLDEFN
PSPNLDEL
Page (Panel)

PGM
PSPNLGRPDEFN
PSPNLGRPDEL
Component (Panel Group)

PJM
PSPROJECTDEFN
PSPROJECTDEL
Project Definition

PRSM
PSPRSMDEFN
PSPRSMDEL
Portal Registry

PRUF
PSPRUFDEFN
PSPRUFDEL
Portal Registry Favourite

PRUH
PSPRUHDEFN
PSPRUHDEL
Portal User Homepage

PSR
PS_PRCSRECUR
PSRECURDEL
Process Scheduler Recurrences

QDM
PSQRYDEFN
PSQRYDEL
Query Definition Manager

QUEM
PSQUEUEDEFN
PSQUEUEDEFNDEL
IB Queue Manager

RDM
PSRECDEFN

PSDBFIELD

PSRECDEL
Record Definition

ROLM
PSROLEDEFN
PSROLEDEL
Security Role Definition

RTDM
PSIBRTNGDEFN
PSIBRTNGDEFNDEL
Integration Broker Routing

UPM
PSOPRDEFN
PSOPRDEL
User Profile Definition

SRM
PSSQLDEFN
PSSQLDEL
SQL Definition

SYS
Global version number.  This number is updated when any of the other versions are incremented.

TDM

TAM

PSTREEDEFN
PSTREEDEL
Tree Definition

TSM
PSTREESTRCT
PSTREESTRDEL
Tree Structure
</TR< td>

TYC
PSTYPECODEDEFN
PSTYPECODEDEL
File Type

XPDSM
PSXPDATASRC
PSXPDATASRCDEL
XML Data Source

XRRDM
PSXPRPTDEFN
PSXPRPTDEFNDEL
XML Report

XTM
PSXLATDEFN
PSXLATDEFNDEL
Translate Value

XTRDM
PSXPTMPLDEFN
PSXPTMPLDEFNDEL
XML Publish Template

VERSION
Version

Author: David Kurtz

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 04 October 2010

Co-Operative PeopleTools Table Reference – PSVERSION – Manager notification versions

Laisser un commentaire »

Aucun commentaire pour l’instant.

RSS feed for comments on this post. TrackBack URI

Laisser un commentaire

Entrez vos coordonnées ci-dessous ou cliquez sur une icône pour vous connecter:

Logo WordPress.com

Vous commentez à l'aide de votre compte WordPress.com. Déconnexion / Changer )

Image Twitter

Vous commentez à l'aide de votre compte Twitter. Déconnexion / Changer )

Photo Facebook

Vous commentez à l'aide de votre compte Facebook. Déconnexion / Changer )

Photo Google+

Vous commentez à l'aide de votre compte Google+. Déconnexion / Changer )

Connexion à %s

Propulsé par WordPress.com.

%d blogueurs aiment cette page :