Addresses
Used with EFFDT for most recent address
- Emplid [VARCHAR2 (11)]
- Address_Type [VARCHAR2 (4)]: Use this to determine HOME
- HOME
- EFFDT [DATE]: Use this to determine most recent address
- EFF_Status [VARCHAR2 (1)]
- Country [VARCHAR2 (3)]
- Address1 VARCHAR2 (55)]
- Address2 VARCHAR2 (55)]
- Address3 VARCHAR2 (55)]
- Address4 VARCHAR2 (55)]
- City [VARCHAR2 (30)]
- NUM1 [VARCHAR2 (6)]
- NUM2 [VARCHAR2 (6)]
- House_Type [VARCHAR2 (2)]
- Addr_Field1 [VARCHAR2 (2)]
- Addr_Field2 [VARCHAR2 (4)]
- Addr_Field3 [VARCHAR2 (4)]
- County [VARCHAR2 (30)]
- State [VARCHAR2 (6)]
- Postal [VARCHAR2 (12)]: Zip Code or Area Code
- Geo_Code [VARCHAR2 (11)]
- In_City_Limit [VARCHAR2 (1)]
- Address1_AC [VARCHAR2 (55)]
- Address2_AC [VARCHAR2 (55)]
- Address3_AC [VARCHAR2 (55)]
- City_AC [VARCHAR2 (30)]
- Reg_Region [VARCHAR2 (5)]
- LastUpDDTM [TIMESTAMP(6)]
- LastUpDoPrID [VARCHAR2 (30)]