Absences
Absences
Columns
| Name | Type | Description |
| AbsenceCaseId | Long | Unique identifier for the absence case. |
| AbsenceEntryBasicFlag | Bool | Indicates whether the absence is recorded in basic mode or advanced mode. The default value is true. |
| AbsencePatternCd | String | Unique code assigned to the absence pattern associated with an absence type. For example, absence pattern can be Generic for a vacation absence, Illness or injury for a sickness absence. |
| AbsenceStatusCd | String | Absence status, such as submitted, withdrawn. |
| AbsenceTypeId | Long | Unique identifier for the absence type. |
| AbsenceTypeReasonId | Long | Unique identifier for the absence reason. |
| AgreementId | Long | Unique identifier for the agreement name used to record absence. |
| ApprovalStatusCd | String | Approval notification status of the recorded absence. |
| AuthStatusUpdateDate | Date | Latest updated date of the authorization status for the absence. |
| BandDtlId | Long | Unique identifier for the payment details. |
| BlockedLeaveCandidate | String | Determines whether the worker is eligible for block leave or not. Block leave enables workers to report a fixed period away from work. |
| CertificationAuthFlag | Bool | Provides notification for an authorized absence. |
| ChildEventTypeCd | String | Unique code assigned for the child event. |
| Comments | String | Comments provided while recording the absence. |
| ConditionStartDate | Date | Condition start date of an illness or injury leave. Used to indicate when the illness began or injury occurred, and could be different from the absence start date. |
| ConfirmedDate | Date | Confirmed start date of an absence. |
| ConsumedByAgreement | String | Represents the agreement consumption condition of the absence. Possible values are Y, N, and null. The default value is null. |
| CreatedBy | String | CreatedBy of Absences |
| CreationDate | Datetime | CreationDate of Absences |
| DiseaseCode | String | Unique code assigned to a disease. |
| Duration | Double | Duration of the recorded absence. |
| EmployeeShiftFlag | Bool | Shift type of the employee's schedule. Possible values are time, duration and null. Default value is null. |
| EndDate | Date | End date of the recorded absence. |
| EndDateDuration | Double | Duration of the absence on the end date. This field allows the duration of the end date to be different than what is derived from the shift duration. |
| EndDateTime | Datetime | End date timestamp of an absence. |
| EndTime | String | End time of the recorded absence. |
| EstablishmentDate | Date | Date on which the period of incapacity began. This date refers to the date the employee could no longer work. |
| Frequency | String | Represents the frequency of the absence, such as weekly or monthly. |
| InitialReportById | Long | Employee name who reported the notification. |
| InitialTimelyNotifyFlag | Bool | An absence notification qualified as a late notification. |
| LastUpdateDate | Datetime | LastUpdateDate of Absences |
| LastUpdateLogin | String | LastUpdateLogin of Absences |
| LastUpdatedBy | String | LastUpdatedBy of Absences |
| LateNotifyFlag | Bool | An absence notification that qualifies as a late notification and is waived. |
| LegalEntityId | Long | Legal identifier for an employer. |
| LegislationCode | String | Legislation code of the employee for whom the absence is being entered. |
| LegislativeDataGroupId | Long | Unique identifier which determines an employee's legislative data group. |
| NotificationDate | Date | Date the employee notifies the employer of an upcoming absence. |
| ObjectVersionNumber | Int | Used to implement optimistic locking. This number is incremented every time 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. |
| OpenEndedFlag | Bool | Indicates whether the absence is open-ended. Enables workers to submit an absence without entering an absence end date. The default value is false. |
| Overridden | String | Indicates whether the absence duration has been overridden or not. The default value is false. |
| PersonAbsenceEntryId [KEY] | Long | Unique identifier for the absence. |
| PeriodOfIncapToWorkFlag | Bool | Indicates whether an employee's period of incapacity to work has been established or not. The default value is false. |
| PeriodOfServiceId | Long | Unique identifier which determines an employee's period of service. |
| PersonId | Long | Unique identifier for the person. |
| PlannedEndDate | Date | Estimated end date used for the maternity absence. |
| ProcessingStatus | String | Processing status of the absence request, such as submitted, approved, declined. |
| ProjectId | Long | Unique project identifier. |
| SingleDayFlag | Bool | Indicates whether the absence request is for a single day. Default value is false. |
| Source | String | Source of the absence imported from other applications. For example, an absence may be recorded via Absence Management, Time and Labor, a data loader or through the REST process. |
| SplCondition | String | Special conditions for the absence. This is applicable when recording an absence using the Illness or injury or Childbirth pattern. |
| StartDate | Date | Start date of the recorded absence. |
| StartDateDuration | Double | Duration of the absence on the start date. This field allows the duration of the start date to be different than what is derived from the shift duration. |
| StartDateTime | Datetime | Start date timestamp of an absence. |
| StartTime | String | Start time of the recorded absence. |
| SubmittedDate | Date | Date on which absence is created and submitted for approval. |
| TimelinessOverrideDate | Date | Date on which the late notification of the absence was waived. |
| UnitOfMeasure | String | Unit of measure used to record the absence, such as days or hours. |
| UserMode | String | Role of the user who entered this absence. Possible values are EMP, MGR or ADMIN. |
| PersonNumber | String | Unique person number for whom the absence is recorded. |
| AbsenceType | String | Unique identifier for the absence type. |
| Employer | String | Name of the employer. |
| AbsenceReason | String | Reason for absence attached to the absence type. |
| AbsenceDispStatus | String | Absence processing status displayed to the user. Valid values are defined in the lookup ANC_PER_ABS_ENT_DISPLAY_STATUS. |
| AssignmentId | Long | Unique identifier of the assignment for which the absence is recorded. When an employee has multiple active assignments, this attribute can be used to restrict the absence to a specific assignment. You can't change the assignment when editing an existing absence. |
| DataSecurityPersonId | Long | DataSecurityPersonId of Absences |
| EffectiveEndDate | Date | EffectiveEndDate of Absences |
| EffectiveStartDate | Date | EffectiveStartDate of Absences |
| ObjectVersionNumber | Int | Used to implement optimistic locking. This number is incremented every time 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. |
| AgreementName | String | Name of the agreement used to record absence. |
| PaymentDetail | String | Name of payment detail of agreement used to record absence. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |