BO_NOTE_VW (SQL View)	Index Back
Note for Business Contact Business Contact Notes. Used for Business Contact.

BO_NOTE_VW

(SQL View)

Note for Business Contact

Business Contact Notes. Used for Business Contact.

SELECT BO_ID , NOTE_GUID , NOTE_SEQ_NBR , NOTE_SUMMARY , BC_NOTE_TYPE , ROW_LASTMANT_OPRID , ROW_LASTMANT_DTTM , DESCRLONG FROM PS_BC_NOTE

Parent record: BO

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 NOTE_GUID Signed Number(32,0) DECIMAL(31) NOT NULL GUID as a number for notes.

3 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID
Default Value: 1

4 NOTE_SUMMARY Character(50) VARCHAR2(50) NOT NULL This field is used for Notes Summary (50 characters).

5 BC_NOTE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Note Types
Prompt Table: BC_NOTETYPE_TBL

6 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

7 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

8 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	NOTE_GUID	Signed Number(32,0)	DECIMAL(31) NOT NULL	GUID as a number for notes.
3	NOTE_SEQ_NBR	Number(6,0)	INTEGER NOT NULL	Note ID Default Value: 1
4	NOTE_SUMMARY	Character(50)	VARCHAR2(50) NOT NULL	This field is used for Notes Summary (50 characters).
5	BC_NOTE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Note Types Prompt Table: BC_NOTETYPE_TBL
6	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
7	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
8	DESCRLONG	Long Character	CLOB	Long Description