HR_ADDRAC_CHG_V

(SQL View)
 Index Back

Alternate Char Addr Changes

ADDRESSES contains effective dated history for personal addresses.

SELECT CUR.EMPLID , CUR.ADDRESS_TYPE , NEW.ACTION_DT_SS , NEW.EFFSEQ , CASE WHEN NEW.ADDRESS1_AC = CUR.ADDRESS1_AC THEN ' ' ELSE NEW.ADDRESS1_AC END , CASE WHEN NEW.ADDRESS1_AC = CUR.ADDRESS1_AC THEN ' ' ELSE CUR.ADDRESS1_AC END , CASE WHEN NEW.ADDRESS2_AC = CUR.ADDRESS2_AC THEN ' ' ELSE NEW.ADDRESS2_AC END , CASE WHEN NEW.ADDRESS2_AC= CUR.ADDRESS2_AC THEN ' ' ELSE CUR.ADDRESS2_AC END , CASE WHEN NEW.ADDRESS3_AC = CUR.ADDRESS3_AC THEN ' ' ELSE NEW.ADDRESS3_AC END , CASE WHEN NEW.ADDRESS3_AC = CUR.ADDRESS3_AC THEN ' ' ELSE CUR.ADDRESS3_AC END , CASE WHEN NEW.CITY_AC =CUR.CITY_AC THEN ' ' ELSE NEW.CITY_AC END , CASE WHEN NEW.CITY_AC =CUR.CITY_AC THEN ' ' ELSE CUR.CITY_AC END FROM PS_PERSON_ADDRESS CUR , PS_HR_ADDR_CHG_DAT NEW WHERE NEW.EMPLID=CUR.EMPLID AND NEW.ADDRESS_TYPE = CUR.ADDRESS_TYPE

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type

    Prompt Table: ADDRESS_TYP_TBL

    3 ACTION_DT_SS Date(10) DATE Termination Date

    Default Value: %date

    4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    5 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    6 ADDRESS1_AC_CUR Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    7 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    8 ADDRESS2_AC_CUR Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    9 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    10 ADDRESS3_AC_CUR Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    11 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    12 CITY_AC_CUR Character(30) VARCHAR2(30) NOT NULL Alternate Character City