Enterprise PeopleTools 8.50 PeopleBook: PeopleSoft Change Impact Analyzer

Appendix: Pre-Processor Tables

This appendix discusses the tables generated in the PeopleCode and File pre-processors.

PeopleCode Pre-Processor

You must run the PeopleCode pre-processor to generate the database tables that Change Impact Analysis reads and analyzes. The PeopleCode pre-processor generates two tables:

PSCIAPCXREF
PSCIAPCXREFTIME

You must have permission to create, delete from and write to these files. If you have full privileges, you can create these files prior to using Change Impact Analyzer.

Note. Database administrators may consider assigning user IDs and passwords that grant read-only access to the database. However, users need create and write access to these work tables used by Change Impact Analyzer.

The following tables describe the columns for each of these tables for the different supported databases:

PSCIAPCXREF for Oracle, Microsoft, Sybase, Informix
PROGSEQ	INT NOT NULL
REFOBJECTID1	SMALLINT NOT NULL
REFOBJECTVALUE1	NCHAR(30) NOT NULL
REFOBJECTID2	SMALLINT NOT NULL
REFOBJECTVALUE2	NCHAR(30) NOT NULL
REFOBJECTID3	SMALLINT NOT NULL
REFOBJECTVALUE3	NCHAR(30) NOT NULL
REFOBJECTID4	SMALLINT NOT NULL
REFOBJECTVALUE4	NCHAR(30) NOT NULL
REFOBJECTID5	SMALLINT NOT NULL
REFOBJECTVALUE5	NCHAR(30) NOT NULL
REFOBJECTID6	SMALLINT NOT NULL
REFOBJECTVALUE6	NCHAR(30) NOT NULL
REFOBJECTID7	SMALLINT NOT NULL
REFOBJECTVALUE7	NCHAR(30) NOT NULL
OBJECTID1	SMALLINT NOT NULL
OBJECTVALUE1	NCHAR(30) NOT NULL
OBJECTID2	SMALLINT NOT NULL
OBJECTVALUE2	NCHAR(30) NOT NULL
OBJECTID3	SMALLINT NOT NULL
OBJECTVALUE3	NCHAR(30) NOT NULL
OBJECTID4	SMALLINT NOT NULL
OBJECTVALUE4	NCHAR(30) NOT NULL
OBJECTID5	SMALLINT NOT NULL
OBJECTVALUE5	NCHAR(30) NOT NULL
OBJECTID6	SMALLINT NOT NULL
OBJECTVALUE6	NCHAR(30) NOT NULL
OBJECTID7	SMALLINT NOT NULL
OBJECTVALUE7	NCHAR(30) NOT NULL

PSCIAPCXREF for DB2/OS390, DB2/Unix
PROGSEQ	INT NOT NULL
REFOBJECTID1	SMALLINT NOT NULL
REFOBJECTVALUE1	CHAR(60) NOT NULL
REFOBJECTID2	SMALLINT NOT NULL
REFOBJECTVALUE2	CHAR(60) NOT NULL
REFOBJECTID3	SMALLINT NOT NULL
REFOBJECTVALUE3	CHAR(60) NOT NULL
REFOBJECTID4	SMALLINT NOT NULL
REFOBJECTVALUE4	CHAR(60) NOT NULL
REFOBJECTID5	SMALLINT NOT NULL
REFOBJECTVALUE5	CHAR(60) NOT NULL
REFOBJECTID6	SMALLINT NOT NULL
REFOBJECTVALUE6	CHAR(60) NOT NULL
REFOBJECTID7	SMALLINT NOT NULL
REFOBJECTVALUE7	CHAR(60) NOT NULL
OBJECTID1	SMALLINT NOT NULL
OBJECTVALUE1	CHAR(60) NOT NULL
OBJECTID2	SMALLINT NOT NULL
OBJECTVALUE2	CHAR(60) NOT NULL
OBJECTID3	SMALLINT NOT NULL
OBJECTVALUE3	CHAR(60) NOT NULL
OBJECTID4	SMALLINT NOT NULL
OBJECTVALUE4	CHAR(60) NOT NULL
OBJECTID5	SMALLINT NOT NULL
OBJECTVALUE5	CHAR(60) NOT NULL
OBJECTID6	SMALLINT NOT NULL
OBJECTVALUE6	CHAR(60) NOT NULL
OBJECTID7	SMALLINT NOT NULL
OBJECTVALUE7	CHAR(60) NOT NULL

PSCIAPCXREFTIME for Oracle, Microsoft, Sybase, Informix
LASTRUN	NCHAR(60)

PSCIAPCXREFTIME for DB2/OS390, DB2/UNIX
LASTRUN	CHAR(120)

File Pre-Processor

The File Pre-processor generates the following database tables that Change Impact Analysis reads to perform analysis.

PSFILEPROCESSRUN
PSSQLXREFDEFN
PSSQLXREFITEM
PSFILESQLXREFDEFN
PSFILEXREFDEFN

Note. You must have permission to create, delete from and write to these files. If you have full privileges, you run the pre-processor and create these files beforehand.

PSFILEPROCESSRUN for Oracle
LASTREFRESHDTTM	DATE
FPPSTATUS	VARCHAR2(10) NOT NULL

PSFILEPROCESSRUN for MicroSoft and Sybase
LASTREFRESHDTTM	PSDATETIME
FPPSTATUS	CHAR(10) NOT NULL

