[Home] [Help] [Dependency Information]
Object Name: | HRIFV_GRADE_RATES_BG |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | HRI.HRIFV_GRADE_RATES_BG |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
This view shows all grades and their corresponding grade rates
if the grade does not have grade rates then null values are shown.
The view uses business group security on the grade business group id.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GRADE_NAME | VARCHAR2 | (240) | ||
GRADE_DATE_FROM | DATE | Yes | ||
GRADE_DATE_TO | DATE | |||
GRADE_RULE_START_DATE | DATE | |||
GRADE_RULE_END_DATE | DATE | |||
GRADE_RATE_NAME | VARCHAR2 | (80) | ||
UNIT_OF_MEASURE | VARCHAR2 | (4000) | ||
GRADE_MAXIMUM | VARCHAR2 | (20) | ||
GRADE_MID_VALUE | VARCHAR2 | (20) | ||
GRADE_MINIMUM | VARCHAR2 | (20) | ||
GRADE_RATE_VALUE | VARCHAR2 | (20) | ||
GRADE_ANNUALIZATION_FACTOR | NUMBER | |||
PAY_BASIS_NAME | VARCHAR2 | (30) | Yes | |
_DF | CHAR | (21) | ||
GRADE_RULE_ID | NUMBER | (15) | ||
GRADE_ID | NUMBER | (15) | Yes | |
GRADE_DEFINITION_ID | NUMBER | (15) | Yes | |
GRADE_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
GRADE_RATE_ID | NUMBER | (15) | ||
GRADE_OR_SPINAL_POINT_ID | NUMBER | (15) | ||
PAY_BASIS_ID | NUMBER | (9) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT GRADE_NAME
, GRADE_DATE_FROM
, GRADE_DATE_TO
, GRADE_RULE_START_DATE
, GRADE_RULE_END_DATE
, GRADE_RATE_NAME
, UNIT_OF_MEASURE
, GRADE_MAXIMUM
, GRADE_MID_VALUE
, GRADE_MINIMUM
, GRADE_RATE_VALUE
, GRADE_ANNUALIZATION_FACTOR
, PAY_BASIS_NAME
, _DF
, GRADE_RULE_ID
, GRADE_ID
, GRADE_DEFINITION_ID
, GRADE_BUSINESS_GROUP_ID
, GRADE_RATE_ID
, GRADE_OR_SPINAL_POINT_ID
, PAY_BASIS_ID
FROM APPS.HRIFV_GRADE_RATES_BG;
APPS.HRIFV_GRADE_RATES_BG is not referenced by any database object
|
|
|