Oracle Fusion · Data dictionary
HXT_SCH_PROF_DEFAULT_VIEW
SharedUsed in 0 subject areas33 reporting columnsBICC incremental-ready
Source object in the Oracle Fusion data model.
Primary key: not yet catalogued for HXT_SCH_PROF_DEFAULT_VIEW, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE, LAST_UPDATE_DATE1
Joins (inferred from key columns): SETUP_OPTION_VAL_ID → HXT_SETUP_OPTION_VALS · SETUP_PROFILE_ASG_ID → HXT_SETUP_PROFILE_ASGS
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSIGN_TO | ● | Assign to. | |
| CREATED_BY | ● | User who created the row. | |
| CREATED_BY1 | ● | Created by1. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CREATION_DATE1 | ● | Creation date1. | |
| DATE_FROM | ● | Date from. | |
| DATE_TO | ● | Date to. | |
| DESCRIPTION | ● | Description. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | ● | Start date of the effective-dated record. | |
| FIRST_DAY_OF_WEEK | ● | First day of week. | |
| GROUP_MANAGER_ID | ● | Identifier for the group manager. | |
| GRP_ID | ● | Identifier for the grp. | |
| GRP_INCL_MEMBER_ID | ● | Identifier for the grp incl member. | |
| INCL_MEMBER_ID | ● | Identifier for the incl member. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATED_BY1 | ● | Last updated by1. | |
| LAST_UPDATE_DATE | INCR | ● | Date and time the row was last updated (the incremental-extract key). |
| LAST_UPDATE_DATE1 | INCR | ● | Last update date1. |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| LAST_UPDATE_LOGIN1 | ● | Last update login1. | |
| NAME | ● | Name. | |
| OVER_STAFF_THRESHOLD | ● | Over staff threshold. | |
| PRECEDENCE | ● | Precedence. | |
| PRODUCT_AREA | ● | Product area. | |
| SCHEDULING_GROUP_ID | ● | Identifier for the scheduling group. | |
| SETUP_OPTION_VAL_CD | ● | Setup option val code. | |
| SETUP_OPTION_VAL_ID | ● | Identifier for the setup option val. | |
| SETUP_PROFILE_ASG_ID | ● | Identifier for the setup profile asg. | |
| SETUP_PROFILE_CD | ● | Setup profile code. | |
| SETUP_PROFILE_ID | ● | Identifier for the setup profile. | |
| TYPE | ● | Type. | |
| UNDER_STAFF_THRESHOLD | ● | Under staff threshold. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for HXT_SCH_PROF_DEFAULT_VIEW?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table