RS_SCWB_TEAM_WS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	RANKING	Character(4)	VARCHAR2(4) NOT NULL	Ranking Value
3	FIT_DISPLAY	Character(15)	VARCHAR2(15) NOT NULL	Fit Display
4	FIT_DISPLAY_AVA	Character(15)	VARCHAR2(15) NOT NULL	Display availability fitness score.
5	FIT_DISPLAY_JOY	Character(15)	VARCHAR2(15) NOT NULL	Display preference fitness scores.
6	FIT_DISPLAY_QUA	Character(15)	VARCHAR2(15) NOT NULL	Display qualification fitness score.
7	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
8	ASSIGN_STS	Character(2)	VARCHAR2(2) NOT NULL	Assignment Status A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel Prompt Table: RS_ASSGN_ST_TBL
9	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID
10	START_DT	Date(10)	DATE	Start Date
11	END_DT	Date(10)	DATE	End Date
12	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label Default Value: %Date
13	COMMENTS_254	Character(254)	VARCHAR2(254) NOT NULL	EDI Comments
14	TIME_START	Time(15)	TIMESTAMP	Start Time
15	SCHEDULED_HRS	Signed Number(10,4)	DECIMAL(8,4) NOT NULL	Scheduled Hours
16	SUN	Character(1)	VARCHAR2(1) NOT NULL	Sunday Y/N Table Edit
17	MON	Character(1)	VARCHAR2(1) NOT NULL	Monday Y/N Table Edit
18	TUES	Character(1)	VARCHAR2(1) NOT NULL	Tuesday Y/N Table Edit
19	WED	Character(1)	VARCHAR2(1) NOT NULL	Wednesday Y/N Table Edit
20	THURS	Character(1)	VARCHAR2(1) NOT NULL	Thursday Y/N Table Edit
21	FRI	Character(1)	VARCHAR2(1) NOT NULL	Friday Y/N Table Edit
22	SAT	Character(1)	VARCHAR2(1) NOT NULL	Saturday Y/N Table Edit
23	UPDATE_ENTRY	Character(1)	VARCHAR2(1) NOT NULL	Don't Post Duplicate Entries Y/N Table Edit Default Value: Y
24	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Task Category Prompt Table: RS_TASK_CAT
25	SKIP_INELGBL_DAYS	Character(1)	VARCHAR2(1) NOT NULL	Skip Ineligible Days Y/N Table Edit