MC_DEFN_IDPrompt Table: MC_TEMPLATE
OPRCLASSPrompt Table: MC_ARCHIVE_DEFN
MC_DEFN_AM_VW(SQL View) |
Index Back |
|---|---|
Mass Change AM Definition |
| 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_AM b, ps_mc_opr_security c where a.mc_defn_id = b.mc_defn_id and a.mc_template_id = c.mc_template_id and a.ps_owner = 'AM' |
| # | 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
Prompt Table: MC_TEMPLATE |
| 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
Prompt Table: MC_ARCHIVE_DEFN |