Skip to content

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

VIEW: APPS.PER_CONTRACTS_F_DFV

Object Details
Object Name: PER_CONTRACTS_F_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)
EMPLOYMENT_STATUS VARCHAR2 (150)
EXPIRY_DATE DATE

CONTRACT_CATEGORY VARCHAR2 (150)
FIRST_DATE_WORKED DATE

LAST_DATE_WORKED DATE

PAYMENT_START_DATE DATE

PAYMENT_END_DATE DATE

NOTICE_PERIOD NUMBER

NOTICE_PERIOD_UNITS VARCHAR2 (150)
REPLACING_EMPLOYEE VARCHAR2 (150)
CONTRACT_SIGN_OFF_DATE DATE

DURATION_OF_PROBATION_LENGTH VARCHAR2 (150)
PROBATION_DURATION_UNIT VARCHAR2 (150)
CONST__PROBATION_END_DATE DATE

ACTUAL_PROBATION_END_DATE DATE

NOTICE_PERIOD__RESIGN_IN_PROB VARCHAR2 (150)
NOTICE_PERIOD__DISMISS_IN_PROB VARCHAR2 (150)
NOTICE_PERIOD__RESIGNATION VARCHAR2 (150)
NOTICE_PERIOD__DISMISSAL VARCHAR2 (150)
NOTICE_DURATION_UNIT VARCHAR2 (150)
COMPETITION_CLAUSE VARCHAR2 (150)
NON_DISCLOSURE_AGREEMENT VARCHAR2 (150)
CONTRACT_CHANGE_REASON VARCHAR2 (150)
CONTRACT_CHANGE_DATE DATE

CONTRACT_EXTENSION_DATE DATE

CONTRACT_TERMINATION_DATE DATE

CONTRACT_CANCELLATION_REASON VARCHAR2 (150)
CONTRACT_CANCELLATION_DATE DATE

CONTRACT_CANCELLATION_FILE_NUM VARCHAR2 (150)
CONTRACT_RENEW_STATUS VARCHAR2 (150)
TYPE_OF_EMPLOYMENT VARCHAR2 (150)
SUBTYPE_OF_WORK_CONTRACT1 VARCHAR2 (150)
SUBTYPE_OF_WORK_CONTRACT2 VARCHAR2 (150)
LIMITED_DURATION VARCHAR2 (150)
LIMITED_DURATION_REASON VARCHAR2 (150)
PART_TIME_CONTRACT VARCHAR2 (150)
PART_TIME_CONTRACT_TYPE VARCHAR2 (150)
REMUNERATION_TYPE VARCHAR2 (150)
TARIFF_CONTRACT VARCHAR2 (150)
WORK_PLACE VARCHAR2 (150)
PAY_GRADE VARCHAR2 (150)
CASE_GROUP VARCHAR2 (150)
FTE NUMBER

COLLECTIVE_AGREEMENT VARCHAR2 (150)
PROBATION_TIME VARCHAR2 (150)
ALTERNATING_SHIFT_WORK VARCHAR2 (150)
DAYS_PER_WEEK VARCHAR2 (150)
SICK_PAY_PERIOD VARCHAR2 (150)
REGULAR_WORKING_HOURS VARCHAR2 (150)
PROMOTION_DETAILS VARCHAR2 (150)
CONTRACT_SUBTYPE VARCHAR2 (150)
IN_CLASS_TRAINING_HOURS VARCHAR2 (150)
REMOTE_TRAINING_HOURS VARCHAR2 (150)
PROPOSED_END_DATE DATE

PERSON_REPLACED VARCHAR2 (150)
REPLACEMENT_REASON VARCHAR2 (150)
EMPLOYEE_TYPE VARCHAR2 (150)
END_EVENT VARCHAR2 (150)
PROBATION_PERIOD NUMBER

PROBATION_PERIOD_UNITS VARCHAR2 (150)
PROBATION_END_DATE DATE

SMIC_ADJUSTED_DURATION_DAYS NUMBER

FIXED_WORKING_TIME VARCHAR2 (150)
AMOUNT NUMBER

