MC_DEFN_SA_VW(SQL View) |
Index Back |
|---|---|
Mass Change CS Definition |
| select a.mc_defn_id, b.oprid, a.ps_owner, a.mc_template_id, a.mc_type_id from ps_mc_defn a, ps_mc_opr_security b where a.mc_template_id = b.mc_template_id and a.ps_owner = 'SA' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  MC_DEFN_ID |
Character(30) | VARCHAR2(30) NOT NULL | Mass Change Definition |
| 2 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 3 | PS_OWNER | Character(2) | VARCHAR2(2) NOT NULL |
PeopleSoft Owner
AM=Asset Management AP=Accounts Payable AR=Accounts Receivable BI=Billing GL=General Ledger HR=Human Resources IN=Inventory PC=Project Costing PO=Purchasing PT=PeopleTools SA=Student Administration TL=Time and Labor |
| 4 | MC_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Mass Change Template ID
Prompt Table: MC_TEMPLATE |
| 5 | MC_TYPE_ID | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Type ID |