WM_WO_ACMP_LNG

(SQL Table)
Index Back

Requirements - Language

Requirements - Language

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 RQMT_LN_NBR Number(5,0) INTEGER NOT NULL Requirement Line Number
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.