GPCHTX011_VW

(SQL View)
 Index Back

Temp Record View for GPCHTX01

Temp Record View for GPCHTX01

SELECT A.PROCESS_INSTANCE ,A.GPCH_TX_CANTON ,A.EMPLID ,A.CAL_RUN_ID ,A.EMPL_RCD ,A.GP_PAYGROUP ,A.CAL_ID ,A.RSLT_SEG_NUM ,B.NAME ,A.GPCH_TX_VILLAGE_CD ,A.GPCH_TX_TRF_TYPE ,A.GPCH_TX_TRF_CD ,A.PRD_END_DT ,A.GPCH_AL_CPAY_ENDDT ,A.SEG_BGN_DT ,A.SEG_END_DT ,A.SLICE_END_DT ,A.BEGIN_DT ,A.END_DT ,A.BIRTHDATE ,A.HIRE_DT ,A.TERMINATION_DT ,A.PAY_ENTITY ,A.COMPANY ,A.CITY ,A.POSTAL ,A.ACTION ,A.MAR_STATUS ,A.NATIONAL_ID ,A.GPCH_AH_NNSS ,A.GPCH_TX_CHRCH ,A.SEX ,A.COUNTRY_FROM ,A.SPOUSE_NAME ,A.GPCH_TX_SPOUSE_WL ,A.GPCH_RP_AMOUNT1 ,A.GPCH_RP_AMOUNT2 ,A.GPCH_RP_AMOUNT3 ,A.GPCH_RP_AMOUNT9 ,A.GPCH_RP_AMOUNT11 ,A.GPCH_RP_AMOUNT14 ,A.GPCH_RP_AMOUNT15 ,A.GPCH_RP_AMOUNT19 ,A.GPCH_RP_AMOUNT20 ,A.GPCH_RP_AMOUNT21 ,A.GPCH_RP_AMOUNT22 ,A.GPCH_RP_AMOUNT26 ,A.GPCH_RP_AMOUNT27 ,A.VISA_PERMIT_TYPE ,A.CONTRACT_TYPE ,A.REG_TEMP ,A.GPCH_RP_CHAR03 ,A.GPCH_RP_FROMDT1 FROM PS_GPCHTX011_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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 NAME Character(50) VARCHAR2(50) NOT NULL Name
10 GPCH_TX_VILLAGE_CD Character(4) VARCHAR2(4) NOT NULL Municipality Code
11 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
12 GPCH_TX_TRF_CD Character(10) VARCHAR2(10) NOT NULL Withholding Tax Tariff
13 PRD_END_DT Date(10) DATE Pay Period End Date
14 GPCH_AL_CPAY_ENDDT Date(10) DATE Current Pay End Date
15 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
16 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
17 SLICE_END_DT Date(10) DATE Element Slice End Date
18 BEGIN_DT Date(10) DATE Begin Date
19 END_DT Date(10) DATE end date
20 BIRTHDATE Date(10) DATE Date of Birth
21 HIRE_DT Date(10) DATE First Start Date
22 TERMINATION_DT Date(10) DATE Termination Date
23 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
24 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
25 CITY Character(30) VARCHAR2(30) NOT NULL City
26 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
27 ACTION Character(3) VARCHAR2(3) NOT NULL Action

Prompt Table: ACTION_TBL

28 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
29 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
30 GPCH_AH_NNSS Character(20) VARCHAR2(20) NOT NULL New Social Insurance ID
31 GPCH_TX_CHRCH Character(1) VARCHAR2(1) NOT NULL Church Tax
1=Including Church Tax
2=Excluding Church Tax
32 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
33 COUNTRY_FROM Character(3) VARCHAR2(3) NOT NULL From Country
34 SPOUSE_NAME Character(40) VARCHAR2(40) NOT NULL Spouse Name
35 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

36 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
37 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
38 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
39 GPCH_RP_AMOUNT9 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 9
40 GPCH_RP_AMOUNT11 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 11
41 GPCH_RP_AMOUNT14 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 14
42 GPCH_RP_AMOUNT15 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 15
43 GPCH_RP_AMOUNT19 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 19
44 GPCH_RP_AMOUNT20 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 20
45 GPCH_RP_AMOUNT21 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 21
46 GPCH_RP_AMOUNT22 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 22
47 GPCH_RP_AMOUNT26 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 23
48 GPCH_RP_AMOUNT27 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 27
49 VISA_PERMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Visa/Permit Type
50 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
51 REG_TEMP Character(1) VARCHAR2(1) NOT NULL Regular/Temporary
R=Regular
T=Temporary
52 GPCH_RP_CHAR03 Character(8) VARCHAR2(8) NOT NULL Character 03
53 GPCH_RP_FROMDT1 Date(10) DATE From Date 1