GPCHAEZV1_VW (SQL View)	Index Back
Social Insurance Table Social Insurance Table

GPCHAEZV1_VW

(SQL View)

Social Insurance Table

SELECT PROCESS_INSTANCE ,EMPLID ,EMPL_RCD ,EFFDT ,GPCH_SI_TYPE_ID ,GPCH_SI_ALT_ID ,GPCH_SI_PROV_TYPE ,STATUS ,GPCH_CALCULATE ,AMOUNT ,CURRENCY_CD ,BEGIN_DT ,END_DT ,ENDING_DT_PERIOD ,HIRE_DT ,TERMINATION_DT ,GPCH_RP_AMOUNT1 ,GPCH_RP_AMOUNT2 ,GPCH_RP_AMOUNT3 ,GPCH_RP_AMOUNT4 ,GPCH_RP_AMOUNT5 FROM PS_GPCHAEZV1_TMP

Parent record: GPCH_SI_VARIAN1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: GPCH_SI_VARIAN1.EFFDT

5 GPCH_SI_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Insurance Type ID

6 GPCH_SI_ALT_ID Character(8) VARCHAR2(8) NOT NULL Insurance Alternative ID

7 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
0=Identify
1=Others
2=UVG-LAA
3=KTG-AMC
4=UVGZ-LAAC
5=FAK-CAF
6=BVG-LPP
7=AHV-AVS
8=LAW-CDS
9=BFS-OFS
A=QST-IS
B=Write File
C=Base AL08
D=GRFI-FRFI
E=EO-APG
I=BNK_BNQ

8 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
Default Value: A

9 GPCH_CALCULATE Character(1) VARCHAR2(1) NOT NULL Calculate
A=Active
I=Inactive
Default Value: A

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

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

12 BEGIN_DT Date(10) DATE Begin Date

13 END_DT Date(10) DATE end date

14 ENDING_DT_PERIOD Date(10) DATE Ending date of period

15 HIRE_DT Date(10) DATE First Start Date

16 TERMINATION_DT Date(10) DATE Termination Date

17 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value

18 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value

19 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value

20 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value

21 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: GPCH_SI_VARIAN1.EFFDT
5	GPCH_SI_TYPE_ID	Character(3)	VARCHAR2(3) NOT NULL	Insurance Type ID
6	GPCH_SI_ALT_ID	Character(8)	VARCHAR2(8) NOT NULL	Insurance Alternative ID
7	GPCH_SI_PROV_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Provider Type 0=Identify 1=Others 2=UVG-LAA 3=KTG-AMC 4=UVGZ-LAAC 5=FAK-CAF 6=BVG-LPP 7=AHV-AVS 8=LAW-CDS 9=BFS-OFS A=QST-IS B=Write File C=Base AL08 D=GRFI-FRFI E=EO-APG I=BNK_BNQ
8	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive Default Value: A
9	GPCH_CALCULATE	Character(1)	VARCHAR2(1) NOT NULL	Calculate A=Active I=Inactive Default Value: A
10	AMOUNT	Signed Number(20,3)	DECIMAL(18,3) NOT NULL	Commuting Allowance Paid Per Cycle.
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
12	BEGIN_DT	Date(10)	DATE	Begin Date
13	END_DT	Date(10)	DATE	end date
14	ENDING_DT_PERIOD	Date(10)	DATE	Ending date of period
15	HIRE_DT	Date(10)	DATE	First Start Date
16	TERMINATION_DT	Date(10)	DATE	Termination Date
17	GPCH_RP_AMOUNT1	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
18	GPCH_RP_AMOUNT2	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
19	GPCH_RP_AMOUNT3	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
20	GPCH_RP_AMOUNT4	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value
21	GPCH_RP_AMOUNT5	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate Result Value