GPTH_PER_DEP_VW

(SQL View)
 Index Back

EE Relative Depts/Benefs

Employee Relative Departments and Benefits

SELECT A.EMPLID ,B.BIRTHDATE ,B.RELATIONSHIP ,B.NAME_PREFIX ,B.FIRST_NAME ,B.LAST_NAME ,B.NATIONAL_ID ,B.GPTH_PER_TAX_ID ,%Substring(C.NATIONAL_ID,1,13) ,D.NATIONAL_ID ,E.NATIONAL_ID ,F.NATIONAL_ID ,G.PROCESS_INSTANCE FROM PS_PERSON A LEFT OUTER JOIN PS_GPTH_BENEF_VW0 B ON A.EMPLID=B.EMPLID LEFT OUTER JOIN PS_GPTH_BENEF_VW1 C ON A.EMPLID=C.EMPLID LEFT OUTER JOIN PS_GPTH_BENEF_VW2 D ON A.EMPLID=D.EMPLID LEFT OUTER JOIN PS_GPTH_BENEF_VW3 E ON A.EMPLID=E.EMPLID LEFT OUTER JOIN PS_GPTH_BENEF_VW4 F ON A.EMPLID=F.EMPLID ,PS_GPTH_RPT_G_VW G WHERE A.EMPLID=G.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

2 BIRTHDATE Date(10) DATE Date of Birth
3 RELATIONSHIP Character(2) VARCHAR2(2) NOT NULL Relationship to Employee
4 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
5 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 GPTH_PER_TAX_ID Character(20) VARCHAR2(20) NOT NULL Person Tax ID
9 GPTH_FA_ID Character(13) VARCHAR2(13) NOT NULL Father ID No
10 GPTH_M_ID Character(20) VARCHAR2(20) NOT NULL Mother's National ID
11 GPTH_FI_ID Character(20) VARCHAR2(20) NOT NULL National ID of Father in law
12 GPTH_MI_ID Character(20) VARCHAR2(20) NOT NULL National ID Mother in law
13 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance