PTIDXPARTDDL - Index Partitioning Defintion - PeopleTools Table Reference

PTIDXPARTDDL	index back
Index Partitioning Defintion

Table to store PSFT Index Partitioning DDL.

PeopleSoft Field Name Field Type Column Type Description
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
PLATFORMID Number(2,0) SMALLINT NOT NULL Platform ID
0=SQLBase
1=DB2
2=Oracle
3=Informix
4=DB2/Unix
5=ALLBASE
6=Sybase
7=Microsoft
8=DB2/400
INDEXPARTDDL Long Character CLOB INDEX PARTITIONING DDL
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19

PeopleSoft Field Name	Field Type	Column Type	Description
RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
PLATFORMID	Number(2,0)	SMALLINT NOT NULL	Platform ID 0=SQLBase 1=DB2 2=Oracle 3=Informix 4=DB2/Unix 5=ALLBASE 6=Sybase 7=Microsoft 8=DB2/400
INDEXPARTDDL	Long Character	CLOB	INDEX PARTITIONING DDL