UNITS VARCHAR2 (150)
FREQUENCY VARCHAR2 (150)
CONTRACT_EXPIRY_DATE DATE

NO_CONTRACT_END_DATE DATE

LEGAL_REASON_IF_ANY_ VARCHAR2 (150)
EXTRA_INFORMATION_IF_ANY_ VARCHAR2 (150)
DESTINATION_EMPLOYER VARCHAR2 (150)
EMPLOYER_VAT_NUMBER__NPC VARCHAR2 (150)
DESTINATION_COUNTRY VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (3050)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      CONTEXT_VALUE
,      EMPLOYMENT_STATUS
,      EXPIRY_DATE
,      CONTRACT_CATEGORY
,      FIRST_DATE_WORKED
,      LAST_DATE_WORKED
,      PAYMENT_START_DATE
,      PAYMENT_END_DATE
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UNITS
,      REPLACING_EMPLOYEE
,      CONTRACT_SIGN_OFF_DATE
,      DURATION_OF_PROBATION_LENGTH
,      PROBATION_DURATION_UNIT
,      CONST__PROBATION_END_DATE
,      ACTUAL_PROBATION_END_DATE
,      NOTICE_PERIOD__RESIGN_IN_PROB
,      NOTICE_PERIOD__DISMISS_IN_PROB
,      NOTICE_PERIOD__RESIGNATION
,      NOTICE_PERIOD__DISMISSAL
,      NOTICE_DURATION_UNIT
,      COMPETITION_CLAUSE
,      NON_DISCLOSURE_AGREEMENT
,      CONTRACT_CHANGE_REASON
,      CONTRACT_CHANGE_DATE
,      CONTRACT_EXTENSION_DATE
,      CONTRACT_TERMINATION_DATE
,      CONTRACT_CANCELLATION_REASON
,      CONTRACT_CANCELLATION_DATE
,      CONTRACT_CANCELLATION_FILE_NUM
,      CONTRACT_RENEW_STATUS
,      TYPE_OF_EMPLOYMENT
,      SUBTYPE_OF_WORK_CONTRACT1
,      SUBTYPE_OF_WORK_CONTRACT2
,      LIMITED_DURATION
,      LIMITED_DURATION_REASON
,      PART_TIME_CONTRACT
,      PART_TIME_CONTRACT_TYPE
,      REMUNERATION_TYPE
,      TARIFF_CONTRACT
,      WORK_PLACE
,      PAY_GRADE
,      CASE_GROUP
,      FTE
,      COLLECTIVE_AGREEMENT
,      PROBATION_TIME
,      ALTERNATING_SHIFT_WORK
,      DAYS_PER_WEEK
,      SICK_PAY_PERIOD
,      REGULAR_WORKING_HOURS
,      PROMOTION_DETAILS
,      CONTRACT_SUBTYPE
,      IN_CLASS_TRAINING_HOURS
,      REMOTE_TRAINING_HOURS
,      PROPOSED_END_DATE
,      PERSON_REPLACED
,      REPLACEMENT_REASON
,      EMPLOYEE_TYPE
,      END_EVENT
,      PROBATION_PERIOD
,      PROBATION_PERIOD_UNITS
,      PROBATION_END_DATE
,      SMIC_ADJUSTED_DURATION_DAYS
,      FIXED_WORKING_TIME
,      AMOUNT
,      UNITS
,      FREQUENCY
,      CONTRACT_EXPIRY_DATE
,      NO_CONTRACT_END_DATE
,      LEGAL_REASON_IF_ANY_
,      EXTRA_INFORMATION_IF_ANY_
,      DESTINATION_EMPLOYER
,      EMPLOYER_VAT_NUMBER__NPC
,      DESTINATION_COUNTRY
,      CONCATENATED_SEGMENTS
FROM APPS.PER_CONTRACTS_F_DFV;

Dependencies

[top of page]

APPS.PER_CONTRACTS_F_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymPER_CONTRACTS_F

APPS.PER_CONTRACTS_F_DFV is not referenced by any database object