PTIAMRGHSQL (SQL Table)	Index Back
SQL Shadow History Table This is an SQL/XSLT Shadow History Table used for 3Way Merge feature in Change Assistant. The information about the different versions used in Merge Analysis and Promotion -- are saved in this table.

PTIAMRGHSQL

(SQL Table)

SQL Shadow History Table

This is an SQL/XSLT Shadow History Table used for 3Way Merge feature in Change Assistant. The information about the different versions used in Merge Analysis and Promotion -- are saved in this table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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)

2 SQLTYPE Character(1) VARCHAR2(1) NOT NULL SQL Object type
0=SQL Object referenced from elsewhere
1=Application Engine Step
2=SQL View
5=Queries for DDDAUDIT and SYSAUDIT
6= Application Engine Step XSLT

3 MARKET Character(3) VARCHAR2(3) NOT NULL Market

4 DBTYPE Character(1) VARCHAR2(1) NOT NULL Database Type
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/UNIX
5=AllBase
6=Sybase
7=Microsoft
8=DB2/400

5 EFFDT Date(10) DATE Effective Date

6 PTMRGOBJVER Character(30) VARCHAR2(30) NOT NULL This field is to keep the version of shadow table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.

7 PTMERGEDVERSION Character(30) VARCHAR2(30) NOT NULL This field is to save the merged version on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.

8 PTUPDDATETIME DateTime(26) TIMESTAMP This field is to save the last update date time on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.

9 PTUPDOPRID Character(30) VARCHAR2(30) NOT NULL This field is to save the last update operator id on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.

10 PTMERGENAME Character(30) VARCHAR2(30) NOT NULL This field is to save the merge name on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.

11 PTPUMIMAGEVERSION Character(30) VARCHAR2(30) NOT NULL This field is to save the PUM image version on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.

12 PTISACTIVE Character(1) VARCHAR2(1) NOT NULL This field is to ensure if the row is enabled/disabled on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.

13 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies 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.

14 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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)
2	SQLTYPE	Character(1)	VARCHAR2(1) NOT NULL	SQL Object type 0=SQL Object referenced from elsewhere 1=Application Engine Step 2=SQL View 5=Queries for DDDAUDIT and SYSAUDIT 6= Application Engine Step XSLT
3	MARKET	Character(3)	VARCHAR2(3) NOT NULL	Market
4	DBTYPE	Character(1)	VARCHAR2(1) NOT NULL	Database Type 0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/UNIX 5=AllBase 6=Sybase 7=Microsoft 8=DB2/400
5	EFFDT	Date(10)	DATE	Effective Date
6	PTMRGOBJVER	Character(30)	VARCHAR2(30) NOT NULL	This field is to keep the version of shadow table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
7	PTMERGEDVERSION	Character(30)	VARCHAR2(30) NOT NULL	This field is to save the merged version on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
8	PTUPDDATETIME	DateTime(26)	TIMESTAMP	This field is to save the last update date time on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
9	PTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	This field is to save the last update operator id on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
10	PTMERGENAME	Character(30)	VARCHAR2(30) NOT NULL	This field is to save the merge name on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
11	PTPUMIMAGEVERSION	Character(30)	VARCHAR2(30) NOT NULL	This field is to save the PUM image version on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
12	PTISACTIVE	Character(1)	VARCHAR2(1) NOT NULL	This field is to ensure if the row is enabled/disabled on the merge history table of PeopleCode & SQL/XSLT used for 3Way Merge feature in Change Assistant.
13	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies 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.
14	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.