GPIT_PIN_NM_VW1 (SQL View)	Index Back
PIN Name View This view is used primarily to display the PIN Name as a related field on the On-line panels.

GPIT_PIN_NM_VW1

(SQL View)

PIN Name View

This view is used primarily to display the PIN Name as a related field on the On-line panels.

SELECT PIN_NM , PIN_NUM , DESCR , COUNTRY FROM PS_GP_PIN WHERE PIN_NUM < 50000000 AND FLD_FMT = '2'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPIT_PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name

2 GPIT_GV93_EL_PEP Number(8,0) INTEGER NOT NULL Period End Date Field for GV93 report.

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

4 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
Prompt Table: GP_COUNTRY_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIT_PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name
2	GPIT_GV93_EL_PEP	Number(8,0)	INTEGER NOT NULL	Period End Date Field for GV93 report.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY_VW