[Home] [Help] [Dependency Information]
Object Name: | GHR_FAMILIES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_FAMILIES |
Subobject Name: | |
Status: | VALID |
GHR_FAMILIES holds information about a family. It is used to group
nature of actions together that have either the same 1) processing
methods 2) update HR logic 3) required items when updating HR for the
PA Request. or 4) information types for PA Request extra information.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_FAMILIES_PK | NORMAL | UNIQUE | APPS_TS_SEED |
NOA_FAMILY_CODE
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOA_FAMILY_CODE | VARCHAR2 | (30) | Yes | Nature of action family code. |
NAME | VARCHAR2 | (100) | Yes | Name of nature of action family name. |
PROC_METHOD_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the family is a processing method family. |
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the family is a required family. |
PA_INFO_TYPE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the family is a PA Request information type family. |
UPDATE_HR_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the family is an update HR family. |
DUAL_OVERLAP_FLAG | VARCHAR2 | (1) | Yes | Dual Actions Overlap Flag |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the family is enabled. |
START_DATE_ACTIVE | DATE | The date when the family becomes active. | ||
END_DATE_ACTIVE | DATE | The date when the family becomes inactive. | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
CREATION_DATE | DATE | Yes | Standard who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT NOA_FAMILY_CODE
, NAME
, PROC_METHOD_FLAG
, REQUIRED_FLAG
, PA_INFO_TYPE_FLAG
, UPDATE_HR_FLAG
, DUAL_OVERLAP_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, ZD_EDITION_NAME
FROM HR.GHR_FAMILIES;
HR.GHR_FAMILIES does not reference any database object
HR.GHR_FAMILIES is referenced by following:
|
|
|