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 NameField TypeColumn TypeDescription
MC_DEFN_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Definition
MC_TEMPLATE_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Template ID
MC_TYPE_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Type ID
OPRCLASSCharacter(30)VARCHAR2(30) NOT NULLOperator Class
ARCHIVE_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19