PSC_PBL_SETUP
This table contains setup information for user registration and account management.
Details
-
Schema: FUSION
-
Object owner: PSC_CC
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PSC_PBL_SETUP_PK |
USER_SETUP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| USER_SETUP_ID | VARCHAR2 | 3 | Yes | Identifies the row in the public user setup table. The only valid value is PSC. | Active | |
| USER_PRVSNG_VERIFICATION_ON | VARCHAR2 | 1 | Yes | Indicates whether the agency needs to verify a user's registration before the user is provisioned. Valid values are Y (Yes) and N (No). The default value is N. | Active | |
| TERMS_OF_USE_ON | VARCHAR2 | 1 | Yes | Indicates whether users need to accept terms of use when registering. Valid values are Y (Yes) and N (No). The default value is N. | Active | |
| USER_TERMS_OF_USE_ID | VARCHAR2 | 15 | Identifier for the terms of use that the user needs to accept during registration. | Active | ||
| SENSITIVE_FLAG_ON | VARCHAR2 | 1 | Yes | Indicates whether registered user can hide contact information from public view. Valid values are Y (Yes) and N (No). The default value is N. | Active | |
| SENSITIVE_FLAG_VERIFICATION_ON | VARCHAR2 | 1 | Yes | Indicates whether the agency needs to verify a registered user's claim to be a member of law enforcement or a judiciary agency. Valid values are Y (Yes) and N (No). The default value is N. | Active | |
| CNTRCTR_FLAG_VERIFICATION_ON | VARCHAR2 | 1 | Yes | Indicates whether the agency needs to verify a registered user's claim to be a contractor. Valid values are Y (Yes) and N (No). The default value is N. | Active | |
| LICENSE_VERIFICATION_ON | VARCHAR2 | 1 | Yes | Indicates whether the agency needs to verify licenses entered by a user. Valid values are Y (Yes) and N (No). The default value is N. | Active | |
| PAYMENT_ACCT_VERIFICATION_ON | VARCHAR2 | 1 | Yes | Indicates whether the agency needs to verify payment accounts entered by a user. Valid values are Y (Yes) and N (No). The default value is N. | Active | |
| USER_CATEGORY | VARCHAR2 | 240 | Yes | Category to be assigned to a user for system access notifications and for URL redirection after initial password creation. | ||
| ALLOW_ATTACHMENTS | VARCHAR2 | 1 | Yes | Indicates whether agency staff and registered users can manage documents in account management. | ||
| ALLOW_DELETE_ATTACHMENTS | VARCHAR2 | 1 | Yes | Indicates whether registered users can delete documents in account management. | ||
| ALLOW_DELEGATION | VARCHAR2 | 1 | Yes | Enables delegation usage on profile or transactions. | ||
| ALLOW_NUM_DELEGATES | NUMBER | 3 | Identify number of delegates allowed per profile. Limit 999. | |||
| ALLOW_VIEW_PROF_CONTACTS | VARCHAR2 | 1 | Yes | Indicates whether registered user can assign privileges to a delegate to view contact list in profile. | ||
| ALLOW_VIEW_PROF_LICENSE | VARCHAR2 | 1 | Yes | Indicates whether registered user can assign privileges to a delegate to view license info in profile. | ||
| ALLOW_VIEW_SPECIFIC_TRANS | VARCHAR2 | 1 | Yes | Indicates whether registered user can assign a delegate privileges to view specific transactions. | ||
| ALLOW_VIEW_ALL_TRANS | VARCHAR2 | 1 | Yes | Indicates whether registered user can assign a delegate privileges to view all transactions associated with profile. | ||
| ALLOW_UPD_SPECIFIC_TRANS | VARCHAR2 | 1 | Yes | Indicates whether registered user can assign a delegate privileges to manage specific transactions. | ||
| ALLOW_UPD_ALL_TRANS | VARCHAR2 | 1 | Yes | Indicates whether registered user can assign a delegate privileges to manage all transactions associated with profile. | ||
| ALLOW_VIEW_PROF_ATTACH | VARCHAR2 | 1 | Yes | Indicates whether registered user can assign privileges to a delegate to view attachments in a profile. | ||
| ALLOW_TEXT_COMMUNICATION | VARCHAR2 | 1 | Yes | Indicates whether registered user can select Text as preferred way of receiving communication. | ||
| DOC_GROUP_ID | VARCHAR2 | 30 | Indicates the attachment document group. | |||
| REQUEST_DELEGATE_PROJ_MGR | VARCHAR2 | 1 | Yes | Indicates registered users with project manager role can request delegation. | ||
| SUPPRESS_EMAIL | VARCHAR2 | 1 | Yes | Indicates profile owner can suppress emails for actions performed by delegate. | ||
| INVITE_EXPIRY_NUM | NUMBER | 3 | Identify number for invitation expiry. | |||
| INVITATION_EXPIRY_OPT | VARCHAR2 | 30 | Identify option for expiry. | |||
| 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. | |||
| SEED_DATA_LOCK | NUMBER | 1 | Yes | Indicates whether the row is seed data. Valid values are 0 for data that is customer data, 1 for seed data that cannot be modified, and 2 indicates that the seed data can be modified. | ||
| DELETED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the record is logically deleted ('Y' or 'N'). Valid values are 'Y' for deleted record, and 'N' for active record. Default value is 'N'. | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |||
| ALLOW_IVR_ACCESS | VARCHAR2 | 1 | Yes | Identifies Interactive Voice Response (IVR) access | ||
| SENSITIVE_FLAG_ALL | VARCHAR2 | 1 | Yes | Indicates whether agency can hide contact information for all applicants from public view. Valid values are Y (Yes) and N (No). The default value is N. | ||
| 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 | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | ||
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PSC_PBL_SETUP_PK | Unique | Default | USER_SETUP_ID, ORA_SEED_SET1 | Active |
| PSC_PBL_SETUP_PK1 | Unique | Default | USER_SETUP_ID, ORA_SEED_SET2 |