SAC_SRCHREC_VW (SQL View)	Index Back
XML Mapper/BBIX RecName prompt XML Mapper/ BBIX Record name prompt view

SAC_SRCHREC_VW

(SQL View)

XML Mapper/BBIX RecName prompt

XML Mapper/ BBIX Record name prompt view

SELECT B.RECNAME ,B.RECDESCR ,B.DESCRLONG FROM PSRECDEFN B WHERE B.RECTYPE NOT IN (2,3,7)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	RECDESCR	Character(30)	VARCHAR2(30) NOT NULL	Record Description
3	DESCRLONG	Long Character	CLOB	Long Description