AE_PTTSUNDO_AET

index back

Temporary record 2 for alloc

Temporary record 1 for application engine allocation process

PeopleSoft Field NameField TypeColumn TypeDescription
PROCESS_INSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
TS_SRCH_IDCharacter(30)VARCHAR2(30) NOT NULLText Search Identifier
TS_SRCH_STATUSCharacter(1)VARCHAR2(1) NOT NULLSearch Status
C=Complete
I=In Process
N=New Search
R=Replace Complete
S=Search Complete
U=Undo Complete
TS_RPLC_RDYCharacter(1)VARCHAR2(1) NOT NULLReplace Ready
LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
BASE_LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code
BASELINECharacter(1)VARCHAR2(1) NOT NULLBaseline
TS_RESULT_SEQNumber(5,0)INTEGER NOT NULLResult Sequence Number
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
RECNAME_TMPCharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name
SQLTABLENAMECharacter(18)VARCHAR2(18) NOT NULLSQL Table Name
TABLE_NAMECharacter(30)VARCHAR2(30) NOT NULLTable Name
RELLANGRECNAMECharacter(15)VARCHAR2(15) NOT NULLRelated Language Record Name
TS_COMBINEDCharacter(1)VARCHAR2(1) NOT NULLCombined Language Table
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
TS_UNDOCharacter(1)VARCHAR2(1) NOT NULLUndo
TS_BASE_TEXTCharacter(254)VARCHAR2(254) NOT NULLBase Text
TS_LANG_TEXTCharacter(254)VARCHAR2(254) NOT NULLNon-Base Text
TS_RPLC_TEXTCharacter(254)VARCHAR2(254) NOT NULLReplacement Text
FIELDTYPENumber(2,0)SMALLINT NOT NULLField Type (from PSST0101)
LENGTHNumber(5,0)INTEGER NOT NULLLength
FIELDNAME0Character(18)VARCHAR2(18) NOT NULLName of Field
TS_KEY_CHARCharacter(50)VARCHAR2(50) NOT NULLCharacter Field Key
TS_KEY_NUMBERNumber(31,0)DECIMAL(31) NOT NULLNumeric Key Field
TS_KEY_DATEDate(10)DATEDate Key Field
FLDFIELDTYPENumber(2,0)SMALLINT NOT NULLField Type
SQL_STMT_254Character(254)VARCHAR2(254) NOT NULLAn internal work field that contains SQL text that is to be utilized in treasury application p
PTREFRESHCharacter(1)VARCHAR2(1) NOT NULLLoad Netting Rows
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19