HRA_TMPL_SECTIONS
This table stores template sections added from the section definitions defined, for a template. For example, the FY07 appraisal template includes the Competency and Objectives defined in Section Definitions.
Details
-
Schema: FUSION
-
Object owner: HRA
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
HRA_TMPL_SECTIONS_PK |
SECTION_ID, BUSINESS_GROUP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| SECTION_ID | NUMBER | 18 | Yes | Primary key of Template Sections. | |||
| ENABLE_SECTION_COMMENTS_FLAG | VARCHAR2 | 30 | ENABLE_SECTION_COMMENTS_FLAG | ||||
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS | |||
| SECTION_DEF_ID | NUMBER | 18 | Yes | Foreign key of Section Definition. | |||
| TEMPLATE_DEFN_ID | NUMBER | 18 | Yes | Foreign key of Template Definition | |||
| SEQUENCE_NUMBER | NUMBER | 18 | Yes | Indicates the sequence of the section within a layout tab. | |||
| SECTION_TYPE_CODE | VARCHAR2 | 30 | This field stores a lookup code for the section type.The section type describes how the system should process this section. | ||||
| DESCRIPTION | VARCHAR2 | 4000 | Description of the Template Section. | ||||
| RATE_SECTION_FLAG | VARCHAR2 | 30 | Indicates whether to allow the user to enter a rating for the section, or for the system to calculate a rating for the section. | ||||
| CALCULATION_RULE_CODE | VARCHAR2 | 30 | Indicates the calculation rule to be used when the section is to be rated. | ||||
| FAST_FORMULA_ID | NUMBER | 18 | Indicates the fast formula that the system should use when the section is to be rated by means of calculation using a fast formula. | ||||
| SECTION_RATING_MODEL_ID | NUMBER | 18 | Indicates the default rating model for the system. | ||||
| WEIGHT_SECTION_FLAG | VARCHAR2 | 30 | Indicates whether the section can have a weighting relative to other sections within the performance document | ||||
| SECTION_WEIGHT | NUMBER | 20 | This is the default weight for a section. | ||||
| SECTION_MIN_WEIGHT | NUMBER | 20 | This is the minimum weight for a section. | ||||
| ENABLE_ITEMS_FLAG | VARCHAR2 | 30 | Indicates that the section will contain items such as specific competencies or goals. | ||||
| CONTENT_PROFILE_FLAG | VARCHAR2 | 30 | Indicates that the section will refer to the content library when the user adds items. | ||||
| CONTENT_TYPE_ID | NUMBER | 18 | This field stores the ID of a content type to be used in the section. | ||||
| FREE_FORM_ALLOWED_FLAG | VARCHAR2 | 30 | Indicates if the system will allow the user to add free-from items. | ||||
| ADD_ITEMS_CONFIRM_CRIT_FLAG | VARCHAR2 | 30 | Indicates if the system will allow users to add items to the section. | ||||
| RATE_ITEM_FLAG | VARCHAR2 | 30 | Indicates if the user can rate each item within the section. | ||||
| RATING_TYPE_CODE | VARCHAR2 | 30 | This field allows the user to choose the rating type they would like to apply to items in this section. | ||||
| USE_SECRTG_FOR_PERFRTG_FLAG | VARCHAR2 | 30 | Indicates whether the system will use the rating model specified for section, for all items within this section. | ||||
| PERF_RATING_MODEL_ID | NUMBER | 18 | This is the rating model for performance ratings, if the section rating model is not being used. | ||||
| ITEM_CALCULATION_CODE | VARCHAR2 | 30 | This field indicates the data that should be used when calculating the rating points for a specific item. | ||||
| SHOW_TARGET_PERF_RTG | VARCHAR2 | 30 | Indicates whether the system will display the target performance rating field at the performance template | ||||
| SHOW_TARGET_PROF_LEVEL | VARCHAR2 | 30 | Indicates whether the system will display the target proficiency level field at the performance template | ||||
| SHOW_MANDATORY | VARCHAR2 | 30 | Indicates if the user can edit or delete items at the performance document. This setting would typically be used in conjunction with integration with profile content. | ||||
| SHOW_DESCRIPTION | VARCHAR2 | 30 | Indicates if the system will display the description of the content item from the content library, at the performance document. | ||||
| SHOW_SECTION_WEIGHT | VARCHAR2 | 30 | Indicates if the section can have a weighting relative to other sections within the performance document. | ||||
| SHOW_SECTION_MIN_WEIGHT | VARCHAR2 | 30 | Indicates whether the HR specialist can enter minimum weights at the performance template. These minima are displayed on the performance document. | ||||
| SHOW_DUE_DATE | VARCHAR2 | 30 | Indicates if the system will display a due date field at the performance document, one date per item. | ||||
| SHOW_OWNED_BY | VARCHAR2 | 30 | Indicates if the system will display an owner field at the performance document. | ||||
| SHOW_PERCENT_COMPLETE | VARCHAR2 | 30 | Indicates if the system will display a percent complete field, at the performance document, for each item. | ||||
| SHOW_CRITICAL | VARCHAR2 | 30 | Allows the user to indicate if a content item is critical, at the performance document. | ||||
| SHOW_MEASUREMENT | VARCHAR2 | 30 | Indicates if the system will display a Measurement field at the performance template. This setting is used with free-form items to describe the standard against which performance is measured. | ||||
| SHOW_REMINDER_DATE | VARCHAR2 | 30 | Indicates if the system will display a reminder date field at the performance document, one date per item. | ||||
| SHOW_STATUS | VARCHAR2 | 30 | Indicates if the system will display a status field, at the performance document, for each item. | ||||
| USE_PROFILE_FLAG | VARCHAR2 | 30 | Indicates whether the system will identify the most specific profile related to a worker's job data, then copy all content items for this content type, into the performance document. | ||||
| PROFILE_TYPE_ID | NUMBER | 18 | This field stores the ID of a model profile that contains the content type specified. | ||||
| USE_SPEC_PROFILE_FLAG | VARCHAR2 | 30 | Indicates whether the system will copy all the content items matching the specified content type, into the performance document. | ||||
| PROFILE_ID | NUMBER | 18 | This field is the profile ID of a specific model profile, used for copying content when generating performance documents. | ||||
| USE_WORKER_GOALS_FLAG | VARCHAR2 | 30 | Indicates whether the system will copy goals from worker's goals into the performance document, when generating the performance document. | ||||
| UPDATE_GOAL_WEIGHTS_FLAG | VARCHAR2 | 30 | Indicates whether to update weights of the existing goals in PD from Goal Management | ||||
| USE_SPEC_CONTENT_ITEM_FLAG | VARCHAR2 | 30 | Indicates whether the system will allow the user to add content items of the content type to the section. | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE30 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER11 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER12 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER13 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER14 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER15 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER16 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER17 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER18 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER19 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_NUMBER20 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE6 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE7 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE8 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE9 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE10 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE11 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE12 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE13 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE14 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| ATTRIBUTE_DATE15 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Performance Template Sections (HRA_TMPL_SECTIONS) | ||||
| 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. | ||||
| 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. | ||||
| USE_WRITING_ASSISTANT_FLAG | VARCHAR2 | 30 | Indicates whether the system will use writing assistant flag at the performance template | ||||
| ROUNDING_RULE_CODE | VARCHAR2 | 30 | Indicates the rounding rule that will be used for ratings that are calculated by the system. Valid values are Standard, Up and Down. | ||||
| DECIMAL_PLACES | VARCHAR2 | 30 | Indicates the number of decimal places for calculated ratings. | ||||
| MAPPING_METHOD_CODE | VARCHAR2 | 30 | Method to determine the rating when there is no exact match between the calculated rating and a rating level from the rating model used in the section. Valid values are Nearest, Lowest, and Highest.' | ||||
| CALC_MAPPING_CODE | VARCHAR2 | 30 | With mapping method code, this field indicates how the calculated numeric score should be mapped to a rating level in the rating model. Valid values are Numeric Rating and Points Range. | ||||
| USE_SEC_WEIGHTS_FOR_CALC | VARCHAR2 | 30 | Indicates section weight to be part of calcuation for the ratings of overall summary section. | ||||
| ENABLE_CHILD_ITEMS_FLAG | VARCHAR2 | 30 | It indicates whether Behaviors defined as child items for Competencies in Profile Management are displayed in the Competency section. | ||||
| INCLUDE_FUTURE_ITEMS_FLAG | VARCHAR2 | 30 | Indicates about future development goals starting after performance document evaluation period | ||||
| EXCLUDE_INACTIVE_ITEMS_FLAG | VARCHAR2 | 30 | Indicates whether to exclude development goals whose status is inactive. | ||||
| 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. | Obsolete | |||
| REFERENCE_SECTION_ID | NUMBER | Indicates the reference to the current section in Profile Management. | |||||
| ENABLE_ITEM_COMMENTS_FLAG | VARCHAR2 | 30 | Indicates whether item comments is enabled for the section. | ||||
| EVALUATION_TYPE_CODE | VARCHAR2 | 30 | Goal evaluation type is to determine how that goal plan should be evaluated in a performance document. | ||||
| INCLUDE_QSTNR_SCORING_FLAG | VARCHAR2 | 30 | Store whether to enable scoring for the questionnaire section in the template. | ||||
| INCLUDE_QSTNR_SCORE_OS_FLAG | VARCHAR2 | 30 | Store whether to include questionnaire score in overall summary ratings calculation in the template. | ||||
| ENABLE_MGR_REASON_FLAG | VARCHAR2 | 30 | Indicates whether manger has to give reason if manual Rating is different from Calculated Rating | ||||
| SKILL_TYPE_CODE | VARCHAR2 | 500 | This field specifies the skill types to be included in the performance document as required by a model profile. Valid values are Core, Role and Others. | ||||
| SKILL_PROGRESS_CODE | VARCHAR2 | 30 | This field specifies the skill progress to be included in the performance document. Valid values are All, Attained, and Developing. | ||||
| LOCK_EVAL_WHEN_GOAL_SET_FLAG | VARCHAR2 | 30 | Indicates whether to allow the performance goal section to be evaluated when the goal setting period is taking place. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| HRA_TMPL_SECTIONS | hra_section_defns_b | SECTION_DEF_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS | hra_tmpl_defns_b | TEMPLATE_DEFN_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS | hrt_rating_models_b | SECTION_RATING_MODEL_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS | hrt_content_types_b | CONTENT_TYPE_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS | hrt_rating_models_b | PERF_RATING_MODEL_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS | hrt_profile_types_b | PROFILE_TYPE_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS | hrt_profiles_b | PROFILE_ID |
| hra_tmpl_role_actions | hra_tmpl_sections | SECTION_ID, BUSINESS_GROUP_ID |
| hra_tmpl_period_qstnr | hra_tmpl_sections | SECTION_ID, TMPL_PERIOD_QSTNR_ID |
| hra_eval_sections | hra_tmpl_sections | TMPL_SECTION_ID, BUSINESS_GROUP_ID |
| hra_tmpl_sec_items | hra_tmpl_sections | SECTION_ID, BUSINESS_GROUP_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HRA_TMPL_SECTIONS_N1 | Non Unique | Default | TEMPLATE_DEFN_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS_PK | Unique | Default | SECTION_ID, BUSINESS_GROUP_ID |
| HRA_TMPL_SECTIONS_UK1 | Unique | Default | SECTION_DEF_ID, TEMPLATE_DEFN_ID, BUSINESS_GROUP_ID |