GPES_EST_SOVR2 (SQL View)	Index Back
Value for CLI VR EST ASG SOB Read the value for CLI VR EST ASG SOB in the Element Assignment by Payee or Payee Assignment by Payee.

GPES_EST_SOVR2

(SQL View)

Value for CLI VR EST ASG SOB

Read the value for CLI VR EST ASG SOB in the Element Assignment by Payee or Payee Assignment by Payee.

SELECT SOVR.PIN_NUM , SOVR.PIN_SOVR_NUM , SOVR.BGN_DT , SOVR.END_DT , SOVR.SOVR_VAL_CHAR , PIN.PIN_CODE FROM PS_GP_ELM_DFN_SOVR SOVR , PS_GP_PIN PIN WHERE SOVR.PIN_SOVR_NUM=PIN.PIN_NUM AND PIN.PIN_CODE='CLI VR EST ASG SOB ESP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PIN_SOVR_NUM Number(8,0) INTEGER NOT NULL Supporting Element PIN Number

3 BGN_DT Date(10) DATE Begin Date

4 END_DT Date(10) DATE end date

5 SOVR_VAL_CHAR Character(25) VARCHAR2(25) NOT NULL Supporting Element Character Value

6 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)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	PIN_SOVR_NUM	Number(8,0)	INTEGER NOT NULL	Supporting Element PIN Number
3	BGN_DT	Date(10)	DATE	Begin Date
4	END_DT	Date(10)	DATE	end date
5	SOVR_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Supporting Element Character Value
6	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)