WM_WO_TTMPL_NOT

(SQL Table)
Index Back

WO Task Tmplt Notes

WO Task Template -- Notes

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

    Prompt Table: SP_SETID_NONVW

    2 WO_TEMPLATE_ID Character(25) VARCHAR2(25) NOT NULL Work Order Task/Job Template ID
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SEQ_NBR_5 Number(5,0) INTEGER NOT NULL Sequence number five digits long

    Default Value: 1

    5 TITLE Character(35) VARCHAR2(35) NOT NULL Title
    6 NOTES Long Character CLOB NOT NULL Budget Notes
    7 NOTE_SOURCE Character(1) VARCHAR2(1) NOT NULL Note Source
    0=Service Request
    1=Work Order Header
    2=3rd Party
    3=Other
    4=Work Order Task
    5=Inspection Activity

    Default Value: 1

    8 VISIBLE_FLG Character(1) VARCHAR2(1) NOT NULL Yes/No Indicator

    Default Value: Y