EMPLIDEMPL_RCDBN_ANNL_BENBASE_CDPrompt Table: ABBR_TYPE_TBL
EFFDTDefault Value: %date
Default Value: %DATE
BN_ANNL_BASE_RT(SQL Table) |
Index Back |
|---|---|
Annual Benefits Base RatesStores Multiple Annual Benefits Base Rates of Employees other than primary on JOB |
| # | 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 Rcd Nbr |
| 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
Default Value: %DATE |