PTUALTRECDATA

index back

Alter Analyzer

Alter Analyzer

PeopleSoft Field NameField TypeColumn TypeDescription
PTUPG_SRECNAMECharacter(15)VARCHAR2(15) NOT NULLSource Record Name
PTUPG_TRECNAMECharacter(15)VARCHAR2(15) NOT NULLTarget Record Name
PTUPG_STABNAMECharacter(18)VARCHAR2(18) NOT NULLSource Table Name
PTUPG_TTABNAMECharacter(18)VARCHAR2(18) NOT NULLTarget Table Name
PTUPG_SRECTYPENumber(3,0)SMALLINT NOT NULLSource Record Type
PTUPG_TRECTYPENumber(3,0)SMALLINT NOT NULLTarget Record Type
PTUPG_STMPTBLINSTNumber(3,0)SMALLINT NOT NULLSource Temp Table Instance
PTUPG_STMPDEDCNTNumber(3,0)SMALLINT NOT NULLSrc Tmp Tbl Dedicated Count
PTUPG_STMPGAPCNTNumber(3,0)SMALLINT NOT NULLSrc Tmp Tbl Gap Count
PTUPG_STMPOPTCNTNumber(3,0)SMALLINT NOT NULLSrc Tmp Tbl Optional Count
PTUPG_TTMPTBLINSTNumber(3,0)SMALLINT NOT NULLTarget Temp Table Instance
PTUPG_TTMPDEDCNTNumber(3,0)SMALLINT NOT NULLTgt Tmp Tbl Dedicated Count
PTUPG_TTMPGAPCNTNumber(3,0)SMALLINT NOT NULLTgt Tmp Tbl Gap Count
PTUPG_TTMPOPTCNTNumber(3,0)SMALLINT NOT NULLTgt Tmp Tbl Optional Count
PTUPG_ALTACTIONCharacter(10)VARCHAR2(10) NOT NULLAlter Action
PTUPG_IDXONLYNumber(3,0)SMALLINT NOT NULLIndex only changes
PTUPG_TRGONLYNumber(3,0)SMALLINT NOT NULLTrigger only changes
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19