PTUALTRECDATA

(SQL Table)
Index Back

Alter Analyzer

Alter Analyzer

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTUPG_SRECNAME Character(15) VARCHAR2(15) NOT NULL Source Record Name
2 PTUPG_TRECNAME Character(15) VARCHAR2(15) NOT NULL Target Record Name
3 PTUPG_STABNAME Character(18) VARCHAR2(18) NOT NULL Source Table Name
4 PTUPG_TTABNAME Character(18) VARCHAR2(18) NOT NULL Target Table Name
5 PTUPG_SRECTYPE Number(3,0) SMALLINT NOT NULL Source Record Type
6 PTUPG_TRECTYPE Number(3,0) SMALLINT NOT NULL Target Record Type
7 PTUPG_STMPTBLINST Number(3,0) SMALLINT NOT NULL Source Temp Table Instance
8 PTUPG_STMPDEDCNT Number(3,0) SMALLINT NOT NULL Src Tmp Tbl Dedicated Count
9 PTUPG_STMPGAPCNT Number(3,0) SMALLINT NOT NULL Src Tmp Tbl Gap Count
10 PTUPG_STMPOPTCNT Number(3,0) SMALLINT NOT NULL Src Tmp Tbl Optional Count
11 PTUPG_TTMPTBLINST Number(3,0) SMALLINT NOT NULL Target Temp Table Instance
12 PTUPG_TTMPDEDCNT Number(3,0) SMALLINT NOT NULL Tgt Tmp Tbl Dedicated Count
13 PTUPG_TTMPGAPCNT Number(3,0) SMALLINT NOT NULL Tgt Tmp Tbl Gap Count
14 PTUPG_TTMPOPTCNT Number(3,0) SMALLINT NOT NULL Tgt Tmp Tbl Optional Count
15 PTUPG_ALTACTION Character(10) VARCHAR2(10) NOT NULL Alter Action
16 PTUPG_IDXONLY Number(3,0) SMALLINT NOT NULL Index only changes
17 PTUPG_TRGONLY Number(3,0) SMALLINT NOT NULL Trigger only changes