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 Name Field Type Column Type Description
AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
INROOTELEMENT Character(50) VARCHAR2(50) NOT NULL In Root Element
INMSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
INMSGVERSION Character(30) VARCHAR2(30) NOT NULL In Message Version
OUTROOTELEMENT Character(50) VARCHAR2(50) NOT NULL Out Root Element
OUTMSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition.
OUTMSGVERSION Character(30) VARCHAR2(30) NOT NULL Out Message Version
DESCR Character(30) VARCHAR2(30) NOT NULL Description
AE_DATE_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Current Date
N=Use Current Date
Y=Override
ASOF_DT Date(10) DATE As of Date
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
AE_APPLLIBRARY Character(1) VARCHAR2(1) NOT NULL Application Library

Y/N Table Edit

AE_DISABLE_RESTART Character(1) VARCHAR2(1) NOT NULL Disable Restart

Y/N Table Edit

VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies 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.
LASTUPDDTTM 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.
OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
AEPROGTYPE Character(1) VARCHAR2(1) NOT NULL Appl Engine Program Type
TEMPTBLINSTANCES Number(4,0) SMALLINT NOT NULL Temp Table Instances (Total)
RECUSE Number(5,0) INTEGER NOT NULL Record Use. Audit Option bit values
LICENSE_CODE Character(64) VARCHAR2(64) NOT NULL License Code
DESCRLONG Long Character CLOB Long Description
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19