Showing posts with label Peoplesoft Records. Show all posts
Showing posts with label Peoplesoft Records. Show all posts

Friday, March 18, 2011

PSPCMPROG - Table stores PeopleCode of the objects | Explanation

Below information about the table that stores PSPCMPROG the PeopleCode of objects.
PSPCMPROG -
Key Fields :OBJECTID1, OBJECTID2, OBJECTID3, OBJECTID4, OBJECTID5, OBJECTID6, OBJECTID7
ObjectID values reference

1Record
2Field
3Menu
4Bar Name
5Item Name
9Page
10Component
12Event
20Database Type
21Effective Date
39Market
60Message
66Application Engine Program
74Component Interface
77Section
78Step
87Subscription
104Application Package
105Class
106Class
107Class

Key Fields: OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4, OBJECTVALUE5, OBJECTVALUE6, OBJECTVALUE7
Refers to object name.
Key Field: PROGSEQ
Refers to Program sequence number
Non Key Fields:
VERSION                 Version 
NAMECOUNT           ?? 
PROGLEN                 PeopleCode Program Length 
PROGRUNLOC           Program Run Location 
PROGFLAGS             ?? 
LICENSE_CODE         License Code 
LASTUPDDTTM         the date and time of the last update to the entry
LASTUPDOPRID        the OPRID which made the last update to the entry 
PROGEXTENDS         ?? 
PROGTXT                 PeopleCode Program

Tuesday, November 9, 2010

PeopleSoft OBJECTTYPE


PeopleSoft OBJECTTYPE:
0RecordPSRECDEFN
1IndexesPSKEYDEFN
2FieldsPSDBFIELD
3Field FormatsPSFMTDEFN
4TranslatesPSXLATITEM
5PagesPSPNLDEFN
6MenusPSMENUDEFN
7ComponentsPSPNLGRPDEFN
8Record PeopleCodePSPCMPROG
9Menu PeopleCodePSPCMPROG
10QueriesPSQRYDEFN
11Tree StructuresPSTREESTRCT
12TreesPSTREEDEFN
13Access GroupsPS_ACCESS_GRP_TBL
14ColoursPSCOLORDEFN
15StylesPSSTYLEDEFN
17Business ProcessesPSBUSPROCDEFN
18ActivitiesPSACTIVITYDEFN
19RolesPSROLEDEFN
20Process DefinitionsPRCSDEFN
21Server DefinitionsPS_SERVERDEFN
22Process Type DefinitionsPS_PRCSTYPEDEFN
23Job DefinitionsPS_PRCSJOBDEFN
24Recurrence DefinitionsPS_PRCSRECUR
25Message Catalog EntriesPSMSGCATDEFN
26Dimension DefinitionPS_DIMENSION
27Cube DefinitionTO_Find
28Cube Instance DefinitionTO_Find
29Business InterlinkPSIODEFN
30SQLPSSQLDESCR
31File Layout DefinitionsPSFLDDEFN
32Component InterfacesPSBCDEFN
33Application Engine ProgramsPSAEAPPLDEFN
34Application Engine SectionsPSAESECTDEFN
35Message NodesPSMSGNODEDEFN
36Message ChannelsPSMSGCATDEFN
37Message DefinitionsPSMSGDEFN
38Approval Rule SetAPPR_RULE_HDR
39Message PeopleCodePSPCMPROG
40Subscription PeopleCodePSPCMPROG
42Comp. Interface PeopleCodePSPCMPROG
43Application Engine PeopleCodePSPCMPROG
44Page PeopleCodePSPCMPROG
46Component PeopleCodePSPCMPROG
47Component Record PeopleCodePSPCMPROG
48Component Rec Fld PeopleCodePSPCMPROG
49ImagesPSCONTDEFN
52File ReferencesPSFILEREDEFN
53Permission ListsPSCLASSDEFN
54Portal Registry DefinitionsTO_Find
55Portal Registry StructuresPSPRSMDEFN
56URL DefinitionsPSURLDEFN
57Application PackagesPSPACKAGEDEFN
58Application Package PeopleCodePSPCMPROG
60Analytic TypesTO_Find
62XSLTTO_Find
64Mobile PagesPSMPDEFN
68File ReferencesPSFILEREDEFN
69File Type CodesPSTYPECODEDEFN
72Dignostic Plug InsTO_Find
73Analytic ModelsTO_Find
79ServicePSSERVICE
80Service OperationPSOPERATION
81Service Operation HandlerPSOPRHDLR
82Service Operation VersionPSOPRVERDFN
83Service Operation RoutingSIBRTNGDEFN
84IB QueuesSIBQUEUEINST
85XLMP Template Definition
86XLMP Report Definition
87XMLP File Definition
88XMPL Data Source Definition