GPMY_NRP_ELG_VW (SQL View)	Index Back
Eligible Benefits Temporary eligible benefits record used in specifying payee benefits for Malaysia

GPMY_NRP_ELG_VW

(SQL View)

Eligible Benefits

Temporary eligible benefits record used in specifying payee benefits for Malaysia

SELECT A.EMPLID ,A.EMPL_RCD ,A.SEQNUM ,A.PIN_NUM +50000000 ,A.BGN_DT ,A.END_DT ,A.PIN_NM ,A.AMOUNT ,A.CURRENCY_CD ,A.GPMY_BIK_USE_APPLY , A.BGN_DT_BFR FROM PS_GPMY_ELIG_TMP A

# 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 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: %GP_EDIT_FLD7

5 BGN_DT Date(10) DATE Begin Date

6 END_DT Date(10) DATE end date

7 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

8 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.

9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

10 GPMY_BIK_USE_APPLY Character(1) VARCHAR2(1) NOT NULL Use Apply Indicator
Y/N Table Edit
Default Value: N

11 BGN_DT_BFR Date(10) DATE Begin Date

#	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	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
4	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %GP_EDIT_FLD7
5	BGN_DT	Date(10)	DATE	Begin Date
6	END_DT	Date(10)	DATE	end date
7	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
8	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	GPMY_BIK_USE_APPLY	Character(1)	VARCHAR2(1) NOT NULL	Use Apply Indicator Y/N Table Edit Default Value: N
11	BGN_DT_BFR	Date(10)	DATE	Begin Date