MC_DEFN

index back

Mass Change Definition


PeopleSoft Field NameField TypeColumn TypeDescription
MC_DEFN_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Definition
MC_TYPE_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Type ID
DTTM_STAMPDateTime(26)TIMESTAMPSpecifies 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_OWNERCharacter(2)VARCHAR2(2) NOT NULLPeopleSoft 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
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
MC_TEMPLATE_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Template ID

Prompt Table: MC_TEMPLATE_VW

MC_NULL_DTDate(10)DATEMass Change Null Date
MC_NULL_DTTM_STAMPDateTime(26)TIMESTAMPMass Change Null Timestamp
MC_NULL_TIMETime(15)TIMESTAMPMass Change Null Time
ARCHIVE_IDCharacter(8)VARCHAR2(8) NOT NULLArchive ID

Prompt Table: MC_ARCHIVE_DEFN

ARCHIVE_DTDate(10)DATEArchive Date
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19