ERNCD_SPCLA=Adds to Special Balance
S=Subtracts from Special Balance
T=Adds TXGRS to Special Balance
ERNCDDefault Value: %date
A=Active
I=Inactive
SPCL_EARNS_VW(SQL View) |
Index Back |
|---|---|
Special Accum / Earnings TableThis view lists earnings codes grouped by special accumulator earnings codes. |
| SELECT a.erncd_spcl ,a.spcl_effect ,b.erncd ,b.effdt ,b.eff_status ,b.descr ,b.descrshort FROM ps_earnings_spcl a , PS_EARNINGS_TBL b WHERE b.erncd = a.erncd AND b.eff_status = 'A' AND a.effdt = b.effdt AND b.effdt = ( SELECT MAX(effdt) FROM PS_EARNINGS_TBL c WHERE c.erncd = b.erncd) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERNCD_SPCL |
Character(3) | VARCHAR2(3) NOT NULL | Special Accumulator Code |
| 2 | 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 |
| 3 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 4 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |