EORM_DB_CONNECT

(SQL Table)
 Index Back

Internal: Database Connections

Internal: This record is used to store Database connectivity details. It is being used in Message Catalog Reservation

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOTR_DBNAME Character(50) VARCHAR2(50) NOT NULL DBName
2 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

Default Value: A

3 EORM_DB_TYPE Character(4) VARCHAR2(4) NOT NULL Internal-Database Type. Used in Message Catalog Reservation
DMO=DMO
DVB=DVB
MST=MST
OTH=Other
STG=STG
SYS=SYS
TM1=TM1

Default Value: OTH

4 EORM_RELEASE Character(4) VARCHAR2(4) NOT NULL Internal: Release. Used in Message Catalog Reservation
8.8=8.8
8.9=8.9
9.0=9.0
9.1=9.1
9.2=9.2
9.21=9.21

Default Value: 9.2

5 DBSERVER Long Character(255) VARCHAR2(255) Database Host Server Name
6 EOTR_DB_PORT Number(10,0) DECIMAL(10) NOT NULL DB Connection Port Number

Default Value: 1521

7 EOTR_USER_NAME Character(30) VARCHAR2(30) NOT NULL Username
8 EOTR_USER_PWD Character(32) VARCHAR2(32) NOT NULL Password