SPA_TE_TRC_VW (SQL View)	Index Back
SPA TRC Codes for Overtime

SPA_TE_TRC_VW

(SQL View)

SPA TRC Codes for Overtime

SELECT B.BUSINESS_UNIT , B.TE_TEMPLATE_ID , A.TRC , A.DESCR , A.FACTOR_MULT FROM PS_TL_TRC_TBL A , PS_SPA_TM_TMPL_TRC B WHERE A.TRC = B.TRC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 TE_TEMPLATE_ID Character(8) VARCHAR2(8) NOT NULL Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.

3 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 FACTOR_MULT Signed Number(11,4) DECIMAL(9,4) NOT NULL Multiplication Factor

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	TE_TEMPLATE_ID	Character(8)	VARCHAR2(8) NOT NULL	Used to define a particular type of travel, i.e. company relocation, internal travel, etc. Determines what type of expenses and expenditure limits are associated with that particular type of travel. Established in the Structure Expenses system and chosen on the header panel of cash expense sheets.
3	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	FACTOR_MULT	Signed Number(11,4)	DECIMAL(9,4) NOT NULL	Multiplication Factor