CNT_TASK_ORDER

(SQL Table)
Index Back

Contract Task Orders

The Contract Task Order table is used to record Task Order Details for a particular Contract.

  • Related Language Record: CNT_TSK_ORD_LNG
  • Parent record: CNT_TEMPLATE
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_09

    2 CNT_TEMPLATE_ID Character(11) VARCHAR2(11) NOT NULL Contract Template ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 CNT_TASK_ORDER_NUM Character(25) VARCHAR2(25) NOT NULL Contract Task Order Number
    5 BEGIN_DT Date(10) DATE Begin Date
    6 END_DT Date(10) DATE end date
    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 DESCRLONG Long Character CLOB Long Description