INSTALLATION_PL

(SQL Table)
Index Back

Planning Installation Table

11/7/97 GTP Added for CN# DI-GPENN-74 Planning installation paramaters 12/9/97 GTP CN# DI-GPENN-74 Fields for OP, PL, and EP connections (host names, servers, ports, etc.) added 01/20/00 EGS: Added TRUSTED_SOURCE. 02/11/03 EGS (CN#PL880-1): Added SCM_INTEGRATION.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQ_NBR_PO Number(15,0) DECIMAL(15) NOT NULL 01/09/02 EGS (CN#PL900-1): Added

Default Value: 1

2 SEQ_NBR_PRDN Number(15,0) DECIMAL(15) NOT NULL 01/09/02 EGS (CN#PL900-1): Added

Default Value: 1

3 SEQ_NBR_TR Number(15,0) DECIMAL(15) NOT NULL 01/09/02 EGS (CN#PL900-1): Added

Default Value: 1

4 SEQ_NBR_SO Number(15,0) DECIMAL(15) NOT NULL 03/09/02 JNW (CN#PL900-1): Added

Default Value: 1

5 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

Prompt Table: SP_PRBINS_NONVW

6 PL_WB_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL PL_WB_TEMPLATE_ID

Prompt Table: PL_WB_TMPLATE_H

7 SPL_KEY_SEPARATOR Character(1) VARCHAR2(1) NOT NULL Key Field Seperator

Default Value: \

8 SCM_INTEGRATION Character(2) VARCHAR2(2) NOT NULL 02/11/03 EGS (CN#PL880-1): Added
1=Release 8.8

Default Value: 1