Download - People Soft Object Type and Record Name
-
8/7/2019 People Soft Object Type and Record Name
1/30
Object ID Object Type0 Record1 Indexes2 Fields3 Field Formats4 Translates
5 Pages6 Menus7 Components8 Record PeopleCode9 Menu PeopleCode
10 Queries11 Tree Structures12 Trees13 Access Groups14 Colours15 Styles17 Business Processes18 Activities19 Roles20 Process Definitions21 Server Definitions22 Process Type Definitions23 Job Definitions24 Recurrence Definitions
25 Message Catalog Entries26 Dimension Definition27 Cube Definition28 Cube Instance Definition29 Business Interlink30 SQL31 File Layout Definitions32 Component Interfaces33 Application Engine Programs34 Application Engine Sections35 Message Nodes36 Message Channels37 Message Definitions38 Approval Rule Set39 Message PeopleCode40 Subscription PeopleCode42 Comp. Interface PeopleCode43 Application Engine PeopleCode44 Page PeopleCode
46 Component PeopleCode47 Component Record PeopleCode48 Component Rec Fld PeopleCode49 Images
-
8/7/2019 People Soft Object Type and Record Name
2/30
52 File References53 Permission Lists54 Portal Registry Definitions55 Portal Registry Structures56 URL Definitions57 Application Packages
58 Application Package PeopleCode60 Analytic Types62 XSLT64 Mobile Pages68 File References69 File Type Codes72 Dignostic Plug Ins73 Analytic Models79 Service80 Service Operation81 Service Operation Handler 82 Service Operation Version83 Service Operation Routing84 IB Queues85 XLMP Template Definition86 XLMP Report Definition87 XMLP File Definition88 XMPL Data Source Definition
A summary of the main PeopleTools security records.
Operators
Record Description
PSOPRDEFN
PSROLEUSER
Stores all operators (users) in the PeopleSoft system. Alsostores their employee ID (EMPLID), encrypted password,primary permission list, default navigator home page,process profile permission list and row security permission list.
The highest level of security access is defined by roles(think of them as groups). This table stores the roles theuser belongs to.
-
8/7/2019 People Soft Object Type and Record Name
3/30
PSOPRCLS
PSOPRALIAS
PSOPRALIASTYPE This is the setup table for operator aliases
PSOPRALIASFIELD
PSUSERATTR
PSUSEREMAIL Email addresses for users.
Roles
Record Description
PSROLEDEFN
PSROLECLASS
Permission Lists
Record Description
PSCLASSDEFN
PSAUTHITEM The link between permission lists and menus
PSAUTHBUSCOMP
Roles link together permission lists which are the security objects that define access to components, pages, and otherareas of the system. This view returns the permission liststhat a user has access to via their roles. Note that prior toPeopleTools 8, permission lists were synonymous withclasses and most of the security tables still use thisconvention.
Aliases can be mapped to a particular operator ID (user).The obvious alias is employee ID (EMPLID) but othersinclude external organisation ID (EXT_ORG_ID) andcustomer ID (CUST_ID). All ways of referring to the sameentity .
This is the setup table that maps operator aliases to
records & fields
User attributes store the a hint password question &response for a user (if this is enabled)
Stores roles and their properties. Roles can be assi
Roles are made of up of one or permission lists, and thistable links the two together. Very handy.
Permission lists are where the security really happens.They provide access to menus, components and pages anda host of other security including PeopleTools, Processsecurity, Component Interfaces, Web Libraries, WebServices, Personalisations, Query and Mass Change.
The link between permission lists and component i
http://peoplesoft.wikidot.com/workflowhttp://peoplesoft.wikidot.com/component-interfaceshttp://peoplesoft.wikidot.com/component-interfaceshttp://peoplesoft.wikidot.com/workflow -
8/7/2019 People Soft Object Type and Record Name
4/30
PSAUTHOPTN The link between permission lists and personalisations
PSAUTHPRCS The link between permission lists and process groups
PSAUTHSIGNON The link between permission lists and signon times
PSAUTHWEBLIBVW
PSAUTHWS
PS_SCRTY_ACC_GRP
PS_MC_OPR_SECURITY
Portal
The PeopleSoft Enterprise Portal basically refers to the navigation system that l
Record Description
PSPRSMDEFN
PSPRSMPERM
Useful Queries
Find out which users (and from what permission lists) have access to a particul
);
A view linking permission lists and access to web li The link between permission lists and web services(service operations)
The link between permission lists, trees and query
The link between permission lists and mass change
Check out this forum post for details about how to check which users have
Stores the structure of the portal registry. This data isstored in a hierarchical (tree) structure within the table.The field PORTAL_URI_SEG1 is the menu,PORTAL_URI_SEG2 is the component, andPORTAL_URI_SEG3 is the market.
Stores permission lists associated with access toeverything within the portal registry
select distinct OPRID, OPRCLASSfrom PSOPRCLSwhere OPRCLASS in (select distinct CLASSIDfrom sysadm.PSAUTHITEM
where PNLITEMNAME = ''
http://peoplesoft.wikidot.com/web-librarieshttp://peoplesoft.wikidot.com/peoplesoft-queryhttp://peoplesoft.wikidot.com/mass-changehttp://peoplesoft.wikidot.com/forum/t-140027http://peoplesoft.wikidot.com/forum/t-140027http://peoplesoft.wikidot.com/mass-changehttp://peoplesoft.wikidot.com/peoplesoft-queryhttp://peoplesoft.wikidot.com/web-libraries -
8/7/2019 People Soft Object Type and Record Name
5/30
Credit History -CREDIT_HISTORY
Tuition Calc -TUIT_CALC_TBLCALC_MESSAGESOPT_FEE_STDNT
Group Post -GROUP_CONT_INFOGROUP_LINE
Cashiering -CSH_BD_CSH_OPENCSH_OFF_RECEIPTCSH_OFF_RCPT_LCSH_OFF_RCPT_T
TP_CONTRACTTP_STUDENT
Refunds -REFUND_HDR REFUND_DTLREFUND_CHECK
Collections -COLLECTION_SF
1098-T Reporting -SF_1098_DTL_SFSF_1098_ITEM
GL Interface -SF_ACCTG_LN
Other CampusSolutions StudentFinancials TablesCHARBIN (guest) 6 May2010, 05:09 GMT+0800
Third Party Contracts/DeferralContracts/Payment Plans-
-
8/7/2019 People Soft Object Type and Record Name
6/30
Optional Fees -OPT_FEE_STDNT
Tuition Group Setup -SEL_GROUP_TBL
SEL_GROUP_CRITR GROUP_FEE_TBL
Criteria Setup -SEL_CRITER_TBLSEL_CRITR_TBLSEL_VALUE_TBL
Term Fee Setup -TERM_FEE_TBLTERM_FE_CD_TBLTERM_SF_CD_TBLTERM_SUBFEE_TBL
Waiver Setup - WAIVER_CODE_TBL WAIVER_TBL
Item Type Setup -
ITEM_TYPE_TBLITEM_ACCT_TYPEGL_INTERFACE
Billing -BI_BILL_HEADER BI_BILLING_LINEBI_BILL_MESSAGEBI_STD_REQ_TBL
-
8/7/2019 People Soft Object Type and Record Name
7/30
Record NamePSRECDEFNPSKEYDEFNPSDBFIELDPSFMTDEFNPSXLATITEM
PSPNLDEFNPSMENUDEFNPSPNLGRPDEFNPSPCMPROGPSPCMPROGPSQRYDEFNPSTREESTRCTPSTREEDEFNPS_ACCESS_GRP_TBLPSCOLORDEFNPSSTYLEDEFNPSBUSPROCDEFNPSACTIVITYDEFNPSROLEDEFNPRCSDEFNPS_SERVERDEFNPS_PRCSTYPEDEFNPS_PRCSJOBDEFNPS_PRCSRECUR
PSMSGCATDEFNPS_DIMENSIONTO_FindTO_FindPSIODEFNPSSQLDESCRPSFLDDEFNPSBCDEFNPSAEAPPLDEFNPSAESECTDEFNPSMSGNODEDEFNPSMSGCATDEFNPSMSGDEFNAPPR_RULE_HDRPSPCMPROGPSPCMPROGPSPCMPROGPSPCMPROGPSPCMPROG
PSPCMPROGPSPCMPROGPSPCMPROGPSCONTDEFN
-
8/7/2019 People Soft Object Type and Record Name
8/30
PSFILEREDEFNPSCLASSDEFNTO_FindPSPRSMDEFNPSURLDEFNPSPACKAGEDEFN
PSPCMPROGTO_FindTO_FindPSMPDEFNPSFILEREDEFNPSTYPECODEDEFNTO_FindTO_FindPSSERVICEPSOPERATIONPSOPRHDLRPSOPRVERDFNSIBRTNGDEFNSIBQUEUEINST
-
8/7/2019 People Soft Object Type and Record Name
9/30
-
8/7/2019 People Soft Object Type and Record Name
10/30
inks menus and components to the PeopleSoft
ar page:
ccess to PeopleTools.
http://peoplesoft.wikidot.com/forum/t-140027http://peoplesoft.wikidot.com/forum/t-140027 -
8/7/2019 People Soft Object Type and Record Name
11/30
-
8/7/2019 People Soft Object Type and Record Name
12/30
-
8/7/2019 People Soft Object Type and Record Name
13/30
PSPROJECTITEM.OBJECTTYPE0 = 'Record'
1 = 'Index'
2 = 'Field'
3 = 'Field Format'
4 = 'Translate Value'
5 = 'Pages'6 = 'Menus'
7 = 'Components'
8 = 'Record PeopleCode'
9 = 'Menu PeopleCode'
10 = 'Query'
11 = 'Tree Structures'
12 = 'Trees'
13 = 'Access group'
14 = 'Color'
15 = 'Style'
16 = 'N/A'
17 = 'Business process'
18 = 'Activity'
19 = 'Role'
20 = 'Process Definition'
21 = 'Server Definition'
22 = 'Process Type Definition'
23 = 'Job Definitions'
24 = 'Recurrence Definition'25 = 'Message Catalog'
26 = 'Dimension'
27 = 'Cube Definitions'
28 = 'Cube Instance Definitions'
29 = 'Business Interlink'
30 = 'SQL'
31 = 'File Layout Definition'
32 = 'Component Interfaces'
33 = 'AE program'
34 = 'AE section'
35 = 'Message Node'
36 = 'Message Channel'
37 = 'Message'
38 = 'Approval rule set'
39 = 'Message PeopleCode'
40 = 'Subscription PeopleCode'
41 = 'N/A'
42 = 'Component Interface PeopleCode'
43 = 'AE PeopleCode'44 = 'Page PeopleCode'
45 = 'Page Field PeopleCode'
46 = 'Component PeopleCode'
-
8/7/2019 People Soft Object Type and Record Name
14/30
47 = 'Component Record PeopleCode'
48 = 'Component Rec Fld PeopleCode'
49 = 'Image'
50 = 'Style sheet'
51 = 'HTML'
52 = 'Not used'
53 = 'Permission List'54 = 'Portal Registry Definitions'
55 = 'Portal Registry Structures'
56 = 'URL Definitions'
57 = 'Application Packages'
58 = 'Application Package Peoplecode'
59 = 'Portal Registry User Homepage'
60 = 'Problem Type'
61 = 'Archive Templates'
62 = 'XSLT'
63 = 'Portal Registry User Favorite'
64 = 'Mobile Page'
65 = 'Relationships'
66 = 'Component Interface Property Peoplecode'
67 = 'Optimization Models'
68 = 'File References'
69 = 'File Type Codes'
70 = 'Archive Object Definitions'
71 = 'Archive Templates (Type 2)'
72 = 'Diagnostic Plug In'73 = 'Analytic Model'
-
8/7/2019 People Soft Object Type and Record Name
15/30
-
8/7/2019 People Soft Object Type and Record Name
16/30
nline interface, navigation and search functionality. Access to anything in the online a
-
8/7/2019 People Soft Object Type and Record Name
17/30
-
8/7/2019 People Soft Object Type and Record Name
18/30
-
8/7/2019 People Soft Object Type and Record Name
19/30
-
8/7/2019 People Soft Object Type and Record Name
20/30
-
8/7/2019 People Soft Object Type and Record Name
21/30
-
8/7/2019 People Soft Object Type and Record Name
22/30
plication is handled through portal security. The records associated with this includ
-
8/7/2019 People Soft Object Type and Record Name
23/30
-
8/7/2019 People Soft Object Type and Record Name
24/30
-
8/7/2019 People Soft Object Type and Record Name
25/30
-
8/7/2019 People Soft Object Type and Record Name
26/30
-
8/7/2019 People Soft Object Type and Record Name
27/30
-
8/7/2019 People Soft Object Type and Record Name
28/30
e:
-
8/7/2019 People Soft Object Type and Record Name
29/30
-
8/7/2019 People Soft Object Type and Record Name
30/30