EOTR_BUILD_AET

(SQL Table)
 Index Back

Project Build AE Temp Table

Internal Use Only - AE temporary table for translation project build process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EOTR_BUILD_ALL Character(1) VARCHAR2(1) NOT NULL Build Project for All Products
3 EOTR_PROJ_PREFIX Character(15) VARCHAR2(15) NOT NULL Project Prefix
4 EOTR_PROJ_SUFFIX Character(15) VARCHAR2(15) NOT NULL Project Suffix
5 IF_FLAG Character(1) VARCHAR2(1) NOT NULL If flag
6 PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
7 EOTR_PRODUCT Character(6) VARCHAR2(6) NOT NULL Product
8 EOTR_RUN_MODE Character(1) VARCHAR2(1) NOT NULL Translatable Project Source
E=Entire Database
P=Project
9 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
10 EOTR_PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name
11 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter
12 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
13 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
14 EOTR_PROJNM_FORMAT Character(1) VARCHAR2(1) NOT NULL Project Name Format
B=Both Prefix and Suffix
P=Prefix Only
S=Suffix Only
15 EOTR_REBUILD_FLG Character(1) VARCHAR2(1) NOT NULL Recreate Projects
16 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
  • SQLTYPE = 0: SQL object name
  • SQLTYPE = 1: Application Engine Step Identifier
  • SQLTYPE = 2: RECNAME
  • SQLTYPE = 6: Application Engine XSLT (XML definition)
    • 17 SQL_TEXT1 Character(254) VARCHAR2(254) NOT NULL SQL Text 1
    18 SQL_STMT_800 Long Character(800) VARCHAR2(800) SQL_Stmt_800