GPCH_EO_RTO_VW

(SQL View)
 Index Back

EO Calculation

EO Calculation

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.FROM_DT , A.GPCH_EO_CORR_IND , A.THRUDATE , A.ACTION_DT , A.DAYS_DIFF , A.GPCH_EO_SERV_TYPE , A.GPCH_EO_CARD_TYPE , A.DEP_BENEF_CNT , A.CURRENCY_CD , A.GPCH_EO_ANNUAL_AM , A.GPCH_EO_DIFF_AM , A.GPCH_EO_DAILY_RT , A.ACCOUNT , A.CONTROL_NUMBER , A.GPCH_GR_OVRD , A.GPCH_TX_CANTON , A.COUNTRY , A.GPCH_EO_IV_GUARANT , A.MAR_STATUS , A.TO_DATE , A.GPCH_EO_REFNBR FROM PS_GPCH_EO_ABR A WHERE A.GPCH_EO_CORR_IND = 'K'

# 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
18 GPCH_GR_OVRD Character(1) VARCHAR2(1) NOT NULL Override

Y/N Table Edit

Default Value: N

19 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton

Prompt Table: GPCH_TX_CANT_VW

20 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

21 GPCH_EO_IV_GUARANT Character(1) VARCHAR2(1) NOT NULL Indicator IV-Daily Payment for EO Page

Y/N Table Edit

Default Value: N

22 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
23 TO_DATE Date(10) DATE Latest Date to be sent to PYR
24 GPCH_EO_REFNBR Number(8,0) INTEGER NOT NULL Unique reference number for Military data