PSC_CE_ISSUE_SUBTYPE_B
This table contains issue sub setup information.
Details
-
Schema: FUSION
-
Object owner: PSC_CE
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_CE_ISSUE_SUBTYPE_B_PK |
ISSUE_SUBTYPE_ID, AGENCY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ISSUE_SUBTYPE_ID | VARCHAR2 | 50 | Yes | This column is used to indicate issue sub type id | |
| ISSUE_SUBTYPE_CODE | VARCHAR2 | 40 | Yes | This column is used to indicate issue sub type code | |
| ISSUE_TYPE_ID | VARCHAR2 | 50 | Yes | Thisi column is used to indicate issue type id | |
| VALID_FROM_DATE | DATE | Yes | This column is used to indicate valid from date | ||
| VALID_TO_DATE | DATE | This column is used to indicate valid to date | |||
| CITIZEN_ENABLED | VARCHAR2 | 10 | Yes | This column is used to indicate whether the issue type is allowed to citizen | |
| STATUS | VARCHAR2 | 10 | Yes | This column is used to indicate status of issue sub type | |
| AUTO_NUM_RULE_CASE | VARCHAR2 | 20 | Yes | This column is used to indicate auto number rule for case | |
| AUTO_NUM_RULE_INCIDENT | VARCHAR2 | 20 | Yes | This column is used to indicate auto number rule for incident | |
| NOTICE_GROUP_CODE | VARCHAR2 | 100 | This column is used to indicate notice group code | ||
| ICON_IMAGE | VARCHAR2 | 100 | This column is used to indicate suiicon image name | ||
| FEE_SCHEDULE_ID | VARCHAR2 | 20 | This column is used to indicate fee schedule id | ||
| PROCESS_GRP_ID | VARCHAR2 | 50 | This column is to indicate process group identifier. | ||
| 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. | |
| 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. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| 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. | ||
| AGENCY_ID | NUMBER | 8 | Yes | This column is used to indicate agency id | |
| DISTRICT_TYPE | VARCHAR2 | 50 | This column is used to store district type. | ||
| WF_SPACE_RENEW | VARCHAR2 | 50 | This column is used to indicate wf space renew | ||
| WF_SPACE_ORIG | VARCHAR2 | 50 | This column is used to indicate wf space orig | ||
| WF_SPACE_NAME_RENEW | VARCHAR2 | 1000 | This column is used to indicate renewal workflow space name. | ||
| WF_SPACE_NAME_ORIG | VARCHAR2 | 1000 | This column is used to indicate original workflow space name. | ||
| WF_SPACE_NAME_AMEND | VARCHAR2 | 1000 | This column is used to indicate amendment workflow space name. | ||
| WF_SPACE_AMEND | VARCHAR2 | 50 | This column is used to indicate wf space amend | ||
| WF_PROJECT_RENEW | VARCHAR2 | 500 | This column is used to indicate wf project renew | ||
| WF_PROJECT_ORIG | VARCHAR2 | 500 | This column is used to indicate wf project orig | ||
| WF_PROJECT_AMEND | VARCHAR2 | 500 | This column is used to indicate wf project amend | ||
| WF_PROC_VERSION_RENEW | VARCHAR2 | 50 | This column is used to indicate wf proc version renew | ||
| WF_PROC_VERSION_ORIG | VARCHAR2 | 50 | This column is used to indicate wf proc version orig | ||
| WF_PROC_VERSION_AMEND | VARCHAR2 | 50 | This column is used to indicate wf proc version amend | ||
| WF_PROC_DEF_ID_RENEW | VARCHAR2 | 1000 | This column is used to indicate wf proc def id renew | ||
| WF_PROC_DEF_ID_ORIG | VARCHAR2 | 1000 | This column is used to indicate wf proc def id orig | ||
| WF_PROC_DEF_ID_AMEND | VARCHAR2 | 1000 | This column is used to indicate wf proc def id amend |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| psc_ce_issue_subtype_tl | psc_ce_issue_subtype_b | ISSUE_SUBTYPE_ID, AGENCY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PSC_CE_ISSUE_SUBTYPE_B_PK | Unique | Default | ISSUE_SUBTYPE_ID, AGENCY_ID |