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'

# 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 Rcd Nbr
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 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