[Home] [Help] [Dependency Information]
Object Name: | HRBV_ASSIGNMENT |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A Business Intelligence System view
Shared HRMS base view on PER_ASSIGNMENTS_F for use in Discoverer shared HRMS end user layer
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EFFECTIVE_START_DATE | DATE | Yes | Effective Start Date. | |
EFFECTIVE_END_DATE | DATE | Yes | Effective End Date. | |
TITLE | VARCHAR2 | (30) | Title Name. | |
ASSIGNMENT_SEQUENCE | NUMBER | (15) | Yes | Assignment sequence. |
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | Assignment Number. | |
DATE_PROBATION_END | DATE | -Date Probation Ends. | ||
CHANGE_REASON | VARCHAR2 | (4000) | ||
INTERNAL_ADDRESS_LINE | VARCHAR2 | (80) | ||
PROJECT_TITLE | VARCHAR2 | (30) | ||
TIME_NORMAL_START | VARCHAR2 | (5) | ||
TIME_NORMAL_FINISH | VARCHAR2 | (5) | ||
NOTICE_PERIOD | NUMBER | (10) | ||
NOTICE_PERIOD_UOM | VARCHAR2 | (4000) | ||
WORK_AT_HOME | VARCHAR2 | (4000) | ||
BARGAINING_UNIT | VARCHAR2 | (4000) | ||
LABOUR_UNION_MEMBER_FLAG | VARCHAR2 | (4000) | ||
PERIOD_OF_PLACEMENT_DATE_START | DATE | |||
PROBATION_PERIOD | NUMBER | (22) | ||
PROBATION_UNIT | VARCHAR2 | (4000) | ||
SAL_REVIEW_PERIOD | NUMBER | (15) | ||
SAL_REVIEW_PERIOD_FREQUENCY | VARCHAR2 | (4000) | ||
PERF_REVIEW_PERIOD | NUMBER | (15) | ||
PERF_REVIEW_PERIOD_FREQUENCY | VARCHAR2 | (4000) | ||
PRIMARY_FLAG | VARCHAR2 | (4000) | ||
MANAGER_FLAG | VARCHAR2 | (4000) | ||
EMPLOYEE_CATEGORY | VARCHAR2 | (4000) | ||
ASSIGNMENT_TYPE | VARCHAR2 | (4000) | ||
ASSIGNMENT_CATEGORY | VARCHAR2 | (30) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (4000) | ||
NORMAL_HOURS | NUMBER | (22) | ||
NORMAL_HOURS_FREQUENCY | VARCHAR2 | (4000) | ||
SOURCE_TYPE | VARCHAR2 | (4000) | ||
VENDOR_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
VENDOR_ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
JOB_POST_SOURCE_NAME | VARCHAR2 | (240) | ||
CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
NOTICE_PERIOD_UOM_CODE | VARCHAR2 | (30) | ||
WORK_AT_HOME_CODE | VARCHAR2 | (30) | ||
BARGAINING_UNIT_CODE | VARCHAR2 | (30) | ||
HOURLY_SALARIED_CODE | VARCHAR2 | (30) | ||
LABOUR_UNION_MEMBER_FLAG_CODE | VARCHAR2 | (30) | ||
PROBATION_UNIT_CODE | VARCHAR2 | (30) | ||
SAL_REVIEW_PERIOD_FREQ_CODE | VARCHAR2 | (30) | ||
PERF_REVIEW_PERIOD_FREQ_CODE | VARCHAR2 | (30) | ||
PRIMARY_FLAG_CODE | VARCHAR2 | (30) | Yes | |
MANAGER_FLAG_CODE | VARCHAR2 | (30) | ||
EMPLOYMENT_CATEGORY_CODE | VARCHAR2 | (30) | ||
ASSIGNMENT_TYPE_CODE | VARCHAR2 | (1) | Yes | |
NORMAL_HOURS_FREQUENCY_CODE | VARCHAR2 | (30) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
_DF:AAD | CHAR | (27) | ||
LEGISLATION_CODE | VARCHAR2 | (4000) | ||
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (9) | Yes | |
GRADE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
PAYROLL_ID | NUMBER | (9) | ||
PERIOD_OF_SERVICE_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (10) | Yes | |
POSITION_ID | NUMBER | (15) | ||
PEOPLE_GROUP_ID | NUMBER | (15) | ||
SOFT_CODING_KEYFLEX_ID | NUMBER | (15) | ||
PAY_BASIS_ID | NUMBER | (9) | ||
SUPERVISOR_ID | NUMBER | (10) | ||
VACANCY_ID | NUMBER | (15) | ||
RECRUITER_ID | NUMBER | (10) | ||
PERSON_REFERRED_BY_ID | NUMBER | (10) | ||
RECRUITMENT_ACTIVITY_ID | NUMBER | (15) | ||
SPECIAL_CEILING_STEP_ID | NUMBER | (15) | ||
SOURCE_ORGANIZATION_ID | NUMBER | (15) | ||
APPLICATION_ID | NUMBER | (15) | ||
COMMENT_ID | NUMBER | (15) | ||
DEFAULT_CODE_COMB_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
CONTRACT_ID | NUMBER | (9) | ||
COLLECTIVE_AGREEMENT_ID | NUMBER | (9) | ||
CAGR_ID_FLEX_NUM | NUMBER | (15) | ||
CAGR_GRADE_DEF_ID | NUMBER | (15) | ||
ESTABLISHMENT_ID | NUMBER | (15) | ||
VENDOR_ID | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
BG_SECURITY_FLAG_CODE | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, TITLE
, ASSIGNMENT_SEQUENCE
, ASSIGNMENT_NUMBER
, DATE_PROBATION_END
, CHANGE_REASON
, INTERNAL_ADDRESS_LINE
, PROJECT_TITLE
, TIME_NORMAL_START
, TIME_NORMAL_FINISH
, NOTICE_PERIOD
, NOTICE_PERIOD_UOM
, WORK_AT_HOME
, BARGAINING_UNIT
, LABOUR_UNION_MEMBER_FLAG
, PERIOD_OF_PLACEMENT_DATE_START
, PROBATION_PERIOD
, PROBATION_UNIT
, SAL_REVIEW_PERIOD
, SAL_REVIEW_PERIOD_FREQUENCY
, PERF_REVIEW_PERIOD
, PERF_REVIEW_PERIOD_FREQUENCY
, PRIMARY_FLAG
, MANAGER_FLAG
, EMPLOYEE_CATEGORY
, ASSIGNMENT_TYPE
, ASSIGNMENT_CATEGORY
, EMPLOYMENT_CATEGORY
, NORMAL_HOURS
, NORMAL_HOURS_FREQUENCY
, SOURCE_TYPE
, VENDOR_EMPLOYEE_NUMBER
, VENDOR_ASSIGNMENT_NUMBER
, JOB_POST_SOURCE_NAME
, CHANGE_REASON_CODE
, NOTICE_PERIOD_UOM_CODE
, WORK_AT_HOME_CODE
, BARGAINING_UNIT_CODE
, HOURLY_SALARIED_CODE
, LABOUR_UNION_MEMBER_FLAG_CODE
, PROBATION_UNIT_CODE
, SAL_REVIEW_PERIOD_FREQ_CODE
, PERF_REVIEW_PERIOD_FREQ_CODE
, PRIMARY_FLAG_CODE
, MANAGER_FLAG_CODE
, EMPLOYMENT_CATEGORY_CODE
, ASSIGNMENT_TYPE_CODE
, NORMAL_HOURS_FREQUENCY_CODE
, SOURCE_TYPE_CODE
, _DF:AAD
, LEGISLATION_CODE
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, ASSIGNMENT_STATUS_TYPE_ID
, GRADE_ID
, JOB_ID
, LOCATION_ID
, ORGANIZATION_ID
, PAYROLL_ID
, PERIOD_OF_SERVICE_ID
, PERSON_ID
, POSITION_ID
, PEOPLE_GROUP_ID
, SOFT_CODING_KEYFLEX_ID
, PAY_BASIS_ID
, SUPERVISOR_ID
, VACANCY_ID
, RECRUITER_ID
, PERSON_REFERRED_BY_ID
, RECRUITMENT_ACTIVITY_ID
, SPECIAL_CEILING_STEP_ID
, SOURCE_ORGANIZATION_ID
, APPLICATION_ID
, COMMENT_ID
, DEFAULT_CODE_COMB_ID
, SET_OF_BOOKS_ID
, CONTRACT_ID
, COLLECTIVE_AGREEMENT_ID
, CAGR_ID_FLEX_NUM
, CAGR_GRADE_DEF_ID
, ESTABLISHMENT_ID
, VENDOR_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_ASSIGNMENT;
APPS.HRBV_ASSIGNMENT is not referenced by any database object
|
|
|