EMPLIDEMPL_RCDBN_ANNL_BENBASE_CDPrompt Table: ABBR_TYPE_TBL
EFFDTDefault Value: %date
BN_ABBR_EFDT_VW(SQL View) |
Index Back |
|---|---|
Annl Benef Base Rate EffDt VwThis is a view of Annual Benefits Base Rates table without peoplecode |
| SELECT A.EMPLID , A.EMPL_RCD , A.BN_ANNL_BENBASE_CD , A.EFFDT , A.ANNL_BENEF_BASE_RT , A.CURRENCY_CD , A.LAST_UPDATE_DATE FROM PS_BN_ANNL_BASE_RT A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 3 | BN_ANNL_BENBASE_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Identifies the type of Annual Benefits Base Rate
Prompt Table: ABBR_TYPE_TBL |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | ANNL_BENEF_BASE_RT | Number(19,3) | DECIMAL(18,3) NOT NULL | Specifies a compensation amount used to calculate benefits and benefit deductions for an employee. The base compensation amount may include commissions and bonuses in addition to regular compensation. If no Annual Benefits Base Rate is entered, then benefits calculations are based on an employee's regular compensation. |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |