PTUALTRECDATA

index back

Alter Analyzer

Alter Analyzer

PeopleSoft Field Name Field Type Column Type Description
PTUPG_SRECNAME Character(15) VARCHAR2(15) NOT NULL Source Record Name
PTUPG_TRECNAME Character(15) VARCHAR2(15) NOT NULL Target Record Name
PTUPG_STABNAME Character(18) VARCHAR2(18) NOT NULL Source Table Name
PTUPG_TTABNAME Character(18) VARCHAR2(18) NOT NULL Target Table Name
PTUPG_SRECTYPE Number(3,0) SMALLINT NOT NULL Source Record Type
PTUPG_TRECTYPE Number(3,0) SMALLINT NOT NULL Target Record Type
PTUPG_STMPTBLINST Number(3,0) SMALLINT NOT NULL Source Temp Table Instance
PTUPG_STMPDEDCNT Number(3,0) SMALLINT NOT NULL Src Tmp Tbl Dedicated Count
PTUPG_STMPGAPCNT Number(3,0) SMALLINT NOT NULL Src Tmp Tbl Gap Count
PTUPG_STMPOPTCNT Number(3,0) SMALLINT NOT NULL Src Tmp Tbl Optional Count
PTUPG_TTMPTBLINST Number(3,0) SMALLINT NOT NULL Target Temp Table Instance
PTUPG_TTMPDEDCNT Number(3,0) SMALLINT NOT NULL Tgt Tmp Tbl Dedicated Count
PTUPG_TTMPGAPCNT Number(3,0) SMALLINT NOT NULL Tgt Tmp Tbl Gap Count
PTUPG_TTMPOPTCNT Number(3,0) SMALLINT NOT NULL Tgt Tmp Tbl Optional Count
PTUPG_ALTACTION Character(10) VARCHAR2(10) NOT NULL Alter Action
PTUPG_IDXONLY Number(3,0) SMALLINT NOT NULL Index only changes
PTUPG_TRGONLY Number(3,0) SMALLINT NOT NULL Trigger only changes
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19