RF_BU_TM_TYP_VW (SQL View)	Index Back
Time Type View for BU This view holds all the Time Types defined for the Business Unit. In addition description field is selected from associated time type.

RF_BU_TM_TYP_VW

(SQL View)

Time Type View for BU

This view holds all the Time Types defined for the Business Unit. In addition description field is selected from associated time type.

SELECT A.BUSINESS_UNIT , A.TIMETYPE , B.DESCRSHORT , A.BILLABLE_FLAG , A.SYNCID , A.SYNCDTTM FROM PS_RF_BU_TIME_TYPE A , PS_RF_TIME_TYPE B , PS_SET_CNTRL_REC C WHERE A.TIMETYPE = B.TIMETYPE AND B.SETID = C.SETID AND C.SETCNTRLVALUE = A.BUSINESS_UNIT AND C.RECNAME = 'RF_TIME_TYPE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT

2 TIMETYPE Character(4) VARCHAR2(4) NOT NULL The different types of time activity used for billing purposes.
Prompt Table: RF_TIME_TYPE

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

4 BILLABLE_FLAG Character(1) VARCHAR2(1) NOT NULL This is used to determine of the item under consideration is billable or not.
N=No
Y=Yes
Y/N Table Edit
Default Value: N

5 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

6 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_RB.BUSINESS_UNIT
2	TIMETYPE	Character(4)	VARCHAR2(4) NOT NULL	The different types of time activity used for billing purposes. Prompt Table: RF_TIME_TYPE
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
4	BILLABLE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This is used to determine of the item under consideration is billable or not. N=No Y=Yes Y/N Table Edit Default Value: N
5	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
6	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time