DW_TLNTRVW_MEETING_D
This dimension Stores the Talent Review meeting information
Details
Module: Talent Review
Key Columns
MEETING_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| MEETING_ID | NUMBER | 38 | 0 | True | Primary key to this table. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 64 | This column is for Oracle Internal use only. | ||||
| BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Foreign key to HR_ALL_ORGANIZATION_UNITS. | |||
| MEETING_PURPOSE | VARCHAR2 | 999 | A larger text area to capture the facilitators instructions and comments for the meeting participants. | ||||
| MEETING_TITLE | VARCHAR2 | 512 | A brief description of the talent review meeting to help distinguish it from other meeting instances. | ||||
| MEETING_INSTRUCTIONS | VARCHAR2 | 999 | An instructions text for the talent review meeting. | ||||
| MEETING_DATE | DATE | Date to indicate when the actual meeting will take place. | |||||
| MEETING_LEADER_PERSON_ID | NUMBER | 38 | 0 | The individual at the top of the organization under review. | |||
| MEETING_STATUS_CODE | VARCHAR2 | 32 | Indicates the status of the meeting | dw_tlntrvw_meet_status_d_tl | MEETING_STATUS_CODE | ||
| MEETING_SUBMIT_STATUS_CODE | VARCHAR2 | 32 | MEETING_SUBMIT_STATUS_CODE | dw_tlntrvw_meet_sub_status_d_tl | MEETING_SUB_STATUS_CODE | ||
| MEETING_FACILITATOR_NOTES | VARCHAR2 | 999 | MEETING_FACILITATOR_NOTES | ||||
| MEETING_ORGANIZATION_ID | NUMBER | 38 | 0 | Organization for the review meeting | |||
| DATA_SUBMIT_DATE | DATE | The deadline for data used during the talent review meeting to be entered in the various source systems by the meeting participants. | |||||
| MEETING_SUBMISSION_DATE | TIMESTAMP | The timestamp when the meeting was actually submitted. |