GPAU_SVRMP_NRVW (SQL View)	Index Back
SOVR Mapping in Category Setup SOVR Mapping in Category Setup - Single Touch Payroll

GPAU_SVRMP_NRVW

(SQL View)

SOVR Mapping in Category Setup

SOVR Mapping in Category Setup - Single Touch Payroll

SELECT PIN_NUM + 50000000 , SOVR_VAL_CHAR , PIN_CODE , DESCR100 FROM PS_GPAU_STP_SOVRMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	SOVR_VAL_CHAR	Character(25)	VARCHAR2(25) NOT NULL	Supporting Element Character Value
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	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description