TRCDESCREFFDTA=Active
I=Inactive
GP_AB_TRC_VW(SQL View) |
Index Back |
|---|---|
TRC TableA Time Reporting Code (TRC) is used to classify a worker's time, primarily as the time is applied to a worker's compensation. |
| SELECT DISTINCT A.TRC , A.DESCR ,d.pin_num ,d.erncd , A.EFFDT , A.EFF_STATUS FROM PS_TL_TRC_TBL A , PS_TL_ERNCD_TBL B ,ps_gp_abs_anly_gen c , ps_gp_abs_ernddmap d , PS_GP_PIN P WHERE A.TRC = B.TRC AND A.EFFDT = B.EFFDT AND A.EFF_STATUS = B.EFF_STATUS AND a.eff_status='A' AND b.effdt= ( SELECT MAX(ch.effdt) FROM PS_TL_ERNCD_TBL ch WHERE ch.trc= b.trc AND ch.pay_system=b.pay_system) AND d.abs_pay_system_cd='NA' AND d.effdt=( SELECT MAX(ch.effdt) FROM ps_gp_abs_ernddmap ch WHERE ch.abs_pay_system_cd=d.abs_pay_system_cd AND ch.pin_num=d.pin_num) AND b.TL_erncd= P.PIN_CODE AND c.pin_num= d.pin_num AND C.PIN_NUM = P.PIN_NUM |
| # | 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 | DESCR |
Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | PIN_NUM_3 | Number(8,0) | INTEGER NOT NULL | Pin Number 3 |
| 4 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 5 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |