MC_TEMPLATE(SQL Table) |
Index Back |
---|---|
Mass Change Template |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(30) | VARCHAR2(30) NOT NULL | Mass Change Template ID | |
2 | MC_TYPE_ID | Character(30) | VARCHAR2(30) NOT NULL |
Mass Change Type ID
Prompt Table: MC_TYPE_VW |
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 |