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
MC_TEMPLATE_IDOPRCLASSMC_TEMPLATE_VW(SQL View) |
Index Back |
|---|---|
Mass Change Template View |
| select a.ps_owner, a.mc_template_id, b.oprid from PS_MC_TEMPLATE a, ps_mc_opr_security b where a.mc_template_id = b.mc_template_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |
| 2 | MC_TEMPLATE_ID |
Character(30) | VARCHAR2(30) NOT NULL | Mass Change Template ID |
| 3 | OPRCLASS |
Character(30) | VARCHAR2(30) NOT NULL | Operator Class |