AUC_DUMMY1_VW (SQL View)	Index Back
Sourcing Group Summary 1

AUC_DUMMY1_VW

(SQL View)

Sourcing Group Summary 1

SELECT COUNTRY ,'X' , 0 , ' ' FROM PS_INSTALLATION WHERE 1 = 4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: COUNTRY_TBL

2 DUMMY_FIELD Character(1) VARCHAR2(1) NOT NULL Dummy Field for Hiding Groups

3 AUC_COLLAB_GRP_NBR Number(3,0) SMALLINT NOT NULL Collaboration Group Number

4 AUC_COLLAB_GRP Character(40) VARCHAR2(40) NOT NULL Collaboration Group

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: COUNTRY_TBL
2	DUMMY_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Dummy Field for Hiding Groups
3	AUC_COLLAB_GRP_NBR	Number(3,0)	SMALLINT NOT NULL	Collaboration Group Number
4	AUC_COLLAB_GRP	Character(40)	VARCHAR2(40) NOT NULL	Collaboration Group