ZX_DATA_UPLOAD_INTERFACE
This is an intermediate table used by the data upload program to temporarily hold the content from third party content providers.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GEOGRAPHY_ID | NUMBER | 18 | Oracle internal use only. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: session login associated to the user who last updated the row. | ||
| PROGRAM_NAME | VARCHAR2 | 30 | Oracle internal use only. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| PROGRAM_APP_NAME | VARCHAR2 | 50 | Oracle internal use only. | ||
| ZONE_GEOGRAPHY_ID | NUMBER | 18 | Unique geography identifier for tax geography | ||
| RECORD_TYPE | NUMBER | 2 | Oracle internal use only. | ||
| COUNTRY_CODE | VARCHAR2 | 3 | Code of the Country to which the Geography belongs. Must use two-letter ISO code. Example: United States is US. Use the Manage Tax Geographies task to identify valid values. | ||
| STATE_JURISDICTION_CODE | VARCHAR2 | 2 | State jurisdiction code for creating the concatenated jurisdiction code. Free text field. Not validated. | ||
| COUNTY_JURISDICTION_CODE | VARCHAR2 | 3 | County jurisdiction code for creating the concatenated jurisdiction code. Free text field. Not validated. | ||
| CITY_JURISDICTION_CODE | VARCHAR2 | 23 | City jurisdiction code for creating the concatenated jurisdiction code. Free text field. Not validated. | ||
| COUNTRY_STATE_ABBREVIATION | VARCHAR2 | 2 | Abbreviation for country or state based on whether this record is for a country or state. Free text field. Not validated. | ||
| GEOGRAPHY_NAME | VARCHAR2 | 30 | Primary name of the geography. Free text field. Not validated. | ||
| EFFECTIVE_FROM | DATE | Effective from date for the tax rate. Date format: YYYY/MM/DD. Must be earlier than the EFFECTIVE_TO date. | |||
| EFFECTIVE_TO | DATE | Effective to date for the tax rate. Date format: YYYY/MM/DD. Must be later than the EFFECTIVE_FROM date. | |||
| ZIP_BEGIN | VARCHAR2 | 5 | Lowest value in the zip code range. There must not be overlapping zip ranges. | ||
| ZIP_END | VARCHAR2 | 5 | Highest value in the zip code range. There must not be overlapping zip ranges. | ||
| JURISDICTION_SERIAL_NUMBER | NUMBER | 1 | Indicates whether geography is inside or outside city limits. Valid values: 0, 1. 0 means outside city limits. 1 means inside city limits. | ||
| ATTRIBUTE1 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE2 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE3 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE4 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE5 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE6 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE7 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE8 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE9 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE10 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE11 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE12 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE13 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE14 | VARCHAR2 | 240 | Oracle internal use only. | ||
| ATTRIBUTE15 | VARCHAR2 | 240 | Oracle internal use only. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: date and time of the last update of the row. | ||
| CREATION_VERSION | NUMBER | 5 | File version of the third party content provider in which this record was first introduced. Free text field. Not validated. | ||
| LAST_UPDATION_VERSION | NUMBER | 5 | File version of the third party content provider in which this record was last updated. Free text field. Not validated. | ||
| STATUS | VARCHAR2 | 60 | Column to indicate whether this record is to be inserted or updated. Valid values: CREATE, UPDATE, ERROR, NOCHANGE. | ||
| ERROR_MESSAGE | VARCHAR2 | 240 | Error message. Populated by Oracle. | ||
| CHANGE_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: request ID of the process that created or last updated the row. | ||
| GEO_DATA_PROVIDER | VARCHAR2 | 60 | Oracle internal use only. | ||
| RENTAL_TAX_RATE | NUMBER | Tax rate for rental tax. | |||
| RENTAL_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether rental tax rate is active. Valid values: Y, N. | ||
| RENTAL_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level for rental tax. Valid values: STATE, COUNTY, CITY. | ||
| USE_TAX_RATE | NUMBER | Tax rate for use tax | |||
| USE_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates use tax rate is active. Valid values: Y, N. | ||
| USE_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level. Valid values: STATE, COUNTY, CITY. | ||
| LEASE_TAX_RATE | NUMBER | Tax rate for lease tax. | |||
| LEASE_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates whether lease tax rate is active. Valid values: Y, N. | ||
| LEASE_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level for lease tax rate. Valid values: STATE, COUNTY, CITY. | ||
| SALES_TAX_RATE | NUMBER | Tax rate for sales tax. | |||
| SALES_TAX_RATE_ACTIVE_FLAG | VARCHAR2 | 1 | Indicates sales tax rate is active. Valid values: Y, N. | ||
| SALES_TAX_AUTHORITY_LEVEL | VARCHAR2 | 6 | Tax authority level for sales tax rate. Valid values: STATE, COUNTY, CITY. | ||
| MULTIPLE_PARENT_FLAG | VARCHAR2 | 1 | Indicates whether a geography has more than one parent. Valid values: Y, N. | ||
| PRIMARY_FLAG | VARCHAR2 | 1 | Check box that identifies primary geographies. Valid values: Y, N. Y is used to create geographies and jurisdictions. N is used to create geographies without jurisdictions. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Oracle internal use only. | ||
| LOAD_STATUS | VARCHAR2 | 30 | Enterprise Service Scheduler: indicates the request status of the interface load job that created the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_DATA_UPLOAD_INTERFACE_N1 | Non Unique | Default | RECORD_TYPE, STATE_JURISDICTION_CODE, COUNTY_JURISDICTION_CODE, CITY_JURISDICTION_CODE |