GPES_PIN_NMS (SQL View)	Index Back
Pin name prompt List of pin names (PIN_NM).

GPES_PIN_NMS

(SQL View)

Pin name prompt

List of pin names (PIN_NM).

SELECT DISTINCT PRF.OPRID , P.COUNTRY , P.PIN_CODE , P.PIN_NM , P.DESCR , P.PIN_TYPE FROM PS_GP_PIN P ,PS_GP_OPR_RULE_PRF PRF WHERE P.USED_BY='A' OR PRF.USED_BY='A' OR P.COUNTRY=PRF.COUNTRY AND P.PIN_TYPE IN ( SELECT T.PIN_TYPE FROM PS_GPES_CRAPTYP_VW T)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

3 PIN_CODE Character(22) VARCHAR2(22) NOT NULL Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)

4 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

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

6 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
Prompt Table: GPES_CRAPTYP_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
3	PIN_CODE	Character(22)	VARCHAR2(22) NOT NULL	Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across. Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
4	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	PIN_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Element Type Prompt Table: GPES_CRAPTYP_VW