GPUS_GRNELN_VW (SQL View)	Index Back
ELN View View to get the pin numbers from ELN.

GPUS_GRNELN_VW

(SQL View)

ELN View

View to get the pin numbers from ELN.

SELECT PIN_NUM , GP_ELN_ATTR1 FROM PS_GP_ELN_PIN_ATTR A WHERE COUNTRY = 'USA' AND GP_ELN_SET = 'GRN'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 GP_ELN_ATTR1 Character(20) VARCHAR2(20) NOT NULL ELN Attribute

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	GP_ELN_ATTR1	Character(20)	VARCHAR2(20) NOT NULL	ELN Attribute