GPCH_TX_INQ_VW

(SQL View)
 Index Back

View for Override LAW Inquire

View for Override LAW Inquire

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , B.FIRST_NAME , B.LAST_NAME , B.NAME , A.BEGIN_DT , A.END_DT , A.GPCH_RP_SEQUENCE , A.GPCH_RP_AMOUNT1 , A.GPCH_RP_AMOUNT2 , A.GPCH_RP_AMOUNT3 , A.GPCH_RP_AMOUNT4 , A.GPCH_RP_AMOUNT5 , A.GPCH_RP_AMOUNT6 , A.GPCH_RP_AMOUNT7 , A.GPCH_RP_AMOUNT8 , A.GPCH_RP_AMOUNT9 , A.GPCH_RP_AMOUNT10 , A.GPCH_RP_AMOUNT11 , A.GPCH_RP_AMOUNT12 , A.GPCH_RP_AMOUNT13 , A.GPCH_RP_AMOUNT14 , A.GPCH_RP_AMOUNT15 , A.GPCH_RP_AMOUNT16 , A.GPCH_RP_AMOUNT17 , A.GPCH_RP_AMOUNT18 , A.GPCH_RP_AMOUNT19 , A.GPCH_RP_AMOUNT20 , A.GPCH_RP_AMOUNT21 , A.GPCH_RP_AMOUNT22 , A.GPCH_RP_AMOUNT23 , A.GPCH_RP_AMOUNT24 , A.GPCH_RP_AMOUNT25 , A.GPCH_RP_AMOUNT26 , A.GPCH_RP_AMOUNT27 , A.GPCH_RP_AMOUNT28 , A.GPCH_RP_AMOUNT29 , A.GPCH_RP_AMOUNT30 , A.GPCH_RP_AMOUNT31 , A.GPCH_RP_AMOUNT32 , A.GPCH_RP_AMOUNT33 , A.GPCH_RP_AMOUNT34 , A.GPCH_RP_AMOUNT35 , A.GPCH_RP_AMOUNT36 , A.GPCH_RP_AMOUNT37 , A.GPCH_RP_AMOUNT38 , A.GPCH_RP_AMOUNT39 , A.GPCH_RP_AMOUNT40 , A.GPCH_RP_AMOUNT41 , A.GPCH_RP_AMOUNT42 , A.GPCH_RP_AMOUNT43 , A.GPCH_RP_AMOUNT44 , A.GPCH_RP_AMOUNT45 , A.GPCH_RP_AMOUNT46 , A.GPCH_RP_AMOUNT47 , A.GPCH_RP_AMOUNT48 , A.GPCH_RP_AMOUNT49 FROM PS_GPCH_RP_TX05C A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# 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 Rcd Nbr
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 BEGIN_DT Date(10) DATE Begin Date
7 END_DT Date(10) DATE end date
8 GPCH_RP_SEQUENCE Number(8,0) INTEGER NOT NULL Sequence number
9 GPCH_RP_AMOUNT1 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
10 GPCH_RP_AMOUNT2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
11 GPCH_RP_AMOUNT3 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
12 GPCH_RP_AMOUNT4 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
13 GPCH_RP_AMOUNT5 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
14 GPCH_RP_AMOUNT6 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
15 GPCH_RP_AMOUNT7 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
16 GPCH_RP_AMOUNT8 Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
17 GPCH_RP_AMOUNT9 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 9
18 GPCH_RP_AMOUNT10 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 10
19 GPCH_RP_AMOUNT11 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 11
20 GPCH_RP_AMOUNT12 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 12
21 GPCH_RP_AMOUNT13 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 13
22 GPCH_RP_AMOUNT14 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 14
23 GPCH_RP_AMOUNT15 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 15
24 GPCH_RP_AMOUNT16 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 16
25 GPCH_RP_AMOUNT17 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 17
26 GPCH_RP_AMOUNT18 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 18
27 GPCH_RP_AMOUNT19 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 19
28 GPCH_RP_AMOUNT20 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 20
29 GPCH_RP_AMOUNT21 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 21
30 GPCH_RP_AMOUNT22 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 22
31 GPCH_RP_AMOUNT23 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 23
32 GPCH_RP_AMOUNT24 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 24
33 GPCH_RP_AMOUNT25 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 25
34 GPCH_RP_AMOUNT26 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 23
35 GPCH_RP_AMOUNT27 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 27
36 GPCH_RP_AMOUNT28 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 28
37 GPCH_RP_AMOUNT29 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 29
38 GPCH_RP_AMOUNT30 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 30
39 GPCH_RP_AMOUNT31 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 31
40 GPCH_RP_AMOUNT32 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 32
41 GPCH_RP_AMOUNT33 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 33
42 GPCH_RP_AMOUNT34 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 34
43 GPCH_RP_AMOUNT35 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 35
44 GPCH_RP_AMOUNT36 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 36
45 GPCH_RP_AMOUNT37 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 37
46 GPCH_RP_AMOUNT38 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount 38
47 GPCH_RP_AMOUNT39 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount39
48 GPCH_RP_AMOUNT40 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount40
49 GPCH_RP_AMOUNT41 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount41
50 GPCH_RP_AMOUNT42 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount42
51 GPCH_RP_AMOUNT43 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount43
52 GPCH_RP_AMOUNT44 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount44
53 GPCH_RP_AMOUNT45 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount45
54 GPCH_RP_AMOUNT46 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount46
55 GPCH_RP_AMOUNT47 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount47
56 GPCH_RP_AMOUNT48 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount48
57 GPCH_RP_AMOUNT49 Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount49