MC_TEMPLATE_VW

index back

Mass Change Template View


select a.ps_owner, a.mc_template_id, b.oprid from ps_mc_template a, ps_mc_opr_security b where a.mc_template_id = b.mc_template_id

PeopleSoft Field Name Field Type Column Type Description
PS_OWNER Character(2) VARCHAR2(2) NOT NULL PeopleSoft Owner
AM=Asset Management
AP=Accounts Payable
AR=Accounts Receivable
BI=Billing
GL=General Ledger
HR=Human Resources
IN=Inventory
PC=Project Costing
PO=Purchasing
PT=PeopleTools
SA=Student Administration
TL=Time and Labor
MC_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Template ID
OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19