CONT_ACMP_LNG

(SQL Table)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CONTACT_ID Character(15) VARCHAR2(15) NOT NULL Contact Identifier for Treasury Contacts

3 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
Prompt Table: RS_ACMP_DEG_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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CONTACT_ID	Character(15)	VARCHAR2(15) NOT NULL	Contact Identifier for Treasury Contacts
3	ACCOMPLISHMENT	Character(8)	VARCHAR2(8) NOT NULL	Accomplishment Prompt Table: RS_ACMP_DEG_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.