TRW_STMT_IDTRW_DATASRC_IDEMPLIDEMPL_RCDCOMPANYPLAN_TYPEACCRUAL_PROC_DT001=None
002=Hours
003=Days
004=Weeks
005=Months
006=Stock Shares
TRW_BN_TMP_LBAL(SQL Table) |
Index Back |
|---|---|
TRW Benefit Leave Temp TableThis is the Benefit Leave Temp table. This table acts as a temporary extract table that is used to extract reward data for a specific configured Reward Item. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRW_STMT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Reward Statement ID |
| 2 | TRW_DATASRC_ID |
Character(15) | VARCHAR2(15) NOT NULL | Total rewards statement - Reward Data Source ID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 5 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 6 | PLAN_TYPE |
Character(2) | VARCHAR2(2) NOT NULL | Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans. |
| 7 | ACCRUAL_PROC_DT |
Date(10) | DATE | Accrual Process Date |
| 8 | LEAVE_HRS_BALANCE | Signed Number(13,6) | DECIMAL(11,6) NOT NULL | Leave Hours Balance |
| 9 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 10 | TRW_UOM | Character(3) | VARCHAR2(3) NOT NULL |
TRW Unit of Measure
001=None 002=Hours 003=Days 004=Weeks 005=Months 006=Stock Shares |
| 11 | TRW_CO_PROV_AMT | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Company Provided Amount |
| 12 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |