PSC_LNP_AGENCY_OPT_B
This table contains agency specific configuration options.
Details
-
Schema: FUSION
-
Object owner: PSC_PER
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PSC_LNP_AGENCY_OPT_B_PK |
AGENCY_ID, OFFERING_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| AGENCY_ID | NUMBER | 8 | Yes | A Unique Number that identifies an agency. | Active | |
| OFFERING_ID | VARCHAR2 | 50 | Yes | List different types of PSC Offerings. | Active | |
| OPA_POLICY_ID | VARCHAR2 | 150 | This column is the OPA Policy that will be used for permits. | Active | ||
| CONTENT_URL | VARCHAR2 | 250 | Indicate the URL user can direct to from welcome message. | Active | ||
| PENDING_INSPECTIONS | VARCHAR2 | 1 | Controls whether inspections can be scheduled as pending. | |||
| AUTO_PENDING_INSPECTIONS | VARCHAR2 | 1 | Controls whether pending inspections are created automatically. | |||
| IVR | VARCHAR2 | 1 | Controls whether IVR is enabled. | |||
| ALLOW_HIDE_BUS_INFO_FLAG | VARCHAR2 | 1 | Flag to allow users to hide business info from public | |||
| CASCADING_CYCLE_DUE_DATE | VARCHAR2 | 1 | Controls whether plan review cycle due dates are cascaded. | |||
| DEFAULT_PLAN_REVIEW_NAME | VARCHAR2 | 1 | Controls whether plan review names are defaulted. | |||
| ELECTRONIC_PLAN_REVIEW | VARCHAR2 | 1 | Controls whether electronic plan review is enabled. | |||
| REQUIRE_COMMENTS_PLAN_REVIEW | VARCHAR2 | 30 | Yes | Indicates the level at which comments are required for Plan Reviews. | ||
| REQUIRE_COMMENTS_INSPECTION | VARCHAR2 | 30 | Yes | Indicates the level at which comments are required for Inspections. | ||
| PR_PROTECT_DOC_OPTION | VARCHAR2 | 30 | Yes | Indicates how to handle protected documents that are uploaded for plan review. | ||
| 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 | |
| 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 | ||
| MODULE_ID | VARCHAR2 | 32 | Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data. | Active | ||
| ISSUE_REISSUE_DATES_OPT | VARCHAR2 | 30 | Yes | Indicates the option whether issue date can be overwritten by reissue date. | ||
| REPORT_CONTROL_ID | VARCHAR2 | 32 | Identifies the type of consolidated report configurations for a Business Location. | |||
| ALLOW_VIEW_BUS_LIC_CERT_FLAG | VARCHAR2 | 1 | Flag to allow public users to view certificate on Business page. | |||
| BL_MULTI_APP_FLAG | VARCHAR2 | 1 | Indicates business license multiple application flag. | |||
| BL_MULTI_APP_TYPE | VARCHAR2 | 20 | Indicates business license multiple application type. | |||
| LNP_REQUEST_ENTRY_METHOD | VARCHAR2 | 30 | Indicates permits request entry method. | |||
| LNP_READY_ENTRY_METHOD | VARCHAR2 | 30 | Indicates permits ready entry method. | |||
| BL_REQUEST_ENTRY_METHOD | VARCHAR2 | 30 | Indicates business license request entry method. | |||
| BL_READY_ENTRY_METHOD | VARCHAR2 | 30 | Indicates business license ready entry method. | |||
| INS_TIME_ENTRY_REQUEST | VARCHAR2 | 30 | Indicates inspections request entry method. | |||
| INS_TIME_ENTRY_READY | VARCHAR2 | 30 | Indicates inspections ready entry method. | |||
| INS_TIME_ENTRY_SCHEDULE | VARCHAR2 | 30 | Indicates inspections schedule entry method. | |||
| INS_ASSIGNMENT_METHOD_REQUEST | VARCHAR2 | 30 | Indicates inspections request assignment method. | |||
| INS_ASSIGNMENT_METHOD_READY | VARCHAR2 | 30 | Indicates inspections ready assignment method. | |||
| INS_ASSIGNMENT_METHOD_SCHEDULE | VARCHAR2 | 30 | Indicates inspections schedule assignment method. | |||
| INS_ARRIVAL_DISPLAY_REQUEST | VARCHAR2 | 30 | Indicates inspections request arrival display. | |||
| INS_ARRIVAL_DISPLAY_READY | VARCHAR2 | 30 | Indicates inspections ready arrival display. | |||
| INS_ARRIVAL_DISPLAY_SCHEDULE | VARCHAR2 | 30 | Indicates inspections schedule arrival display. | |||
| SCHED_TIME_DISPLAY_CUTOFF | TIMESTAMP | Indicates the cutoff time to determine which description to show for the inspection scheduled time. | ||||
| PMT_INS_PUBLIC_CANCEL_OPT | VARCHAR2 | 30 | Yes | Cancel inspection options available to public users for permits. | ||
| BL_INS_PUBLIC_CANCEL_OPT | VARCHAR2 | 30 | Yes | Cancel inspection options available to public users for business licenses. | ||
| PMT_INS_ENABLE_POSTPONE_FLAG | VARCHAR2 | 1 | Yes | Enable users to postpone inspection for permits. | ||
| BL_INS_ENABLE_POSTPONE_FLAG | VARCHAR2 | 1 | Yes | Enable users to postpone inspection for permits. | ||
| PMT_APPLY_INSTRUCTIONS | VARCHAR2 | 50 | A unique value that identifies an instructional text for Permits. | |||
| PZ_APPLY_INSTRUCTIONS | VARCHAR2 | 50 | A unique value that identifies an instructional text for Planning and Zoning. | |||
| BL_APPLY_INSTRUCTIONS | VARCHAR2 | 50 | A unique value that identifies an instructional text for Business License. | |||
| BL_BE_DOC_GROUP_ID | VARCHAR2 | 30 | Stores the document group identifier for business entity attachments. | |||
| BL_LOC_DOC_GROUP_ID | VARCHAR2 | 30 | Stores the document group identifier for business location attachments. | |||
| BL_OWN_DOC_GROUP_ID | VARCHAR2 | 30 | Stores the document group identifier for business owner attachments. | |||
| PZ_DISPLAY_PLANNER_CONTACT | VARCHAR2 | 30 | Yes | Indicate which planner's contact to display to public users. | ||
| PZ_GENERAL_PLANNER_EMAIL | VARCHAR2 | 320 | Indicate the general planner's email to display to public users. | |||
| BL_DISPLAY_SPECIALIST_CONTACT | VARCHAR2 | 30 | Yes | Indicate which BL specialist's contact to display to public users. | ||
| BL_GENERAL_SPECIALIST_EMAIL | VARCHAR2 | 320 | Indicate the general specialist's email to display to public users. | |||
| PZ_ALLOW_APPEAL_FOR_SELF_FLAG | VARCHAR2 | 1 | Yes | Indicates public users can submit appeal for self. | ||
| COPY_ASSIGNED_FLAG | VARCHAR2 | 1 | Indicates if the assigned planner or specialist should be copied to the new transaction. | |||
| CONFIDENTIAL_ATTACH_FLAG | VARCHAR2 | 1 | Indicates if the applicant is allowed to set an individual document as confidential. | |||
| ENABLE_CONSOL_EXP_COMM_FLAG | VARCHAR2 | 1 | Indicates whether sending consolidated communication for expiring or expired business licenses is enabled. | |||
| INS_SCHED_DATE_CUTOFF_DAYS | NUMBER | 3 | Yes | Indicates the number of days allowed to schedule an inspection in advance. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PSC_LNP_AGENCY_OPT_B | psc_com_agency_options | AGENCY_ID, OFFERING_ID |
| psc_lnp_agency_opt_tl | psc_lnp_agency_opt_b | AGENCY_ID, OFFERING_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PSC_LNP_AGENCY_OPT_B_PK | Unique | Default | AGENCY_ID, OFFERING_ID | Active |