GPCHTX012_VW

(SQL View)
 Index Back

Temp Record View for GPCHTX01

Temp Record View for GPCHTX01

SELECT A.PROCESS_INSTANCE ,A.GPCH_TX_CANTON ,A.GPCH_TX_VILLAGE_CD ,A.GPCH_TX_TRF_TYPE ,A.EMPLID ,A.EMPL_RCD ,A.BEGIN_DT ,A.END_DT ,B.NAME ,A.HIRE_DT ,A.TERMINATION_DT ,A.BIRTHDATE ,A.MAR_STATUS ,A.SEX ,A.GPCH_TX_TRF_CD ,A.POSTAL ,A.GPCH_TX_VILLAGE_L ,A.NATIONAL_ID ,A.GPCH_AH_NNSS ,A.COUNTRY_FROM ,A.SPOUSE_NAME ,A.GPCH_TX_SPOUSE_WL ,A.GPCH_RC_AL01_S1 ,A.GPCH_RC_AL01_S2 ,A.GPCH_RP_AMOUNT1 ,A.GPCH_RP_AMOUNT2 ,A.GPCH_RP_AMOUNT3 ,A.GPCH_RP_AMOUNT10 ,A.GPCH_RP_AMOUNT14 ,A.GPCH_RP_AMOUNT15 ,A.GPCH_RP_AMOUNT19 ,A.GPCH_RP_AMOUNT20 ,A.GPCH_RP_AMOUNT21 ,A.GPCH_RP_AMOUNT24 ,A.GPCH_RP_AMOUNT25 ,A.GPCH_RP_AMOUNT27 ,A.VISA_PERMIT_TYPE ,A.CONTRACT_TYPE ,A.REG_TEMP ,A.LOCATION ,A.FTE ,A.SETID_LOCATION FROM PS_GPCHTX012_TMP A ,PS_NAMES B WHERE A.EMPLID=B.EMPLID AND B.NAME_TYPE = ( SELECT C.NAME_TYPE FROM PS_GPCH_AL_INSTALL C) AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_NAMES D WHERE D.EMPLID = B.EMPLID AND D.NAME_TYPE = B.NAME_TYPE AND D.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 GPCH_TX_CANTON Character(2) VARCHAR2(2) NOT NULL Canton
3 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code
4 GPCH_TX_TRF_TYPE Character(1) VARCHAR2(1) NOT NULL Tariff Group
A=A Single Person
B=B Sole Earner (Married)
C=C Double Earner
D=D Secondary Occupation
K=K Cohabitants GR Only
L=I1 Spouse Intl Function 0.5 GE
M=I2 Spouse Intl Function 1.0 GE
N=I3 Spouse Intl Function 1.5 GE
O=I4 Spouse Intl Function 2.0 GE
V=V Double Earner (Female) VD
5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
7 BEGIN_DT Date(10) DATE Begin Date
8 END_DT Date(10) DATE end date
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 HIRE_DT Date(10) DATE First Start Date
11 TERMINATION_DT Date(10) DATE Termination Date
12 BIRTHDATE Date(10) DATE Date of Birth
13 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
14 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
15 GPCH_TX_TRF_CD Character(10) VARCHAR2(10) NOT NULL Withholding Tax Tariff
16 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
17 GPCH_TX_VILLAGE_L Character(4) VARCHAR2(4) NOT NULL Village Code
18 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
19 GPCH_AH_NNSS Character(20) VARCHAR2(20) NOT NULL New Social Insurance ID
20 COUNTRY_FROM Character(3) VARCHAR2(3) NOT NULL From Country
21 SPOUSE_NAME Character(40) VARCHAR2(40) NOT NULL Spouse Name
22 GPCH_TX_SPOUSE_WL Character(1) VARCHAR2(1) NOT NULL Indicates whether spouse works in Switzerland. Required for Source Tax GE and TI
0=No
1=Works in Switzerland
2=Works in Geneva
3=Works outside Switzerland

Y/N Table Edit

23 GPCH_RC_AL01_S1 Character(1) VARCHAR2(1) NOT NULL
C=Company
D=Deptid
E=Emplid
G=PayGroup
K=Canton
L=Location
N=Name
24 GPCH_RC_AL01_S2 Character(1) VARCHAR2(1) NOT NULL 2. Sort Criteria
C=Company
D=Deptid
E=Emplid
G=PayGroup
K=Canton
L=Location
N=Name
25 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
26 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
27 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
28 GPCH_RP_AMOUNT10 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 10
29 GPCH_RP_AMOUNT14 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 14
30 GPCH_RP_AMOUNT15 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 15
31 GPCH_RP_AMOUNT19 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 19
32 GPCH_RP_AMOUNT20 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 20
33 GPCH_RP_AMOUNT21 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 21
34 GPCH_RP_AMOUNT24 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 24
35 GPCH_RP_AMOUNT25 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 25
36 GPCH_RP_AMOUNT27 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 27
37 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
38 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
39 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
40 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
41 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
42 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID