FO_JOB_BILL_RT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL.SETID Prompt Table: SP_SETID_NONVW
2	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
5	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL
6	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
7	BILL_RATE_A	Number(7,2)	DECIMAL(6,2) NOT NULL	Bill Rate A
8	PAY_RATE_A	Number(7,2)	DECIMAL(6,2) NOT NULL	Pay Rate A
9	BILL_RATE_B	Number(7,2)	DECIMAL(6,2) NOT NULL	Bill Rate B
10	PAY_RATE_B	Number(7,2)	DECIMAL(6,2) NOT NULL	Pay Rate B
11	BILL_RATE_C	Number(7,2)	DECIMAL(6,2) NOT NULL	Bill Rate C
12	PAY_RATE_C	Number(7,2)	DECIMAL(6,2) NOT NULL	Pay Rate C
13	MARGIN_CAUTION	Number(6,2)	DECIMAL(5,2) NOT NULL	Caution
14	MARGIN_CRITICAL	Number(6,2)	DECIMAL(5,2) NOT NULL	Critical
15	GL_INDEX_SALES	Number(6,0)	INTEGER NOT NULL	Sales
16	GL_INDEX_COST_SALE	Number(6,0)	INTEGER NOT NULL	Cost of Sales
17	GL_INDEX_APP_LABOR	Number(6,0)	INTEGER NOT NULL	Applied Labor Expense