[Home] [Help] [Dependency Information]
Object Name: | HRBV_COLLECTIVE_AGREEMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Collective agreements (from PER_COLLECTIVE_AGREEMENTS table).
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
NAME | VARCHAR2 | (80) | Yes | Collective agreement name. |
CAG_NUMBER | NUMBER | (15) | Number. | |
DESCRIPTION | VARCHAR2 | (2000) | Description. | |
START_DATE | DATE | Start date. | ||
END_DATE | DATE | End date. | ||
EMPLOYER_SIGNATORY | VARCHAR2 | (80) | Employer signatory. | |
BARGAINING_UNIT_SIGNATORY | VARCHAR2 | (80) | Bargaining unit signatory. | |
JURISDICTION | VARCHAR2 | (80) | Jurisdiction. | |
AUTHORIZING_BODY | VARCHAR2 | (80) | Authorizing body. | |
AUTHORIZED_DATE | DATE | Authorized date. | ||
CAG_INFORMATION_CATEGORY | VARCHAR2 | (30) | Cag information category. | |
CAG_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
CAG_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column. | |
STATUS | VARCHAR2 | (30) | Yes | (Lookup code based on lookup type CAGR_STATUS). |
STATUS_M | VARCHAR2 | (4000) | (Lookup meaning based on lookup type CAGR_STATUS). | |
_DF:CAG | CHAR | (37) | Descriptive Flex placeholder | |
COLLECTIVE_AGREEMENT_ID | NUMBER | (9) | Yes | Primary key for PER_COLLECTIVE_AGREEMENTS. |
EMPLOYER_ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
BARGAINING_ORGANIZATION_ID | NUMBER | (15) | Foreign key to HR_ALL_ORGANIZATION_UNITS. | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS. |
PL_ID | NUMBER | (15) | Foreign key to BEN_PL. | |
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 NAME
, CAG_NUMBER
, DESCRIPTION
, START_DATE
, END_DATE
, EMPLOYER_SIGNATORY
, BARGAINING_UNIT_SIGNATORY
, JURISDICTION
, AUTHORIZING_BODY
, AUTHORIZED_DATE
, CAG_INFORMATION_CATEGORY
, CAG_INFORMATION1
, CAG_INFORMATION2
, CAG_INFORMATION3
, CAG_INFORMATION4
, CAG_INFORMATION5
, CAG_INFORMATION6
, CAG_INFORMATION7
, CAG_INFORMATION8
, CAG_INFORMATION9
, CAG_INFORMATION10
, CAG_INFORMATION11
, CAG_INFORMATION12
, CAG_INFORMATION13
, CAG_INFORMATION14
, CAG_INFORMATION15
, CAG_INFORMATION16
, CAG_INFORMATION17
, CAG_INFORMATION18
, CAG_INFORMATION19
, CAG_INFORMATION20
, STATUS
, STATUS_M
, _DF:CAG
, COLLECTIVE_AGREEMENT_ID
, EMPLOYER_ORGANIZATION_ID
, BARGAINING_ORGANIZATION_ID
, BUSINESS_GROUP_ID
, PL_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATED_BY
, CREATION_DATE
, BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_COLLECTIVE_AGREEMENTS_V;
|
|
|