GPTH_SI_BRAN_VW

(SQL View)
 Index Back

Social Security Fund Branches

Get the row which has the max effect date. For report only.

SELECT A.COMPANY , A.EFFDT , A.GPTH_SI_BRANCH_NO , A.GPTH_SI_BRANCH_NM , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.NUM1 , A.NUM2 , A.HOUSE_TYPE , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.ADDR_FIELD3 , A.COUNTY , A.STATE , A.POSTAL , A.GEO_CODE , A.IN_CITY_LIMIT , A.COUNTRY_CODE , A.PHONE , A.EXTENSION , A.FAX , G.PROCESS_INSTANCE , G.EMPLID FROM PS_GPTH_SI_BRANCH A ,PS_GPTH_RPT_G_VW G WHERE A.COMPANY=G.COMPANY AND A.GPTH_SI_BRANCH_NO=G.GPTH_SI_BRANCH_NO AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_GPTH_SI_BRANCH A_ED WHERE A.COMPANY = A_ED.COMPANY AND A_ED.EFFDT <= G.PRD_END_DT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 GPTH_SI_BRANCH_NO Character(6) VARCHAR2(6) NOT NULL Social Security Branch Number
4 GPTH_SI_BRANCH_NM Character(50) VARCHAR2(50) NOT NULL Social Security Branch Name
5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
9 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
10 CITY Character(30) VARCHAR2(30) NOT NULL City
11 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
12 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
13 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
14 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
15 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
16 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
17 COUNTY Character(30) VARCHAR2(30) NOT NULL County
18 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

19 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
20 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
21 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

22 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
23 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
24 EXTENSION Character(6) VARCHAR2(6) NOT NULL Phone number extension
25 FAX Character(24) VARCHAR2(24) NOT NULL Fax Number
26 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
27 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID