UPG_TL_TRC_XREF(SQL Table) |
Index Back |
|---|---|
TL TRC XREFTime and Labor Upgrade to 8.0 TRC Cross-reference Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TIME_RPTG_CD |
Character(5) | VARCHAR2(5) NOT NULL |
Time Reporting code
Prompt Table: TL_TRC_TBL |
| 2 | WORKGROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Workgroup
Prompt Table: TL_WRKGRP_TBL |
| 3 | TIME_RPTG_CD_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Time Reporting Code Type
A=Amounts Only B=Both Hours and Amounts OK E=Either Hours or Amounts OK H=Hours Only U=Units Only |
| 4 | UPG_TRC_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Time and Labor Upgrade to 8.0 TRC Type
A=Amounts H=Hours U=Units |
| 5 | UPG_MAPPING_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Time and Labor Upgrade to 8.0 Mapping Type
D=Duplicate TRC P=TRC Program Mapping T=TRC Type Conversion |
| 6 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 7 | UPG_TRC | Character(5) | VARCHAR2(5) NOT NULL |
Time and Labor Upgrade to 8.0 Time Reporting Code
Prompt Table: UPG_TL_TRC_VW |