Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PER_ABSENCE_ATTENDANCES1_DFV

Object Details
Object Name: PER_ABSENCE_ATTENDANCES1_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
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)
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)
Query Text

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;

Dependencies

[top of page]

APPS.PER_ABSENCE_ATTENDANCES1_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPER_ABSENCE_ATTENDANCES
APPS.PER_ABSENCE_ATTENDANCES1_DFV is referenced by following:

SchemaPUBLIC
SynonymPER_ABSENCE_ATTENDANCES1_DFV