IB_XSLTBLD_VW

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

Y/N Table Edit

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

Y/N Table Edit

14 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
15 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.
16 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.
17 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier
18 AEPROGTYPE Character(1) VARCHAR2(1) NOT NULL Appl Engine Program Type
19 TEMPTBLINSTANCES Number(4,0) SMALLINT NOT NULL Temp Table Instances (Total)
20 RECUSE Number(5,0) INTEGER NOT NULL Record Use. Audit Option bit values
21 LICENSE_CODE Character(64) VARCHAR2(64) NOT NULL License Code
22 DESCRLONG Long Character CLOB Long Description