SSR_GR_ADDR_VW

(SQL View)
 Index Back

Grad App Address View

Grad App Address View

SELECT A.EMPLID , A.ADDRESS_TYPE , A.EFFDT , T.ADDR_TYPE_DESCR , A.EFF_STATUS , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.ADDRESS3 , A.ADDRESS4 , A.CITY , A.STATE , A.POSTAL , A.COUNTRY ,A. EFFDT FROM PS_ADDRESSES A ,PS_ADDRESS_TYP_TBL T WHERE T.ADDRESS_TYPE = A.ADDRESS_TYPE

  • Related Language Record: SSR_GR_ADDR_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SSR_ADDR_TYPE_ADD Character(4) VARCHAR2(4) NOT NULL Address Type
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 ADDR_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Address Type
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

    13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    14 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    15 ASOFDATE Date(10) DATE As of Date