MC_DEFN_PT_VW

index back

Mass Change Defn Tools View


SELECT a.mc_defn_id , a.mc_template_id , a.mc_type_id , c.oprid , a.archive_id FROM ps_mc_defn a , ps_mc_defn_pt b , ps_mc_opr_security c WHERE a.mc_defn_id = b.mc_defn_id AND a.mc_template_id = c.mc_template_id

PeopleSoft Field Name Field Type Column Type Description
MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
MC_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Template ID
MC_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Type ID
OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
ARCHIVE_ID Character(8) VARCHAR2(8) NOT NULL Archive ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19