PER_ASSIGNMENT_DAY_ABSENCES
The effect of an Absence on different Assignments can vary based on the Work Schedule assigned to them. This table stores the calculated Day level Absence breakup details of individual Assignment records that have an impact of the Absence being created.
Details
-
Schema: FUSION
-
Object owner: PER
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PER_ASSIGNMENT_DAY_ABSENCES_PK |
ASSIGNMENT_DAY_ABSENCE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ASSIGNMENT_DAY_ABSENCE_ID | NUMBER | 18 | Yes | System generated primary key column. | |
| BUSINESS_GROUP_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS. | |
| ASG_ABSENCE_RECORDING_ID | NUMBER | 18 | Yes | Foreign Key to PER_ASG_ABSENCE_RECORDING table. | |
| ABSENCE_ATTENDANCE_ID | NUMBER | 18 | Yes | Foreign Key to PER_ABSENCE_ATTENDANCES table. | |
| ASSIGNMENT_ID | NUMBER | 18 | Yes | Foreign Key to PER_ALL_ASSIGNMENTS_M table. | |
| PERSON_ID | NUMBER | 18 | Yes | Foreign key to PER_PERSONS table. Identifies the person. | |
| ABSENCE_DATE | DATE | Absence date for which the daily break up information was calculated. | |||
| DAY_TYPE | VARCHAR2 | 30 | Indicates whether the day is a working day or a day that is associated with a calendar event that marks it as a non working day. | ||
| SCHEDULE_WORK_DURATION | NUMBER | 9 | Total scheduled work duration for the selected day. | ||
| CALENDAR_EVENT_DURATION | NUMBER | 9 | Total calendar event duration for the selected day. | ||
| WORK_SCHEDULE_UNIT | VARCHAR2 | 1 | Indicates the work schedule unit. | ||
| ABSENCE_DURATION_DAYS | NUMBER | 9 | Absence duration value in days. | ||
| ABSENCE_DURATION_HOURS | NUMBER | 9 | Absence duration value in hours. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PER_ASSGN_DAY_ABSENCES_F1 | Non Unique | Default | ABSENCE_ATTENDANCE_ID |
| PER_ASSGN_DAY_ABSENCES_F2 | Non Unique | Default | ASG_ABSENCE_RECORDING_ID |
| PER_ASSGN_DAY_ABSENCES_N1 | Non Unique | Default | PERSON_ID, ASSIGNMENT_ID |
| PER_ASSGN_DAY_ABSENCES_PK | Unique | Default | ASSIGNMENT_DAY_ABSENCE_ID |
| PER_ASSIGNMENT_DAY_ABSENCES_N2 | Non Unique | Default | LAST_UPDATE_DATE |