PC_RATE_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PC_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rate Template ID
3	TEMPLATE_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Used to identify what document/transaction is associated with a particular template. This is a translate table field whose value is either expense sheet or travel authorization. Cash advances do not use templates. Projects is using types are R and C. C=Contract E=Expense Report R=Standard T=Travel Authorization
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	DETAIL_NO	Number(3,0)	SMALLINT NOT NULL	Detail Number Default Value: 1
6	ANALYSIS_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Analysis Type Prompt Table: PROJ_ANTYPE_TBL
7	RESOURCE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Source Type Prompt Table: PROJ_RES_TYPE
8	RESOURCE_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	Category Prompt Table: %EDITTABLE
9	RESOURCE_SUB_CAT	Character(5)	VARCHAR2(5) NOT NULL	Subcategory Prompt Table: %EDITTABLE2
10	PROJ_ROLE	Character(15)	VARCHAR2(15) NOT NULL	Project Role Prompt Table: PROJ_ROLE
11	JOBCODE	Character(6)	VARCHAR2(6) NOT NULL	Job Code Prompt Table: JOBCODE_TBL
12	TIME_RPTG_CD	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Prompt Table: TL_TM_RPTCD_VW
13	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
14	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PROJ_TEAM_VW
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
16	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit Prompt Table: SP_BU_GL_NONVW
17	ACCOUNT	Character(10)	VARCHAR2(10) NOT NULL	Account Prompt Table: GL_ACCOUNT_TBL
18	ALTACCT	Character(10)	VARCHAR2(10) NOT NULL	Alternate Account Prompt Table: ALTACCT_BUGL_VW
19	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPTID_BUGL_VW
20	OPERATING_UNIT	Character(8)	VARCHAR2(8) NOT NULL	Operating Unit ChartField Prompt Table: OPERUNT_BUGL_VW
21	PRODUCT	Character(6)	VARCHAR2(6) NOT NULL	Product ChartField Prompt Table: PRODUCT_BUGL_VW
22	FUND_CODE	Character(5)	VARCHAR2(5) NOT NULL	Fund Code Prompt Table: FUND_BUGL_VW
23	CLASS_FLD	Character(5)	VARCHAR2(5) NOT NULL	Class Field Prompt Table: CLASSCF_BUGL_VW
24	PROGRAM_CODE	Character(5)	VARCHAR2(5) NOT NULL	Program Code ChartField Prompt Table: PROGRAM_BUGL_VW
25	BUDGET_REF	Character(8)	VARCHAR2(8) NOT NULL	Budget Reference Prompt Table: BUD_REF_BUGL_VW
26	AFFILIATE	Character(5)	VARCHAR2(5) NOT NULL	Affiliate Prompt Table: AFFILIATE_VW
27	AFFILIATE_INTRA1	Character(10)	VARCHAR2(10) NOT NULL	IntraUnit Affiliate1 Prompt Table: %EDIT_INTRA01
28	AFFILIATE_INTRA2	Character(10)	VARCHAR2(10) NOT NULL	Operating Unit Affiliate Prompt Table: %EDIT_INTRA02
29	CHARTFIELD1	Character(10)	VARCHAR2(10) NOT NULL	Expansion chartfield 1 Prompt Table: CF1_BUGL_VW
30	CHARTFIELD2	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 2 Prompt Table: CF2_BUGL_VW
31	CHARTFIELD3	Character(10)	VARCHAR2(10) NOT NULL	Expansion Chartfield 3 Prompt Table: CF3_BUGL_VW
32	SCH_LABOR_IND	Character(3)	VARCHAR2(3) NOT NULL	Labor Indicator N=No Y=Yes Default Value: Y
33	STANDARD_RATE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Standard Rate Default Value: 0
34	OVERTIME_RATE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	OverTime Rate Default Value: 0
35	COST_PER_USE	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Cost Per Use Default Value: 0
36	WHERE_CLAUSE_LONG	Long Character(4000)	CLOB	Where Clause
37	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
38	PC_MSP_RES_ID	Character(40)	VARCHAR2(40) NOT NULL	MSP Transaction Definition
39	DESCR254_MIXED	Character(254)	VARCHAR2(254) NOT NULL	Description