ERN_PROGRAMEFFDTDefault Value: %date
ERNCDA=Amounts Only
B=Both Hours and Amount OK
E=Either Hours or Amount OK
F=Flat Amount
H=Hours Only
S=Defined by Salary System
U=Unit/Override Rate
ERN_PROG_DESCR(SQL View) |
Index Back |
|---|---|
Earnings Codes by Ern Pgm ViewThis view lists earnings codes by earnings program. |
| SELECT A.Ern_Program ,A.EffDt ,A.Erncd ,C.Descr ,C.Descrshort ,C.PAYMENT_TYPE FROM PS_Ern_Program_Def A, PS_Ern_Program_Tbl B, PS_EARNINGS_TBL C WHERE A.Ern_Program = B.Ern_Program AND A.Effdt = B.Effdt AND B.Eff_Status = 'A' AND C.Erncd = A.Erncd AND C.EffDt = (SELECT MAX(D.EffDt) FROM PS_EARNINGS_TBL D WHERE D.Erncd = C.Erncd AND D.EffDt <= A.EffDt) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERN_PROGRAM |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Program ID |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | ERNCD |
Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | PAYMENT_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payment Type
A=Amounts Only B=Both Hours and Amount OK E=Either Hours or Amount OK F=Flat Amount H=Hours Only S=Defined by Salary System U=Unit/Override Rate |