PSPTMERGEDEC

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GUID Character(36) VARCHAR2(36) NOT NULL Unique Identifier
2 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
3 PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).
4 PTADSCONTENTID Number(6,0) INTEGER NOT NULL ADS Content Identifier
5 PTMERGEACTION Number(3,0) SMALLINT NOT NULL Merge Action
6 PTMERGESTATUS Number(3,0) SMALLINT NOT NULL Merge Status
7 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.
8 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.