COMP_ERNCD_VW(SQL View) |
Index Back |
|---|---|
Earnings code view of Comp RecGive an earnings code view of the compensation record by employee and effective date/sequence. |
| SELECT A.EMPLID, A.EMPL_RCD, A.EFFDT, A.EFFSEQ, A.COMPRATE, A.CURRENCY_CD, B.ERNCD FROM PS_COMPENSATION A, PS_COMP_RATECD_TBL B WHERE A.COMP_RATECD = B.COMP_RATECD AND B.EFFDT <= A.EFFDT |
| # | 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 | EFFDT | Date(10) | DATE | Effective Date |
| 4 | EFFSEQ | Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | COMPRATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Compensation Rate |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL | Earnings Code |