[Home] [Help] [Dependency Information]
Object Name: | HRBV_CONTRACTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Contracts (from PER_CONTRACTS table).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_START_DATE | DATE | Yes | Effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date. | |
REFERENCE | VARCHAR2 | (80) | Yes | Reference. |
TYPE | VARCHAR2 | (30) | Yes | (Lookup code based on lookup type CONTRACT_TYPE). |
TYPE_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type CONTRACT_TYPE). | |
STATUS | VARCHAR2 | (30) | Yes | (Lookup code based on lookup type CONTRACT_STATUS). |
STATUS_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type CONTRACT_STATUS). | |
STATUS_REASON | VARCHAR2 | (240) | (Lookup code based on lookup type CONTRACT_STATUS_REASON). | |
STATUS_REASON_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type CONTRACT_STATUS_REASON). | |
DOC_STATUS | VARCHAR2 | (240) | Document status. | |
DOC_STATUS_CHANGE_DATE | DATE | Date of change. | ||
DESCRIPTION | VARCHAR2 | (2000) | Description. | |
DURATION | NUMBER | (22) | Duration. | |
DURATION_UNITS | VARCHAR2 | (30) | (Lookup code based on lookup type QUALIFYING_UNITS). | |
DURATION_UNITS_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type QUALIFYING_UNITS). | |
CONTRACTUAL_JOB_TITLE | VARCHAR2 | (80) | Contractual job title. | |
PARTIES | VARCHAR2 | (80) | Parties. | |
START_REASON | VARCHAR2 | (30) | (Lookup code based on lookup type CONTRACT_START_REASON). | |
START_REASON_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type CONTRACT_START_REASON). | |
END_REASON | VARCHAR2 | (30) | (Lookup code based on lookup type CONTRACT_END_REASON). | |
END_REASON_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type CONTRACT_END_REASON). | |
NUMBER_OF_EXTENSIONS | NUMBER | (9) | Number of extensions. | |
EXTENSION_REASON | VARCHAR2 | (80) | Extension reason. | |
EXTENSION_PERIOD | NUMBER | (22) | Extension period. | |
EXTENSION_PERIOD_UNITS | VARCHAR2 | (30) | (Lookup code based on lookup type QUALIFYING_UNITS). | |
EXTENSION_PERIOD_UNITS_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type QUALIFYING_UNITS). | |
CTR_INFORMATION_CATEGORY | VARCHAR2 | (30) | Ctr information category. | |
CTR_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CTR_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
_DF:CTC | CHAR | (25) | Descriptive Flex placeholder | |
LEGISLATION_CODE | VARCHAR2 | (4000) | Legislation code. | |
CONTRACT_ID | NUMBER | (9) | Yes | Primary key for PER_CONTRACTS. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS. |
PERSON_ID | NUMBER | (9) | Yes | Foreign key to PER_ALL_PEOPLE_F. |
LAST_UPDATE_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
BG_SECURITY_FLAG_CODE | CHAR | (1) | Business group security flag code. |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, REFERENCE
, TYPE
, TYPE_M
, STATUS
, STATUS_M
, STATUS_REASON
, STATUS_REASON_M
, DOC_STATUS
, DOC_STATUS_CHANGE_DATE
, DESCRIPTION
, DURATION
, DURATION_UNITS
, DURATION_UNITS_M
, CONTRACTUAL_JOB_TITLE
, PARTIES
, START_REASON
, START_REASON_M
, END_REASON
, END_REASON_M
, NUMBER_OF_EXTENSIONS
, EXTENSION_REASON
, EXTENSION_PERIOD
, EXTENSION_PERIOD_UNITS
, EXTENSION_PERIOD_UNITS_M
, CTR_INFORMATION_CATEGORY
, CTR_INFORMATION1
, CTR_INFORMATION2
, CTR_INFORMATION3
, CTR_INFORMATION4
, CTR_INFORMATION5
, CTR_INFORMATION6
, CTR_INFORMATION7
, CTR_INFORMATION8
, CTR_INFORMATION9
, CTR_INFORMATION10
, CTR_INFORMATION11
, CTR_INFORMATION12
, CTR_INFORMATION13
, CTR_INFORMATION14
, CTR_INFORMATION15
, CTR_INFORMATION16
, CTR_INFORMATION17
, CTR_INFORMATION18
, CTR_INFORMATION19
, CTR_INFORMATION20
, _DF:CTC
, LEGISLATION_CODE
, CONTRACT_ID
, BUSINESS_GROUP_ID
, PERSON_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_CONTRACTS_V;
|
|
|