CTI_PNL_VW (SQL View)	Index Back
CTI Panel prompt view Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration Copied from FIN database. Joe Edgar - 03/23/04: Added new PANELNAME field with a length of 30 (instead of 18). This is because the pspnlgroup table's pnlname field is length 30. This showed up on the audits.

CTI_PNL_VW

(SQL View)

CTI Panel prompt view

Date Initials Issue Description 022301 dms SP2 (F-CJORGENS-9) CTI Integration Copied from FIN database. Joe Edgar - 03/23/04: Added new PANELNAME field with a length of 30 (instead of 18). This is because the pspnlgroup table's pnlname field is length 30. This showed up on the audits.

SELECT DISTINCT g.pnlgrpname ,g.pnlgrpname , g.pnlname FROM PSPNLGROUP g WHERE g.hidden = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

2 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

3 PANELNAME30 Character(30) VARCHAR2(30) NOT NULL Panel Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPONENT_ID	Character(18)	VARCHAR2(18) NOT NULL	04/10/00 (Internet Architecture) SCC: Uppercase label Id.
2	PNLGRPNAME	Character(18)	VARCHAR2(18) NOT NULL	Component Name
3	PANELNAME30	Character(30)	VARCHAR2(30) NOT NULL	Panel Name