ERNCDEFFDTDefault Value: %date
ERNCD_SPCLPrompt Table: SPCL_EARNS_TBL
A=Adds to Special Balance
S=Subtracts from Special Balance
T=Adds TXGRS to Special Balance
Default Value: A
EARNINGS_SPCL(SQL Table) |
Index Back |
|---|---|
Spcl Accum for Earnings CodeThis record is used to roll together specific earnings types to be used later in deduction calculations. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | ERNCD_SPCL |
Character(3) | VARCHAR2(3) NOT NULL |
Special Accumulator Code
Prompt Table: SPCL_EARNS_TBL |
| 4 | SPCL_EFFECT | Character(1) | VARCHAR2(1) NOT NULL |
Effect on Special Balance
A=Adds to Special Balance S=Subtracts from Special Balance T=Adds TXGRS to Special Balance Default Value: A |