UPG_SP_TRC_VW (SQL View)	Index Back
sPro TRC View for Upgrades Introduced for Upgrade from Release 8.0x to 8.9 - Returns the Time Reporting Codes and description that are defined in the TL_TRC_TBL record having TRC_TYPE = 'H', FACTOR_MULT = 1 and EFF_STATUS = 'A'. This view is used as a prompt record in the pre-upgrade options for Services Procurement.

UPG_SP_TRC_VW

(SQL View)

sPro TRC View for Upgrades

Introduced for Upgrade from Release 8.0x to 8.9 - Returns the Time Reporting Codes and description that are defined in the TL_TRC_TBL record having TRC_TYPE = 'H', FACTOR_MULT = 1 and EFF_STATUS = 'A'. This view is used as a prompt record in the pre-upgrade options for Services Procurement.

SELECT TRC , DESCR FROM PS_TL_TRC_TBL WHERE TRC_TYPE = 'H' AND FACTOR_MULT = 1 AND EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description