GPMY_NRP_ERN_VW (SQL View)	Index Back
Earning Tax Record - Malaysia Temporary Earningns Tax Record - Malaysia

GPMY_NRP_ERN_VW

(SQL View)

Earning Tax Record - Malaysia

Temporary Earningns Tax Record - Malaysia

SELECT A.EMPLID ,A.EMPL_RCD ,A.SEQNUM ,A.PIN_NUM +50000000 ,A.PIN_NM ,A.BGN_DT ,A.END_DT ,A.AMOUNT FRP FROM PS_GPMY_EARN_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 Record

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 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field

6 BGN_DT Date(10) DATE Begin Date

7 END_DT Date(10) DATE end date

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

#	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 Record
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	PIN_NM	Character(18)	VARCHAR2(18) NOT NULL	Element Name field
6	BGN_DT	Date(10)	DATE	Begin Date
7	END_DT	Date(10)	DATE	end date
8	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.