MC_DEFN_IDMC_DEFN_PT_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | MC_DEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Mass Change Definition |
| 2 | MC_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Template ID |
| 3 | MC_TYPE_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Type ID |
| 4 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 5 | ARCHIVE_ID | Character(8) | VARCHAR2(8) NOT NULL | Archive ID |