[Home] [Help] [Dependency Information]
Object Name: | GHR_NOA_FAM_PROC_METHODS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_NOA_FAM_PROC_METHODS |
Subobject Name: | |
Status: | VALID |
GHR_NOA_FAM_PROC_METHODS is the intersection between families (which
groups nature of actions together) and personnel action data fields.
For processing method type families it determines the processing
method (e.g. Auto populate, non enterable) and if the data field is
navigable within the request for personnel action form for that
family. For required type families it determins if the data fields are
required for that family.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_NOA_FAM_PROC_METHODS_PK | NORMAL | UNIQUE | APPS_TS_SEED |
NOA_FAMILY_CODE
PA_DATA_FIELD_ID |
GHR_NOA_FAM_PROC_METHODS_FK1 | NORMAL | NONUNIQUE | APPS_TS_SEED | PA_DATA_FIELD_ID |
Table | |
Foreign Table | Foreign Key Column | GHR_NOA_FAM_PROC_METHODS | GHR_FAMILIES | GHR_NOA_FAM_PROC_METHODS NOA_FAMILY_CODE | GHR_NOA_FAM_PROC_METHODS | GHR_PA_DATA_FIELDS | GHR_NOA_FAM_PROC_METHODS PA_DATA_FIELD_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NOA_FAMILY_CODE | VARCHAR2 | (30) | Yes | Foreign key to GHR_FAMILIES |
PA_DATA_FIELD_ID | NUMBER | (15) | Yes | Foreign key to GHR_PA_DATA_FIELDS. |
PROCESS_METHOD_CODE | VARCHAR2 | (30) | Process method code. | |
REQUIRED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the data field for the family is required upon udate to HR. |
NAVIGABLE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the data field for the family is navigable in the form. |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the data field for the family is enabled. |
START_DATE_ACTIVE | DATE | The date when the data field for the family becomes active. | ||
END_DATE_ACTIVE | DATE | The date when the data field for the family becomes inactive. | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. |
Cut, paste (and edit) the following text to query this object:
SELECT NOA_FAMILY_CODE
, PA_DATA_FIELD_ID
, PROCESS_METHOD_CODE
, REQUIRED_FLAG
, NAVIGABLE_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM HR.GHR_NOA_FAM_PROC_METHODS;
HR.GHR_NOA_FAM_PROC_METHODS does not reference any database object
HR.GHR_NOA_FAM_PROC_METHODS is referenced by following:
|
|
|