CNT_NUM_BEL_VW (SQL View)	Index Back
Orig, Contract Number View This prompt view is used for Belgian contracts to select an original contract number, when the current contract is a replacement.

CNT_NUM_BEL_VW

(SQL View)

Orig, Contract Number View

This prompt view is used for Belgian contracts to select an original contract number, when the current contract is a replacement.

SELECT EMPLID ,CONTRACT_NUM FROM PS_CONTRACT_DATA

# 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 ORIG_CNT_NUM_BEL Character(25) VARCHAR2(25) NOT NULL Original Contract Nbr

#	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	ORIG_CNT_NUM_BEL	Character(25)	VARCHAR2(25) NOT NULL	Original Contract Nbr