[Home] [Help]
[Dependency Information]
[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) | ||
| SICKNESS_REPORTING | VARCHAR2 | (150) | ||
| ASSIGNMENT_NUMBER | VARCHAR2 | (150) | ||
| EMPLOYER_SICKNESS_REFERENCE | VARCHAR2 | (150) | ||
| PAYMENT_TO_EMPLOYEE | VARCHAR2 | (150) | ||
| REASON_FOR_SICKNESS_REPORT | VARCHAR2 | (150) | ||
| WORKDAY_ON_SATURDAY | VARCHAR2 | (150) | ||
| WORKDAY_ON_SUNDAY | VARCHAR2 | (150) | ||
| SI_WAGE_ON_SICKNESS_FIRST_DAY | NUMBER | |||
| DAILY_SI_WAGE | NUMBER | |||
| AMOUNT_OF_WSW_SUBSIDY | NUMBER | |||
| ACCIDENT | VARCHAR2 | (150) | ||
| LATE_PAYMENT_REASON | VARCHAR2 | (150) | ||
| AVERAGE_WORKING_HOURS_A_WEEK | NUMBER | |||
| DATE_OF_NOTICE_OF_TERMINATION | DATE | |||
| TERMINATION_INITIATIVE | VARCHAR2 | (150) | ||
| IMMEDIATE_TERMINATION | VARCHAR2 | (150) | ||
| NUMBER_OF_CALLS_FOR_WORK | NUMBER | |||
| PERIODS_LESS_THAN_3_MONTHS | VARCHAR2 | (150) | ||
| NUMBER_OF_FIRST_CALL_FOR_WORK | NUMBER | |||
| EXCEEDS_ALLOWED_PERIOD_OF_WORK | VARCHAR2 | (150) | ||
| NUMBER_OF_TEMPORARY_CONTRACTS | NUMBER | |||
| CONNECTED_ABSENCE | VARCHAR2 | (150) | ||
| OVER_ALL_START_DATE | DATE | |||
| FIRST_DAY_OF_PARTIAL_RECOVERY | DATE | |||
| REASON | VARCHAR2 | (150) | ||
| SPECIAL_SITUATION | VARCHAR2 | (150) | ||
| ESTIMATED_DATE_OF_BIRTH | DATE | |||
| 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) | ||
| DISABLED_CHILD_CARE | 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 | (4000) |
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
, SICKNESS_REPORTING
, ASSIGNMENT_NUMBER
, EMPLOYER_SICKNESS_REFERENCE
, PAYMENT_TO_EMPLOYEE
, REASON_FOR_SICKNESS_REPORT
, WORKDAY_ON_SATURDAY
, WORKDAY_ON_SUNDAY
, SI_WAGE_ON_SICKNESS_FIRST_DAY
, DAILY_SI_WAGE
, AMOUNT_OF_WSW_SUBSIDY
, ACCIDENT
, LATE_PAYMENT_REASON
, AVERAGE_WORKING_HOURS_A_WEEK
, DATE_OF_NOTICE_OF_TERMINATION
, TERMINATION_INITIATIVE
, IMMEDIATE_TERMINATION
, NUMBER_OF_CALLS_FOR_WORK
, PERIODS_LESS_THAN_3_MONTHS
, NUMBER_OF_FIRST_CALL_FOR_WORK
, EXCEEDS_ALLOWED_PERIOD_OF_WORK
, NUMBER_OF_TEMPORARY_CONTRACTS
, CONNECTED_ABSENCE
, OVER_ALL_START_DATE
, FIRST_DAY_OF_PARTIAL_RECOVERY
, REASON
, SPECIAL_SITUATION
, ESTIMATED_DATE_OF_BIRTH
, 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
, DISABLED_CHILD_CARE
, 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;
APPS
FND_NUMBER
- show dependent code
PER_ABSENCE_ATTENDANCES
APPS.PER_ABSENCE_ATTENDANCES1_DFV is not referenced by any database object
|
|
|
|