PSPTMERGEGRPINS (SQL Table)	Index Back
Group instance merge decision Record for maining group instance level merge decisions. It contains both row-level and field-level merge decisions. This record is intended to be used by the ADS framework only.

PSPTMERGEGRPINS

(SQL Table)

Group instance merge decision

Record for maining group instance level merge decisions. It contains both row-level and field-level merge decisions. This record is intended to be used by the ADS framework only.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier

2 PTGROUPNAME Character(40) VARCHAR2(40) NOT NULL Group Code

3 PTKEYHASH Character(28) VARCHAR2(28) NOT NULL

4 PTDIFFTYPE Number(3,0) SMALLINT NOT NULL Difference Type

5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

6 PTMERGEACTION Number(3,0) SMALLINT NOT NULL Merge Action

7 PTMERGESTATUS Number(3,0) SMALLINT NOT NULL Merge Status

8 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.

9 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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GUID	Character(36)	VARCHAR2(36) NOT NULL	Unique Identifier
2	PTGROUPNAME	Character(40)	VARCHAR2(40) NOT NULL	Group Code
3	PTKEYHASH	Character(28)	VARCHAR2(28) NOT NULL
4	PTDIFFTYPE	Number(3,0)	SMALLINT NOT NULL	Difference Type
5	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
6	PTMERGEACTION	Number(3,0)	SMALLINT NOT NULL	Merge Action
7	PTMERGESTATUS	Number(3,0)	SMALLINT NOT NULL	Merge Status
8	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.
9	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.