PTIA_DTLIDTBLS

(SQL Table)
 Index Back

Upgrade Tables

This table contains tables that are used in the upgrade process. This is analyzed data from the PTIA_ANALYSIS table. Fields: DETAIL_ID >> Uniquely identifies what appengine action the code came from. PTIA_SQLNUM >> Counter of the statements found in PTIA_ANALYSIS.STMT_TEXT. TABLE_NAME >> The table name that is used by the app engine action code. PTIA_TABLEUSAGE >> Indicates the TABLE_NAME is used as a Target (T) or Source (S). PTIA_TABLETYPE >> PTIA_INFO1 >> Just carried over from PTIA_ANALYSIS PTIA_INFO2 >> Just carried over from PTIA_ANALYSIS PTIA_INFO3 >> Just carried over from PTIA_ANALYSIS PTIA_INFO4 >> Just carried over from PTIA_ANALYSIS PTIA_INFO5 >> Just carried over from PTIA_ANALYSIS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIA_GUID Character(36) VARCHAR2(36) NOT NULL  
2 DETAIL_ID Character(100) VARCHAR2(100) NOT NULL Detail line identifer
3 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
4 PTIA_UPG_PATH Character(15) VARCHAR2(15) NOT NULL Definition of supported upgrade paths
5 PTIA_DBTYPE Character(10) VARCHAR2(10) NOT NULL DBType
6 PTIA_UPG_CONV_TYPE Character(4) VARCHAR2(4) NOT NULL Upgrade Conversion Type
DDL=DDL Conversion Group
MAIN=Main Conversion Group
PRE=Pre Conversion Group
7 PTIA_SQLNUM Number(3,0) SMALLINT NOT NULL SQL Number
8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
9 TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
10 PTIA_TABLEUSAGE Character(1) VARCHAR2(1) NOT NULL Table Operation
11 PTIA_TABLETYPE Character(1) VARCHAR2(1) NOT NULL Table Type
12 PTIA_INFO1 Character(100) VARCHAR2(100) NOT NULL Information1
13 PTIA_INFO2 Character(100) VARCHAR2(100) NOT NULL Information2
14 PTIA_INFO3 Character(100) VARCHAR2(100) NOT NULL Information3
15 PTIA_INFO4 Character(100) VARCHAR2(100) NOT NULL Information4
16 PTIA_INFO5 Character(100) VARCHAR2(100) NOT NULL Information5