GPTH_SI_BR_E_VW

(SQL View)
 Index Back

Social Security Fund Branches

Social Security Fund Branches Table with an extension of the STATE long description. Use this view only when you want to get the long description of the STATE in address, else use GPTH_SI_BRANCH instead.

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 , B.DESCR AS GPTH_STATEDESCR , A.GPTH_SI_BRANCH_AP FROM PS_GPTH_SI_BRANCH A LEFT JOIN PS_STATE_TBL B ON A.COUNTRY = B.COUNTRY AND A.STATE = B.STATE

  • Related Language Record: GPTH_SI_BR_LANG

    • # 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 GPTH_STATEDESCR Character(30) VARCHAR2(30) NOT NULL Long description of State
    27 GPTH_SI_BRANCH_AP Character(40) VARCHAR2(40) NOT NULL This field will be used to store social security area/province information.