UPG_TL_TRC_X_VW(SQL View) |
Index Back |
|---|---|
TL TRC XREF ViewTime and Labor Upgrade to 8.0 TRC Cross Reference View |
| SELECT TIME_RPTG_CD , WORKGROUP , TIME_RPTG_CD_TYPE , UPG_TRC_TYPE , UPG_MAPPING_TYPE , ERNCD , UPG_TRC FROM PS_UPG_TL_TRC_XREF |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TIME_RPTG_CD |
Character(5) | VARCHAR2(5) NOT NULL | Time Reporting code |
| 2 | WORKGROUP |
Character(10) | VARCHAR2(10) NOT NULL | Workgroup |
| 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 |