HR_CONTRACT_VW

(SQL View)
 Index Back

Contract Data View

This is a view used to fetch Contract Data information for Expiration Inquiry Page.

SELECT DISTINCT A.EMPLID , B.EMPL_RCD , A.CONTRACT_NUM , D.PER_ORG , C.NAME , C.LAST_NAME , C.SECOND_LAST_SRCH , C.NAME_AC , A.CONTRACT_END_DT , A.CONTRACT_STATUS , A.CNT_TEMPLATE_ID , A.COMMENTSHORT FROM PS_CONTRACT_DATA A , PS_JOB_EXPIR_NT_VW B , PS_PERSONAL_DATA C ,PS_JOB D WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND D.EMPLID=A.EMPLID AND D.EMPL_RCD = B.EMPL_RCD AND A.CONTRACT_NUM = B.CONTRACT_NUM AND A.CONTRACT_STATUS ='A'

  • Related Language Record: PERSON_NAME_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    4 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

    Default Value: PER_ORG_ASGN.PER_ORG

    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    7 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Last Name
    8 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    9 CONTRACT_END_DT Date(10) DATE Contract End Date
    10 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

    Default Value: A

    11 CNT_TEMPLATE_ID Character(11) VARCHAR2(11) NOT NULL Contract Template ID

    Prompt Table: CNT_TEMPL_VW

    12 COMMENTSHORT Character(30) VARCHAR2(30) NOT NULL Short Comment