PSC_COM_VALIDATE_OPT_B
This table contains general contractor validation options.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PSC_COM_VALIDATE_OPT_PK |
LICENSE_SETUP_CODE, AGENCY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| LICENSE_SETUP_CODE | VARCHAR2 | 30 | Yes | Setup code identifying segments usages on the license. Can be a state code like CA. | ||
| AGENCY_ID | NUMBER | 8 | Yes | Identifier for the agency that is maintaining license validation. | ||
| SETUP_ENABLED | VARCHAR2 | 1 | Yes | Status of the setup code. Only one should be enabled at a time. | ||
| INTEGRATION_ENABLED | VARCHAR2 | 1 | Yes | Status of the integration that maps license data. | ||
| USE_CLASSIFICATIONS | VARCHAR2 | 1 | Yes | Use license classifications. | ||
| USE_LICENSE_TYPE | VARCHAR2 | 1 | Yes | Use license types. | ||
| LIMIT_LICENSE_USAGE | VARCHAR2 | 1 | Yes | Indicates that in application, user can only select a license that is related to them. | ||
| SELECT_FACTS | VARCHAR2 | 1 | Yes | Choose license sections to display. | ||
| USE_STATUS_MAPPING | VARCHAR2 | 1 | Yes | Map external status to internal status for easy management of status. | ||
| INTEGRATION_NAME | VARCHAR2 | 1000 | Integration name for the mapping to license information site. | Obsolete | ||
| INTEGRATION_VERSION | NUMBER | 9 | Integration version for the mapping to license information site. | Obsolete | ||
| INTEGRATION_PARAMETER | VARCHAR2 | 100 | Name of the query parameter that needs to be added to the integration end point. | Obsolete | ||
| HIDE_WHEN_NOT_CONTRACTOR | VARCHAR2 | 1 | Hide contractor information when applicant is not contractor. | Obsolete | ||
| USE_CONTRACTOR_LIST | VARCHAR2 | 1 | Yes | In application, user can only select a license that exists in contractor list. | ||
| DOC_GROUP_ID | VARCHAR2 | 30 | Indicates the attachment document group. | |||
| 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. | ||
| 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. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| psc_com_val_opt_integ | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
| psc_com_val_ins_type_b | psc_com_validate_opt_b | LICENSE_SETUP_CODE, OBJECT_VERSION_NUMBER |
| psc_com_val_opt_lctp_b | psc_com_validate_opt_b | LICENSE_SETUP_CODE, OBJECT_VERSION_NUMBER |
| psc_com_val_opt_fact | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
| psc_com_val_ownshp_tp_b | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
| psc_com_val_opt_class_b | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
| psc_com_val_opt_sts_map | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
| psc_com_val_ownshp_tp_tl | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
| psc_com_val_ins_type_tl | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
| psc_com_validate_opt_tl | psc_com_validate_opt_b | LICENSE_SETUP_CODE, AGENCY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| psc_com_validate_opt_b_U1 | Unique | Default | LICENSE_SETUP_CODE, AGENCY_ID |