GPNL_PYENT_DTL (SQL Table)	Index Back
Pay Entity - Netherland Ext This table will be used to record the pay entity information that is required for\The Netherlands These information are in addition to the details that ca be entered through the core pages.

GPNL_PYENT_DTL

(SQL Table)

Pay Entity - Netherland Ext

This table will be used to record the pay entity information that is required for\The Netherlands These information are in addition to the details that ca be entered through the core pages.

Parent Record Of GPNL_PYENT_BANK

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Default Value: GP_PYENT.PAY_ENTITY

2 EFFDT Date(10) DATE Effective Date
Default Value: GP_PYENT_DTL.EFFDT

3 CONTACT_EMPLID Character(11) VARCHAR2(11) NOT NULL Contact - Vacancy Announcement
Prompt Table: PERSON_NAME

4 FILE_DIRECTORY Character(80) VARCHAR2(80) NOT NULL File Directory

5 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name

6 GPNL_LAST_EXT_NBR Number(3,0) SMALLINT NOT NULL Payment File Last Extension

7 GPNL_BATCH_MEDIUM Character(1) VARCHAR2(1) NOT NULL Batch Medium Details
1=Datacom
2=Tape
3=Cartridge
4=Diskette

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Default Value: GP_PYENT.PAY_ENTITY
2	EFFDT	Date(10)	DATE	Effective Date Default Value: GP_PYENT_DTL.EFFDT
3	CONTACT_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Contact - Vacancy Announcement Prompt Table: PERSON_NAME
4	FILE_DIRECTORY	Character(80)	VARCHAR2(80) NOT NULL	File Directory
5	FILE_NAME	Character(80)	VARCHAR2(80) NOT NULL	File Name
6	GPNL_LAST_EXT_NBR	Number(3,0)	SMALLINT NOT NULL	Payment File Last Extension
7	GPNL_BATCH_MEDIUM	Character(1)	VARCHAR2(1) NOT NULL	Batch Medium Details 1=Datacom 2=Tape 3=Cartridge 4=Diskette