TL_ERNCD_TBL(SQL Table) |
Index Back |
|---|---|
Earning Code TableThis object is child record that records the pay systems and corresponding earnings code for a particular TRC. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  TRC |
Character(5) | VARCHAR2(5) NOT NULL | Time Reporting Code used to report time in Time and Labor |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | PAY_SYSTEM |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America Prompt Table: TL_PAY_SYS_VW |
| 4 | TL_ERNCD | Character(22) | VARCHAR2(22) NOT NULL |
This field is an image of Earning code field or Payroll
Prompt Table: %EDITTABLE |
| 5 | TL_COPY_FROM | Character(3) | VARCHAR2(3) NOT NULL |
This field is used on TRC page to copy the TRC characteristics from Earnings table
Prompt Table:
EARNINGS_TBL
|
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 7 | TL_TAKECD | Character(22) | VARCHAR2(22) NOT NULL |
Take Code is used only when mapping a Global Payroll Absence specific TRC to the Take Code associated with absence reporting in Global Payroll.
Prompt Table: GP_TAKE_SRCH |
| 8 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: GP_ABS_NAERN_VW |