EX_TRC_MAP_VW (SQL View)	Index Back
TRC Map Table This table maps Time Reporting Codes to user definable positions on the Time Sheet for items such as Vacation, Sick Leave, etc...This gives the Time Sheet a much more customizable User Interface, especially for the Traveler Professional.

EX_TRC_MAP_VW

(SQL View)

TRC Map Table

This table maps Time Reporting Codes to user definable positions on the Time Sheet for items such as Vacation, Sick Leave, etc...This gives the Time Sheet a much more customizable User Interface, especially for the Traveler Professional.

SELECT SETID , TRC , DESCR , BUS_HOL_FLG , FUTURE_ENTRY_FLG FROM PS_EX_TRC_MAP_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
Prompt Table: TL_TRC_TBL

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

4 BUS_HOL_FLG Character(1) VARCHAR2(1) NOT NULL This field defines the TRC code that is the default business holiday code.
N=No
Y=Yes

5 FUTURE_ENTRY_FLG Character(1) VARCHAR2(1) NOT NULL Disable Future Entry

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code Prompt Table: TL_TRC_TBL
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	BUS_HOL_FLG	Character(1)	VARCHAR2(1) NOT NULL	This field defines the TRC code that is the default business holiday code. N=No Y=Yes
5	FUTURE_ENTRY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Disable Future Entry