CNT_JOB_BRA_VW (SQL View)	Index Back
Contract Data Search CNT_DTA_BRA_VW is a Contract Data and Employment Search record.

CNT_JOB_BRA_VW

(SQL View)

Contract Data Search

CNT_DTA_BRA_VW is a Contract Data and Employment Search record.

SELECT DISTINCT B.EMPLID ,B.EMPL_RCD ,C.CONTRACT_NUM ,C.CONTRACT_BEGIN_DT ,C.CONTRACT_END_DT ,B.REG_REGION FROM PS_JOB B , PS_CONTRCT_DTA_BRA C WHERE C.EMPLID=B.EMPLID AND B.EMPL_RCD=C.EMPL_RCD AND C.CONTRACT_NUM=B.CONTRACT_NUM

Parent Record Of CONTRCT_DTA_BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: EMPLMT_SRCH_GBL

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number

4 CONTRACT_BEGIN_DT Date(10) DATE Contract Begin Date

5 CONTRACT_END_DT Date(10) DATE Contract End Date

6 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: EMPLMT_SRCH_GBL
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Number
4	CONTRACT_BEGIN_DT	Date(10)	DATE	Contract Begin Date
5	CONTRACT_END_DT	Date(10)	DATE	Contract End Date
6	REG_REGION	Character(5)	VARCHAR2(5) NOT NULL	Regulatory Region