AE_PTTSRPLC_AET

index back

Temporary record 2 for alloc

Temporary record 1 for application engine allocation process

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
TS_SRCH_ID Character(30) VARCHAR2(30) NOT NULL Text Search Identifier
TS_SRCH_STATUS Character(1) VARCHAR2(1) NOT NULL Search Status
C=Complete
I=In Process
N=New Search
R=Replace Complete
S=Search Complete
U=Undo Complete
TS_RPLC_RDY Character(1) VARCHAR2(1) NOT NULL Replace Ready
LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
BASE_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
BASELINE Character(1) VARCHAR2(1) NOT NULL Baseline
TS_RESULT_SEQ Number(5,0) INTEGER NOT NULL Result Sequence Number
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
SQLTABLENAME Character(18) VARCHAR2(18) NOT NULL SQL Table Name
TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name
TS_COMBINED Character(1) VARCHAR2(1) NOT NULL Combined Language Table
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
TS_RPLC Character(1) VARCHAR2(1) NOT NULL Replace
TS_RPLC_TEXT Character(254) VARCHAR2(254) NOT NULL Replacement Text
FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101)
LENGTH Number(5,0) INTEGER NOT NULL Length
FIELDNAME0 Character(18) VARCHAR2(18) NOT NULL Name of Field
TS_KEY_CHAR Character(50) VARCHAR2(50) NOT NULL Character Field Key
TS_KEY_NUMBER Number(31,0) DECIMAL(31) NOT NULL Numeric Key Field
TS_KEY_DATE Date(10) DATE Date Key Field
FLDFIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type
SQL_STMT_254 Character(254) VARCHAR2(254) NOT NULL An internal work field that contains SQL text that is to be utilized in treasury application p
PTREFRESH Character(1) VARCHAR2(1) NOT NULL Load Netting Rows
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19