GPCH_EO_SNOR_VW

(SQL View)
 Index Back

EO Calculation

EO Calculation

SELECT B.EMPLID , B.EMPL_RCD , B.EFFDT , B.FROM_DT , B.GPCH_EO_CORR_IND , B.THRUDATE , B.ACTION_DT , B.DAYS_DIFF , B.GPCH_EO_SERV_TYPE , B.GPCH_EO_CARD_TYPE , B.DEP_BENEF_CNT , B.CURRENCY_CD , B.GPCH_EO_ANNUAL_AM , B.GPCH_EO_DIFF_AM , B.GPCH_EO_DAILY_RT , B.ACCOUNT , B.CONTROL_NUMBER FROM PS_JOB A , PS_GPCH_EO_ABR B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = B.EMPLID AND A1.EMPL_RCD = B.EMPL_RCD AND A1.EFFDT <= B.FROM_DT) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = B.EMPLID AND A2.EMPL_RCD = B.EMPL_RCD AND A2.EFFDT = A.EFFDT) AND A.COMP_FREQUENCY <> 'H' AND B.GPCH_EO_CORR_IND = 'S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 EFFDT Date(10) DATE NOT NULL Effective Date
4 FROM_DT Date(10) DATE NOT NULL From Date
5 GPCH_EO_CORR_IND Character(1) VARCHAR2(1) NOT NULL Household Allowance
6 THRUDATE Date(10) DATE NOT NULL End Date
7 ACTION_DT Date(10) DATE Action Date

Default Value: %Date

8 DAYS_DIFF Number(4,0) SMALLINT NOT NULL Days Difference
9 GPCH_EO_SERV_TYPE Character(2) VARCHAR2(2) NOT NULL Service Type
10=10 Military - Regular
11=11 Military Recruit
12=12 Military Promotion
13=13 Selection
14=14 Continued Service Uof
20=20 Civil defence
21=21 CivilS Recruit
22=22 Civils Mgr&Specialist
23=23 Civils&Serv Command
30=30 Trainer / J+S
40=40 Civil Service - regular
41=41 Civil Service - recruit
50=50 Young Rifleman Leader
10 GPCH_EO_CARD_TYPE Character(1) VARCHAR2(1) NOT NULL Card Type
1=1 EO Card
2=2 EO Replacement Card
4=4 Corrected Claim
11 DEP_BENEF_CNT Number(2,0) SMALLINT NOT NULL Dependent/Beneficiary Count
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

13 GPCH_EO_ANNUAL_AM Signed Number(12,2) DECIMAL(10,2) NOT NULL Annual Amount
14 GPCH_EO_DIFF_AM Signed Number(12,2) DECIMAL(10,2) NOT NULL Amount Difference
15 GPCH_EO_DAILY_RT Signed Number(12,2) DECIMAL(10,2) NOT NULL Annual Amount
16 ACCOUNT Character(10) VARCHAR2(10) NOT NULL Account
17 CONTROL_NUMBER Character(12) VARCHAR2(12) NOT NULL Control Number