TRC_PROGRAMEFFDTTRCPrompt Table: TL_TRC_TBL
A=Administrator Only
M=Manager or Administrator Only
N=No Restrictions
Default Value: N
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 |
| 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 |
| 4 | TRC_ACCESS | Character(1) | VARCHAR2(1) NOT NULL |
Field introduced to control TRC selection indicating a TRC is only available for entry in the Manager View (the employee cannot report this TRC himself). Applicable for example to BONUS etc..
A=Administrator Only M=Manager or Administrator Only N=No Restrictions Default Value: N |
| 5 | ORDER_BY_SEQ | Number(2,0) | SMALLINT NOT NULL | Added in Mouse Over Label |