PSIBMSGSCHEM_VW (SQL View)	Index Back
IB Schema View View into the pre-8.49 schema tables. Used to detect old schemas that may need to be converted to the new managed object schema tables.

PSIBMSGSCHEM_VW

(SQL View)

IB Schema View

View into the pre-8.49 schema tables. Used to detect old schemas that may need to be converted to the new managed object schema tables.

SELECT DISTINCT MSGNAME , APMSGVER , IB_NAMESPACE FROM PSIBMSGSCHEMA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

2 APMSGVER Character(30) VARCHAR2(30) NOT NULL Message Version

3 IB_NAMESPACE Character(254) VARCHAR2(254) NOT NULL Service Namespace

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
2	APMSGVER	Character(30)	VARCHAR2(30) NOT NULL	Message Version
3	IB_NAMESPACE	Character(254)	VARCHAR2(254) NOT NULL	Service Namespace