CNT_SRCH_GBL

(SQL View)
 Index Back

Contract Data Search

CNT_SRCH_GBL is an Contract Data and Employment Search record. Use it to select employee records for you to use when you access a panel. This view shows you records only for employees in departments that your operator class is allowed to access.

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 LEFT OUTER JOIN PS_JOB B ON D.EMPLID = B.EMPLID AND D.CONTRACT_NUM = B.CONTRACT_NUM ,PS_PERS_SRCH_GBL SEC WHERE D.EMPLID = SEC.EMPLID

  • Related Language Record: PERSON_NAME_LNG

    • # 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 Contract Number
    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 Contract Begin Date
    15 CONTRACT_END_DT Date(10) DATE Contract End Date
    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