GPIN_LWF_GEN_VW

(SQL View)
 Index Back

Establ view for LWF Generation

This view is used in wriatable array LWF WA DTL. The view hold employee and its establishment details.

SELECT A.EMPLID , A.EFFDT , A.ESTABID , A.GPIN_LWF_ELIGIBLE , B.ADDRESS1 , B.ADDRESS2 , B.ADDRESS3 , B.ADDRESS4 , B.CITY , B.POSTAL , B.STATE , C.DESCR FROM PS_GPIN_TDS_GEN A , PS_ESTAB_TBL B ,PS_STATE_TBL C WHERE A.ESTABID=B.ESTABID AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_ESTAB_TBL B1 WHERE B1.ESTABID=B.ESTABID) AND C.COUNTRY = 'IND' AND C.STATE = B.STATE

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

Prompt Table: PERSON

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

Default Value: JOB.ESTABID

Prompt Table: ESTAB_TBL

4 GPIN_LWF_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL This flag is used to enroll emplyee for LWF contribution.

Y/N Table Edit

Default Value: N

5 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
6 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
7 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
8 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
9 CITY Character(30) VARCHAR2(30) NOT NULL City
10 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
11 STATE Character(6) VARCHAR2(6) NOT NULL State
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description