MC_DEFN_IDMC_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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |