MC_DEFN

index back

Mass Change Definition


PeopleSoft Field Name Field Type Column Type Description
MC_DEFN_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Definition
MC_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Type ID
DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default: %Date

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
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
MC_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Template ID

Prompt Table: MC_TEMPLATE_VW

MC_NULL_DT Date(10) DATE Mass Change Null Date
MC_NULL_DTTM_STAMP DateTime(26) TIMESTAMP Mass Change Null Timestamp
MC_NULL_TIME Time(15) TIMESTAMP Mass Change Null Time
ARCHIVE_ID Character(8) VARCHAR2(8) NOT NULL Archive ID

Prompt Table: MC_ARCHIVE_DEFN

ARCHIVE_DT Date(10) DATE Archive Date
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19