SAC_MSGREC_VW (SQL View)	Index Back
XML Mapper Msg RecName prompt XML Mapper view of record names by message.

SAC_MSGREC_VW

(SQL View)

XML Mapper Msg RecName prompt

XML Mapper view of record names by message.

SELECT A.MSGNAME , B.RECNAME ,B.RECDESCR ,B.DESCRLONG FROM PSMSGREC A , PSRECDEFN B WHERE A.RECNAME = B.RECNAME AND B.RECTYPE NOT IN (2,3,7)

# 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).
Prompt Table: PSMSGDEFN

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

3 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description

4 DESCRLONG Long Character CLOB Long Description

#	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). Prompt Table: PSMSGDEFN
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	RECDESCR	Character(30)	VARCHAR2(30) NOT NULL	Record Description
4	DESCRLONG	Long Character	CLOB	Long Description