GP_VER_PIN_VW (SQL View)	Index Back
Versioning- GP PIN view View over GP_PIN that selects PIN_NUM, USED_BY and COUNTRY from GP_PIN. This view is used in the dynamic view created for selecting GP_VERSIONs. A view over GP_PIN had to be created instead of using GP_PIN in the JOIN so as to avoid ambiguity with the field GP_VERSION.

GP_VER_PIN_VW

(SQL View)

Versioning- GP PIN view

View over GP_PIN that selects PIN_NUM, USED_BY and COUNTRY from GP_PIN. This view is used in the dynamic view created for selecting GP_VERSIONs. A view over GP_PIN had to be created instead of using GP_PIN in the JOIN so as to avoid ambiguity with the field GP_VERSION.

SELECT PIN_NUM , USED_BY , COUNTRY FROM PS_GP_PIN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

2 USED_BY Character(1) VARCHAR2(1) NOT NULL USED_BY
A=All Countries
C=Specific Country

3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	USED_BY	Character(1)	VARCHAR2(1) NOT NULL	USED_BY A=All Countries C=Specific Country
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country