[Home] [Help] [Dependency Information]
Object Name: | IRCFV_CANDIDATES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Shows the personal details entered by a candidate. A candidate is defined as a iRecruitment site visitor which has selected the checkbox 'Allow my details to be searched'
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CANDIDATE_NAME | VARCHAR2 | (450) | ||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
FIRST_NAME | VARCHAR2 | (150) | ||
LAST_NAME | VARCHAR2 | (150) | ||
MATCHING_JOBS | VARCHAR2 | (4000) | ||
RECEIVE_INFO_MAIL | VARCHAR2 | (4000) | ||
FREQUENCY_OF_EMAILS | VARCHAR2 | (4000) | ||
EMAIL_IN_HTML_FORMAT | VARCHAR2 | (4000) | ||
MATCHING_JOBS_CODE | VARCHAR2 | (30) | Yes | |
RECEIVE_INFO_MAIL_CODE | VARCHAR2 | (30) | Yes | |
MATCHING_JOBS_FREQ_CODE | VARCHAR2 | (30) | Yes | |
_DF:NTP | CHAR | (40) | ||
_DF:HZP | CHAR | (29) | ||
PARTY_ID | NUMBER | (15) | Yes | |
USER_ID | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CANDIDATE_NAME
, EMAIL_ADDRESS
, FIRST_NAME
, LAST_NAME
, MATCHING_JOBS
, RECEIVE_INFO_MAIL
, FREQUENCY_OF_EMAILS
, EMAIL_IN_HTML_FORMAT
, MATCHING_JOBS_CODE
, RECEIVE_INFO_MAIL_CODE
, MATCHING_JOBS_FREQ_CODE
, _DF:NTP
, _DF:HZP
, PARTY_ID
, USER_ID
, CUSTOMER_ID
FROM APPS.IRCFV_CANDIDATES;
APPS.IRCFV_CANDIDATES is not referenced by any database object
|
|
|