[Home] [Help] [Dependency Information]
Object Name: | PER_ABSENCE_ATTENDANCES1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
CERTIFICATE_REQUIRED | VARCHAR2 | (150) | ||
CERTIFICATE_RECEIVED | VARCHAR2 | (150) | ||
PAY_DATE | DATE | |||
ADVANCE_DEFER | VARCHAR2 | (150) | ||
ADVANCE_OVERRIDE | VARCHAR2 | (150) | ||
ROE_REASON | VARCHAR2 | (150) | ||
ROE_COMMENTS | VARCHAR2 | (150) | ||
NOTIFY_RECEIVED_FOR_ADOPTION | DATE | |||
EXPECTED_DATE_OF_ADOPTION | DATE | |||
ACTUAL_DATE_OF_ADOPTION | DATE | |||
FIRST_ABSENCE | VARCHAR2 | (150) | ||
LINKED_TO_ABSENCE | VARCHAR2 | (150) | ||
HOLIDAY_ACCRUAL_ELIGIBILITY | VARCHAR2 | (150) | ||
PAYMENT_DURING_LEAVE | VARCHAR2 | (150) | ||
PRE___ADOPT_DURATION_OVERRIDE | NUMBER | |||
AFTER_ADOPT_DURATION_OVERRIDE | NUMBER | |||
ADOPTION_WEEKS_TRANSFERRED | NUMBER | |||
WEEKS_FROM_MOTHER_ABSENCE | NUMBER | |||
NOTIFY_DATE_RETURN_TO_WORK | DATE | |||
EXPECT_RETURN_DATE_TO_WORK | DATE | |||
RIGHT_OF_LEAVE_NOTIFY_DATE | DATE | |||
NOTIFY_DATE_OF_32_WEEKS_ABSENC | DATE | |||
SHARED_LEAVE_NOTIFICATION_DATE | DATE | |||
ACTUAL_DATE_OF_BIRTH_ADOPTION | DATE | |||
DURATION_OVERRIDE | NUMBER | |||
RIGHT_MORE_THAN_1_PERIOD | VARCHAR2 | (150) | ||
ABSENCE_REASON | VARCHAR2 | (150) | ||
NOTIFY_RECEIVED_FOR_MATERNITY | DATE | |||
EXPECTED_DATE_OF_BIRTH | DATE | |||
ACTUAL_DATE_OF_CHILD_BIRTH | DATE | |||
PRE_BIRTH_DURATION_OVERRIDE | NUMBER | |||
AFTER_BIRTH_DURATION_OVERRIDE | NUMBER | |||
MATERNITY_WEEKS_TRANSFERRED | NUMBER | |||
NOTIFY_RECEIVED_FOR_PATERNITY | DATE | |||
DATE_OF_CHILD_BIRTH___ADOPTION | DATE | |||
DURATION_OVERRIDE_WEEKS | NUMBER | |||
WEEKS_FROM_MOTH_RIGHT_OF_ABS | NUMBER | |||
NOTIFY_RECEIVED_FOR_LEAVE | DATE | |||
DATE_OF_CHILD_BIRTH | DATE | |||
PART_TIME_HOURS | NUMBER | |||
PART_TIME_HOURS_FREQUENCY | VARCHAR2 | (150) | ||
NUMBER_OF_CHILDREN_ADOPTED | VARCHAR2 | (150) | ||
PLUS_180_DAYS | VARCHAR2 | (150) | ||
BENEFIT_UPLIFT_CALCULATION | VARCHAR2 | (150) | ||
BENEFIT_UPLIFT_RATE_FORMULA | VARCHAR2 | (150) | ||
BENEFIT_UPLIFT_DURATIONFORMULA | VARCHAR2 | (150) | ||
DATE_OF_BIRTH | DATE | |||
DATE_STILLBORN | DATE | |||
NUMBER_OF_BABIES_BORN | VARCHAR2 | (150) | ||
PART_TIME_MATERNITY_PERCENTAGE | NUMBER | |||
LINKED_ABSENCE | VARCHAR2 | (150) | ||
EXTENDED_DURATION | VARCHAR2 | (150) | ||
FI | VARCHAR2 | (150) | ||
END_DATE_OF_MATERNITY_LEAVE | DATE | |||
NAME_OF_CHILD | VARCHAR2 | (150) | ||
DOCTORS_CERTIFICATE | VARCHAR2 | (150) | ||
CERTIFICATE_DETAILS | VARCHAR2 | (150) | ||
WORK_INCIDENT | VARCHAR2 | (150) | ||
WORK_INCIDENT_DETAILS | VARCHAR2 | (150) | ||
CONTRACT | VARCHAR2 | (150) | ||
CONTRACT_DETAILS | VARCHAR2 | (150) | ||
NAME_OF_SUBSTITUE | VARCHAR2 | (150) | ||
TRAINING_LEAVE_CATEGORY | VARCHAR2 | (150) | ||
COURSE_NAME | VARCHAR2 | (150) | ||
TRAINING_PROVIDER | VARCHAR2 | (150) | ||
TYPE_OF_TRAINING | VARCHAR2 | (150) | ||
SUBSIDIZED_TYPE | VARCHAR2 | (150) | ||
SUBSIDIZING_OPACIF | VARCHAR2 | (150) | ||
EXTERNAL_ORG_SUBSIDY_CURRENCY | VARCHAR2 | (150) | ||
EMPLOYER_SUBSIDY_CURRENCY | VARCHAR2 | (150) | ||
YEAR_1_EXTERNAL_ORG_AMOUNT | NUMBER | |||
YEAR_1_EXTERNAL_ORG_HOURS | VARCHAR2 | (150) | ||
YEAR_1_EMPLOYER_AMOUNT | NUMBER | |||
YEAR_1_EMPLOYER_HOURS | VARCHAR2 | (150) | ||
YEAR_2_EXTERNAL_ORG_AMOUNT | NUMBER | |||
YEAR_2_EXTERNAL_ORG_HOURS | VARCHAR2 | (150) | ||
YEAR_2_EMPLOYER_AMOUNT | NUMBER | |||
YEAR_2_EMPLOYER_HOURS | VARCHAR2 | (150) | ||
DATE_ACCRUED | DATE | |||
DAYS | NUMBER | |||
ACTUAL_ADOPTION_DATE | DATE | |||
ELIGIBLE_FOR_GUARANTEE_AU_NET | VARCHAR2 | (150) | ||
DUMMY_ELIG_GUAR | VARCHAR2 | (150) | ||
NUMBER_OF_ADOPTIONS | NUMBER | |||
PAY_IJSS_ESTIMATE | VARCHAR2 | (150) | ||
PLUS_200_WORKING_HOURS | VARCHAR2 | (150) | ||
SMID_CONTRB_OVER_LAST_6_MONTHS | NUMBER | |||
SPOUSE_ADOPTION_LEAVE | NUMBER | |||
MAIN_DAYS | NUMBER | |||
PROTECTED_DAYS | NUMBER | |||
CONVENTIONAL_DAYS | NUMBER | |||
SENIORITY_DAYS | NUMBER | |||
YOUNG_MOTHERS_DAYS | NUMBER | |||
BIRTH_OR_ADOPTION_DATE | DATE | |||
NUMBER_BORN_OR_ADOPTED | NUMBER | |||
PARENT_ABSENCE | VARCHAR2 | (150) | ||
DUMMY | VARCHAR2 | (150) | ||
MEDICAL_CERTIFICATE_TYPE | VARCHAR2 | (150) | ||
CONFINEMENT_DATE | DATE | |||
CONFINEMENT_DATE_STATUS | VARCHAR2 | (150) | ||
NUMBER_BORN | NUMBER | |||
SUBROGATION | VARCHAR2 | (150) | ||
FINAL_CERTIFICATE_CONCLUSION | VARCHAR2 | (150) | ||
DATE_INELIGIBLE_FOR_IJSS | DATE | |||
SMID_CONTRB_OVER_LAST_12_MONTH | NUMBER | |||
PLUS_800_WORKING_HOURS | VARCHAR2 | (150) | ||
TRAINING_REFERENCE | VARCHAR2 | (150) | ||
WITHIN_TRAINING_PLAN | VARCHAR2 | (150) | ||
LEGAL_CATEGORY | VARCHAR2 | (150) | ||
HOURS_OUTSIDE_WORKING_HOURS | NUMBER | |||
SUBSIDIZING_ORGANIZATION | VARCHAR2 | (150) | ||
EMPLOYER_SUBSIDY_CURENCY | VARCHAR2 | (150) | ||
STUDENT_SALARY | NUMBER | |||
TRAINING_ALLOCATION | NUMBER | |||
PART_DAYS_UNIT_OF_MEASURE | VARCHAR2 | (150) | ||
FRACTION_OF_START_DATE | VARCHAR2 | (150) | ||
FRACTION_OF_END_DATE | VARCHAR2 | (150) | ||
PENSION_RATE_START_DATE | DATE | |||
PENSION_RATE_END_DATE | DATE | |||
PENSION_RATE_VALUE | NUMBER | |||
DATE_OF_DEATH | DATE | |||
DATE_TAKEN_INTO_CARE | DATE | |||
CHILDS_DATE_OF_BIRTH | DATE | |||
TYPE_OF_DISABILITY | VARCHAR2 | (150) | ||
DISABILITY_ID | VARCHAR2 | (150) | ||
NON_SI_ABSENCE | VARCHAR2 | (150) | ||
PERCENTAGE_SICK | NUMBER | |||
NON_ABP_ABSENCE | VARCHAR2 | (150) | ||
CERTIFICATE_TYPE | VARCHAR2 | (150) | ||
CERTIFICATE_START_DATE | DATE | |||
CERTIFICATE_END_DATE | DATE | |||
REIMBURSE_FROM_SOCIAL_SECURITY | VARCHAR2 | (150) | ||
USE_SOCIAL_SECURITY_DAILY_RATE | VARCHAR2 | (150) | ||
EMPLOYERS_PAY_MAXIMUM_6G | VARCHAR2 | (150) | ||
RECLAIMABLE_PAY_MAXIMUM_6G | VARCHAR2 | (150) | ||
DAILY_RATE_CALCULATION | VARCHAR2 | (150) | ||
DATE_OF_ADOPTION | DATE | |||
NUMBER_OF_CHILDREN | VARCHAR2 | (150) | ||
COMPENSATION_RATE | VARCHAR2 | (150) | ||
INITIAL_ABSENCE | VARCHAR2 | (150) | ||
SPOUSE | VARCHAR2 | (150) | ||
DAYS_SPOUSE_ON_PATERNITY_LEAVE | NUMBER | |||
HOLIDAY_PAY_DAYS | NUMBER | |||
MATERNITY_COMPENSATION_RATE | VARCHAR2 | (150) | ||
DAYS_SPOUSE_ON_MATERNITY_LEAVE | NUMBER | |||
PART_TIME_ADOPTION__ | NUMBER | |||
PART_TIME_MATERNITY__ | NUMBER | |||
PART_TIME_PATERNITY__ | NUMBER | |||
PART_TIME_SICKNESS__ | NUMBER | |||
DATE_FOLLOW_UP_PLAN_DUE | DATE | |||
DATE_FOLLOW_UP_PLAN_CREATED | DATE | |||
DATE_FOLLOW_UP_PLAN_SENT | DATE | |||
DATE_LIAISON_MEETING_DUE | DATE | |||
ACTUAL_DATE_OF_LIAISON_MEETING | DATE | |||
DISABILITY_DETAILS | VARCHAR2 | (150) | ||
BABY_DATE_OF_BIRTH | DATE | |||
ABSENCE_PERCENTAGE | NUMBER | |||
HOURLY_RATE | VARCHAR2 | (150) | ||
SALARY_RATE | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (3352) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, CERTIFICATE_REQUIRED
, CERTIFICATE_RECEIVED
, PAY_DATE
, ADVANCE_DEFER
, ADVANCE_OVERRIDE
, ROE_REASON
, ROE_COMMENTS
, NOTIFY_RECEIVED_FOR_ADOPTION
, EXPECTED_DATE_OF_ADOPTION
, ACTUAL_DATE_OF_ADOPTION
, FIRST_ABSENCE
, LINKED_TO_ABSENCE
, HOLIDAY_ACCRUAL_ELIGIBILITY
, PAYMENT_DURING_LEAVE
, PRE___ADOPT_DURATION_OVERRIDE
, AFTER_ADOPT_DURATION_OVERRIDE
, ADOPTION_WEEKS_TRANSFERRED
, WEEKS_FROM_MOTHER_ABSENCE
, NOTIFY_DATE_RETURN_TO_WORK
, EXPECT_RETURN_DATE_TO_WORK
, RIGHT_OF_LEAVE_NOTIFY_DATE
, NOTIFY_DATE_OF_32_WEEKS_ABSENC
, SHARED_LEAVE_NOTIFICATION_DATE
, ACTUAL_DATE_OF_BIRTH_ADOPTION
, DURATION_OVERRIDE
, RIGHT_MORE_THAN_1_PERIOD
, ABSENCE_REASON
, NOTIFY_RECEIVED_FOR_MATERNITY
, EXPECTED_DATE_OF_BIRTH
, ACTUAL_DATE_OF_CHILD_BIRTH
, PRE_BIRTH_DURATION_OVERRIDE
, AFTER_BIRTH_DURATION_OVERRIDE
, MATERNITY_WEEKS_TRANSFERRED
, NOTIFY_RECEIVED_FOR_PATERNITY
, DATE_OF_CHILD_BIRTH___ADOPTION
, DURATION_OVERRIDE_WEEKS
, WEEKS_FROM_MOTH_RIGHT_OF_ABS
, NOTIFY_RECEIVED_FOR_LEAVE
, DATE_OF_CHILD_BIRTH
, PART_TIME_HOURS
, PART_TIME_HOURS_FREQUENCY
, NUMBER_OF_CHILDREN_ADOPTED
, PLUS_180_DAYS
, BENEFIT_UPLIFT_CALCULATION
, BENEFIT_UPLIFT_RATE_FORMULA
, BENEFIT_UPLIFT_DURATIONFORMULA
, DATE_OF_BIRTH
, DATE_STILLBORN
, NUMBER_OF_BABIES_BORN
, PART_TIME_MATERNITY_PERCENTAGE
, LINKED_ABSENCE
, EXTENDED_DURATION
, FI
, END_DATE_OF_MATERNITY_LEAVE
, NAME_OF_CHILD
, DOCTORS_CERTIFICATE
, CERTIFICATE_DETAILS
, WORK_INCIDENT
, WORK_INCIDENT_DETAILS
, CONTRACT
, CONTRACT_DETAILS
, NAME_OF_SUBSTITUE
, TRAINING_LEAVE_CATEGORY
, COURSE_NAME
, TRAINING_PROVIDER
, TYPE_OF_TRAINING
, SUBSIDIZED_TYPE
, SUBSIDIZING_OPACIF
, EXTERNAL_ORG_SUBSIDY_CURRENCY
, EMPLOYER_SUBSIDY_CURRENCY
, YEAR_1_EXTERNAL_ORG_AMOUNT
, YEAR_1_EXTERNAL_ORG_HOURS
, YEAR_1_EMPLOYER_AMOUNT
, YEAR_1_EMPLOYER_HOURS
, YEAR_2_EXTERNAL_ORG_AMOUNT
, YEAR_2_EXTERNAL_ORG_HOURS
, YEAR_2_EMPLOYER_AMOUNT
, YEAR_2_EMPLOYER_HOURS
, DATE_ACCRUED
, DAYS
, ACTUAL_ADOPTION_DATE
, ELIGIBLE_FOR_GUARANTEE_AU_NET
, DUMMY_ELIG_GUAR
, NUMBER_OF_ADOPTIONS
, PAY_IJSS_ESTIMATE
, PLUS_200_WORKING_HOURS
, SMID_CONTRB_OVER_LAST_6_MONTHS
, SPOUSE_ADOPTION_LEAVE
, MAIN_DAYS
, PROTECTED_DAYS
, CONVENTIONAL_DAYS
, SENIORITY_DAYS
, YOUNG_MOTHERS_DAYS
, BIRTH_OR_ADOPTION_DATE
, NUMBER_BORN_OR_ADOPTED
, PARENT_ABSENCE
, DUMMY
, MEDICAL_CERTIFICATE_TYPE
, CONFINEMENT_DATE
, CONFINEMENT_DATE_STATUS
, NUMBER_BORN
, SUBROGATION
, FINAL_CERTIFICATE_CONCLUSION
, DATE_INELIGIBLE_FOR_IJSS
, SMID_CONTRB_OVER_LAST_12_MONTH
, PLUS_800_WORKING_HOURS
, TRAINING_REFERENCE
, WITHIN_TRAINING_PLAN
, LEGAL_CATEGORY
, HOURS_OUTSIDE_WORKING_HOURS
, SUBSIDIZING_ORGANIZATION
, EMPLOYER_SUBSIDY_CURENCY
, STUDENT_SALARY
, TRAINING_ALLOCATION
, PART_DAYS_UNIT_OF_MEASURE
, FRACTION_OF_START_DATE
, FRACTION_OF_END_DATE
, PENSION_RATE_START_DATE
, PENSION_RATE_END_DATE
, PENSION_RATE_VALUE
, DATE_OF_DEATH
, DATE_TAKEN_INTO_CARE
, CHILDS_DATE_OF_BIRTH
, TYPE_OF_DISABILITY
, DISABILITY_ID
, NON_SI_ABSENCE
, PERCENTAGE_SICK
, NON_ABP_ABSENCE
, CERTIFICATE_TYPE
, CERTIFICATE_START_DATE
, CERTIFICATE_END_DATE
, REIMBURSE_FROM_SOCIAL_SECURITY
, USE_SOCIAL_SECURITY_DAILY_RATE
, EMPLOYERS_PAY_MAXIMUM_6G
, RECLAIMABLE_PAY_MAXIMUM_6G
, DAILY_RATE_CALCULATION
, DATE_OF_ADOPTION
, NUMBER_OF_CHILDREN
, COMPENSATION_RATE
, INITIAL_ABSENCE
, SPOUSE
, DAYS_SPOUSE_ON_PATERNITY_LEAVE
, HOLIDAY_PAY_DAYS
, MATERNITY_COMPENSATION_RATE
, DAYS_SPOUSE_ON_MATERNITY_LEAVE
, PART_TIME_ADOPTION__
, PART_TIME_MATERNITY__
, PART_TIME_PATERNITY__
, PART_TIME_SICKNESS__
, DATE_FOLLOW_UP_PLAN_DUE
, DATE_FOLLOW_UP_PLAN_CREATED
, DATE_FOLLOW_UP_PLAN_SENT
, DATE_LIAISON_MEETING_DUE
, ACTUAL_DATE_OF_LIAISON_MEETING
, DISABILITY_DETAILS
, BABY_DATE_OF_BIRTH
, ABSENCE_PERCENTAGE
, HOURLY_RATE
, SALARY_RATE
, CONCATENATED_SEGMENTS
FROM APPS.PER_ABSENCE_ATTENDANCES1_DFV;
|
|
|