PSC_BL_FIELD_GROUPS_
This table contains application specific details for business licenses.
Details
-
Schema: FUSION
-
Object owner: PSC_BL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_BP_FIELD_GROUPS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, LNP_RECORD_KEY |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| LNP_RECORD_KEY | NUMBER | 18 | Yes | This column is used to indicate lnp record key | |
| LNP_RECORD_ID | VARCHAR2 | 50 | This column is used to indicate lnp record id | ||
| CURRENCY_CODE | VARCHAR2 | 3 | This column is used to indicate currency code | ||
| RST_FOOD_SERVICE_START_TIME | TIMESTAMP | Indicates the proposed food service start time of operation. | |||
| RST_FOOD_SERVICE_END_TIME | TIMESTAMP | Indicates the proposed food service end time of operation. | |||
| RST_ALCOHOL_SRV_START_TIME | TIMESTAMP | Indicates the proposed alcohol service start time of operation. | |||
| RST_ALCOHOL_SRV_END_TIME | TIMESTAMP | Indicates the proposed alcohol service end time of operation. | |||
| RST_TOTAL_SEATING | NUMBER | Indicates the total number of seats. | |||
| RST_EXISTING_FLOOR_AREA | NUMBER | Indicates the total floor area of existing establishment. | |||
| RST_PARKING_SPACES | NUMBER | Indicates the number of dedicated parking spaces. | |||
| RST_FOOD_PREP_ONPREMISE | VARCHAR2 | 1 | Indicates if food will be prepared on premise. | ||
| RST_BEVERAGE_VEND_MACH | VARCHAR2 | 1 | Indicates if beverages are sold in a vending machine. | ||
| RST_SELL_ALCOHOL | VARCHAR2 | 1 | Indicates if alcoholic beverages are sold to the public. | ||
| RST_OUTDOOR_SEATING | VARCHAR2 | 1 | Indicates if outdoor seating is provided. | ||
| RST_MAX_OUTDOOR_SEATING | NUMBER | Indicates the maximum outdoor seating. | |||
| RST_PRIVATE_EVENTS | VARCHAR2 | 1 | Indicates if there are private event rooms. | ||
| RST_MAX_SEATING_PRVTE_EVNT | NUMBER | Indicates the maximum private event seating. | |||
| RST_SIT_DOWN_BAR | VARCHAR2 | 1 | Indicates if there is a sit-down bar. | ||
| RST_MAX_SEATING_BAR | NUMBER | Indicates the maximum sit-down bar seating. | |||
| RTL_PROD_DESC | VARCHAR2 | 1000 | This column is used to indicate the products to be sold. | ||
| RTL_SPACE_SIZE | NUMBER | This column indicates the retail space size. | |||
| RTL_HAZARDOUS | VARCHAR2 | 1 | Flag to indicate thatbusiness manufacture store or sell any type of hazardous material. | ||
| RTL_MERCHANDISE | VARCHAR2 | 1 | Flag to indicate that any merchandise be displayed outside the building. | ||
| RTL_COMMERCIAL | VARCHAR2 | 1 | Flag to indicate that business store any commercial vehicles, tools, or equipment on-site. | ||
| RTL_WM_PERMIT_NUM | VARCHAR2 | 100 | Indicates permit number for weights and measures. | ||
| RTL_WM_PERMIT_EXP | DATE | Indicates permit expiration date for weights and measures permit. | |||
| RTL_FIRE_INS_NUM | VARCHAR2 | 100 | Indicates inspection number for fire safety inspection. | ||
| RTL_FIRE_INS_EXP | DATE | Indicates expiration date for fire safety inspection. | |||
| RTL_BRG_PER_NUM | VARCHAR2 | 100 | This column indicates alarm permit number. | ||
| RTL_BRG_PER_EXP | DATE | This column indicates expiration date for alarm permit. | |||
| RTL_BRG_CMP_NAME | VARCHAR2 | 200 | This column indicates alarm company name. | ||
| RTL_BRG_PHN_NUM | VARCHAR2 | 100 | This column indicates alarm alarm company phone number. | ||
| CNL_BUSINESS_DETAIL | VARCHAR2 | 1000 | Indicates the detail about the products or services being sold. | ||
| CNL_BUSINESS_FROM_HOME | VARCHAR2 | 1 | Indicates whether all or part of the business be conducted from home. | ||
| CNL_BUSINESS_NONPROFIT | VARCHAR2 | 1 | Indicates whether this business is a non?profit or an exempt entity. | ||
| CNL_SELL_TOBACCO | VARCHAR2 | 1 | Indicates whether there is a plan to sell tobacco or tobacco products. | ||
| CNL_SELL_FOOD_BEVRG | VARCHAR2 | 1 | Indicates whether food or beverages will be sold or provided in the business. | ||
| CNL_SELL_ALCOHOL | VARCHAR2 | 1 | Indicates whether there is a plan to sell alcohol beverages in the business. | ||
| CNL_HZRD_MATERIAL | VARCHAR2 | 1 | Indicates whether the business will handle hazardous materials. | ||
| CNL_MOBILE_BUSINESS | VARCHAR2 | 1 | Indicates whether this a mobile business or make use of cars or trucks to transport goods. | ||
| CNL_SWMMING_POOL | VARCHAR2 | 1 | Indicates whether the business provides a swimming pool or spa for use by the public. | ||
| CNL_CANNABIS_ACTIVITY | VARCHAR2 | 1 | Indicates whether the business involves cannabis activity. | ||
| CNL_NEW_STRUCTURE | VARCHAR2 | 1 | Indicates whether there is a plan to make a new structure for the business. | ||
| CNL_MOD_EXISTING_STRUCTURE | VARCHAR2 | 1 | Indicates whether there is a plan to make any modifications to an existing structure for the business. | ||
| OHR_DAYS_HRS_DESC | VARCHAR2 | 1000 | This column indicates Operating Days and Hours. | ||
| RTL_SELLERSPERMIT_NUM | VARCHAR2 | 1000 | Indicates Seller's Permit Number. | ||
| RTL_SELLERSPERMIT_EXP | DATE | Indicates Seller's Permit Expiration Date. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_BL_FIELD_GROUPSN1_ | Non Unique | Default | LNP_RECORD_KEY, LAST_UPDATE_DATE |
| PSC_BL_FIELD_GROUPS_PK_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, LNP_RECORD_KEY |