HR_LOCDET_TL_VW

(SQL View)
Index Back

Location Source Tax Vw

This view searches for the Tax Location code on the JOB table when determining the employee address to use for Market Pay Geography purposes

SELECT L.SETID , J.EMPLID , J.EMPL_RCD , J.EFFDT , J.EFFSEQ , J.TAX_LOCATION_CD , J.JOBCODE , L.COUNTRY , L.CITY , L.STATE FROM PS_JOB J , PS_LOCATION_TBL L WHERE J.TAX_LOCATION_CD = L.LOCATION AND J.EFFDT = L.EFFDT AND J.TAX_LOCATION_CD <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SET_VLD_HR_03

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 EFFDT Date(10) DATE Effective Date
5 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
6 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

Prompt Table: %RECNAME_EDIT

7 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL