GPIN_NRP_PIN_VW (SQL View)	Index Back
Payee Report PINs Child record for Payee Reports - PINs

GPIN_NRP_PIN_VW

(SQL View)

Payee Report PINs

Child record for Payee Reports - PINs

SELECT A.GPIN_REPORT_ID ,A.GPIN_FLD_NAME ,A.PIN_NUM+50000000 ,A.ENTRY_TYPE_ID ,A.GPIN_ADD_SUB_PIN ,A.GPIN_LAST_PROC_VAL FROM PS_GPIN_PR_PIN A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPIN_REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier

2 GPIN_FLD_NAME Character(15) VARCHAR2(15) NOT NULL Payee Report Field Name

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: %GP_EDIT_FLD7

4 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID
Prompt Table: %RECNAME_EDIT

5 GPIN_ADD_SUB_PIN Character(2) VARCHAR2(2) NOT NULL Add or Subtract
10=Add
20=Subtract

6 GPIN_LAST_PROC_VAL Character(1) VARCHAR2(1) NOT NULL This field holds the last processed value.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPIN_REPORT_ID	Character(8)	VARCHAR2(8) NOT NULL	Report Identifier
2	GPIN_FLD_NAME	Character(15)	VARCHAR2(15) NOT NULL	Payee Report Field Name
3	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %GP_EDIT_FLD7
4	ENTRY_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Element Entry Type ID Prompt Table: %RECNAME_EDIT
5	GPIN_ADD_SUB_PIN	Character(2)	VARCHAR2(2) NOT NULL	Add or Subtract 10=Add 20=Subtract
6	GPIN_LAST_PROC_VAL	Character(1)	VARCHAR2(1) NOT NULL	This field holds the last processed value.