EX_TRC_MAP_TBL (SQL Table)	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_TBL

(SQL Table)

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.

Related Language Record: EX_TRC_MAP_LNG

# 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 GRID_ROW_NUM Number(3,0) SMALLINT NOT NULL Grid Row Number
Default Value: 1

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

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

5 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
Default Value: N

6 FUTURE_ENTRY_FLG Character(1) VARCHAR2(1) NOT NULL Disable Future Entry
Y/N Table Edit
Default Value: Y

#	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	GRID_ROW_NUM	Number(3,0)	SMALLINT NOT NULL	Grid Row Number Default Value: 1
3	TRC	Character(5)	VARCHAR2(5) NOT NULL	Time Reporting Code
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	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 Default Value: N
6	FUTURE_ENTRY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Disable Future Entry Y/N Table Edit Default Value: Y