[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 |
Table | |
Foreign Table | Foreign Key Column | GHR_DUAL_ACTIONS | GHR_FAMILIES | GHR_DUAL_ACTIONS NOA_FAMILY_CODE | GHR_DUAL_PROC_METHODS | GHR_FAMILIES | GHR_DUAL_PROC_METHODS NOA_FAMILY_CODE | GHR_NOA_FAMILIES | GHR_FAMILIES | GHR_NOA_FAMILIES NOA_FAMILY_CODE | GHR_NOA_FAM_PROC_METHODS | GHR_FAMILIES | GHR_NOA_FAM_PROC_METHODS NOA_FAMILY_CODE | GHR_PA_REQUESTS | GHR_FAMILIES | GHR_PA_REQUESTS NOA_FAMILY_CODE | GHR_PA_REQUEST_INFO_TYPES | GHR_FAMILIES | GHR_PA_REQUEST_INFO_TYPES NOA_FAMILY_CODE | GHR_PA_ROUTING_HISTORY | GHR_FAMILIES | GHR_PA_ROUTING_HISTORY NOA_FAMILY_CODE |
---|
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. |
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
FROM HR.GHR_FAMILIES;
HR.GHR_FAMILIES does not reference any database object
HR.GHR_FAMILIES is referenced by following:
|
|
|