GPJP_JOB_IT_VW (SQL View)	Index Back
GPJP Job-Income Tax view This view fetches employee's job hr status, job effdt, income tax type and income tax effdt which is used in array.

GPJP_JOB_IT_VW

(SQL View)

GPJP Job-Income Tax view

This view fetches employee's job hr status, job effdt, income tax type and income tax effdt which is used in array.

SELECT a.EMPLID ,a.EMPL_RCD ,a.EFFDT , b.EFFDT , a.HR_STATUS , b.GPJP_IT_TYPE FROM PS_JOB a , PS_GPJP_IT_PYE_TAX b WHERE a.EMPLID = b.EMPLID AND a.EMPL_RCD = b.EMPL_RCD

# 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 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 EFFDT2_JPN Date(10) DATE This field is used as an Effective Date field on a page. This field prompts for acceptable values, and the Core field EFFDT does not permit such prompting.

5 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive

6 GPJP_IT_TYPE Character(2) VARCHAR2(2) NOT NULL Used in Income Tax Data.
10=KOU
20=OTSU
30=Designated Rate

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	EFFDT2_JPN	Date(10)	DATE	This field is used as an Effective Date field on a page. This field prompts for acceptable values, and the Core field EFFDT does not permit such prompting.
5	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
6	GPJP_IT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Used in Income Tax Data. 10=KOU 20=OTSU 30=Designated Rate