HR_ADDR_CHG_DAT

(SQL Table)
 Index Back

Address Change Transactions

ADDRESSES contains effective dated history for personal addresses.

  • 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 WF_STATUS Character(1) VARCHAR2(1) NOT NULL Workflow Status
    A=Approved
    C=Cancelled
    D=Denied
    E=Error. Contact Administrator.
    F=Awaiting final approval
    I=In Approval Process
    M=Administrator is Processing
    N=Not Available
    P=Rework
    S=Submitted
    V=Data Saved
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

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

    Prompt Table: STATE_TBL

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

    Y/N Table Edit

    24 ADDRESS1_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 1
    25 ADDRESS2_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 2
    26 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    27 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    28 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region
    29 ORIGINATORID Character(30) VARCHAR2(30) NOT NULL Originator Identifier
    30 TRANSACTION_NAME Character(25) VARCHAR2(25) NOT NULL EDI Transaction Name
    31 UPD_BY_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    32 UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    33 MANUAL_UPD_USERID Character(30) VARCHAR2(30) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    34 MANUAL_UPD_DTTM DateTime(26) TIMESTAMP Used on "_DAT" records for 8.3 Workflow Enhancements
    35 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered

    Default Value: I

    36 SS_WARNING_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    37 SS_FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements

    Y/N Table Edit

    Default Value: N

    38 APPROVAL_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field for page WF_CO_CONFIG. Checkbox used for "Approval Required" on configuration page.
    N=No Approval Required
    Y=Approval Required

    Default Value: N