1. Tables and Views
  2. PSC_COM_AGENCY_ADDRESS

PSC_COM_AGENCY_ADDRESS

This table contains agency address information.

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PSC_COM_AGENCY_ADDRESS_PK

AGENCY_ID, AGENCY_ADDRESS_ID

Columns

Name Datatype Length Precision Not-null Comments Status
AGENCY_ID NUMBER 8 Yes This column is used to indicate agency id Active
AGENCY_ADDRESS_ID NUMBER 18 Yes This column is used to indicate agency address id Active
ADDRESS_CODE VARCHAR2 32 Yes This is used to store Address code or the short name for an agency address
VALID_FROM_DATE DATE Yes This column is used to indicate valid from date Active
VALID_TO_DATE DATE Yes This column is used to indicate valid to date Active
PRIMARY_FLAG VARCHAR2 1 Yes This column is used to indicate primary flag Active
ADDRESS1 VARCHAR2 240 This column is used to indicate address1 Active
ADDRESS2 VARCHAR2 240 This column is used to indicate address2 Active
ADDRESS3 VARCHAR2 240 This column is used to indicate address3 Active
ADDRESS4 VARCHAR2 240 This column is used to indicate address4 Active
CITY_NAME VARCHAR2 60 This column is used to indicate city name Active
ZIP_CODE VARCHAR2 60 This column is used to indicate zip code Active
COUNTRY_CODE VARCHAR2 3 Yes This column is used to indicate country code Active
STATE_CODE_ISO VARCHAR2 60 This column is used to indicate state code iso Active
COUNTY_CODE_INCITS VARCHAR2 60 This column is used to indicate county code incits Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
POSTAL_PLUS4_CODE VARCHAR2 10 This column is used to indicate postal plus4 code Active
PROVINCE VARCHAR2 60 This column is used to indicate province Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Foreign Keys

Table Foreign Table Foreign Key Column
PSC_COM_AGENCY_ADDRESS psc_com_agency_b AGENCY_ID
psc_com_person_prof psc_com_agency_address AGENCY_ID, AGENCY_ADDRESS_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_COM_AGENCY_ADDRESS_PK Unique Default AGENCY_ID, AGENCY_ADDRESS_ID Active