CNT_EMPL_BEL_VW (SQL View)	Index Back
Original Contract Emplid This prompt view is used for Belgian contracts to select the Employee ID from an original contract when the current contract is a replacement.

CNT_EMPL_BEL_VW

(SQL View)

Original Contract Emplid

This prompt view is used for Belgian contracts to select the Employee ID from an original contract when the current contract is a replacement.

SELECT A.EMPLID , A.CONTRACT_BEGIN_DT , B.NAME , B.LAST_NAME FROM PS_CONTRACT_DATA A ,PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND A.REG_REGION = 'BEL'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ORIG_EMPLID_BEL Character(11) VARCHAR2(11) NOT NULL Original Employee ID used by Belgium to track the original contract data.

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ORIG_EMPLID_BEL	Character(11)	VARCHAR2(11) NOT NULL	Original Employee ID used by Belgium to track the original contract data.
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name