PSFILEPROCESSRUN for Informix
LASTREFRESHDTTM	DATETIME YEAR TO FRACTION(3)
FPPSTATUS	CHAR(10) NOT NULL

PSFILEPROCESSRUN for DB2/Unix, DB2/OS390
LASTREFRESHDTTM	TIMESTAMP
FPPSTATUS	CHAR(10) NOT NULL

PSSQLXREFDEFN for Oracle
XREF_ID	VARCHAR2(128) NOT NULL
XREF_SQLTYPE	VARCHAR2(1) NOT NULL
DBTYPE	VARCHAR2(1) NOT NULL
XREF_GROUPBY_CNT	SMALLINT NOT NULL
XREF_ORDERBY_CNT	SMALLINT NOT NULL
XREF_HAVING_CNT	SMALLINT NOT NULL
XREF_SUBQUERY_CNT	SMALLINT NOT NULL
XREF_OUTERJOIN_CNT	SMALLINT NOT NULL
LASTUPDDTTM	DATE
SQLTEXT	LONG VARCHAR

PSSQLXREFDEFN for MicroSoft, Sybase
XREF_ID	CHAR(128) NOT NULL
XREF_SQLTYPE	CHAR(1) NOT NULL
DBTYPE	CHAR(1) NOT NULL
XREF_GROUPBY_CNT	SMALLINT NOT NULL
XREF_ORDERBY_CNT	SMALLINT NOT NULL
XREF_HAVING_CNT	SMALLINT NOT NULL
XREF_SUBQUERY_CNT	SMALLINT NOT NULL
XREF_OUTERJOIN_CNT	SMALLINT NOT NULL
LASTUPDDTTM	PSDATETIME NULL
SQLTEXT	TEXT NULL

PSSQLXREFDEFN for Informix
XREF_ID	CHAR(128) NOT NULL
XREF_SQLTYPE	CHAR(1) NOT NULL
DBTYPE	CHAR(1) NOT NULL
XREF_GROUPBY_CNT	SMALLINT NOT NULL
XREF_ORDERBY_CNT	SMALLINT NOT NULL
XREF_HAVING_CNT	SMALLINT NOT NULL
XREF_SUBQUERY_CNT	SMALLINT NOT NULL
XREF_OUTERJOIN_CNT	SMALLINT NOT NULL
LASTUPDDTTM	DATETIME YEAR TO FRACTION(3)
SQLTEXT	TEXT

PSSQLXREFDEFN for DB2/Unix, DB2/OS390
XREF_ID	CHAR(128) NOT NULL
XREF_SQLTYPE	CHAR(1) NOT NULL
DBTYPE	CHAR(1) NOT NULL
XREF_GROUPBY_CNT	SMALLINT NOT NULL
XREF_ORDERBY_CNT	SMALLINT NOT NULL
XREF_HAVING_CNT	SMALLINT NOT NULL
XREF_SUBQUERY_CNT	SMALLINT NOT NULL
XREF_OUTERJOIN_CNT	SMALLINT NOT NULL
LASTUPDDTTM	TIMESTAMP
SQLTEXT	LONG VARCHAR

PSSQLXREFITEM for Oracle
XREF_ID	VARCHAR2(128) NOT NULL
XREF_SQLTYPE	VARCHAR2(1) NOT NULL
DBTYPE	VARCHAR2(1) NOT NULL
XREF_ITEMSEQ	SMALLINT NOT NULL
XREF_ITEMTYPE	VARCHAR2(4) NOT NULL
XREF_RECNAME	VARCHAR2(30) NOT NULL
XREF_VALUE	VARCHAR2(128) NOT NULL
XREF_USAGE	VARCHAR2(4) NOT NULL
XREF_CLAUSE	VARCHAR2(5) NOT NULL

PSSQLXREFITEM for MicroSoft, Sybase, Informix, DB2/Unix, DB2/OS390
XREF_ID	CHAR(128) NOT NULL
XREF_SQLTYPE	CHAR(1) NOT NULL
DBTYPE	CHAR(1) NOT NULL
XREF_ITEMSEQ	SMALLINT NOT NULL
XREF_ITEMTYPE	CHAR(4) NOT NULL
XREF_RECNAME	CHAR(30) NOT NULL
XREF_VALUE	CHAR(128) NOT NULL
XREF_USAGE	CHAR(4) NOT NULL
XREF_CLAUSE	CHAR(5) NOT NULL

PSFILESQLXREFDEFN Oracle
SOURCE_FILE	VARCHAR2(40) NOT NULL
FILE_TYPE	VARCHAR2(4) NOT NULL
XREF_ID	VARCHAR2(128) NOT NULL

PSFILESQLXREFDEFN for MicroSoft, Sybase, Informix, DB2/Unix, DB2/OS390
SOURCE_FILE	CHAR(40) NOT NULL
FILE_TYPE	CHAR(4) NOT NULL
XREF_ID	CHAR(128) NOT NULL

PSFILEXREFDEFN for Oracle
SOURCE_FILE	VARCHAR2(40) NOT NULL
CALLED_FILE	VARCHAR2(40) NOT NULL
FILE_TYPE	VARCHAR2(3) NOT NULL

PSFILEXREFDEFN for MicroSoft, Sybase, Informix, DB2/Unix, DB2/OS390
SOURCE_FILE	CHAR(40) NOT NULL
CALLED_FILE	CHAR(40) NOT NULL
FILE_TYPE	CHAR(3) NOT NULL