GPSC_ECPY_M_LNG (SQL View)	Index Back
Element Copy - Messages Element Copy - Messages

GPSC_ECPY_M_LNG

(SQL View)

Element Copy - Messages

SELECT MESSAGE_SET_NBR ,MESSAGE_NBR ,LANGUAGE_CD ,MESSAGE_TEXT ,DESCRLONG FROM PSMSGCATLANG WHERE MESSAGE_SET_NBR=17340

Related Language Record for GPSC_ECPY_MSG_V

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

2 MESSAGENBR Number(10,0) DECIMAL(10) NOT NULL Message Number

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 MESSAGE_TEXT Character(100) VARCHAR2(100) NOT NULL Message Text This field refers to the Text for a particular Message Number in the Message Catalog.

5 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
2	MESSAGENBR	Number(10,0)	DECIMAL(10) NOT NULL	Message Number
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	MESSAGE_TEXT	Character(100)	VARCHAR2(100) NOT NULL	Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
5	DESCRLONG	Long Character	CLOB	Long Description