CONTRACT_CLAUSE

(SQL Table)
 Index Back

Contract Clause

Contract Clause setup table - Contains the clauses by Template ID.

  • Related Language Record: CONTRCT_CLS_LNG

  • Parent Record Of CNT_CLS_VW_LNG CONTRCT_CLS_LNG HCR_CTR_CLS_LNI HRS_CTR_CLS_LNI HRS_CTR_CLS_LVW

    • # 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 Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    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