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 NameField TypeColumn TypeDescription
PS_OWNERCharacter(2)VARCHAR2(2) NOT NULLPeopleSoft 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_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Template ID
OPRCLASSCharacter(30)VARCHAR2(30) NOT NULLOperator Class
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19