GPGB_PIN_LNGVW (SQL View)	Index Back
Pay Item Name Definition This is the main record for setting up/maintaining Pay Item Name elements in the Global Payroll system.

GPGB_PIN_LNGVW

(SQL View)

Pay Item Name Definition

This is the main record for setting up/maintaining Pay Item Name elements in the Global Payroll system.

SELECT DISTINCT C.OPRID , GPL.PIN_CODE ,GPL.LANGUAGE_CD ,GPL.DESCR FROM PS_GP_PIN_LANG GPL ,PS_GP_PIN GP , PS_GP_OPR_RULE_PRF C WHERE GP.PIN_TYPE IN ('DD','ER') AND (GP.USED_BY = 'A' OR (GP.USED_BY = 'C' AND C.USED_BY= 'A') OR (GP.USED_BY = 'C' AND GP.COUNTRY = C.COUNTRY))

Related Language Record for GPGB_PIN_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 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)
Default Value: GP_PIN.PIN_NM

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	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	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) Default Value: GP_PIN.PIN_NM
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description