CNT_TEMPL_VW

(SQL View)
 Index Back

Contract Template View

Contract Template view is used to store display default Contract information

SELECT CT.SETID ,CT.CNT_TEMPLATE_ID ,CT.EFFDT ,CT.DESCR ,CT.CONTRACT_FAMILY ,CT.CONTRACT_TYPE ,CT.COMMENTS FROM PS_CNT_TEMPLATE CT WHERE CT.EFFDT = ( SELECT MAX(CT1.EFFDT) FROM PS_CNT_TEMPLATE CT1 WHERE CT1.SETID = CT.SETID AND CT.CNT_TEMPLATE_ID = CT1.CNT_TEMPLATE_ID AND CT1.EFFDT <= %CurrentDateIn) AND CT.EFF_STATUS = 'A'

  • Related Language Record: CNT_TEMPLVW_LNG

  • Parent Record Of CNT_TEMPLVW_LNG

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

    Prompt Table: SET_VLD_HR_09

    2 CNT_TEMPLATE_ID Character(11) VARCHAR2(11) NOT NULL Contract Template ID
    3 EFFDT_USED Date(10) DATE Date driving 'processed' code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 CONTRACT_FAMILY Character(2) VARCHAR2(2) NOT NULL Contract Family
    01=Regular
    02=Temporary
    6 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
    7 COMMENTS Long Character CLOB Comment