EOTP_GRP_VW2 (SQL View)	Index Back
Service Group View Service Group View selects all rows in EOTP_GROUP. It is needed to handle related edits on DESCR and EOTP_GROUPID in the page EOTP_SVC_WRK which are shared in multiple components, one of which is the group component. This prevented us from using the EOTP_GROUP directly as the prompt tables on the control field since it conflicts with the actual descr field in the eotp_group component.

EOTP_GRP_VW2

(SQL View)

Service Group View

Service Group View selects all rows in EOTP_GROUP. It is needed to handle related edits on DESCR and EOTP_GROUPID in the page EOTP_SVC_WRK which are shared in multiple components, one of which is the group component. This prevented us from using the EOTP_GROUP directly as the prompt tables on the control field since it conflicts with the actual descr field in the eotp_group component.

SELECT DISTINCT C.EOTP_PARTNERID , A.EOTP_GROUPID , A.DESCR FROM PS_EOTP_GROUP A , PS_EOTP_SVCGROUP B , PS_EOTP_PARTNRSVCS C WHERE A.EOTP_GROUPID = B.EOTP_GROUPID AND B.EOTP_SERVICEID = C.EOTP_SERVICEID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOTP_PARTNERID Number(15,0) DECIMAL(15) NOT NULL Partner ID

2 EOTP_GROUPID Number(15,0) DECIMAL(15) NOT NULL Service Group ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOTP_PARTNERID	Number(15,0)	DECIMAL(15) NOT NULL	Partner ID
2	EOTP_GROUPID	Number(15,0)	DECIMAL(15) NOT NULL	Service Group ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description