RS_FACT_WS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
3	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
4	RS_QUALIF_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Qulaiifcation Types for SO ANY=Any Type ATT=Attribute CMP=Competency DEG=Degree FAC=Other LIC=License LNG=Language MEM=Membership
5	RS_QUALIF_VALUE	Character(10)	VARCHAR2(10) NOT NULL	Code
6	RS_ATTRIBUTE_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.
7	RS_ATTR_VAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Attribute Value ID Prompt Table: %EDITTABLE3
8	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
9	REQUIRED_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Required Flag N=No Y=Yes Y/N Table Edit Default Value: N
10	WEIGHT_POINTS	Number(7,2)	DECIMAL(6,2) NOT NULL	Factor Weight Points
11	IMPORTANCE	Character(3)	VARCHAR2(3) NOT NULL	Importance EIM=Desired REQ=Required
12	IMPORTANCE_NO_REQ	Character(3)	VARCHAR2(3) NOT NULL	Importance EIM=1 - Extremely Important IMP=3 - Important SLI=Desirable SOI=Very Desirable VIM=2 - Very Important