CNT_SRCH_ESP

(SQL View)
 Index Back

Contract Data Search ESP

CNT_SRCH_ESP is an Contract Data and Employment Search record.

SELECT DISTINCT SEC.OPRID ,SEC.ROWSECCLASS ,D.EMPLID ,B.EMPL_RCD ,D.CONTRACT_NUM ,SEC.NAME ,SEC.NAME_DISPLAY_SRCH ,SEC.LAST_NAME_SRCH ,SEC.SECOND_LAST_SRCH ,SEC.FIRST_NAME ,SEC.LAST_NAME ,SEC.NAME_AC ,SEC.PER_ORG , D.CONTRACT_BEGIN_DT , D.CONTRACT_END_DT ,D.CONTRACT_STATUS FROM PS_CONTRACT_DATA D , PS_JOB B , PS_PERS_SRCH_GBL SEC WHERE D.EMPLID = B.EMPLID(+) AND D.CONTRACT_NUM = B.CONTRACT_NUM(+) AND D.EMPLID = SEC.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERS_SRCH_GBL

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Labor Relation ID
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 NAME_DISPLAY_SRCH Character(50) VARCHAR2(50) NOT NULL Uppercase version of Name to improve performance on searches.
8 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
9 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
10 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
11 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
12 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
13 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
14 CONTRACT_BEGIN_DT Date(10) DATE Labor Relation Begin Dt
15 CONTRACT_END_DT Date(10) DATE Labor Relation End Dt
16 CONTRACT_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status - The values 'N - N/A' and 'P - Pending' are suppressed from release 8.
A=Active
I=Inactive