GPCH_TX_LAW_VW

(SQL View)
 Index Back

View for Override LAW

View for Override LAW

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.PAY_ENTITY , 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 AND A.GPCH_RP_SEQUENCE = ( SELECT MAX(C.GPCH_RP_SEQUENCE) FROM PS_GPCH_RP_TX05C C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.BEGIN_DT =A.BEGIN_DT AND C.END_DT = A.END_DT AND C.PAY_ENTITY = A.PAY_ENTITY)

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