GPCH_TX_INQ_VW1

(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.PAY_ENTITY , A.DEPTID , A.STATUS , A.LANG_CD , A.GPCH_RP_DEPT1 , A.GPCH_RP_DEPT2 , A.GPCH_RP_DEPT3 , A.GPCH_RP_DEPT4 , A.GPCH_RP_DEPT5 , A.GPCH_RP_LOC1 , A.GPCH_RP_LOC2 , A.GPCH_RP_LOC3 , A.GPCH_RP_LOC4 , A.GPCH_RP_LOC5 , A.GPCH_RP_FROMDT1 , A.GPCH_RP_FROMDT2 , A.GPCH_RP_FROMDT3 , A.GPCH_RP_FROMDT4 , A.GPCH_RP_FROMDT5 , A.GPCH_RP_TODT1 , A.GPCH_RP_TODT2 , A.GPCH_RP_TODT3 , A.GPCH_RP_TODT4 , A.GPCH_RP_TODT5 , A.GPCH_RP_ADDR1 , A.GPCH_RP_ADDR2 , A.GPCH_RP_ADDR3 , A.GPCH_RP_ADDR4 , A.GPCH_RP_ADDR5 , A.GPCH_RP_ADDR6 , A.GPCH_RP_ADDR7 , A.GPCH_RP_YR , A.NATIONAL_ID , A.GPCH_RC_DESCR , A.GPCH_RC_DESCR3 , A.GPCH_RC_DESCR4 , A.PHONE , A.SOURCE_IND 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 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
11 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
12 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
13 GPCH_RP_DEPT1 Character(30) VARCHAR2(30) NOT NULL Department 1
14 GPCH_RP_DEPT2 Character(30) VARCHAR2(30) NOT NULL Department 2
15 GPCH_RP_DEPT3 Character(30) VARCHAR2(30) NOT NULL Department 3
16 GPCH_RP_DEPT4 Character(30) VARCHAR2(30) NOT NULL Department 4
17 GPCH_RP_DEPT5 Character(30) VARCHAR2(30) NOT NULL Department 5
18 GPCH_RP_LOC1 Character(30) VARCHAR2(30) NOT NULL Location 1
19 GPCH_RP_LOC2 Character(30) VARCHAR2(30) NOT NULL Location 2
20 GPCH_RP_LOC3 Character(30) VARCHAR2(30) NOT NULL Location 3
21 GPCH_RP_LOC4 Character(30) VARCHAR2(30) NOT NULL Location 1
22 GPCH_RP_LOC5 Character(30) VARCHAR2(30) NOT NULL Location 5
23 GPCH_RP_FROMDT1 Date(10) DATE From Date 1
24 GPCH_RP_FROMDT2 Date(10) DATE From Date 2
25 GPCH_RP_FROMDT3 Date(10) DATE From Date 3
26 GPCH_RP_FROMDT4 Date(10) DATE From Date 4
27 GPCH_RP_FROMDT5 Date(10) DATE From Date 5
28 GPCH_RP_TODT1 Date(10) DATE To Date 1
29 GPCH_RP_TODT2 Date(10) DATE To Date 2
30 GPCH_RP_TODT3 Date(10) DATE To Date 3
31 GPCH_RP_TODT4 Date(10) DATE To Date 4
32 GPCH_RP_TODT5 Date(10) DATE To Date 5
33 GPCH_RP_ADDR1 Character(100) VARCHAR2(100) NOT NULL Address1
34 GPCH_RP_ADDR2 Character(100) VARCHAR2(100) NOT NULL Address2
35 GPCH_RP_ADDR3 Character(100) VARCHAR2(100) NOT NULL Address3
36 GPCH_RP_ADDR4 Character(100) VARCHAR2(100) NOT NULL Address4
37 GPCH_RP_ADDR5 Character(100) VARCHAR2(100) NOT NULL Address5
38 GPCH_RP_ADDR6 Character(100) VARCHAR2(100) NOT NULL Address6
39 GPCH_RP_ADDR7 Character(100) VARCHAR2(100) NOT NULL Address7
40 GPCH_RP_YR Character(4) VARCHAR2(4) NOT NULL Report Year
41 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
42 GPCH_RC_DESCR Character(100) VARCHAR2(100) NOT NULL Signature
43 GPCH_RC_DESCR3 Character(100) VARCHAR2(100) NOT NULL Descr3
44 GPCH_RC_DESCR4 Character(100) VARCHAR2(100) NOT NULL Description
45 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
46 SOURCE_IND Character(1) VARCHAR2(1) NOT NULL Indicates the source of payable time. S - system generated U - User entered O - Offset
O=Offset
S=System Generated
U=User Reported