PC_RATE_D_L_HIS

#	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	LINE_NO	Number(3,0)	SMALLINT NOT NULL	Line Number Default Value: 1
7	TGT_SEQ_NBR	Number(6,2)	DECIMAL(5,2) NOT NULL	Target sequence number
8	RATE_OPTION	Character(3)	VARCHAR2(3) NOT NULL	Rate Option ABI=Activity Bill Rate ACO=Activity Cost Rate AML=Mark Up/Down Labor AMN=Mark Up/Down Non-labor AMT=Quantity Rate CRB=Custom Bill Rate CRC=Custom Cost Rate EBI=Employee Bill Rate ECO=Employee Cost Rate FIX=Fixed Amount JBI=Job Code Bill Rate JCO=Job Code Cost Rate MUP=Markup Rate NON=Bill at Cost RBI=Project Role Bill Rate RCO=Project Role Cost Rate TBI=MM Tools Usage Bill Rate TCO=MM Tools Usage Cost Rate WBI=Work Order Labor Bill Rate WCO=Work Order Labor Cost Rate
9	RATE_AMT	Number(30,6)	DECIMAL(29,6) NOT NULL	Rate Amount for Rates.
10	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
11	USER_ID	Character(30)	VARCHAR2(30) NOT NULL	User ID
12	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	PROCESSED_DATE	Date(10)	DATE	Processed Date
14	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
15	VAR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Variance Status A=Active I=Inactive P=Pending