AE_APPL_TBL

index back

Application Definitions


PeopleSoft Field Name Field Type Column Type Description
AE_PRODUCT Character(2) VARCHAR2(2) NOT NULL Product
AE=PS/AE
AM=PS/AM
AP=PS/AP
AR=PS/AR
BI=PS/BI
EO=PS/EO
EX=PS/EX
FS=PS/FS
GL=PS/GL
HR=PS/HR
IN=PS/IN
OM=PS/OM
PC=PS/PC
PO=PS/PO
TR=PS/TR
AE_APPL_ID Character(8) VARCHAR2(8) NOT NULL Application
AE_VERSION Number(6,2) DECIMAL(5,2) NOT NULL 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

Default: N

ASOF_DT Date(10) DATE As of Date
LAST_DTTM_UPDATE 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.
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
AE_CACHE_RECNAME Character(15) VARCHAR2(15) NOT NULL Cache Record

Prompt Table: AE_CACHE_REC_VW

AE_SYMBOLICS_PROG Character(8) VARCHAR2(8) NOT NULL Symbolics Handler

Default: PTPESYMB

AE_FILTER_PROG_1 Character(8) VARCHAR2(8) NOT NULL Filter 1

Default: PTPESYMF

AE_FILTER_PROG_2 Character(8) VARCHAR2(8) NOT NULL Filter 2
AE_FILTER_PROG_3 Character(8) VARCHAR2(8) NOT NULL Filter 3
AE_USE_PLATFORM Character(1) VARCHAR2(1) NOT NULL Platform Override
AE_DEF_TRN_CTL Character(1) VARCHAR2(1) NOT NULL Default Transaction Control
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Prompt Table: PSMSGSETDEFN

AE_DEBUG_MODE Character(1) VARCHAR2(1) NOT NULL Debug Application

Y/N Table Edit

Default: N

AE_TRACE Character(1) VARCHAR2(1) NOT NULL Trace Application Steps
N=Off
S=SQL
Y=Steps only
Z=Abend Trap

Default: N

AE_FORCE_COMMIT Character(1) VARCHAR2(1) NOT NULL Force Commit after each Step

Y/N Table Edit

Default: N

AE_FORCE_ABEND Character(1) VARCHAR2(1) NOT NULL Force Abend after each Commit

Y/N Table Edit

Default: N

AE_COMMIT_MSG Character(1) VARCHAR2(1) NOT NULL Issue Message for each Commit

Y/N Table Edit

Default: N

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

Y/N Table Edit

Default: N

AE_CHUNK_FACTOR Number(3,0) SMALLINT NOT NULL Chunk Factor
AE_CHUNK_METHOD Character(1) VARCHAR2(1) NOT NULL Chunking Method
D=Section Description
E=Section Name
S=Step Name

Default: D

AE_ADJ_DTTM DateTime(26) TIMESTAMP Last Adjustments
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19