AbsencesabsenceMaternity
AbsencesabsenceMaternity
Columns
| Name | Type | Description |
| AbsencespersonAbsenceEntryId [KEY] | Long | AbsencespersonAbsenceEntryId of AbsencesabsenceMaternity |
| PersonAbsenceMaternityId [KEY] | Long | Unique identifier of a maternity record of absence. |
| PersonAbsenceEntryId | Long | Unique identifier for the absence. |
| ExpectedDateOfChildBirth | Date | Expected date of childbirth or placement. |
| IntendToWorkFlag | Bool | Indicates whether the absence can be submitted without a planned return date. Used for maternity absence only. The default value is true. |
| PlannedStartDate | Date | Planned start date of maternity leave. |
| PlannedReturnDate | Date | Planned end date of maternity leave. |
| LeaveDuration | Double | Planned maternity leave duration. |
| ActualChildBirthDate | Date | Actual date of childbirth or placement. |
| ActualStartDate | Date | Actual start date of maternity leave. |
| ActualReturnDate | Date | Actual return date of maternity leave. |
| ActualDuration | Double | Actual duration of maternity leave. |
| ExpectedEndDate | Date | Expected end date of maternity leave. |
| ExpectedWeekOfChildBirth | Date | Expected week of maternity leave. This is Monday of the week in which the expected date of childbirth falls. |
| OpenEndedFlag | Bool | Indicates whether the absence can be submitted without an absence end date. The default value is false. |
| MatchingDate | Date | Date field to be used by localization team. |
| CreatedBy | String | CreatedBy of AbsencesabsenceMaternity |
| CreationDate | Datetime | CreationDate of AbsencesabsenceMaternity |
| LastUpdateDate | Datetime | LastUpdateDate of AbsencesabsenceMaternity |
| LastUpdateLogin | String | LastUpdateLogin of AbsencesabsenceMaternity |
| LastUpdatedBy | String | LastUpdatedBy of AbsencesabsenceMaternity |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AbsenceTypeId | Long | absenceTypeId |
| EndDate | Date | endDate |
| Finder | String | finder |
| PersonId | Long | personId |
| StartDate | Date | startDate |