INC_EARD_VW_NLD(SQL View) |
Index Back |
|---|---|
Inc. Earnings - Data EntryIncident Earnings View of PS_INC_EARNING_NLD - for NLD |
| SELECT A.EFFDT , A.EMPLID , A.EMPL_RCD , A.EFFSEQ , A.ERNCD , A.CURRENCY_CD , A.SHIFT , A.OTH_HRS , A.HOURLY_RT , A.OTH_PAY , A.PERIOD_BEGIN_NLD , A.PERIOD_END_NLD , A.COMMENTS_NLD , A.OK_TO_PAY FROM PS_INC_EARNING_NLD A WHERE EXISTS ( SELECT 'X' FROM PS_EARNINGS_TBL B WHERE B.ERNCD = A.ERNCD AND (B.PERMANENCY_NLD = 'I' OR B.PERMANENCY_NLD = 'B') AND B.PAYMENT_TYPE = 'H') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: EMPLMT_SRCH_GBL |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL |
Empl Record
Prompt Table: EMPLMT_SRCH_GBL |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | ERNCD | Character(3) | VARCHAR2(3) NOT NULL |
Earnings Code
Prompt Table: INC_EARH_VW_NLD |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: JOB_CURR_VW.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 7 | SHIFT | Character(1) | VARCHAR2(1) NOT NULL |
Regular Shift
1=Day 2=Evening 3=Night A=Any C=Compressed N=Not Applicable R=Rotating |
| 8 | OTH_HRS | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Other hours. |
| 9 | HOURLY_RT | Number(19,6) | DECIMAL(18,6) NOT NULL | Hourly Rate |
| 10 | OTH_PAY | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Other Pay |
| 11 | PERIOD_BEGIN_NLD | Date(10) | DATE | Begin Period |
| 12 | PERIOD_END_NLD | Date(10) | DATE | End Period |
| 13 | COMMENTS_NLD | Character(80) | VARCHAR2(80) NOT NULL | Comments |
| 14 | OK_TO_PAY | Character(1) | VARCHAR2(1) NOT NULL |
Okay to pay indicator.
Default Value: Y |