FO_RATE_PRFL_WS

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	RATE_PROFILE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Profile Type S=Salaried Staff T=Temporary Staff V=Associated Supplier
3	DETAIL_NO	Number(3,0)	SMALLINT NOT NULL	Detail Number Default Value: 1
4	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence Default Value: 1
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	FO_DFLT_RATE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Default Rate Y/N Table Edit Default Value: N
8	FO_RATE_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Rate Action A=Pay and Bill B=Bill Only M=Mark-up P=Pay Only Default Value: A
9	FO_PAY_RATE_FACTOR	Number(5,2)	DECIMAL(4,2) NOT NULL	Rate Factor
10	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PROJ_ANTYPE_TBL
11	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RES_TYPE
12	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDITTABLE
13	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDITTABLE2
14	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
15	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Prompt Table: FO_TRC_VW
16	UNIT_OF_MEASURE	Character(3)	VARCHAR2(3) NOT NULL	Used on an approval rule set. MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: UNITS_TBL
17	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PROJ_TEAM_VW
18	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
19	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
20	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL
21	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_BUGL_VW
22	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
23	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
24	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
25	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
26	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
27	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
28	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
29	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
30	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
31	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
32	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
33	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
34	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
35	SCH_LABOR_IND	Character(3)	VARCHAR2(3) NOT NULL	Labor Indicator N=No Y=Yes Default Value: Y
36	STANDARD_RATE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Standard Rate Default Value: 0
37	OVERTIME_RATE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	OverTime Rate Default Value: 0
38	COST_PER_USE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Cost Per Use Default Value: 0
39	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
40	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
41	PC_MSP_RES_ID	Character(40)	VARCHAR2(40) NOT NULL	MSP Transaction Definition
42	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description
43	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: PROJ_ROLE