TL_TRC_PGM_TBL (SQL Table)	Index Back
TRC Program Table A TRC Program is a collection of Time Reporting Codes (TRCs), which fit the Time Reporting and Compensation requirements of one or more groups of time reporters. The TRC Program Table maintains the definition of the program, while the assignment of the TRCs to the program is maintained in the TRC Program Element table (TL_TRCPGELE_TBL).

TL_TRC_PGM_TBL

(SQL Table)

TRC Program Table

A TRC Program is a collection of Time Reporting Codes (TRCs), which fit the Time Reporting and Compensation requirements of one or more groups of time reporters. The TRC Program Table maintains the definition of the program, while the assignment of the TRCs to the program is maintained in the TRC Program Element table (TL_TRCPGELE_TBL).

Related Language Record: TL_TRC_PGM_LANG

Parent Record Of TL_TRCPGELE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRC_PROGRAM Character(5) VARCHAR2(5) NOT NULL TRC Program ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
Default Value: TL_TRC_PGM_TBL.DESCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRC_PROGRAM	Character(5)	VARCHAR2(5) NOT NULL	TRC Program ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: TL_TRC_PGM_TBL.DESCR