[Home] [Help] [Dependency Information]
Object Name: | GHR_RIF_REGISTERS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | GHR.GHR_RIF_REGISTERS |
Subobject Name: | |
Status: | VALID |
GHR_RIF_REGISTERS is a temporary table used to list the people who
match the criteria and hold information about that person that is
helpful when running a reduction in force (RIF) register.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GHR_RIF_REGISTERS_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | RIF_REGISTER_ID |
GHR_RIF_REGISTERS_FK | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | RIF_CRITERIA_ID |
Table | |
Foreign Table | Foreign Key Column | GHR_RIF_REGISTERS | GHR_RIF_CRITERIA | GHR_RIF_REGISTERS RIF_CRITERIA_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RIF_REGISTER_ID | NUMBER | (15) | Yes | System-generated primary key from GHR_RIF_REGISTERS_S. |
SESSION_ID | NUMBER | (9) | Yes | Oracle generated unique Id for each session. |
RIF_CRITERIA_ID | NUMBER | (15) | Foreign key to GHR_RIF_CRITERIA. | |
EFFECTIVE_DATE | DATE | Yes | Effective date of the RIF | |
PERSON_ID | NUMBER | (10) | Yes | Foreign key to PER_PEOPLE_F. |
POSITION_ID | NUMBER | (15) | Foreign key to PER_POSITIONS. | |
FULL_NAME | VARCHAR2 | (240) | Full name as given in PER_PEOPLE_F. | |
LAST_NAME | VARCHAR2 | (150) | Last name. | |
FIRST_NAME | VARCHAR2 | (150) | First name. | |
MIDDLE_NAMES | VARCHAR2 | (60) | Middle Names | |
NATIONAL_IDENTIFIER | VARCHAR2 | (30) | Number by which a person is identified in a given legislation (SSN). | |
TENURE | VARCHAR2 | (30) | Tenure. | |
TENURE_DESC | VARCHAR2 | (80) | Tenure description. | |
TENURE_GROUP | VARCHAR2 | (30) | Tenure group. | |
TENURE_GROUP_DESC | VARCHAR2 | (80) | Tenure group description. | |
TENURE_GROUP_ORDER | NUMBER | (3) | Tenure group order. | |
VETERANS_PREF_FOR_RIF | VARCHAR2 | (30) | Veterans preference for RIF. | |
VETERANS_PREFERENCE | VARCHAR2 | (30) | Veterans preference. | |
VETERANS_PREFERENCE_DESC | VARCHAR2 | (80) | Veterans preference description. | |
VETERANS_PREF_SUB_GROUP | VARCHAR2 | (30) | Veterans preference sub group. | |
VETERANS_PREF_SUB_GROUP_DESC | VARCHAR2 | (80) | Veterans preference sub group description. | |
VETERANS_PREF_SUB_GROUP_ORDER | NUMBER | (3) | Veterans preference sub group order. | |
SERVICE_COMP_DATE_RIF | DATE | Service computation date for RIF | ||
PERFORMANCE_SCORE | NUMBER | (3) | Performance score | |
ADJUSTED_SERVICE_COMP_DATE | DATE | Adjusted service computation date. | ||
OCC_CODE | VARCHAR2 | (30) | Occupational code. | |
OCC_CODE_DESC | VARCHAR2 | (80) | Occupational code description. | |
JOB_NAME | VARCHAR2 | (240) | Job name. | |
PAY_PLAN | VARCHAR2 | (30) | Pay plan. | |
GRADE_OR_LEVEL | VARCHAR2 | (30) | Grade or level. | |
STEP_OR_RATE | VARCHAR2 | (30) | Step or rate. | |
WGI_DUE_DATE | DATE | WGI due date. | ||
ENTERED_GRADE_DATE | DATE | Date person entered grade. | ||
SERVICE_COMP_DATE_CIVILIAN | DATE | Service computation date for civilian. | ||
RATING_OF_RECORD1 | VARCHAR2 | (30) | First rating of record. | |
RATING_OF_RECORD1_DESC | VARCHAR2 | (80) | First rating of record description. | |
RATING_OF_RECORD1_DATE | DATE | First rating of record date. | ||
RATING_OF_RECORD2 | VARCHAR2 | (30) | Second rating of record. | |
RATING_OF_RECORD2_DESC | VARCHAR2 | (80) | Second rating of record description. | |
RATING_OF_RECORD2_DATE | DATE | Second rating of record desc. | ||
RATING_OF_RECORD3 | VARCHAR2 | (30) | Third rating of record. | |
RATING_OF_RECORD3_DESC | VARCHAR2 | (80) | Third rating of record description. | |
RATING_OF_RECORD3_DATE | DATE | Third rating of record date. | ||
POSITION_OCCUPIED | VARCHAR2 | (30) | Position occupied | |
POSITION_OCCUPIED_DESC | VARCHAR2 | (80) | Position occupied description. | |
POSITION_TITLE | VARCHAR2 | (240) | Position title. | |
POSITION_NAME | VARCHAR2 | (240) | Position name. | |
OBLIGATED_POSN_TYPE | VARCHAR2 | (30) | Obligated position type. | |
OBLIGATED_POSN_TYPE_DESC | VARCHAR2 | (80) | Obligated position type description. | |
ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS. | |
ORGANIZATION_NAME | VARCHAR2 | (240) | Organization name. | |
ORG_STRUCTURE_ID | VARCHAR2 | (20) | Org structure ID. | |
OFFICE_SYMBOL | VARCHAR2 | (18) | Office symbol. | |
AGENCY_CODE_SUBELEMENT | VARCHAR2 | (30) | Agency Code / Sub-element. | |
AGENCY_CODE_SUBELEMENT_DESC | VARCHAR2 | (80) | Agency Code / Sub-element description. | |
OBLIGATED_EXPIRATION_DATE | DATE | Obligated expiration date. | ||
COMP_AREA | VARCHAR2 | (30) | Competitive Area | |
COMP_LEVEL | VARCHAR2 | (30) | Competitive Level | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column. |
CREATION_DATE | DATE | Yes | Standard who column. | |
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. |
Cut, paste (and edit) the following text to query this object:
SELECT RIF_REGISTER_ID
, SESSION_ID
, RIF_CRITERIA_ID
, EFFECTIVE_DATE
, PERSON_ID
, POSITION_ID
, FULL_NAME
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAMES
, NATIONAL_IDENTIFIER
, TENURE
, TENURE_DESC
, TENURE_GROUP
, TENURE_GROUP_DESC
, TENURE_GROUP_ORDER
, VETERANS_PREF_FOR_RIF
, VETERANS_PREFERENCE
, VETERANS_PREFERENCE_DESC
, VETERANS_PREF_SUB_GROUP
, VETERANS_PREF_SUB_GROUP_DESC
, VETERANS_PREF_SUB_GROUP_ORDER
, SERVICE_COMP_DATE_RIF
, PERFORMANCE_SCORE
, ADJUSTED_SERVICE_COMP_DATE
, OCC_CODE
, OCC_CODE_DESC
, JOB_NAME
, PAY_PLAN
, GRADE_OR_LEVEL
, STEP_OR_RATE
, WGI_DUE_DATE
, ENTERED_GRADE_DATE
, SERVICE_COMP_DATE_CIVILIAN
, RATING_OF_RECORD1
, RATING_OF_RECORD1_DESC
, RATING_OF_RECORD1_DATE
, RATING_OF_RECORD2
, RATING_OF_RECORD2_DESC
, RATING_OF_RECORD2_DATE
, RATING_OF_RECORD3
, RATING_OF_RECORD3_DESC
, RATING_OF_RECORD3_DATE
, POSITION_OCCUPIED
, POSITION_OCCUPIED_DESC
, POSITION_TITLE
, POSITION_NAME
, OBLIGATED_POSN_TYPE
, OBLIGATED_POSN_TYPE_DESC
, ORGANIZATION_ID
, ORGANIZATION_NAME
, ORG_STRUCTURE_ID
, OFFICE_SYMBOL
, AGENCY_CODE_SUBELEMENT
, AGENCY_CODE_SUBELEMENT_DESC
, OBLIGATED_EXPIRATION_DATE
, COMP_AREA
, COMP_LEVEL
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM HR.GHR_RIF_REGISTERS;
HR.GHR_RIF_REGISTERS does not reference any database object
HR.GHR_RIF_REGISTERS is referenced by following:
|
|
|