PSPTPN_MSG_TBL

index back

PeopleSoft Field NameField TypeColumn TypeDescription
PTPN_CATEGORY_NAMECharacter(50)VARCHAR2(50) NOT NULLCategory Name
PTPN_EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLEvent Name
PTPN_NODENAMECharacter(30)VARCHAR2(30) NOT NULLNode Name
PTPN_CAT_ALIASCharacter(50)VARCHAR2(50) NOT NULLCategory Alias
PTPN_CATEGORY_TYPECharacter(10)VARCHAR2(10) NOT NULLCategory Type
PTPN_CATEGORY_CNTCharacter(10)VARCHAR2(10) NOT NULLCategory Count
PTPN_CAT_DATA_KEYCharacter(100)VARCHAR2(100) NOT NULLData Key
PTPN_DATA_MSG_INFOCharacter(250)VARCHAR2(250) NOT NULLMessage Info
PTPN_ONCLICK_LINKCharacter(250)VARCHAR2(250) NOT NULLOnclick
PTPN_MSG_STATECharacter(10)VARCHAR2(10) NOT NULLMessage State
PTPN_ACTIONS_LABELCharacter(200)VARCHAR2(200) NOT NULLActions Label
PTPN_ACTIONS_LINKLong CharacterCLOBMessage Actions
LASTUPDDTTMDateTime(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.
ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
INSTANCEIDNumber(10,0)DECIMAL(10) NOT NULLFor a given worklist the unique number of rows in PSWORKLIST
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19