[Home] [Help] [Dependency Information]
Object Name: | PER_PERIODS_OF_SERVICE1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
TERMINATION_TYPE | VARCHAR2 | (150) | ||
DEATH_BENEFIT_TYPE | VARCHAR2 | (150) | ||
TFN_SUPPLIED_FOR_NON_DEPENDENT | VARCHAR2 | (150) | ||
TAX_FILE_NUMBER | VARCHAR2 | (150) | ||
FUTURE_RETIREMENT_DATE | DATE | |||
COMPENSATION | VARCHAR2 | (150) | ||
GOLDEN_HANDSHAKE | VARCHAR2 | (150) | ||
SALARY_IN_LIEU | VARCHAR2 | (150) | ||
UNUSED_SICK_LEAVE | VARCHAR2 | (150) | ||
UNUSED_RDO | VARCHAR2 | (150) | ||
OTHER | VARCHAR2 | (150) | ||
NOTIFIED_DATE | VARCHAR2 | (150) | ||
NOTICE_TYPE | VARCHAR2 | (150) | ||
DERIVATION_METHOD | VARCHAR2 | (150) | ||
SALARY | VARCHAR2 | (150) | ||
NOTICE_PERIOD_MONTHS | VARCHAR2 | (150) | ||
COUNTER_NOTICE_MONTHS | VARCHAR2 | (150) | ||
LEAVE_DAYS | VARCHAR2 | (150) | ||
CURRENCY | VARCHAR2 | (150) | ||
ROE_REASON | VARCHAR2 | (150) | ||
ROE_COMMENTS | VARCHAR2 | (150) | ||
LAST_WORKED | DATE | |||
ACCRUED_VACATION | VARCHAR2 | (150) | ||
VACATION_ACCRUED | NUMBER | |||
VACATION_TAKEN | NUMBER | |||
VACATION_REMAINING | NUMBER | |||
VACATION_ACCRUED_FROM | DATE | |||
VACATION_ACCRUED_TO | DATE | |||
STARTING_REASON | VARCHAR2 | (150) | ||
ENDING_REASON | VARCHAR2 | (150) | ||
QUALIFICATION_LEVEL | VARCHAR2 | (150) | ||
TYPE_OF_WORK | VARCHAR2 | (150) | ||
EMPLOYEE_STATUS | VARCHAR2 | (150) | ||
AFFILIATED_ALSACEMOSELLE_DSS | VARCHAR2 | (150) | ||
RELATIONSHIP_WITH_MD | VARCHAR2 | (150) | ||
NOTICE_PERIOD_START_DATE | DATE | |||
NOTICE_PERIOD_END_DATE | DATE | |||
LAST_DAY_WORKED | DATE | |||
FINAL_PAYMENT_SCHEDULE | VARCHAR2 | (150) | ||
COVERED_BY_SOCIAL_PLAN | VARCHAR2 | (150) | ||
LAST_FULLTIME_DAY_WORKED | DATE | |||
DATE_ATTESTATION_ASSEDIC_RUN | DATE | |||
AUTHORISATION_DATE | DATE | |||
DATE_OF_DEPARTURE | DATE | |||
REASON_FOR_DEPARTURE | VARCHAR2 | (150) | ||
COUNTRY_RETURNING_TO | VARCHAR2 | (150) | ||
SECONDED_TO | VARCHAR2 | (150) | ||
RETURNING_TO_HONG_KONG | VARCHAR2 | (150) | ||
PROBABLE_RETURN_DATE | DATE | |||
NEW_EMPLOYER_NAME_AND_ADDRESS | VARCHAR2 | (150) | ||
SALARIES_TAX_BORNE_BY_EMPLOYER | VARCHAR2 | (150) | ||
PF_PRINT_LEAV | VARCHAR2 | (150) | ||
PF_EFILE_LEAV | VARCHAR2 | (150) | ||
ECR_LEAV_REAS | VARCHAR2 | (150) | ||
SS_LEAVING_REASON | VARCHAR2 | (150) | ||
OLD_TERMINATION_DATE | DATE | |||
NEW_TERMINATION_DATE | DATE | |||
ABP_REPORTING_PERIOD | DATE | |||
HIJRAH_TERMINATION_DATE | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (2295) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, TERMINATION_TYPE
, DEATH_BENEFIT_TYPE
, TFN_SUPPLIED_FOR_NON_DEPENDENT
, TAX_FILE_NUMBER
, FUTURE_RETIREMENT_DATE
, COMPENSATION
, GOLDEN_HANDSHAKE
, SALARY_IN_LIEU
, UNUSED_SICK_LEAVE
, UNUSED_RDO
, OTHER
, NOTIFIED_DATE
, NOTICE_TYPE
, DERIVATION_METHOD
, SALARY
, NOTICE_PERIOD_MONTHS
, COUNTER_NOTICE_MONTHS
, LEAVE_DAYS
, CURRENCY
, ROE_REASON
, ROE_COMMENTS
, LAST_WORKED
, ACCRUED_VACATION
, VACATION_ACCRUED
, VACATION_TAKEN
, VACATION_REMAINING
, VACATION_ACCRUED_FROM
, VACATION_ACCRUED_TO
, STARTING_REASON
, ENDING_REASON
, QUALIFICATION_LEVEL
, TYPE_OF_WORK
, EMPLOYEE_STATUS
, AFFILIATED_ALSACEMOSELLE_DSS
, RELATIONSHIP_WITH_MD
, NOTICE_PERIOD_START_DATE
, NOTICE_PERIOD_END_DATE
, LAST_DAY_WORKED
, FINAL_PAYMENT_SCHEDULE
, COVERED_BY_SOCIAL_PLAN
, LAST_FULLTIME_DAY_WORKED
, DATE_ATTESTATION_ASSEDIC_RUN
, AUTHORISATION_DATE
, DATE_OF_DEPARTURE
, REASON_FOR_DEPARTURE
, COUNTRY_RETURNING_TO
, SECONDED_TO
, RETURNING_TO_HONG_KONG
, PROBABLE_RETURN_DATE
, NEW_EMPLOYER_NAME_AND_ADDRESS
, SALARIES_TAX_BORNE_BY_EMPLOYER
, PF_PRINT_LEAV
, PF_EFILE_LEAV
, ECR_LEAV_REAS
, SS_LEAVING_REASON
, OLD_TERMINATION_DATE
, NEW_TERMINATION_DATE
, ABP_REPORTING_PERIOD
, HIJRAH_TERMINATION_DATE
, CONCATENATED_SEGMENTS
FROM APPS.PER_PERIODS_OF_SERVICE1_DFV;
APPS.PER_PERIODS_OF_SERVICE1_DFV is not referenced by any database object
|
|
|