AE_APPL_TMP

index back

Application Definition Temp


PeopleSoft Field NameField TypeColumn TypeDescription
AE_PRODUCTCharacter(2)VARCHAR2(2) NOT NULLProduct
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_IDCharacter(8)VARCHAR2(8) NOT NULLApplication
AE_VERSIONNumber(6,2)DECIMAL(5,2) NOT NULLVersion
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
AE_DATE_OVERRIDECharacter(1)VARCHAR2(1) NOT NULLOverride Current Date
N=Use Current Date
Y=Override

Default: N

ASOF_DTDate(10)DATEAs of Date
LAST_DTTM_UPDATEDateTime(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.
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
AE_CACHE_RECNAMECharacter(15)VARCHAR2(15) NOT NULLCache Record

Prompt Table: AE_CACHE_REC_VW

AE_SYMBOLICS_PROGCharacter(8)VARCHAR2(8) NOT NULLSymbolics Handler

Default: PTPESYMB

AE_FILTER_PROG_1Character(8)VARCHAR2(8) NOT NULLFilter 1

Default: PTPESYMF

AE_FILTER_PROG_2Character(8)VARCHAR2(8) NOT NULLFilter 2
AE_FILTER_PROG_3Character(8)VARCHAR2(8) NOT NULLFilter 3
AE_USE_PLATFORMCharacter(1)VARCHAR2(1) NOT NULLPlatform Override
AE_DEF_TRN_CTLCharacter(1)VARCHAR2(1) NOT NULLDefault Transaction Control
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.

Prompt Table: PSMSGSETDEFN

AE_DEBUG_MODECharacter(1)VARCHAR2(1) NOT NULLDebug Application

Y/N Table Edit

Default: N

AE_TRACECharacter(1)VARCHAR2(1) NOT NULLTrace Application Steps
N=Off
S=SQL
Y=Steps only
Z=Abend Trap

Default: N

AE_FORCE_COMMITCharacter(1)VARCHAR2(1) NOT NULLForce Commit after each Step

Y/N Table Edit

Default: N

AE_FORCE_ABENDCharacter(1)VARCHAR2(1) NOT NULLForce Abend after each Commit

Y/N Table Edit

Default: N

AE_COMMIT_MSGCharacter(1)VARCHAR2(1) NOT NULLIssue Message for each Commit

Y/N Table Edit

Default: N

AE_DISABLE_RESTARTCharacter(1)VARCHAR2(1) NOT NULLDisable Restart

Y/N Table Edit

Default: N

AE_CHUNK_FACTORNumber(3,0)SMALLINT NOT NULLChunk Factor
AE_CHUNK_METHODCharacter(1)VARCHAR2(1) NOT NULLChunking Method
D=Section Description
E=Section Name
S=Step Name

Default: D

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19