Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.HR_S_US_GARN_EXEMPTION_RULES_#

Object Details
Object Name: HR_S_US_GARN_EXEMPTION_RULES_#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXEMPTION_RULE_ID NUMBER (9) Yes
EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

GARN_CATEGORY VARCHAR2 (30) Yes
STATE_CODE VARCHAR2 (2) Yes
ADDL_DEP_AMOUNT_VALUE NUMBER (7)
AMOUNT_VALUE NUMBER (7)
CALC_RULE VARCHAR2 (30)
CREATOR_TYPE VARCHAR2 (30)
DEPENDENTS_CALC_RULE VARCHAR2 (30)
DEPENDENT_AMOUNT_VALUE NUMBER (7)
DI_PCT NUMBER (7)
DI_PCT_DEPENDENTS NUMBER (7)
DI_PCT_DEPENDENTS_IN_ARREARS NUMBER (7)
DI_PCT_IN_ARREARS NUMBER (7)
EXEMPTION_BALANCE NUMBER (9)
EXEMPTION_BALANCE_MAX_PCT NUMBER (7)
EXEMPTION_BALANCE_MIN_PCT NUMBER (7)
MARITAL_STATUS VARCHAR2 (30)
MIN_WAGE_FACTOR NUMBER (7)
PRORATION_RULE VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXEMPTION_RULE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      GARN_CATEGORY
,      STATE_CODE
,      ADDL_DEP_AMOUNT_VALUE
,      AMOUNT_VALUE
,      CALC_RULE
,      CREATOR_TYPE
,      DEPENDENTS_CALC_RULE
,      DEPENDENT_AMOUNT_VALUE
,      DI_PCT
,      DI_PCT_DEPENDENTS
,      DI_PCT_DEPENDENTS_IN_ARREARS
,      DI_PCT_IN_ARREARS
,      EXEMPTION_BALANCE
,      EXEMPTION_BALANCE_MAX_PCT
,      EXEMPTION_BALANCE_MIN_PCT
,      MARITAL_STATUS
,      MIN_WAGE_FACTOR
,      PRORATION_RULE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_S_US_GARN_EXEMPTION_RULES_#;

Dependencies

[top of page]

HR.HR_S_US_GARN_EXEMPTION_RULES_# references the following:

SchemaHR
TableHR_S_US_GARN_EXEMPTION_RULES_F
HR.HR_S_US_GARN_EXEMPTION_RULES_# is referenced by following:

SchemaAPPS
SynonymHR_S_US_GARN_EXEMPTION_RULES_F