IB_XSLTBLD_VW

index back

AE Application Defn


SELECT AE_APPLID , INROOTELEMENT , INMSGNAME , INMSGVERSION , OUTROOTELEMENT , OUTMSGNAME , OUTMSGVERSION , DESCR , AE_DATE_OVERRIDE , ASOF_DT , MESSAGE_SET_NBR , AE_APPLLIBRARY , AE_DISABLE_RESTART , VERSION , LASTUPDOPRID , LASTUPDDTTM , OBJECTOWNERID , AEPROGTYPE , TEMPTBLINSTANCES , RECUSE , LICENSE_CODE , DESCRLONG FROM PSAEAPPLDEFN WHERE AEPROGTYPE = '4'

PeopleSoft Field NameField TypeColumn TypeDescription
AE_APPLIDCharacter(12)VARCHAR2(12) NOT NULLProgram Name (see PSAEAPPLDEFN).
INROOTELEMENTCharacter(50)VARCHAR2(50) NOT NULLIn Root Element
INMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
INMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLIn Message Version
OUTROOTELEMENTCharacter(50)VARCHAR2(50) NOT NULLOut Root Element
OUTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition.
OUTMSGVERSIONCharacter(30)VARCHAR2(30) NOT NULLOut Message Version
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
AE_DATE_OVERRIDECharacter(1)VARCHAR2(1) NOT NULLOverride Current Date
N=Use Current Date
Y=Override
ASOF_DTDate(10)DATEAs of Date
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
AE_APPLLIBRARYCharacter(1)VARCHAR2(1) NOT NULLApplication Library

Y/N Table Edit

AE_DISABLE_RESTARTCharacter(1)VARCHAR2(1) NOT NULLDisable Restart

Y/N Table Edit

VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
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.
OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
AEPROGTYPECharacter(1)VARCHAR2(1) NOT NULLAppl Engine Program Type
TEMPTBLINSTANCESNumber(4,0)SMALLINT NOT NULLTemp Table Instances (Total)
RECUSENumber(5,0)INTEGER NOT NULLRecord Use. Audit Option bit values
LICENSE_CODECharacter(64)VARCHAR2(64) NOT NULLLicense Code
DESCRLONGLong CharacterCLOBLong Description
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19