WM_WO_TTMPL_LLG

(SQL Table)
 Index Back

WO Task Tmplt Lbr Accmp Lang

WO Task Template -- Labor Accomplishment-Language

  • Parent record: WM_WO_TTMPL_LBR

    • # 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 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number

    Default Value: 1

    5 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: WM_ACMP_LNG_VW

    6 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
    1=Low
    2=Moderate
    3=High
    7 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
    1=Low
    2=Moderate
    3=High
    8 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
    1=Low
    2=Moderate
    3=High
    9 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points

    Default Value: 5

    10 SPEAK_PROF_NUM Number(1,0) SMALLINT NOT NULL The numeric version of the SPEAK_PROFICIENCY field.
    11 READ_PROF_NUM Number(1,0) SMALLINT NOT NULL Numeric version of the READ_PROFICIENCY field.
    12 WRITE_PROF_NUM Number(1,0) SMALLINT NOT NULL Numeric version of the WRITE_PROFICIENCY field.