[Home] [Help] [Dependency Information]
Object Name: | IRCFV_CANDIDATE_EMPLYMNT_HSTRY |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Shows the candidate entered employment history, and the HRMS entered employment history, if the employment history is associated with a previous job. Employment history records not associated with a previous job are not shown.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CANDIDATE_NAME | VARCHAR2 | (450) | ||
EMPLOYER_NAME | VARCHAR2 | (240) | ||
EMPLOYER_START_DATE | DATE | |||
EMPLOYER_END_DATE | DATE | |||
EMPLOYER_START_DATE_NN | DATE | |||
EMPLOYER_END_DATE_NN | DATE | |||
EMPLOYER_PERIOD_YEARS | NUMBER | (2) | ||
EMPLOYER_PERIOD_MONTHS | NUMBER | (2) | ||
EMPLOYER_PERIOD_DAYS | NUMBER | (3) | ||
JOB_TITLE | VARCHAR2 | (240) | ||
JOB_START_DATE | DATE | |||
JOB_END_DATE | DATE | |||
JOB_PERIOD_YEARS | NUMBER | (2) | ||
JOB_PERIOD_MONTHS | NUMBER | (2) | ||
JOB_PERIOD_DAYS | NUMBER | (3) | ||
EMPLOYER_COUNTRY | VARCHAR2 | (80) | ||
EMPLOYER_ADDRESS | VARCHAR2 | (4000) | ||
EMPLOYER_TYPE | VARCHAR2 | (4000) | ||
EMPLOYER_SUBTYPE | VARCHAR2 | (4000) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (4000) | ||
EMPLOYER_DESCRIPTION | VARCHAR2 | (4000) | ||
JOB_DESCRIPTION | VARCHAR2 | (4000) | ||
_DF:PEMP1 | CHAR | (34) | ||
_DF:PEMP2 | CHAR | (42) | ||
_DF:PJOB1 | CHAR | (29) | ||
_DF:PJOB2 | CHAR | (37) | ||
EMPLOYER_COUNTRY_CODE | VARCHAR2 | (30) | ||
EMPLOYER_TYPE_CODE | VARCHAR2 | (30) | ||
EMPLOYER_SUBTYPE_CODE | VARCHAR2 | (30) | ||
EMPLOYMENT_CATEGORY_CODE | VARCHAR2 | (30) | ||
PREVIOUS_EMPLOYER_ID | NUMBER | (15) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | ||
PERSON_ID | NUMBER | (15) | ||
PARTY_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CANDIDATE_NAME
, EMPLOYER_NAME
, EMPLOYER_START_DATE
, EMPLOYER_END_DATE
, EMPLOYER_START_DATE_NN
, EMPLOYER_END_DATE_NN
, EMPLOYER_PERIOD_YEARS
, EMPLOYER_PERIOD_MONTHS
, EMPLOYER_PERIOD_DAYS
, JOB_TITLE
, JOB_START_DATE
, JOB_END_DATE
, JOB_PERIOD_YEARS
, JOB_PERIOD_MONTHS
, JOB_PERIOD_DAYS
, EMPLOYER_COUNTRY
, EMPLOYER_ADDRESS
, EMPLOYER_TYPE
, EMPLOYER_SUBTYPE
, EMPLOYMENT_CATEGORY
, EMPLOYER_DESCRIPTION
, JOB_DESCRIPTION
, _DF:PEMP1
, _DF:PEMP2
, _DF:PJOB1
, _DF:PJOB2
, EMPLOYER_COUNTRY_CODE
, EMPLOYER_TYPE_CODE
, EMPLOYER_SUBTYPE_CODE
, EMPLOYMENT_CATEGORY_CODE
, PREVIOUS_EMPLOYER_ID
, BUSINESS_GROUP_ID
, PERSON_ID
, PARTY_ID
FROM APPS.IRCFV_CANDIDATE_EMPLYMNT_HSTRY;
APPS.IRCFV_CANDIDATE_EMPLYMNT_HSTRY is not referenced by any database object
|
|
|