DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.PER_ADDRESSES

Object Details
Object Name: PER_ADDRESSES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_ADDRESSES
Subobject Name:
Status: VALID

Address information for people.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_ADDRESSES_PK
  1. ColumnADDRESS_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_ADDRESSES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnADDRESS_ID
SYS_IL0000043714C00068$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000043714C00069$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
PER_ADDRESSES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_ADDRESSES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
PER_ADDRESSES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTY_ID
PER_ADDRESSES_N4 DOMAIN NONUNIQUE Tablespace ColumnDERIVED_LOCALE
PER_ADDRESSES_SPT DOMAIN NONUNIQUE Tablespace ColumnGEOMETRY
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_ADDRESSES PER_ADDRESSES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_ADDRESSES BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
ADDRESS_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
PERSON_ID NUMBER (10)
Foreign key to PER_PEOPLE.
DATE_FROM DATE
Yes Start date at the address.
PRIMARY_FLAG VARCHAR2 (30) Yes Indicates whether this is the primary address for the person.
STYLE VARCHAR2 (30) Yes Address style - foreign key to FND_TERRITORIES.
ADDRESS_LINE1 VARCHAR2 (240)
The first line of the address.
ADDRESS_LINE2 VARCHAR2 (240)
The second line of the address.
ADDRESS_LINE3 VARCHAR2 (240)
The third line of the address.
ADDRESS_TYPE VARCHAR2 (30)
Address type, for example, home, business, weekend.
COUNTRY VARCHAR2 (60)
Country.
DATE_TO DATE

End date at this address.
POSTAL_CODE VARCHAR2 (30)
National code to identify addresses in a specific country.
REGION_1 VARCHAR2 (120)
Primary region in which the address is located.
REGION_2 VARCHAR2 (120)
Sub region of region 1 in which the address is located.
REGION_3 VARCHAR2 (120)
Sub region of region 2 in which the address is located.
TELEPHONE_NUMBER_1 VARCHAR2 (60)
Telephone number for the address.
TELEPHONE_NUMBER_2 VARCHAR2 (60)
Second telephone number for the address.
TELEPHONE_NUMBER_3 VARCHAR2 (60)
Third telephone number for the address.
TOWN_OR_CITY VARCHAR2 (30)
Town or city name.
REQUEST_ID NUMBER (15)
Standard Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
ADDR_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Developers Descriptive flexfield column.
ADDR_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ADDR_ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
ADD_INFORMATION13 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADD_INFORMATION14 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADD_INFORMATION15 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADD_INFORMATION16 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADD_INFORMATION17 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADD_INFORMATION18 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADD_INFORMATION19 VARCHAR2 (150)
Developers Descriptive flexfield column.
ADD_INFORMATION20 VARCHAR2 (150)
Developers Descriptive flexfield column.
PARTY_ID NUMBER (15)
Party Id
DERIVED_LOCALE VARCHAR2 (240)
derived locale
GEOMETRY SDO_GEOMETRY (1)
COMMENTS LONG (0)
General remark.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADDRESS_ID
,      BUSINESS_GROUP_ID
,      PERSON_ID
,      DATE_FROM
,      PRIMARY_FLAG
,      STYLE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_TYPE
,      COUNTRY
,      DATE_TO
,      POSTAL_CODE
,      REGION_1
,      REGION_2
,      REGION_3
,      TELEPHONE_NUMBER_1
,      TELEPHONE_NUMBER_2
,      TELEPHONE_NUMBER_3
,      TOWN_OR_CITY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ADDR_ATTRIBUTE_CATEGORY
,      ADDR_ATTRIBUTE1
,      ADDR_ATTRIBUTE2
,      ADDR_ATTRIBUTE3
,      ADDR_ATTRIBUTE4
,      ADDR_ATTRIBUTE5
,      ADDR_ATTRIBUTE6
,      ADDR_ATTRIBUTE7
,      ADDR_ATTRIBUTE8
,      ADDR_ATTRIBUTE9
,      ADDR_ATTRIBUTE10
,      ADDR_ATTRIBUTE11
,      ADDR_ATTRIBUTE12
,      ADDR_ATTRIBUTE13
,      ADDR_ATTRIBUTE14
,      ADDR_ATTRIBUTE15
,      ADDR_ATTRIBUTE16
,      ADDR_ATTRIBUTE17
,      ADDR_ATTRIBUTE18
,      ADDR_ATTRIBUTE19
,      ADDR_ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      ADD_INFORMATION13
,      ADD_INFORMATION14
,      ADD_INFORMATION15
,      ADD_INFORMATION16
,      ADD_INFORMATION17
,      ADD_INFORMATION18
,      ADD_INFORMATION19
,      ADD_INFORMATION20
,      PARTY_ID
,      DERIVED_LOCALE
,      GEOMETRY
,      COMMENTS
FROM HR.PER_ADDRESSES;

Dependencies

[top of page]

HR.PER_ADDRESSES references the following:

SchemaMDSYS
TYPESDO_ELEM_INFO_ARRAY
TYPESDO_GEOMETRY
TYPESDO_ORDINATE_ARRAY
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
HR.PER_ADDRESSES is referenced by following:

SchemaAPPS
TriggerBEN_EXT_ADD_EVT
TriggerGHR_PER_ADDRESSES_AFIUD
TriggerHR_PA_MAINTN_ADDR_HIST_BRI
TriggerHR_PA_MAINTN_ADDR_HIST_BRU
TriggerPERADDRESSES_1136I_DYT
TriggerPERADDRESSES_56U_DYT
SynonymPER_ADDRESSES
TriggerPER_ADDRESSES_OVN
TriggerPER_ADDRESSES_WHO
SchemaHR
TriggerDR$PER_ADDRESSES_N4TC
SchemaPUBLIC
SynonymPER_ADDRESSES