CNT_CLAUSE_VW

(SQL View)
 Index Back

Contract Clause

view of CONTRACT_CLAUSE with effdt renamed to effdt-used

SELECT A.SETID , A.CNT_TEMPLATE_ID , A.EFFDT , A.CONTRACT_SEQ , A.CONTRACT_CLAUSE , A.CLAUSE_STATUS , B.DESCR254 , B.COMMENTS FROM PS_CONTRACT_CLAUSE A , PS_CNT_CLAUSE_TBL B WHERE A.CONTRACT_CLAUSE = B.CONTRACT_CLAUSE AND B.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_CNT_CLAUSE_TBL C WHERE C.CONTRACT_CLAUSE = B.CONTRACT_CLAUSE AND C.EFFDT <= A.EFFDT)

  • Related Language Record: CNT_CLS_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: CNT_TEMPLATE.SETID

    Prompt Table: SET_VLD_HR_09

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

    Prompt Table: CNT_TEMPLATE

    3 EFFDT_USED Date(10) DATE Date driving 'processed' code
    4 CONTRACT_SEQ Number(3,0) SMALLINT NOT NULL Contract Seq#
    5 CONTRACT_CLAUSE Character(3) VARCHAR2(3) NOT NULL Contract Clause

    Prompt Table: CNT_CLAUSE_TBL

    6 CLAUSE_STATUS Character(1) VARCHAR2(1) NOT NULL Clause Status
    1=Optional
    2=Required
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    8 COMMENTS Long Character CLOB Comment