EOTP_GRP_VW (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_VW

(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 EOTP_GROUPID , DESCR , DESCRLONG FROM PS_EOTP_GROUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOTP_GROUPID Number(15,0) DECIMAL(15) NOT NULL Service Group ID
Default Value: 999999999999999

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

3 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOTP_GROUPID	Number(15,0)	DECIMAL(15) NOT NULL	Service Group ID Default Value: 999999999999999
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRLONG	Long Character	CLOB	Long Description