PGM_ED_IM_NOTES (SQL View)	Index Back
Issue Management Notes View of Issue Notes for sending to Endeca

PGM_ED_IM_NOTES

(SQL View)

Issue Management Notes

View of Issue Notes for sending to Endeca

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.PC_IM_ISSUE_ID %Concat '::' %Concat A.PC_IM_NAME , A.DESCR254 , A.DESCRLONG , A.DTTM_STAMP FROM PS_PC_IM_NOTE_TBL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: SP_PROJ_NONVW

3 CONCAT_PHYS_KEYS Character(120) VARCHAR2(120) NOT NULL Concatinated physical_inv keys

4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

5 DESCRLONG Long Character CLOB Long Description

6 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: SP_PROJ_NONVW
3	CONCAT_PHYS_KEYS	Character(120)	VARCHAR2(120) NOT NULL	Concatinated physical_inv keys
4	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
5	DESCRLONG	Long Character	CLOB	Long Description
6	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.