TRC_PROGRAMPrompt Table: TL_TRC_PGM_TBL
EFFDTTRCPrompt Table: TL_TRC_TBL
TL_TRCPGELE_TBL(SQL Table) |
Index Back |
|---|---|
TRC Program Element TableA 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 Element Table maintains the assignment of TRCs to the program. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRC_PROGRAM |
Character(5) | VARCHAR2(5) NOT NULL |
TRC Program ID
Prompt Table: TL_TRC_PGM_TBL |
| 2 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 3 | TRC |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting Code used to report time in Time and Labor
Prompt Table: TL_TRC_TBL |