FO_CUST_ACMP_LG

(SQL Table)
Index Back

Table for desired languages

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
3 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

Prompt Table: RS_ACMP_LNG_VW

4 SPEAK_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Speaking Proficiency
1=Low
2=Moderate
3=High
5 READ_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Reading Proficiency
1=Low
2=Moderate
3=High
6 WRITE_PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Writing Proficiency
1=Low
2=Moderate
3=High
7 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points
8 SPEAK_PROF_NUM Number(1,0) SMALLINT NOT NULL The numeric version of the SPEAK_PROFICIENCY field.
9 READ_PROF_NUM Number(1,0) SMALLINT NOT NULL Numeric version of the READ_PROFICIENCY field.
10 WRITE_PROF_NUM Number(1,0) SMALLINT NOT NULL Numeric version of the WRITE_PROFICIENCY field.