HR OBJ RELATION FAC SPONSOR Table
Stores faculty sponsor relationships between HR objects, identifying sponsorship links and their effective dates. Each row represents a faculty sponsorship relationship between two HR objects.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_OBJECT_CODE |
Identifier of the primary HR object participating in the sponsorship relationship. |
VARCHAR2 |
8 |
HR_OBJECT_RELATIONSHIP |
Descriptive name of the faculty sponsorship relationship. |
VARCHAR2 |
25 |
HR_OBJECT_RELATIONSHIP_CODE |
Code identifying the type of faculty sponsorship relationship. |
VARCHAR2 |
4 |
HR_OBJECT_RELATION_END_DATE |
Effective end date of the faculty sponsorship relationship. |
DATE |
|
HR_OBJECT_RELATION_START_DATE |
Effective start date of the faculty sponsorship relationship. |
DATE |
|
HR_OBJECT_TYPE |
Descriptive name of the primary HR object type. |
VARCHAR2 |
25 |
HR_OBJECT_TYPE_CODE |
Code identifying the type of the primary HR object. |
VARCHAR2 |
2 |
HR_OBJECT_WITH_TYPE |
Composite identifier representing the primary HR object and its object type. |
VARCHAR2 |
10 |
HR_RELATED_OBJECT_CODE |
Identifier of the related HR object participating in the sponsorship relationship. |
VARCHAR2 |
45 |
HR_RELATED_OBJECT_TYPE |
Descriptive name of the related HR object type. |
VARCHAR2 |
25 |
HR_RELATED_OBJECT_TYPE_CODE |
Code identifying the type of the related HR object. |
VARCHAR2 |
2 |
HR_RELATED_OBJECT_WITH_TYPE |
Composite identifier representing the related HR object and its object type. |
VARCHAR2 |
47 |
LAST_UPDATE_DATE |
Date the sponsorship relationship record was last updated. |
DATE |
|
LAST_UPDATE_USER |
Identifier of the user or process that last updated the record. |
VARCHAR2 |
12 |
RELATIONSHIP_ACTIVE_FLG |
Flag indicating whether the faculty sponsorship relationship is currently active. |
CHAR |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |