1. Tables and Views
  2. PSC_COM_JOB_FUNC_SEC_B

PSC_COM_JOB_FUNC_SEC_B

The PSC_COM_JOB_FUNC_SEC_B table stores Job Function Section data that is used Employee Profile page

Details

  • Schema: FUSION

  • Object owner: PSC_CC

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

PSC_COM_JOB_FUNC_SEC_B_PK

JOB_FUNC_SEC_ID

Columns

Name Datatype Length Precision Not-null Comments Status
JOB_FUNC_SEC_ID VARCHAR2 50 Yes Unique key that identifies a Job Function section Active
ENABLED_FLAG VARCHAR2 1 Yes To indicate if the Job Function configuration section is enabled Active
INHERIT_ALL_VALUES VARCHAR2 1 Yes To indicate if the values returned from the prompt are to be selected in the grid Active
PROMPT_TABLE_NAME VARCHAR2 100 View Name of the Job Function Section Prompt table Active
PROMPT_TABLE_KEY1 VARCHAR2 100 Key 1 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY2 VARCHAR2 100 Key 2 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY3 VARCHAR2 100 Key 3 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY4 VARCHAR2 100 Key 4 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY5 VARCHAR2 100 Key 5 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY6 VARCHAR2 100 Key 6 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY7 VARCHAR2 100 Key 7 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY8 VARCHAR2 100 Key 8 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY9 VARCHAR2 100 Key 9 of the Job Function Section prompt table Active
PROMPT_TABLE_KEY10 VARCHAR2 100 Key 10 of the Job Function Section prompt table Active
REST_RESOURCE_ID VARCHAR2 1000 Rest resource of the job section prompt
REST_RESOURCE_PARAMETER VARCHAR2 1000 query parameter for rest resourceid
SECTION_RETURN_VALUE VARCHAR2 4 Yes This can have user_defined, multi_value, single_value. This is to indicate how many values the section can return 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
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.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
psc_com_job_func_sec_tl psc_com_job_func_sec_b JOB_FUNC_SEC_ID
psc_com_job_func_conf psc_com_job_func_sec_b JOB_FUNC_SEC_ID

Indexes

Index Uniqueness Tablespace Columns Status
PSC_COM_JOB_FUNC_SEC_B_PK Unique Default JOB_FUNC_SEC_ID, ORA_SEED_SET1 Active
PSC_COM_JOB_FUNC_SEC_B_PK1 Unique Default JOB_FUNC_SEC_ID, ORA_SEED_SET2